how to save variables

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

[KSSV]

You can save them into .mat file. REad about save.

Answer 1

[Fangjun Jiang]

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

[rough93]

Does this write each array to a different sheet?

[Ilaria Shireen Sestili]

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]

just type "product" in MATLAB Command Window to make sure they exist in workspace first.

[Ilaria Shireen Sestili]

yeah actually it says it doesn't exist, do you happen to know what may be the problem?

[Ilaria Shireen Sestili]

here is how I am saving them during the simulation.

Thanks a lot

[Fangjun Jiang]

It is inside the struct "out".

In Simulink model, press Ctrl+E, Data Import/Export, un-check "single simulation output"

[Ilaria Shireen Sestili]

although I can visualize them if I write out.TIS for example

[Ilaria Shireen Sestili]

thank you so much!!!

[Ilaria Shireen Sestili]

it works perfectly

Answer 2

[rough93]

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)

[Ilaria Shireen Sestili]

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]

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.

[Ilaria Shireen Sestili]

thanks!