how to save variables

1 view (last 30 days)
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 Comment
KSSV
KSSV on 22 Jul 2020
You can save them into .mat file. REad about save.

Sign in to comment.

Accepted Answer

Fangjun Jiang
Fangjun Jiang on 22 Jul 2020
xlswrite('MyFile.xlsx',[product, TIS, error, error2])
  9 Comments
Ilaria Shireen Sestili
Ilaria Shireen Sestili on 22 Jul 2020
it works perfectly

Sign in to comment.

More Answers (1)

rough93
rough93 on 22 Jul 2020
Edited: rough93 on 22 Jul 2020
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 Comments

Sign in to comment.

Tags

Community Treasure Hunt

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

Start Hunting!