MATLAB: How to read spreadsheet files iteratively

iterationreadtable

I am trying to access .xls files that are indexed in the following approach:

for a=1:5 
    filename = sprintf('%s_%d','Set_90',a);
    fname=readtable('filename.xls');

But obviously, 'readtable' function is calling a file named 'filename.xls' and not 'Set_90_1.xls' . How do I change the code, in order to call the latter?

Thanks.

Best Answer

Replace

readtable('filename.xls');

readtable( [ filename, '.xls' ] );

to use the value of the variable not its name.

Related Solutions

MATLAB: How to determine the names and idicies of worksheets in an Excel file using ActiveX

I suggest

N_Sheets=ewb.Sheets.Count;
for k=1:N_Sheets
ewb.Sheets.Item(k).Name
end

MATLAB: How to delete worksheets in the Excel file using MATLAB

The following code runs through an Excel file and deletes sheets based on user input. Note that the code will produce an error if you delete all the sheets in an Excel file because Excel requires valid files to have at least one worksheet.

The code requires the user to have Microsoft Excel and uses ActiveX.

% This example operates on an Excel file called test.xls in the
% current directory. The test.xls file has 3 worksheets by default. This file can be 
% created by creating a new Excel file via Microsoft Excel and saving it as test.xls.
% Get information returned by XLSINFO on the workbook
XL_file = [pwd '\test.xls'];
[type, sheet_names] = xlsfinfo(XL_file);
% First open Excel as a COM Automation server
Excel = actxserver('Excel.Application'); 
% Make the application invisible
set(Excel, 'Visible', 0);
% Make excel not display alerts
set(Excel,'DisplayAlerts',0);
% Get a handle to Excel's Workbooks
Workbooks = Excel.Workbooks; 
% Open an Excel Workbook and activate it
Workbook=Workbooks.Open(XL_file);
% Get the sheets in the active Workbook
Sheets = Excel.ActiveWorkBook.Sheets;
index_adjust = 0;
% Cycle through the sheets and delete them based on user input
for i = 1:max(size(sheet_names))
      inp_prompt = sprintf('Do you want to delete the Worksheet called %s [y/n]?',sheet_names{i});
      user_inp = lower(input(inp_prompt,'s'));
      switch user_inp
          case{'y'}
              current_sheet = get(Sheets, 'Item', (i-index_adjust));
              invoke(current_sheet, 'Delete')
              out_string = sprintf('Worksheet called %s deleted',sheet_names{i});
              index_adjust = index_adjust +1;
          otherwise
              out_string = sprintf('Worksheet called %s ***NOT*** deleted',sheet_names{i});
      end
      disp(out_string);
      disp(' ');
end
% Now save the workbook
Workbook.Save;
% Close the workbook
Workbooks.Close;
% Quit Excel
invoke(Excel, 'Quit');
% Delete the handle to the ActiveX Object
delete(Excel);

Note that one must exercise caution when using ActiveX to modify Excel as this could lead to potentially serious errors if used incorrectly. An error in ActiveX instructions can not only crash Excel but also adversely affect MATLAB. Therefore, we recommend that critical ActiveX code executed through MATLAB should be used by those who understand ActiveX to the degree that the programmer can undo any particular ActiveX instructions.

Best Answer

Related Solutions

MATLAB: How to determine the names and idicies of worksheets in an Excel file using ActiveX

MATLAB: How to delete worksheets in the Excel file using MATLAB

Related Question