Convert [4,5] to D5 for excel write

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

Answer 1

[Walter Roberson]

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

Answer 2

[Meaghan]

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?

Answer 3

[Iain]

 coordinate = ['A'-1+wanted_col num2str(wanted_row)];

It only works for up to "Z".

[Meaghan]

Thank you!