Open excel file that user defined the address of the file

1 回表示 (過去 30 日間)
Samer Husam
Samer Husam 2012 年 6 月 20 日
hi all; how can I open excel file that user can set the path of it.. lets say I have and edit text for user to paste the address of wanted file. I didn't like this but its not working:
Open_Excel=str2double(get(handles.edit_Load,'string'));
T=xlsread(Mulit_Excel,'Sheet1',A1);
any suggestions please on how to do it please ???

採用された回答

Walter Roberson
Walter Roberson 2012 年 6 月 20 日
Open_Excel = get(handles.edit_Load,'string');
T = xlsread(Open_Excel,'Sheet1','A1');
Consider using uigetfile() instead of an edit handle
[filename, filepath] = uigetfile(...)
Open_Excel = fullfile(filepath, filename);
T = xlsread(Open_Excel, 'Sheet1', 'A1');
  1 件のコメント
Samer Husam
Samer Husam 2012 年 6 月 20 日
thanks a lot.. its really works :)

サインインしてコメントする。

その他の回答 (0 件)

カテゴリ

Help Center および File ExchangeData Import from MATLAB についてさらに検索

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by