Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Import MEMO fields from Excell xls files
Message
 
 
À
25/04/2002 13:23:59
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00649136
Message ID:
00649220
Vues:
13
Alan,

Sorry, I typed that on the fly... one of those endwiths shoulda been an endfor. It's corrected below
m_xlsfile = getfile('xls')
oExcel = createobject( "excel.application" )
oExcel.Visible = .t.

oWorkbook = oExcel.Workbooks
oWorkbook.Open( m_xlsfile )

oSheet = oExcel.ActiveSheet

for each oRow in oSheet.Rows
   ?? '.'
   with oRow
      for each oCol in oRow.Cloumns
         ? oCol.Value
      endfor
   endwith
endfor

oWorkbook.Close()
oExcel.Quit()
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform