XLSread - multiple sheets

36 次查看（过去 30 天）
Prathamesh Halagi
评论： Ann 2021-1-9
Hello,
I have 215 excel sheets with similar data and each file has 4 sheets. Is there a way I can read all four sheets in a file in Matlab thorugh xlsread/import opts?
--
Thanks

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

采纳的回答

Ann
Ann 2021-1-7
Hi, Pratha.
I'm not sure if it helps or not because I also have similar situation with you but my parameter can combine in one excel file.
TimeP1=xlsread('Book001.xlsx','PRN1','A:A');
PRNP1=xlsread('Book001.xlsx','PRN1','B:B');
S4P1=xlsread('Book001.xlsx','PRN1','C:C');
%_______________read PRN1_______________%
TimeP2=xlsread('Book001.xlsx','PRN2','A:A');
PRNP2=xlsread('Book001.xlsx','PRN2','B:B');
S4P2=xlsread('Book001.xlsx','PRN2','C:C');
%_______________read PRN2_______________%
In another word:
ParameterP1 = xlsread('your excel file with format','your tab name in that excel','column selected');
  2 个评论
dpb
dpb 2021-1-7
编辑：dpb 2021-1-7
The above is quite inefficient in opening/closing the Excel workbook three separate times for each sheet; six times altogether in addition to the fact that xlsread is deprecated.
Use readtable instead
tTable1=xlsread('Book001.xlsx','Sheet','PRN1','Range','A:C');
Then reference the variables as
tTable1.Time
etc., ...
With multiple workbooks or sheets, you could further compact by using an array of tables.
Ann
Ann 2021-1-9
Thanks sir, for your recommendations and it do helps!

请先登录，再进行评论。

更多回答（1 个）

dpb
dpb 2021-1-5
xlsread has been deprecated; use readcell, readmatrix, readtable instead depending on how you want the data returned and the content of the spreadsheet.
None of these including xlsread has the facility to return more than a single sheet per invocation; you'll just have to loop over the sheets in each workbook in turn.

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by