Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Creating spreadsheets
Message
De
14/07/2002 18:03:07
 
 
À
14/07/2002 14:42:08
Alan Harris-Reid
Baseline Data Services
Devon, Royaume Uni
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00678510
Message ID:
00678531
Vues:
16
>2. The OLE-created spreadsheet by default has 3 sheets. Do I have to delete sheets 2 and 3 programmatically, or is there a way to create the workbook with one sheet only? Come to think of it, do I have to create a workbook at all? Can I create a single sheet by itself?
oXL = CreateObject("Excel.Application")
oXL.SheetsInNewWorkbook = 1
oWorkBook = oXL.Workbooks.Add
...
As per your other question on Excel clashing with VFP I am not sure. Will have to look into it.


Alex Feldstein, MCP, Microsoft MVP
VFP Tips: English - Spanish
Website - Blog - Photo Gallery


"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform