Is possible?
Thank you
REPORT export to Excel
REPORT export to Excel
FWH 11.11, Harbour 3.1 and Borland C++ 5.82
-
- Posts: 1033
- Joined: Fri Oct 07, 2005 3:33 pm
- Location: Cochabamba - Bolivia
- TecniSoftware
- Posts: 213
- Joined: Fri Oct 28, 2005 6:29 pm
- Location: Quilmes, Buenos Aires, Argentina
Re: REPORT export to Excel
Los links a la clase repexcel estan muertos.Marcelo Via Giglio wrote:http://forums.fivetechsupport.com/viewtopic.php?t=3023
Alguien tiene una copia ?
Muchas gracias
Alejandro Cebolido
Buenos Aires, Argentina
Buenos Aires, Argentina
Re: REPORT export to Excel
Hi,
Links are broken!!.
Thanks
Links are broken!!.
Thanks
FWH 11.11, Harbour 3.1 and Borland C++ 5.82
- TecniSoftware
- Posts: 213
- Joined: Fri Oct 28, 2005 6:29 pm
- Location: Quilmes, Buenos Aires, Argentina
Re: REPORT export to Excel
Thanks for the links!
Best regards
Best regards
Alejandro Cebolido
Buenos Aires, Argentina
Buenos Aires, Argentina
Re: REPORT export to Excel
Hi,
It does not work. It says that method save() does not exist.
Anyone got it working?
Why does not standard FWH Report class support exporting to Excel, Word and Html?
It does not work. It says that method save() does not exist.
Anyone got it working?
Why does not standard FWH Report class support exporting to Excel, Word and Html?
FWH 11.11, Harbour 3.1 and Borland C++ 5.82
- reinaldocrespo
- Posts: 918
- Joined: Thu Nov 17, 2005 5:49 pm
- Location: Fort Lauderdale, FL
Re: REPORT export to Excel
ukservice;
You make a legitimate point. The change to treport that exports to excel using tfilexls class has been around for many years now. Why hasn't it been officially integrated? There is no logical answer.
Anyway- i do have it working. At least with Ramon Avendaño's tfilexls class. It works quite well. You need to add to your project the following prgs:
tSalxls.prg
mreport.prg
xlserror.prg
xlsfunc.prg
pdreport.prg
I must admit that it's been working so well for so long now, that I can't remember exactly how it works. Basically mreport inherits from treport taking care of everything and including a new method: :Saveas() where all you need is to call seding "excel" as parameter. Like this:
oreport:saveas( "excel" ) ...and you get a beautiful excel spreadsheet identical to the report, including lines, fonts, etc...
pdreport changes rptbegin(), rptend()... to call the new class declared in mreport. Some like that. But I've made so many changes to the prgs that ties it to the preview which I also had to change to allow for my own botton bar, I'm afraid my prgs will not work for you.
Maybe someone/somewhere has the original prgs from Ramon. I -myself got help on these very same forums years ago with the same subject and that's how I got the prgs in the first place. I'm sure many people are using Ramon's excel class.
Reinaldo.
You make a legitimate point. The change to treport that exports to excel using tfilexls class has been around for many years now. Why hasn't it been officially integrated? There is no logical answer.
Anyway- i do have it working. At least with Ramon Avendaño's tfilexls class. It works quite well. You need to add to your project the following prgs:
tSalxls.prg
mreport.prg
xlserror.prg
xlsfunc.prg
pdreport.prg
I must admit that it's been working so well for so long now, that I can't remember exactly how it works. Basically mreport inherits from treport taking care of everything and including a new method: :Saveas() where all you need is to call seding "excel" as parameter. Like this:
oreport:saveas( "excel" ) ...and you get a beautiful excel spreadsheet identical to the report, including lines, fonts, etc...
pdreport changes rptbegin(), rptend()... to call the new class declared in mreport. Some like that. But I've made so many changes to the prgs that ties it to the preview which I also had to change to allow for my own botton bar, I'm afraid my prgs will not work for you.
Maybe someone/somewhere has the original prgs from Ramon. I -myself got help on these very same forums years ago with the same subject and that's how I got the prgs in the first place. I'm sure many people are using Ramon's excel class.
Reinaldo.
- jose_murugosa
- Posts: 943
- Joined: Mon Feb 06, 2006 4:28 pm
- Location: Uruguay
- Contact:
Re: REPORT export to Excel
http://forums.fivetechsupport.com/viewt ... =17&t=6849
Para utilizar la clase repexcel se requiere de la lib repexcel y de la lib filexls.
Ambas y muchas otras las hallarás en el post arriba
Espero sea de ayuda.
Para utilizar la clase repexcel se requiere de la lib repexcel y de la lib filexls.
Ambas y muchas otras las hallarás en el post arriba
Espero sea de ayuda.
Saludos/Regards,
José Murugosa
FWH + Harbour + Bcc7. Una seda!
José Murugosa
FWH + Harbour + Bcc7. Una seda!