auto columns width (in Excel)

[prog]

Help me plase!
When I export data from LabView to Excel, cells (in Excel) has standart width. Which column property (in LV) make auto column width (in Excel)?

[m3nth]

If you're using standard functions (not the ActiveX Excel stuff), I don't think there's a way to autosize the columns.

That's easy enough in Excel though:

Shade all your columns with data and double click one of the column resize bars (the vertical bar between column A header and column B header for example). Wa-la... all shaded columns get auto-sized.

[prog]

I want do to this from LV (not in Excel document)!

[m3nth]

Your best bet then will be to download an LV ActiveX Excel library such as the one written by Philips Research for Excel 97 (easily modifiable for later versions of Excel). I'm not sure if the functions available via ActiveX will be able to do what you want, but they do a whole lot more than just exporting data. You might be able to figure out how to do what you're trying to do with a good LV Excel library and a little bit of research into the ActiveX methods and properties available for an Excel worksheet.

[Michael_Munroe]

If you are using ActiveX to control Excel, you can import your data into a new workbook. Then use the ActiveX property Columns to feed the method AutoFit.

[m3nth]

Bingo!