Read from *.txt file and write to excel file
36 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
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 comentarios
Johannes Hougaard
el 4 de Mayo de 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
Respuestas (1)
Pratik Pawar
el 18 de Mayo de 2022
Editada: Pratik Pawar
el 18 de Mayo de 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 comentarios
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!