MATLAB Answers

Change variable name in a loop

19 views (last 30 days)
Sehoon Chang
Sehoon Chang on 29 Aug 2020
Commented: Stephen on 29 Aug 2020
Hi,
I have multiple excel table data, that are imported to MATLAB in a loop function.
csvFiles = dir('*.csv');
numfiles_csv = length(csvFiles)
for a = 1:numfiles_csv
readtable(csvFiles(a).name)
end
I wish to name each table with numbers (e.g. table1, table2, etc.).
Currently when i run the code, all the tables are shown with a output name 'ans', which is preventing me from further allocation task.
thanks.
  3 Comments
Stephen
Stephen on 29 Aug 2020
"Could you please provide me with links or examples how i could make the tables visible,"
mydata_csv{1} % the 1st table
mydata_csv{2} % the 2nd table
mydata_csv{3} % the 3rd table
...etc

Sign in to comment.

Answers (1)

Matt J
Matt J on 29 Aug 2020
Tables{a} = readtable(csvFiles(a).name)
  1 Comment
Sehoon Chang
Sehoon Chang on 29 Aug 2020
Hi Matt, thanks for the reply.
I have tried that already. But the result that i receive is as following:
Tables = 1×2 cell array
{301×2 table} {104853×12 table}
Is there a secondary coding needed to make the table itself visible?

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!

Translated by