Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Copy to blah.xls type xl5 loses column widths
Message
 
À
01/03/2005 02:19:31
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 8 SP1
Divers
Thread ID:
00991053
Message ID:
01004399
Vues:
31
Hi Shafid. Excel isn't on the server. Probably won't put office on there because of the added security risk.

>Hi Evan
>
>I've had the same problem, so now I copy the file to xl5 then use this code to extend the date field :
>
>********* modify excel files column width
>oXL = CREATEOBJECT( [Excel.Application] )
>lcXlFile = "name of excel file"
>oWb = oXL.Workbooks.Open( lcXlFile )
>oSheet = oWb.ActiveSheet
>oSheet.columns( "A:A" ).columnWidth = 9.2
>osheet.Columns( "A:A" ).NumberFormat = "m/d/yyyy"
>oWb.Save()
>oXL.Quit()
>
>This fixes the date width problem. Hope this helps.
>
>Shafid
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform