Forums

Non-string values in xlsread/xlsinfo

Started by szacharski October 22, 2009
Hello

I am working with an excel file with data on multiple sheets where I
may not know the sheet name

I'm trying to automate my calculations by reading the xls file and
saving the sheet names into a matrix (see example below)
[txt0,descr] = xlsfinfo('C:\inputs.xls')
m=size(descr,2)
for(i=0:1:m)
txt = xlsread('C:\inputs.xls', descr(1,i)))

I want to "automate" the xlsread function by referring to the stored
string information in the 'descr' variable..... but xlsread won't let
me read non-string values?
Is this possible, for what I want to do?
Best Regards
Steven
UBC