Export part of the matrix to excel

I understand that a matrix output could be exported to excel using the writematrix command. But it has a limit when it is a large matrix. I got the following error 'The data block starting at cell 'A1' exceeds the sheet boundaries by 0 row(s) and 249744 column(s)'. Is it possible that I can extract part of the matrix to excel in matlab?

[Image Analyst]

What is the size of your matrix, and what section do you want to extract and export to Excel?

If you have any more questions, then attach your data and code to read it in with the paperclip icon after you read this:

TUTORIAL: How to ask a question (on Answers) and get a fast answer

Answer 1

[Animesh Gupta]

Hello,

It is my understansing that you want to extract part of the matrix and export it to excel.

The interested part of the matrix can be extracted by using square brackets and then extracted using writematrix.

You may refer the following script to understand the procedure

arr = rand(1024,100024);
writematrix(arr([1:100], [1:744]), 'out.xlsx'); % () are used for indexing and [] are used for truncation.

Please note that MATLAB supports .xls, .xlsm, .xlsx formats of excel to export to. Based on the upper limit of rows and columns, any of these can be chosen.

I hope it helps.