Jump to content

Excel range conversion


Recommended Posts

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

Link to comment
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:

Link to comment
  • 6 months later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.