How to make a xlsx file to a comma delimited csv file?

Question

Zeynab Mousavikhamene 2021-3-24

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/781703-how-to-make-a-xlsx-file-to-a-comma-delimited-csv-file

评论： Walter Roberson 2021-3-24

I need to covert a xlsx file to a comma delimited csv file. writematrix is not a good option as its input is matrix and in my case the data look like this:

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2021-3-24

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/781703-how-to-make-a-xlsx-file-to-a-comma-delimited-csv-file#answer_656313

readtable and writetable

2 个评论
显示无隐藏无

Zeynab Mousavikhamene 2021-3-24

编辑：Zeynab Mousavikhamene 2021-3-24

How to make it vice versa? I have csv file and want to convert to xlsx. The file looks like the above image.

Walter Roberson 2021-3-24

readtable and writetable again. Both of them can read and write csv and xlsx. There are some differences on the ability to write into selective locations, so which you are using for output can matter, but for this particular purpose the code is simple (provided that the column headings are valid matlab variable names; if not then newer matlab can handle the situation but not older matlab)

请先登录，再进行评论。