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

11 views (last 30 days)
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:

Accepted Answer

Walter Roberson
Walter Roberson on 24 Mar 2021
readtable and writetable
  2 Comments
Zeynab Mousavikhamene
Zeynab Mousavikhamene on 24 Mar 2021
Edited: Zeynab Mousavikhamene on 24 Mar 2021
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
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)

Sign in to comment.

More Answers (0)

Tags

Community Treasure Hunt

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

Start Hunting!