Thread Subject: xlsread

I know there is a way to import seperate worksheets from an excel book into matlab as seperate variables, but I cannot remember how. I have the sheet names from using xlsfinfo, and can read them in individually, but I can't figure out how to get the in en-mass.

[type, sheets] = xlsfinfo('raw data.xls')

for i=1:8
data=xlsread('raw data.xls',sheets{1})
end

This only gives me the last of the sheets (which is obvious because it keeps overwriting itself). How can I change 'data' with each itteration of i?

"Travis" <sinusoid2@hotmail.com> wrote in message <gkj742$bej$1@fred.mathworks.com>...
> I know there is a way to import seperate worksheets from an excel book into matlab as seperate variables, but I cannot remember how. I have the sheet names from using xlsfinfo, and can read them in individually, but I can't figure out how to get the in en-mass.
>
> [type, sheets] = xlsfinfo('raw data.xls')
>
> for i=1:8
> data=xlsread('raw data.xls',sheets{1})
> end
>
> This only gives me the last of the sheets (which is obvious because it keeps overwriting itself). How can I change 'data' with each itteration of i?

Would something like this do it?

data = cell( 1, 8 );
for ii=1:8
data{ii}=xlsread('raw data.xls',sheets{ii})
end

/per

"per isakson" <poi.nospam@bimDOTkthDOT.se> wrote in message <gkjbgl$irm$1@fred.mathworks.com>...
> "Travis" <sinusoid2@hotmail.com> wrote in message <gkj742$bej$1@fred.mathworks.com>...
> > I know there is a way to import seperate worksheets from an excel book into matlab as seperate variables, but I cannot remember how. I have the sheet names from using xlsfinfo, and can read them in individually, but I can't figure out how to get the in en-mass.
> >
> > [type, sheets] = xlsfinfo('raw data.xls')
> >
> > for i=1:8
> > data=xlsread('raw data.xls',sheets{1})
> > end
> >
> > This only gives me the last of the sheets (which is obvious because it keeps overwriting itself). How can I change 'data' with each itteration of i?
>
> Would something like this do it?
>
> data = cell( 1, 8 );
> for ii=1:8
> data{ii}=xlsread('raw data.xls',sheets{ii})
> end
>
> /per


OK, that works great, thank you. Now do you know of a way for use xlswrite, and NOT get the default Sheet1, Sheet2, Sheet3?

"per isakson" <poi.nospam@bimDOTkthDOT.se> wrote in message <gkjbgl$irm$1@fred.mathworks.com>...
> "Travis" <sinusoid2@hotmail.com> wrote in message <gkj742$bej$1@fred.mathworks.com>...
> > I know there is a way to import seperate worksheets from an excel book into matlab as seperate variables, but I cannot remember how. I have the sheet names from using xlsfinfo, and can read them in individually, but I can't figure out how to get the in en-mass.
> >
> > [type, sheets] = xlsfinfo('raw data.xls')
> >
> > for i=1:8
> > data=xlsread('raw data.xls',sheets{1})
> > end
> >
> > This only gives me the last of the sheets (which is obvious because it keeps overwriting itself). How can I change 'data' with each itteration of i?
>
> Would something like this do it?
>
> data = cell( 1, 8 );
> for ii=1:8
> data{ii}=xlsread('raw data.xls',sheets{ii})
> end
>
> /per

Actually, looked at the data a little more, and while that does bring in all the data, there is are no tags on the data. Is there a way to bring the data in as individual variables?

"Travis" <sinusoid2@hotmail.com> wrote in message <gkqf8q$pkh$1@fred.mathworks.com>...
> "per isakson" <poi.nospam@bimDOTkthDOT.se> wrote in message <gkjbgl$irm$1@fred.mathworks.com>...
> > "Travis" <sinusoid2@hotmail.com> wrote in message <gkj742$bej$1@fred.mathworks.com>...
> > > I know there is a way to import seperate worksheets from an excel book into matlab as seperate variables, but I cannot remember how. I have the sheet names from using xlsfinfo, and can read them in individually, but I can't figure out how to get the in en-mass.
> > >
> > > [type, sheets] = xlsfinfo('raw data.xls')
> > >
> > > for i=1:8
> > > data=xlsread('raw data.xls',sheets{1})
> > > end
> > >
> > > This only gives me the last of the sheets (which is obvious because it keeps overwriting itself). How can I change 'data' with each itteration of i?
> >
> > Would something like this do it?
> >
> > data = cell( 1, 8 );
> > for ii=1:8
> > data{ii}=xlsread('raw data.xls',sheets{ii})
> > end
> >
> > /per
>
> Actually, looked at the data a little more, and while that does bring in all the data, there is are no tags on the data. Is there a way to bring the data in as individual variables?

The full syntax reads:

    [num, txt, raw] = xlsread(filename, ...)

What do you mean by "tags"?

XLSREAD splits the contents of the sheet. Numerical data goes into num and text into txt. Be aware that num(1,1) might not refer to the same cell as txt(1,1). raw holds both numerical and text data. I guess you will find the "tags" in txt and raw.

No, I don't know how to avoid the default sheets, sheet1, ... . However, with the Ms COM-ActiveX-??-object you can do "everything". It might be worth searching the File Exchange.

/ per

"per isakson" <poi.nospam@bimDOTkthDOT.se> wrote in message <gkrqvj$bd6$1@fred.mathworks.com>...
> "Travis" <sinusoid2@hotmail.com> wrote in message <gkqf8q$pkh$1@fred.mathworks.com>...
> > "per isakson" <poi.nospam@bimDOTkthDOT.se> wrote in message <gkjbgl$irm$1@fred.mathworks.com>...
> > > "Travis" <sinusoid2@hotmail.com> wrote in message <gkj742$bej$1@fred.mathworks.com>...
> > > > I know there is a way to import seperate worksheets from an excel book into matlab as seperate variables, but I cannot remember how. I have the sheet names from using xlsfinfo, and can read them in individually, but I can't figure out how to get the in en-mass.
> > > >
> > > > [type, sheets] = xlsfinfo('raw data.xls')
> > > >
> > > > for i=1:8
> > > > data=xlsread('raw data.xls',sheets{1})
> > > > end
> > > >
> > > > This only gives me the last of the sheets (which is obvious because it keeps overwriting itself). How can I change 'data' with each itteration of i?
> > >
> > > Would something like this do it?
> > >
> > > data = cell( 1, 8 );
> > > for ii=1:8
> > > data{ii}=xlsread('raw data.xls',sheets{ii})
> > > end
> > >
> > > /per
> >
> > Actually, looked at the data a little more, and while that does bring in all the data, there is are no tags on the data. Is there a way to bring the data in as individual variables?
>
> The full syntax reads:
>
> [num, txt, raw] = xlsread(filename, ...)
>
> What do you mean by "tags"?
>
> XLSREAD splits the contents of the sheet. Numerical data goes into num and text into txt. Be aware that num(1,1) might not refer to the same cell as txt(1,1). raw holds both numerical and text data. I guess you will find the "tags" in txt and raw.
>
> No, I don't know how to avoid the default sheets, sheet1, ... . However, with the Ms COM-ActiveX-??-object you can do "everything". It might be worth searching the File Exchange.
>
> / per
>
>


By tags I mean the name of the worksheet, in this case the filename saved to the worksheet.

"Travis" <sinusoid2@hotmail.com> wrote in message <gkt759>
....
By tags I mean the name of the worksheet, in this case the filename saved to the worksheet.

xlsinfo returns the names of the worksheets - but you know that.

/per