bimbim Posted March 8, 2005 Report Share Posted March 8, 2005 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 Quote Link to comment
pckost Posted March 8, 2005 Report Share Posted March 8, 2005 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: Quote Link to comment
jbrohan Posted March 8, 2005 Report Share Posted March 8, 2005 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 Quote Link to comment
bimbim Posted March 9, 2005 Author Report Share Posted March 9, 2005 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 Quote Link to comment
bimbim Posted September 15, 2005 Author Report Share Posted September 15, 2005 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: Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.