Reading very heavy .txt files and writing into .xlsx

2 ビュー (過去 30 日間)
Pankaj Yadav
Pankaj Yadav 2018 年 10 月 8 日
再開済み: Walter Roberson 2018 年 12 月 22 日
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!
  4 件のコメント
Kevin Chng
Kevin Chng 2018 年 10 月 8 日
Then we have to
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
Jan 2018 年 10 月 8 日
What exactly is a "heavy data file"? Which format does it have? What exactly is the problem? What have you tried so far?

サインインしてコメントする。

回答 (1 件)

ANKUR KUMAR
ANKUR KUMAR 2018 年 10 月 8 日
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.

カテゴリ

Help Center および File ExchangeSpreadsheets についてさらに検索

タグ

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by