MATLAB Answers

Create a table in MatLab with specific data in different spreadsheets in one Excel File.

20 views (last 30 days)
Hello together,
I have an Excel File with 10 spreadsheets and I want to import data (always range: A2:K7) from every spreadsheet into a table in MatLab. I want to create a Loop so that the data is displayed beneath one another.
Thank you for your support!

  0 Comments

Sign in to comment.

Accepted Answer

Stephan
Stephan on 19 Oct 2019
Edited: Stephan on 19 Oct 2019
Use the sheet option from the readtable function to loop through the single sheets. Indexing the values correctly in the table you create will let the data appear the way you want. in the given link you also find how to select the range of the Excel document.

  5 Comments

Show 2 older comments
Stephan
Stephan on 21 Oct 2019
filename = 'NASDAQ Company Data.xlsx';
sheets = sheetnames(filename);
xlRange = 'A1:K7';
data = cell(numel(sheets),1);
for k = 1:numel(sheets)
data{k} = readtable(filename,'Sheet',sheets(k),'Range',xlRange,...
'PreserveVariableNames',true);
end

Sign in to comment.

More Answers (0)

Community Treasure Hunt

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

Start Hunting!

Translated by