increment column reference in exel

[franckfischer]

Is there an easy way to write datas in an xl sheet in the "A" column and then to increment the reference to B, C, etc, to write datas of the next program runs ? Thank you.

[Aaron Marks]

You can right an entire range of values to Excel at one time. You can make the range an entire column or row. See if this example program helps:

http://zone.ni.com/devzone/explprog.nsf/webmain/FDBBD2BBA6084D9B86256682005E9758?opendocument&node=DZ53003_US

or

http://zone.ni.com/devzone/explprog.nsf/webmain/3DFFDCFE161A52028625663C007A4AC1?opendocument&node=DZ53003_US

[franckfischer]

In fact i saw this example. Start and end column have to be specified each program run. What I would like to do is to automatically increment the column reference from A to B, etc... at each run. For lines it is easy as it exists increment.vi. I have not found an easy way to change this reference for columns. I don't if it is possible. Thank you.

Franck.

[Aaron Marks]

All you really need is a VI capable of converting a column index 0,1,2... to an Excel column name A,B,C..
Then you can build your range strings dynamically. I created a quick VI that aught to do this for you and included a small example program. I'll attach them here.