Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
List Excel worksheets
Message
De
23/03/2004 11:07:24
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
23/03/2004 10:54:11
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00888885
Message ID:
00888892
Vues:
11
>Hi
>
>How would I return a list of worksheets from an excel spreadsheet.
>
>Thanks
>
>Nick Mason
lcFileName = GetFile('xls')
oExcel = createobject('Excel.Application')
oExcel.Workbooks.Open(m.lcFileName)
with oExcel.ActiveWorkbook
  dimension aSheets[.Sheets.Count]
  for ix=1 to .Sheets.Count
    aSheets[m.ix] = .Sheets(m.ix).Name
  endfor
endwith
oExcel.quit
disp memo like aSheets
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform