Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to Import XML produced by MS-Excel?
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00903822
Message ID:
00903864
Vues:
17
Thanks sergey, it works, but now I have another issue, as you should expect, now a have a beauty cursor with 7 rows, in this cursor I have a field called Table with all the information in the Worsheet I want to use. It's not necesary to say I'd like the information in that field, obviously as a cursor.
So?, do I need XMLAdapter? Or what else I can do?
TIA.

>Yes, you need flag 512 otherwise the first parameter is treated as a variable with XML stored in it.
   XMLToCursor(lcXMLFile,"cPagos", 512)
>Keep in mind that XMLToCursor() is designed to process simple XML which is created by CURSORTOXML() or close to it.

>>I have a XML file, it was produced by MS-Excel, if I try to convert with XMLToCursor function I get the error 1435, what do I need?
>>

>>lcXMLFile = GETFILE("xml")
>>IF NOT EMPTY(lcXMLFile)
>> XMLToCursor(lcXMLFile,"cPagos")
>>ENDIF
>>

>>
>>Do I need an especial flag?
Apoya a Visual FoxPro usandolo legalmente
--
¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º
Espartaco Palma Martínez
SysOp PortalFox
http://www.portalfox.com
esparta@portalfox.com
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform