Create .csv output with 'sheets' like excel?

Question

kschau 2013-6-11

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/78709-create-csv-output-with-sheets-like-excel

评论： Walter Roberson 2022-6-26

Hey all

I am compiling a standalone executable to import .csv files, perform operations, compile the results, and export the results to an excel file, with different sheets that are labeled

CH1 CH2 CH3 etc.

This works great, I use xlswrite to write to sheet 1, 2, 3 etc. then use the

'actxserver('Excel.Application')'

to rename sheet 1, 2, 3 etc to the appropriate name.

This works fine, except if the computing running the executable does not have excel (rare as that would be, they exist in my universe) and the 'actxserver' is stopped in its tracks because it has no Excel Application to discover.

Is there a way to just write a .csv file with 'sheet' names instead that will be essentially the same thing when opened on a computer with excel or some other application?

Thanks for the advice as always

kyle

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

Walter Roberson 2022-6-26

csv file format does not support sheets

Walter Roberson 2022-6-26

These days you would usually use writetable() or writematrix()

请先登录，再进行评论。

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

Answer 1

Iain 2013-6-11

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/78709-create-csv-output-with-sheets-like-excel#answer_88464

Simple answer: No. CSVs are plain text files and there is way to split them into sheets.

Complex answer: If you save a CSV per sheet, then you can actually write a VBA program which will open the entire set of CSVs, and collate them into a single spreadsheet.