From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, ni.com will undergo system upgrades that may result in temporary service interruption.
We appreciate your patience as we improve our online experience.
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.
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.
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.