Open excel file that user defined the address of the file

조회 수: 5 (최근 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');

추가 답변 (0개)

카테고리

Help CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기

Community Treasure Hunt

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

Start Hunting!

Translated by