Read from *.txt file and write to excel file
40 views (last 30 days)
Show older comments
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 Comments
Johannes Hougaard
on 4 May 2022
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
Answers (1)
Pratik Pawar
on 18 May 2022
Edited: Pratik Pawar
on 18 May 2022
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 Comments
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!