Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
XLS doc with multiple worksheets
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
XLS doc with multiple worksheets
Divers
Thread ID:
00933782
Message ID:
00933782
Vues:
65
I'm outputting data into excell spreadsheets. I'm having trouble finding out how to create xls docs with multiple worksheets.

*Create the object:
oExcel = CreateObject("Excel.Application")

*State how many worksheets will be in the xls doc via:
oExcel.SheetsInNewWorkBook = 4

*Open the doc I just made:
oWorkbook = oExcel.Workbooks.Open(cFileName)

*Rename the Sheet
oActiveSheet = oExcel.ActiveSheet
oActiveSheet.Name = "MyData"

I'm sure I'm missing steps... but after that how do I do the same for multiple sheets? Thanks in advance!
+=================================+
|John McCarthy, Programmer, MEG
+=================================+
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform