Use writetable to everything in the workspace

2 次查看（过去 30 天）
Arthur Romeu
Arthur Romeu 2020-4-3
评论： Arthur Romeu 2020-4-6
Hello there,
I have a script that outputs many different Nx2 tables that contain the same type of information, being column 1 a "Status" column and column 2 a datetime column. I am currently trying to put them all in a single .xlsx file sorted by their datetimes. The thing is: Depending on the input data on the beggining of the script, some tables will not be written in the first place, so the situation is as follows:
All the tables have to be in the .xlsx file, but I can't simply use their name to call them because if some table doesn't exist on the run, matlab will report that said table doesn't exist.
I'll attach some output tables for better understanding.
I hope I was clear enough for you guys to have a picture of the problem that I'm facing.
Thanks in advance,
Arthur.
  3 个评论
显示 1更早的评论
Stephen23
Stephen23 2020-4-3
This is exactly why splitting data into lots of separate variables just makes it harder to work with.
Put the data into one variable (it could be a cell array, a table, a structure, whatever suits your data) and then simply iterate over the appropriate indices/fields/rows or whatever. Designing your data better would improve your code a lot.
Arthur Romeu
Arthur Romeu 2020-4-6
That's true! However, the source of these data is different for each one of them. I'll try and put them in one var.. I'm fairly new to programming :)

请先登录，再进行评论。

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

回答（0 个）

类别

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

标签

产品


版本

R2019a

Community Treasure Hunt

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

Start Hunting!

Translated by