How to Export VFP Report Form output to MS Excel Format

[1010ash1957]

Hi
We have an application written VFP 6.0 and would like to add function or addon which can convert VFP Report forms output to MS Excel format.

Please advise.

Thanks

 

[Mike Lewis]

There are several third-party tools that can do this. The one I use is XFRX (from

http://www.eqeus.com).

Or, you could do a search for FRX2ANY.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[JRB-Bldr]

Alternatively, you could by-pass going to the VFP Report Form at all and merely output your data to Excel directly by using either:

COPY TO <XLSFile> XL5 && which is somewhat 'raw' but functional
OR
Use Excel Automation where you can get Excel to do almost anything you want (select fonts, insert calculations, format cells, change cell backgrounds, borders, etc.). Somewhat tedious at first to develop, but it works well.

Good Luck,
JRB-Bldr

 

[Mike Lewis]

JRB-Bldr made a good point.

Often, when a client asks me to export a report to Excel, it turns out that what they really want is just the underlying data -- the body of the report -- in Excel. They don't want the report title, page headings, page numbers, etc. to be exported.

In those cases, using COPY TO is the best solution.

But, 1010ash1957, if you want to preserve the headings, page layout, formatting, etc of the report, then go with one of my original suggestions.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[mtchary]

Consider FRX2Any -

http://www.frx2any.com

- as an option

 

[alvechurchdata]

But, 1010ash1957, if you want to preserve the headings, page layout, formatting, etc of the report, then go with one of my original suggestions.

Also if you want to preserve things like totals and subtotals.

Geoff Franklin

http://www.alvechurchdata.co.uk