Excel range conversion

[bimbim]

Hi everybody,

I found a Vi that converts indexes to Excel range on http://forums.ni.com/ni/board/message?board.id=170&message.id=84295&requireLogin=False but I can't find the reciprocal, i.e how to convert row and column indexes of an array (numerical) to Excel row and column format (A1, etc.)

It should already exists so if someone knows the appropriate VI...

Maybe just a VI that provides the column (or row) names from the column (or row) number is enought.

Thank you in advance.

bim

[pckost]

Hi everybody,

I found a Vi that converts indexes to Excel range on http://forums.ni.com/ni/board/message?board.id=170&message.id=84295&requireLogin=False but I can't find the reciprocal, i.e how to convert row and column indexes of an array (numerical) to Excel row and column format (A1, etc.)

It should already exists so if someone knows the appropriate VI...

Maybe just a VI that provides the column (or row) names from the column (or row) number is enought.

Thank you in advance.

bim

4161[/snapback]

In the LabVIEW example finder "communicating with external applications/activex/excel/write table to xl.vi" there is a sub vi called "Row Col to Range Format.vi that takes care of this.

I hope this helps!

:thumbup:

[jbrohan]

Hello

I have one that has been working for a while. It converts only one and two letter columns to numeric. If you generalize it and test it, I'll be glad to see it back!

Download File:post-230-1110321244.vi

[bimbim]

OK, thank you all!

jbrohan, I'll test your VI and (if necessary) modify it. Be sure I 'll return it to you as soon as possible.

Thanks again, have a good day!

bim

[bimbim]

OK, thank you all!

jbrohan, I'll test your VI and (if necessary) modify it. Be sure I 'll return it to you as soon as possible.

Thanks again, have a good day!

bim

No problem...everything's running well.

Thank you again! :thumbup: