Page 1 of 1

REPORT export to Excel

Posted: Wed Jan 05, 2011 9:50 am
by ukservice
Is possible?

Thank you

Re: REPORT export to Excel

Posted: Wed Jan 05, 2011 12:11 pm
by Marcelo Via Giglio

Re: REPORT export to Excel

Posted: Wed Jan 05, 2011 1:49 pm
by TecniSoftware
Los links a la clase repexcel estan muertos.
Alguien tiene una copia ?

Muchas gracias

Re: REPORT export to Excel

Posted: Thu Jan 06, 2011 10:01 am
by ukservice
Hi,

Links are broken!!.

Thanks

Re: REPORT export to Excel

Posted: Fri Jan 07, 2011 10:36 am
by anserkk
Links are broken!!.
ReplExcel
http://rapidshare.com/files/441396864/RepExcel.zip

Regards
Anser

Re: REPORT export to Excel

Posted: Fri Jan 07, 2011 1:47 pm
by TecniSoftware
Thanks for the links!


Best regards

Re: REPORT export to Excel

Posted: Fri Jan 14, 2011 8:39 pm
by ukservice
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?

Re: REPORT export to Excel

Posted: Mon Jan 17, 2011 3:26 pm
by reinaldocrespo
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.

Re: REPORT export to Excel

Posted: Tue Jan 18, 2011 1:55 pm
by jose_murugosa
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 :D

Espero sea de ayuda. :)