xlsread with linux

4 views (last 30 days)
Sukram
Sukram on 11 May 2012
is there no support for opening special worksheets from an xls file with linux?
>> m=xlsread('mysheed.xlsx','L2010');
Error using xlsreadXLSX>sheetNameToIndex (line 210)
Worksheet 'L2010' not found.
Error in xlsreadXLSX>getXLSXData (line 130)
sheetIndex = sheetNameToIndex(baseDir, sheet);
Error in xlsreadXLSX (line 9)
[sharedStrings, parsedSheetData, range] = getXLSXData(file, sheet, range);
Error in xlsread (line 233)
[numericData, textData, rawData] = xlsreadXLSX(file, sheet, range);
  2 Comments
Walter Roberson
Walter Roberson on 11 May 2012
Do you have a reference for what a "special worksheet" is in Excel ? Is 'L2010' supposed to be a flag indicating Excel 2010 compatibility or something like that?
Also, which version of MATLAB are you using?
Sukram
Sukram on 12 May 2012
I mean this http://paste.osuv.de/index.php/hhtt2/ seperate worksheets in excel. I don't know if i use the correct word :)
MATLAB Version: 7.14.0.739 (R2012a)

Sign in to comment.

Answers (1)

Sukram
Sukram on 13 May 2012
Calling it with int instead of string works fine
>> m=xlsread('sheet.xlsx',2);

Categories

Find more on Characters and Strings in Help Center and File Exchange

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!