LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

How to change width of cell in Excel using LabVIEW 5.1

Enable program to change width of cell in Excel 97 file using LabVIEW 5.1.
0 Kudos
Message 1 of 3
(3,282 Views)
You must have an automation reference to the workbook or the worksheet. Using Application Control pallette find the Property and Invode nodes and wire up the following, cascading the output of each node into the reference of the next:

Start with worksheet reference
Invoke Range
Property Entirecolumn
Property Columnwidth

Change Columnwidth to write and wire in the numeric value in pixels.

Michael
mmunroe@abcdefirm.com
http://www.abcdefirm.com
Michael Munroe, CLD, CTD, MCP
Automate 1M+ VI Search, Sort and Edit operations with Property Inspector 5.1, now with a new Interactive Window Manager!
Now supports full project automation using one-click custom macros or CLI.
Message 2 of 3
(3,282 Views)
Thanks for the help.

-iceman
0 Kudos
Message 3 of 3
(3,282 Views)