Info
此问题已关闭。 请重新打开它进行编辑或回答。
conversion .txt to .xls
1 次查看(过去 30 天)
显示 更早的评论
hello, please, how can I convert a txt file to an Excel file
3 个评论
回答(1 个)
Walter Roberson
2016-4-25
Depending on the format of the text file, there are different ways of reading it. Sometimes it is enough to load() the file. Sometimes you need textscan(). Sometimes you need to do a log of work with parsing it. Try the import wizard; if it is able to handle the file then it can generate code for you.
If you end up with a numeric matrix, use num2cell() to convert it to cell array.
When you have a cell array, use xlswrite() to save it as xls file.
Note: if you are running on OS-X or Linux, or on MS Windows without Excel installed, then use the File Exchange contribution xlwrite() instead of xlswrite()
7 个评论
Walter Roberson
2016-4-28
I looked at your sample file with an editor. The difficulty of reading it in is going to depend upon exactly what data you want to extract out and into what variables. The difficulty is greatly increased if the "TOTAL =" data has to be extracted into the same variable as what it is being totaled.
Please show a sample output, indicating which values need to end up in which variables.
此问题已关闭。
另请参阅
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!