Writing data from Matlab to Excel Macro sheet

3 次查看（过去 30 天）
kaivlya patel
kaivlya patel 2020-4-25
评论： kaivlya patel 2020-4-28
I want to export the data generated in Matlab, to be written into .xlsm file.
I have my Matlab file generated in C folder and my macro excel file is in D folder.
I wan to send this following data to the .xlsm file.
5×5 string array
"10" "HPP" "ELS" "HFS" "MINT"
"19" "HPP" "PC" "HFS" "MINT"
"21" "HPP" "PC" "HFS" "PR"
"" "" "" "" ""
"" "" "" "" ""
Any help would be really appreciated and I would be greatful.
  1 个评论
kaivlya patel
kaivlya patel 2020-4-25
the location of the excel file is : "D:\CVT\VBA\Practice of the tradspace updated file.xlsm" and I want to export the data from Matlab to this excel macro file

请先登录，再进行评论。

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

采纳的回答

Sai Sri Pathuri
Sai Sri Pathuri 2020-4-28
You may use writematrix function to write the string array to macro excel sheet by giving the full path of macro excel sheet as filename.
filename = 'D:\CVT\VBA\Practice of the tradspace updated file.xlsm';
writematrix(stringArray,filename);
  3 个评论
显示 1更早的评论
Sai Sri Pathuri
Sai Sri Pathuri 2020-4-28
If you want to write all the rows vertically, you may transpose the string array and write it
writematrix(stringArray',filename);
kaivlya patel
kaivlya patel 2020-4-28
I thaught so but was not sure but I checked it with some samll changes this works.
Thank you very much again for the help.

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by