Create table from excel spreadsheet with multiple sheets

9 次查看（过去 30 天）
alpedhuez
alpedhuez 2018-7-7
评论： dpb 2018-7-7
Suppose I have xlsx file with multiple sheets. I want to create table A from the first sheet and create table B from the second sheet. Please advise.

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

采纳的回答

Image Analyst
Image Analyst 2018-7-7
Try this:
folder = fileparts(which('patients.xls')) % Determine where demo folder is.
fullFileName = fullfile(folder, 'patients.xls');
[status, sheetNames] = xlsfinfo(fullFileName)
numSheets = length(sheetNames)
t1 = readtable(fullFileName, 'Sheet', 1)
t2 = readtable(fullFileName, 'Sheet', 2)
and so on. Put in a loop if you want.

更多回答（1 个）

dpb
dpb 2018-7-7
See
doc readtable
  2 个评论
dpb
dpb 2018-7-7
That's certainly possible, yes...you're missing a LHS variable to assign the result to, however.

请先登录，再进行评论。

类别

在 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