xlsread with linux

3 Ansichten (letzte 30 Tage)
Sukram
Sukram am 11 Mai 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 Kommentare
Walter Roberson
Walter Roberson am 11 Mai 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 am 12 Mai 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)

Melden Sie sich an, um zu kommentieren.

Antworten (1)

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

Kategorien

Mehr zu Characters and Strings finden Sie in Help Center und File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by