How to write specific rows and columns to excel sheet
5 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
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 Kommentare
Antworten (2)
Jan
am 15 Apr. 2013
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 Kommentare
Azzi Abdelmalek
am 15 Apr. 2013
% If A is your matrix
B=A(3000:6000,:)
xlswrite('yourfile.xls',B)
0 Kommentare
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!