Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Expand column in excel view
Message
From
16/05/2012 00:02:04
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Expand column in excel view
Miscellaneous
Thread ID:
01543652
Message ID:
01543652
Views:
60
When i open an excel file the columns are crammed to default 10 or 12 spaces so may entries appear cut off.
is there a command to expand column for viewing
let's say expand a column called 'mynames' to 31 spaces - or perhaps increase size to longest name in that column
oWorkbook = oExcel.Application.Workbooks.Open ("C/:mytable.xls")
oExcel.Visible = .T.
oExcel.Application.UserControl=.T.
oExcel.Application.Interactive=.T.
thanks k
Next
Reply
Map
View

Click here to load this message in the networking platform