conversion .txt to .xls

1 次查看（过去 30 天）

显示更早的评论

Ahmed BOULMANE 2016-4-22

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/280405-conversion-txt-to-xls

关闭： MATLAB Answer Bot 2021-8-20

hello, please, how can I convert a txt file to an Excel file

3 个评论
显示 1更早的评论隐藏 1更早的评论

Stephen23 2016-4-27

编辑：Stephen23 2016-4-27

Please upload an example file so that we can actually test our code on something.

Ahmed BOULMANE 2016-4-28

EXP.txt

here is the file,

此问题已关闭。

回答（1 个）

Walter Roberson 2016-4-25

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/280405-conversion-txt-to-xls#answer_219302

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 个评论
显示 5更早的评论隐藏 5更早的评论

Ahmed BOULMANE 2016-4-28

I have always the same number of group, but the number of row and column change

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.

此问题已关闭。