Convert [4,5] to D5 for excel write

2013 6 3
3 个回答
回答已采纳
3 次查看（30 天）

0 个投票

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

请先登录，再回答此问题。

 采纳的回答

Walter Roberson
Walter Roberson 2013-6-3

0 个投票

Convert to base 26, add 1 to each digit, and use the result to index 'A':'Z' to find the characters.

更多回答（2 个）

Meaghan
Meaghan 2013-6-3

0 个投票

Thanks! I got it to convert a letter, now I have the column and row as two different variables and need to combine them as one. Any further suggestions?
Iain
Iain 2013-6-3

0 个投票

coordinate = ['A'-1+wanted_col num2str(wanted_row)];
It only works for up to "Z".

类别

在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by