VFP9 ReportListner and Excel  
Author Message
mathiasb





PostPosted: Visual FoxPro General, VFP9 ReportListner and Excel Top

Hi All,

Has anyone managed to turn the xml output generated by vfp9's reportlistner into a cursor

I would like to then turn the cursor into an excel worksheet adding all the formating and formulae for subtotals etc etc

But xmtocursor() generates "XML parse error:field name is invalid or duplicate...."

Help please

Mathias




Visual FoxPro1  
 
 
SuperFox





PostPosted: Visual FoxPro General, VFP9 ReportListner and Excel Top

I have not used xmltocursor, but if I wanted to turn a cursor into an excel spreadsheet I would use:

EXPORT TO filename TYPE xls

Then you can open it with Excel.


 
 
mathiasb





PostPosted: Visual FoxPro General, VFP9 ReportListner and Excel Top

Your suggestion SuperFox is what would be the final piece to the jigsaw.

The idea is use the reporting capabilities in the reportlistner first. The output is user driven and so the cursor doesn't exist as such. The listner does export to xml though, so I want to "xml-to-cursor" the output then, I can do what you are suggesting here.