MATLAB: How to read a specific element from an excel file

excelsheet

i want to read a specific element from a excel file named "try.xls" i tried this command : xlsread('C:\Users\Mahmoud\Desktop\RECHERCHE\try.xlsx','sheet1','B2') it didn't work it gives me this error : "Worksheet 'sheet1' not found."

Best Answer

It sounds like Worksheet 'sheet1' does not exist.

Support for .XLSX files with xlsread() was not introduced until R2009a, and may not work as expected until R2012a.

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: Excllink with open office

I think it only works with Excel, see:

http://www.mathworks.com/help/releases/R2011a/toolbox/exlink/f2-2282.html

HTH,

Arnaud

Best Answer

Related Solutions

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

MATLAB: Excllink with open office

Related Question