Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
AutoFitWidth in ExcelML
Message
From
18/03/2013 15:23:09
Michel Fournier
Level Extreme Inc.
Petit-Rocher, New Brunswick, Canada
 
 
To
18/03/2013 13:34:42
Sylvain Larin
Montréal, Quebec, Canada
General information
Forum:
Microsoft Office
Category:
Excel
Title:
Re: AutoFitWidth in ExcelML
Environment versions
Microsoft Office:
Office 2010
Miscellaneous
Thread ID:
01568605
Message ID:
01568737
Views:
25
>This should work:
loExcel = CREATEOBJECT ("Excel.Application")
>...
>loExcel.Columns.EntireColumn.AutoFit()
After more research on this, this option is only supported for datetime and numeric values. This cannot be applied to string values.

Note also that I am doing everything in XML, thus some of the functionalities may not be supported.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform