MATLAB: Reading a special sheet of an EXCEL file with knowing the row numbers of that

excelMATLABreadsheetxls

does anyone know how matlab can read a special sheet of an excel file with knowing only row numbers of that sheet? for example one excel file have 4 sheets and one of that sheets has more than 500 rows( we don't know how many rows there are exactly) and only 2 columns exactly. now its needed matlab to read this sheet.

Best Answer

use [Num,Txt,Raw]=xlsread(ExcelFile,SheetName)

then size(Raw) will tell you how many rows and columns of data are in that sheet.

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: How can I read different data types from excel file

[NUM,TXT,RAW]=xlsread(FILE). Get the Raw data.

Best Answer

Related Solutions

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

MATLAB: How can I read different data types from excel file

Related Question