Read from *.txt file and write to excel file
44 次查看(过去 30 天)
显示 更早的评论
I need to read with Matlab from *.txt file which have few columns - let's say 10 columns.
after I read it, I need to analyze this data and to make graphs in new excel file.
what are the recommended ways for doing a mission like this?
thank you for your help in advance :)
3 个评论
Johannes Hougaard
2022-5-4
Could you include an example of your txt file?
I think your cause of action would include something using readtable and writetable, but if you include a txt file and some of the code bits that didn't do it for you it would be way easier to help you
回答(1 个)
Pratik Pawar
2022-5-18
编辑:Pratik Pawar
2022-5-18
You can use the 'readtable' function to read column-oriented data from .txt file and the 'writetable' function to export data from workspace to any worksheet in the file or to any location within that worksheet.
Please refer to the code below:
>> T = readtable('myTxtFile.txt');
% Here you can analyze this table data
>> filename = 'myExcelFile.xlsx';
>> writetable(T, filename, 'Sheet', 1);
For example, suppose you have a text file myTxtFile.txt as shown below, then the code will generate myExcelFile.xlsx after execution.
myTxtFile.txt myExcelFile.xlsx
0 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!