Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Create graphs and worksheet in excell from foxpro
Message
De
29/11/2004 06:07:59
Marcia Akins
Arkansas, États-Unis
 
 
À
28/11/2004 23:00:30
Shafid Khan
Khan Software Ltd
Motueka, Nouvelle Zélande
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Re: Create graphs and worksheet in excell from foxpro
Divers
Thread ID:
00965185
Message ID:
00965356
Vues:
11
When I create the excel file the date column does not show the full width so the data in the date field are "Hashes". If I open up the excel file and widen the date column, everthing looks sweet. Is there a way to open an existing excel file from the form, and adjust the date column size and shut the excel file ???
oXL = CREATEOBJECT( [Excel.Application] )
lcXlFile = GETFILE()
oWb = oXL.Workbooks.Open( lcXlFile )
oSheet = oWb.ActiveSheet
oSheet.Columns( "A:A" ).ColumnWidth = 10
oWb.Save()
oXL.Quit()
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform