Specified matrix range to Excel file
2 次查看(过去 30 天)
显示 更早的评论
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 个评论
采纳的回答
Pouya Jamali
2017-4-29
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 个评论
更多回答(1 个)
Dominika Szt
2017-4-29
3 个评论
Image Analyst
2017-4-29
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.
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!