How can I save a table to excel file so that all excel cells have not specific format?

2 views (last 30 days)
How can I save a table to excel file so that all excel cells have not specific format (so not text or number but general)?
Thanks in advance

Answers (1)

Cris LaPierre
Cris LaPierre on 16 Nov 2021
Edited: Cris LaPierre on 16 Nov 2021
Use writetable. A quick test showed a table containing text and numbers that I saved using writetable was using the general format in the excel spreadsheet.

Community Treasure Hunt

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

Start Hunting!