Leaving a line after writing to an excel sheet
Show older comments
I am writing a matrices to an excel sheet and after writing every matrix, I want to leave a line (row in excel) such that the matrices are not mixed up.
For e.g.,
A B C D ......
1 Matrix 1
2
3 Matrix 2
4
5 Matrix 3
6
7 Matrix 4
8
3 Comments
dpb
on 24 Jun 2021
That's just a simple bookkeeping exercise in you code that does the writing -- you need to keep a running sum of the row size of each array written plus the extra record and begin the next write at the proper row number.
Ketan Shende
on 24 Jun 2021
dpb
on 25 Jun 2021
Why don't you start with what you've gotten so far...
Answers (1)
Swatantra Mahato
on 28 Jun 2021
0 votes
Hi Ketan,
You can refer the examples in the documentation for the "writematrix" function to get started on writing matrices to a particular position in an Excel worksheet
Hope this helps
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!