MATLAB: Obtain information on excel files

excel

Is there a method for obtaining more information for excel files? I can use

    [status,sheets,format] = xlsfinfo(filename)

to find the names of each sheet in the workbook, however, I'm trying to find a way of obtaining the number of measurements i.e. the number of rows and columns in the excel files. Is there a way of doing this without having to import the data into matlab?

Best Answer

You could open the file using actxserver (see doc) and make your way through the file using methods and properties. It probably will be cumbersome, though.

Related Solutions

MATLAB: How to rename a sheet in Excel using the COM interface in MATLAB

You can rename an Excel sheet using the "Name" property of a sheet object. For example the following renames the first sheet of an Excel file:

filename = 'C:\SomeExcelFile.xls';
% Open Excel Automation server
Excel = actxserver('Excel.Application');
% Make Excel visible
Excel.Visible=1;
% Open Excel file
Workbook = Excel.Workbooks.Open(filename);
% Get the list of sheets in the workbook
Sheets = Excel.ActiveWorkbook.Sheets;
% Rename the first sheet
Sheets.Item(1).Name = 'This is sheet 1';

The following code then saves the Workbook, quits Excel and removes the COM server:

% Save the file
Workbook.Save();
% Quit Excel, remove the COM server and delete the related objects
Excel.Quit();
Excel.delete();
clear Excel;
clear Workbook;
clear Sheets;

MATLAB: Account sign in window pops up when files are stored on onedrive using actxserver with Workbooks.Open

After I unticked file collaboration in the onedrive settings it works :)

Best Answer

Related Solutions

MATLAB: How to rename a sheet in Excel using the COM interface in MATLAB

MATLAB: Account sign in window pops up when files are stored on onedrive using actxserver with Workbooks.Open

Related Question