xlsread not able to reference my sheet names.

Question

Chameleon17 2016-1-6

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/262867-xlsread-not-able-to-reference-my-sheet-names

评论： Image Analyst 2016-1-7

Good afternoon,

I've never had this problem before, I'm certain it must be a pretty easy fix.

I'm trying to open an excel file, using xlsread. I have my program on a loop though specifying that each pass it should use a sheet of a different name. It keeps telling me though that the sheet name does not exist, but when I use xlsinfo it tells me that the sheet name is there.

DATA = xlsread('DATA1', 12)

I'm just a bit stumped as to how to get around this.

Any advice would be very much appreciated!

Thanks

2 个评论
显示无隐藏无

Stephen23 2016-1-6

编辑：Stephen23 2016-1-6

@Chameleon17: for this forum please don't put leading space characters in front of each line of your text, because this will be formatted as monospaced text (i.e. code). I just removed your leading space characters, and you can see now how the text of your question is normal text.

http://www.mathworks.com/matlabcentral/answers/13205-tutorial-how-to-format-your-question-with-markup

Renato Agurto 2016-1-6

I that the actual command you are using? where are you writing the filename? You also have to write the sheet name OR the number, not both

请先登录，再进行评论。

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

Answer 1

Image Analyst 2016-1-6

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/262867-xlsread-not-able-to-reference-my-sheet-names#answer_205297

Are you sure you have 12 worksheets in the workbook? Have you tried using the name of the sheet instead of it's number? Can you attach the data.xlsx workbook file to your posting with the paperclip icon?

4 个评论
显示 2更早的评论隐藏 2更早的评论

Image Analyst 2016-1-6

I saw you just posted that this did not work. However, I'm not seeing your workbook attached anywhere so that anyone can try it. Are you able to do that? You can take out any proprietary numbers and strings if you want first.