How to make a xlsx file to a comma delimited csv file?
2 views (last 30 days)
Show older comments
Zeynab Mousavikhamene
on 24 Mar 2021
Commented: Walter Roberson
on 24 Mar 2021
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 Comments
Accepted Answer
Walter Roberson
on 24 Mar 2021
readtable and writetable
2 Comments
Walter Roberson
on 24 Mar 2021
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)
More Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!