LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

how to transfer number to Excel column letter

I want to write a table into Excel file with fomula "=AVERAGE(G18:G64)", how to transfer table column nunber into excel column letter?

 

for example, from table column 7, how to know 7 means G in excel?

 

thanks!


"I think therefore I am"
0 Kudos
Message 1 of 4
(1,611 Views)

Please use report generation toolkit.

 

Here is the snippet from RGT.

 

Excel Set location.png

Munna
Message 2 of 4
(1,577 Views)

 

thx!

I created one before, but yours is great!

 


"I think therefore I am"
0 Kudos
Message 3 of 4
(1,560 Views)

..this is why we can't have nice things...

 

Here is a VI that converts an Excel Column String notation "A", "BA" to the excel zero based column numeric. This is very handy when you want to allow a layman to create an excel cell insert map using the Letter column normenclature displayed in Excel: "AC".

 

I don't know why this does not exist in any of the MS Office routines, it can give you headaches to have to convert letters to numbers, then adjust for zero based.

 

Excel Column FP.png

 

Excel Column Diagram.png

0 Kudos
Message 4 of 4
(172 Views)