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

You can automate Excel to open the file and process it cell by cell from inside VFP.
oExcel = createobject( "excel.application" )
oExcel.Visible = .t.

oWorkbook = oExcel.Workbooks
oWorkbook.Open( "TheSpreadsheet.xls" )

oSheet = oExcel.ActiveSheet

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

oWorkbook.Close()
oExcel.Quit()
>I have a situation where I have data that comes to me in xls files. One of the colums can be very wide. In excess of 3000 characters.
>
>I have setup a table to append this data with that field being a memo field. When I append the xls file, the memo field is empty.
>
>Is there some better way to get the data into Fox table other than the append from command.
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