How to read .txt and convert to .xlsx?
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
I have a .txt file with 135 columns and around 1000 rows. I want to convert it into an excel file. However when I use importdata, some of the rows are read as string and stuffed into one cell. I have also tried textscan but I get the error 'Index exceeds matrix dimensions.'. How do I write a code where each row in .txt will be written in its separate cell in .xlsx for all 1000 rows?
1 Kommentar
Walter Roberson
am 20 Aug. 2018
readtable() and then writetable() .
Depending how the .txt file is divided internally, it might be easier to use detectImportOptions() before the readtable() .
Antworten (0)
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!