How to display an excel report in foxpro?
How to display an excel report in foxpro?
(OP)
I have a cursor as 'Absent_xl' and I want to create a excel report using this cursor data. And for this I'm using two options such as, "optexcel and optpdf'.
Whe I'm selecting 'optexcel' I want to display the excel report.
How can I do this?
Thank you
Whe I'm selecting 'optexcel' I want to display the excel report.
How can I do this?
Thank you
RE: How to display an excel report in foxpro?
My preferred option would be to use XFRX. This is a very useful tool for converting a VFP report to several different output formats, including Excel, Word, PDF and others. It is not free, but it is not very expensive. See eqeus.com.
Another option is FoxyPreviewer (which is free). Many developers use it as a substitute for the native VFP report preview. It also offers options for output to Excel, PDF and others. See www.foxypreviewer.com.
For a completely different approach, you could send your data direct to Excel using Automation. However, that's quite a bit more complicated, so I won't give you any detailed information unless you decide to go down that road.
Mike
__________________________________
Mike Lewis (Edinburgh, Scotland)
Visual FoxPro articles, tips and downloads
RE: How to display an excel report in foxpro?
CODE
The function BROWSER() just calls shellexecute if the file specified exists - code below, it calls MyFile as I don't like File()
CODE
Regards
ing
Griff
Keep
I'm trying to cut down on the use of shrieks (exclamation marks), I'm told they are !good for you.
There is no place like G28 X0 Y0 Z0
RE: How to display an excel report in foxpro?
Do you want to create an Excel-sheet and copy the data from a VFP table to it? If that's the case please have a look at the following commands APPEND FROM, COPY TO, Import, Export.
hth
MarK
RE: How to display an excel report in foxpro?
Mike
__________________________________
Mike Lewis (Edinburgh, Scotland)
Visual FoxPro articles, tips and downloads
RE: How to display an excel report in foxpro?
Aside of that, the simplest option surely is COPY TO with TYPE XLS or XL5 or EXPORT.
And a third option is using Vilhelm-Ion Praisachs export libraries. You find lots of options on http://praisachion.blogspot.com/search?q=export
Chriss
RE: How to display an excel report in foxpro?
Tamar