xlsread with linux

2012 5 11
1 个回答
5 次查看（30 天）

0 个投票

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 个评论
显示 无 隐藏 无

Walter Roberson
Walter Roberson 2012-5-11
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 2012-5-12
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)

请先登录，再进行评论。

请先登录，再回答此问题。

回答（1 个）

Sukram
Sukram 2012-5-13

0 个投票

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

类别

在 帮助中心 和 File Exchange 中查找有关 Characters and Strings 的更多信息

标签

提问:

Sukram
Sukram
2012-5-11

Community Treasure Hunt

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

Start Hunting!

Translated by