MATLAB Answers

Specified matrix range to Excel file

3 views (last 30 days)
Hi everyone! I am trying to export matrix A to Excel file. The matrix is quite big and I need only specified rows of it (e.g. from 8 to 12 - it's 4 rows). When I use:
Range = 'A8:Z12'
xlswrite('file',A,Range);
it exports not the 8-12 matrix rows, but saves first 4 rows in 8-12 range in Excel. Does anyone of you know how to solve this problem?

  0 Comments

Sign in to comment.

Accepted Answer

Pouya Jamali
Pouya Jamali on 29 Apr 2017
Hi,
Did you try using a medium variable? I mean before you try to save your matrix A in an Excel file save those elements you want in another Matrix, lets say aux_A then save it into an Excel file.

  0 Comments

Sign in to comment.

More Answers (1)

Dominika Szt
Dominika Szt on 29 Apr 2017
Och, you're right, now it looks perfect. Thank you very much!

  3 Comments

Pouya Jamali
Pouya Jamali on 29 Apr 2017
Wish you luck!
Please don't forget to accept right answers.
Dominika Szt
Dominika Szt on 29 Apr 2017
Ok, thanks. I'm a fresh user so any tips are welcomed :)
Image Analyst
Image Analyst on 29 Apr 2017
Here's another tip, if you're willing to learn how to use ActiveX to gain total and complete control over Excel. See attached demo that only breaks the surface of what you can do with ActiveX. Basically ActiveX lets you do anything from MATLAB that you could do manually or from a macro in Excel itself.

Sign in to comment.

Sign in to answer this question.