Reading very heavy .txt files and writing into .xlsx

Hello, I have a very heavy data file and I have divided it into several parts but I don't know how to write those separated files into excel format.

Would be very helpful to get the code for that.

Thank you!

[Kevin Chng]

Combine multiple .txt file into a single excel file?

[Pankaj Yadav]

Yes!

[Kevin Chng]

Then we have to

1st step : Import your text file to MATLAB https://www.mathworks.com/help/matlab/import_export/ways-to-import-text-files.html

2nd step : Write to excel file

writetable()

if you are unsure with it, you may provide few of your files. So we can assist you better.

[Jan]

What exactly is a "heavy data file"? Which format does it have? What exactly is the problem? What have you tried so far?

Answer 1

[ANKUR KUMAR]

A=randi(10,50,50); %a random matrix to store in excel file
xlswrite('sample.xlsx',A,'sheet1','A1')

You can use 'sheet1' to write in sheet1 of excel file.

If you wish to save every output in different sheets, then keep on changing sheets.