Hi:
VFP 90 is able to generate output to XML format. Great !!
Excel is able to import file from XML format. Great !!
So, we are trying to combine both tools. The problem is that VFP XML file
contain the FRX table. The results in XLS format aren't the expected.
But, in Data section of XML are stored our values with captions and so on.
How could we obtain Excel table from XML file generate by VFP 90
Is it possible
Thank you.
--
Regards,
Ana
Madrid, Spain
www.amby.net
Reports VFP 90 Output to Excel
Hot Topic
- Date problem in VFP 6.0
- USB Modem (serial) communication question
- MSGraph.Chart.8 control
- Cancel Button Does not work--A known bug?
- seek char+date
- Data Retrieval Slow with VFP 9 OLEDB Driver and Crystal Reports 10
- VFP9 printing issue with multiple detail bands and group subtotals and/or summary totals
- Runing Total
- use the reccount
- function argument is invalid...
Visual FoxPro
- editbox programmatic change
- my SQL passthrough problem
- Calling a report with a command button on a form
- memo file corrupt
- newbie question
- How to show images(pictures) in RTF control??? (like chat...)
- Urgent : Question abt using MDI form in VFP
- How using barcode in VFP?
- Foxpro, or Access, or Filemaker?
- Determining opened files
Reports VFP 90 Output to Excel
KeWin
Hi Ana
I don't know the answer to your specific question but I would not do it this way anyway. Instead of sending the FRX to Excel why not just create the cursor for the report and send that
Presumably the XML for the FRX includes all the necessary formatting fields, and values, required to re-create the original FRX/FRT tables from the XML - but Excel doesn't work with FRX/FRT - all it wants is the actual data.
So I would just send the data in the XML file and then apply whatever formatting is necessary to the results in Excel.
Julien Gourdet SOPRA
Hi Andy:
I agree with you.
I have found that VFP give us the possibility of send just the data to the XML from ReportListener XML Foundation Class. There is XMLMode property. If we set XMLMode = 0 (OUTPUTXML_DATA_ONLY) will be just the data in the XML file.
But, at the time we are importing to Excel file, the results aren't that I need. There is an odd format. I'm afraid will be necessary develop and extra code for transforming. The good news here is that I've found something interesting in http://reportlistener.com/files Maybe it will be useful. Let's see.
Thanks Andy,
Regards,
Ana