Read from *.txt file and write to excel file

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 :)

[Rik]

Bit by bit.

What did you try already to read the data from you file?

What did you try in terms of the analys required?

Do you actually need the graphs in Excel? Or is it fine to have the processed data in Excel?

[Sapir Zuriat]

I try to understand how can I read the data from *.txt file?

in addition, it is fine to have the processed data in Excel.

[Johannes Hougaard]

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

Answer 1

[Pratik Pawar]

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