0 个投票

Hello,
after I have run my simulation I obtaind these variables in my workspace and I would like to save them on excel.
Does someone knows a code that I can use? since they are many variables in an array type, but I haven't found yet a code that does wokr for me.
I would like to save product, TIS, error and error2
thanks in advanced

1 个评论
显示 -1更早的评论 隐藏 -1更早的评论

KSSV
KSSV 2020-7-22
You can save them into .mat file. REad about save.

请先登录，再进行评论。

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

 采纳的回答

Fangjun Jiang
Fangjun Jiang 2020-7-22

0 个投票

xlswrite('MyFile.xlsx',[product, TIS, error, error2])

9 个评论
显示 7更早的评论 隐藏 7更早的评论

rough93
rough93 2020-7-22
Does this write each array to a different sheet?
it gives me error saying that product is an unrecognized variable. Do you know why I am not able to access these variables? because this is a recurrent problem, whenever I try to call one of them it gives me the same error.
thanks to all of you!
Fangjun Jiang
Fangjun Jiang 2020-7-22
just type "product" in MATLAB Command Window to make sure they exist in workspace first.
yeah actually it says it doesn't exist, do you happen to know what may be the problem?
here is how I am saving them during the simulation.
Thanks a lot
Fangjun Jiang
Fangjun Jiang 2020-7-22
It is inside the struct "out".
In Simulink model, press Ctrl+E, Data Import/Export, un-check "single simulation output"
although I can visualize them if I write out.TIS for example
thank you so much!!!
it works perfectly

请先登录，再进行评论。

更多回答（1 个）

rough93
rough93 2020-7-22
编辑：rough93 2020-7-22

0 个投票

Use the Write Data to Excel Spreadsheets method:
First, let's convert your data to tables:
product_table = array2table(product);
TIS_table = array2table(TIS);
error_table = array2table(error);
error2_table = array2table(error2);
then, you can specify the filename you want:
filename = 'your_filename.xlsx';
and write each table to your file on a different sheet:
writetable(product_table,filename,'Sheet',1)
writetable(TIS_table,filename,'Sheet',2)
writetable(error_table,filename,'Sheet',3)
writetable(error2_table,filename,'Sheet',4)

3 个评论
显示 1更早的评论 隐藏 1更早的评论

it gives me error saying that product is an unrecognized variable. Do you know why I am not able to access these variables? because this is a recurrent problem, whenever I try to call one of them it gives me the same error.
it seems that these variables are properties of the output
thanks to all of you
rough93
rough93 2020-7-22
Follow Fangjun's suggestion and let us know the answer, this code should be included in the editor after all the outputs are created/saved.

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Discrete-Event Simulation 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by