xlsread not able to reference my sheet names.
13 views (last 30 days)
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!
Image Analyst on 6 Jan 2016
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?