Using Excel for Reports:

[FoxLearner]

Hi
My client asked me to generate the reports in Excel. Now the reports are generated in VFP reports(frx).
Can someone please tell me how to do this? I have 7 different reports for 7 regions. Is it possible to generate the reports in one Excel book, with 7 sheets?

Thanks and regards
FoxLearner

 

[mejiaks]

There is a tool named FRX2ANY that can export your FRX to xls, doc, rtf, you could try this.

also you could try OLE automation to do so

 

[baltman]

The best (fastest) way would be to write out an Excel compatible XML file. This requires Excel XP.

If you hand import the data into Excel, format it as you'd want and save as an XML file, you should be able to pick out the code you'd need to generate using wither textmerge or fwrite().

For an HTML example (without formatting), see faq184-3005. I'd go with XML if possible because it allows all of the information for multiple Excel sheets to exist in one file.

Excel COM automation works great too, but will be a whole lot slower if that matters to you.

Brian

Brian