MATLAB Answers

xlswrite is not recommended, what should I use instead?

39 views (last 30 days)
Gabriela Garcia
Gabriela Garcia on 19 Jan 2021
Commented: Gabriela Garcia on 19 Jan 2021
I have eleven 12x8 matrices composed of 1s and 0s. I want to export each matrix into its own excel file as a table with the rows labeled with times and the columns labeled with weekdays. I want to use an efficient code and possibly a loop to prevent typing over and over again. Each Matrix is saved as as a variable, like 'A53'. Of the eleven matrices, ten are have consecutive counting titles, like 'A51', 'A52', 'A53'...'A60'. Is it possible to use a loop to load these into separate excel sheets, as described above?

Answers (1)

Star Strider
Star Strider on 19 Jan 2021
Since you have R2020a, first, create a table using your data, then use writetable to write it to an Excel file (or other options).

  8 Comments

Show 5 older comments
Gabriela Garcia
Gabriela Garcia on 19 Jan 2021
Thank you for your help! Do you think that there is a way to have the new excel documents open when I run the program?
Gabriela Garcia
Gabriela Garcia on 19 Jan 2021
While I run the script that is supposed to write the matrices into their own excel sheets, is there another function to add that will have the new excel documents open?

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!