Maintaining Column Widths in Excel Template when using LabVIEW

Updated Jan 14, 2025

Reported In

Software

  • LabVIEW Report Generation Toolkit
  • LabVIEW

Other

Microsoft Excel

Issue Details

I have an Excel template where I have set the column widths according to my requirements. However, when I try to insert values into the template using LabVIEW, the column sizes automatically expand. How can I maintain the original column sizes in Excel while inserting data with LabVIEW?

Solution

You can use the Append Table to Report function. This function can be found under Programming>>Report Generation in Functions Palette. To maintain the original column widths of your Excel template, set the column width input to -1.