auto size column width in repor generation toolkit

[karpaga]

Im using RGT for excel creating tables i excel i wan to auto size the column width automatically.how to do this?

[GerdW]

To summarize for others:

kavi wants to:
- auto size column width (in Excel)

- change table headers font and size (in Excel)

- change table headers orientation (in Excel)

- combine ActiveX and ReportGenerationToolkit to control Excel

[smercurio_fc]

Basically everything you want to do needs to be done with ActiveX. The Report Generation Toolkit does just that. If there's something you need to do that the RGT doesn't do, then you need to use Excel's object model to call the properties and methods to do what you want. This information is in the Excel documentation, not the LabVIEW documentation. Examples ship with LabVIEW on how to use ActiveX to control Excel. There have also been tons of examples posted on this forum on various operations on Excel. Search and you will find them. There are also lots of examples in the Excel thread.

Message Edited by smercurio_fc on 08-30-2009 09:18 AM