Loading a text file and generating a .xls file from that
1 view (last 30 days)
Show older comments
Sanwal Yousaf
on 5 Jan 2016
Answered: Walter Roberson
on 5 Jan 2016
I was wondering if there were any functions or a way that i could look at where i could import or load a .txt file and convert it to .xls file automatically rather than doing it manually.
0 Comments
Accepted Answer
Walter Roberson
on 5 Jan 2016
You would need at least two calls.
xlswrite('YourOutput.xls', load('TheTextFile.txt', '-ascii'));
For this short form to work, the txt file would have to consist of pure numeric values, the same number of columns in every row, and space separated. If that is not the format of your .txt file then the processing involved might be longer.
0 Comments
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!