Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel Worksheets....
Message
De
09/07/2002 13:32:24
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Programmation Orientée Object
Divers
Thread ID:
00676667
Message ID:
00676746
Vues:
15
>I am currently experiencing a problem while attempting to create a Microsoft Excel spreadsheet containing more than one worksheet. I have no problem creating 2 separate spreadsheets, but I cannot seem to link multiple worksheets to the same spreadsheet...
>

You can add worksheets to an existing workbook, using the
Worksheets.Add method:

oXL.ActiveWorkbook.Worksheets.Add()

You can control the number of sheets in a new workbook by setting the SheetsInNewWorkbook property of the Application object:

oXL.SheetsInNewWorkbook = 5

Tamar
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform