Convert [4,5] to D5 for excel write
3 views (last 30 days)
Show older comments
Hi,
I have a loop that continuously generates data that gets written one at a time. Problem is that the cell that gets called is named as a spot in a matrix ie 4,5. In order to excel write i need to say D5.
Any ideas?
Thanks
0 Comments
Accepted Answer
Walter Roberson
on 3 Jun 2013
Convert to base 26, add 1 to each digit, and use the result to index 'A':'Z' to find the characters.
0 Comments
More Answers (2)
See Also
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!