How to write specific rows and columns to excel sheet
5 ビュー (過去 30 日間)
古いコメントを表示
Hi, I want to export specific data from my matrix to excel sheet. For example: matrix dimension is 15000 x 500. i want to export data from row 3000 to 6000 to the excel sheet.
Thanking in anticipation, Best Regards.
0 件のコメント
回答 (2 件)
Jan
2013 年 4 月 15 日
The documentation of xlswrite explains, how to insert data in a specified range. See:
doc xlswrite
When you want to export a part of your data only, simple crop them by indexing:
data = rand(15000, 500);
xlswrite('FileName.xls', data(3000:6000, :));
0 件のコメント
Azzi Abdelmalek
2013 年 4 月 15 日
% If A is your matrix
B=A(3000:6000,:)
xlswrite('yourfile.xls',B)
0 件のコメント
参考
カテゴリ
Help Center および File Exchange で Spreadsheets についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!