AutoFit Excel Columns and Rows

[Sarci1]

Overview
The example is to demonstrate how to open an excel file with the feature of auto fit enabled automatically

Description:
By using the file reference and New Report VI, we could practically make a new report file in the xls format that would be processed into the format of auto fit so by the time the file is opened, the user could face the file represented in the auto fit format

Steps to Implement or Execute Code:
To implement this example:

1. Define the directory of the file
2. Run the VI
3. (Optional) Turn on the Highlight Execution to see the flow of the VI

To execute this example:

1. Install the required software.
2. Open the VI and refer the Implement Steps

Requirements
Software
LabVIEW 2012 or compatible

Hardware
-

**This document has been updated to meet the current required format for the NI Code Exchange.**

[deaw42]

Sarci1,

    thank you for this VI and guidance with good explanation.

[TimsTools]

The example for LV 2010 worked great.  Uses the active Excel spreadsheet, so simply use the Report Generation Toolkit to select the desired spreadsheet before using this method.  Will attach a VI that workes in flow after this comment.

[asukumari]

What if we want to set the column width to a set value. How do we do that?