Insert Single or Multiple Data into Excel File Without Using Table Format

Updated Oct 27, 2020



  • LabVIEW Report Generation Toolkit

I know I can insert data into Excel file by using Excel Easy, for example. But when I use this function, I found unnecessary ruled line around data I inserted and my template file was unexpectedly modified. How can I avoid this ?

Basically, Excel Easy in Report Generation Toolkit has auto format option which allows you to choose table type that is applied for your data.
If you want to just insert data into your Excel file, you can implement the functionality by following manner. In the image below, using Report Generation Toolkit is assumed.
Input row and column information into Row Col To Range and wire output of this function into Range.

Row Col To Range is placed in the following path (the function name can be
C:\Program Files (x86)\National Instruments\<LabVIEW version>\vi.lib\imath\common

If you want to insert multiple data like Table format but still you do not want any ruled line to be included, you can modify the code something like below.
Note that above-mentioned code is implemented as sub vi called