MATLAB: Import worksheet in excel

excelsheet

Hi all, I have a little problem. I have a file in Excel and import to Matlab:

lab= {'9.4', '9.2_1','9.2_2','9.2_3','9.2_4','9.2_5','8.1','8.2_1','8.2_2'};
K = length(lab);  
 for c = 1:K    
[ndata, text, alldata] = xlsread('test.xls',lab{c});
 end

I don't know how I solve the problem when in Excel is not sheet (eg. '8.2_1')

Thank you

Best Answer

[~,sheets] = xlsfinfo('test.xls')

Then compare sheets to lab using set operations (eg ismember or intersect)

Related Solutions

MATLAB: How can you make a particular Excel workbook active when you have more than one open in MATLAB 7.14 (R2012a)

In order to make a particular Excel workbook active from MATLAB, you will need to use the method ACTIVATE.

The following code is an example of how to use it. In this example MATLAB writes to an empty Excel file 'Book1.xlsm' which contains a macro named 'AddNew' that creates a new Excel file called 'test.xls'.

If the code is run, it is possible to see that first, the Excel file 'Book1.xlsm' is open and then, from MATLAB, the macro is run. This macro creates and opens the new Excel file 'test.xls', which becomes the active workbook. Then, to make 'Book1.xlsm' the active workbook, the command 'Workbook.Activate' is used. Finally, the code makes the second sheet active and writes on it, saves the workbook and closes Excel.

%%Specify file name 
file = 'path_to_file\Book1.xlsm'; % This must be full path name 
%%Open Excel Automation server 
Excel = actxserver('Excel.Application'); 
Workbooks = Excel.Workbooks; 
%%Make Excel visible 
Excel.Visible = 1; 
%%Open Excel file 
Workbook = Workbooks.Open(file);
%%Run Macro
Excel.Run('AddNew');
%This macro will create a new Excel file called test.xls
%%Specify sheet number, data, and range to write to 
sheetnum=1; 
data=rand(4);  % use a cell array if you want both numeric and text data 
range = 'F10:I13'; 
%%Make first workbook open the active one
Workbook.Activate
%%Make the second sheet from the active workbook active 
Sheets = Excel.ActiveWorkBook.Sheets; 
sheet2 = get(Sheets, 'Item', 2); 
invoke(sheet2, 'Activate'); 
Activesheet = Excel.Activesheet; 
%%Put MATLAB data into the active Excel 
ActivesheetRange = get(Activesheet,'Range',range); 
set(ActivesheetRange, 'Value', data); 
%%Save file 
invoke(Workbook,'Save') 
%%Close Excel and clean up 
invoke(Excel,'Quit'); 
delete(Excel); 
clear Excel;

MATLAB: Do I receive errors when reading certain Excel files into MATLAB

This bug has been fixed for Release 14 (R14). For previous releases, please read below for any possible workarounds:

This bug has been fixed for Release 14 SP1 (R14SP1). For previous releases, please read below for any possible workarounds:

This problem appears when an .XLS file is created with an unsupported version of Microsoft Excel for a particular version of MATLAB, such as Excel XP with MATLAB 6.1 (R12.1). Even if you save the file in different formats, such as Excel 2000 or Excel 97, the file still is not recognized. This may be due to different header information in files created with different versions of Excel.

The only workaround is to copy the contents of the file and paste it into a Excel sheet created using a supported Excel version and save that file.

Best Answer

Related Solutions

MATLAB: How can you make a particular Excel workbook active when you have more than one open in MATLAB 7.14 (R2012a)

MATLAB: Do I receive errors when reading certain Excel files into MATLAB

Related Question