フィルターのクリア

How to write specific rows and columns to excel sheet

5 ビュー (過去 30 日間)
Muhammad
Muhammad 2013 年 4 月 15 日
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.

回答 (2 件)

Jan
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, :));

Azzi Abdelmalek
Azzi Abdelmalek 2013 年 4 月 15 日
% If A is your matrix
B=A(3000:6000,:)
xlswrite('yourfile.xls',B)

カテゴリ

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