FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour REPORT export to Excel
Posts: 417
Joined: Tue Feb 23, 2010 03:09 PM
REPORT export to Excel
Posted: Wed Jan 05, 2011 09:50 AM

Is possible?

Thank you

FWH 11.11, Harbour 3.1 and Borland C++ 5.82
Posts: 1088
Joined: Fri Oct 07, 2005 03:33 PM
Re: REPORT export to Excel
Posted: Wed Jan 05, 2011 12:11 PM
Posts: 244
Joined: Fri Oct 28, 2005 06:29 PM
Re: REPORT export to Excel
Posted: Wed Jan 05, 2011 01:49 PM
Marcelo Via Giglio wrote:http://forums.fivetechsupport.com/viewtopic.php?t=3023


Los links a la clase repexcel estan muertos.
Alguien tiene una copia ?

Muchas gracias
Alejandro Cebolido

Buenos Aires, Argentina
Posts: 417
Joined: Tue Feb 23, 2010 03:09 PM
Re: REPORT export to Excel
Posted: Thu Jan 06, 2011 10:01 AM

Hi,

Links are broken!!.

Thanks

FWH 11.11, Harbour 3.1 and Borland C++ 5.82
Posts: 1335
Joined: Fri Jun 13, 2008 11:04 AM
Re: REPORT export to Excel
Posted: Fri Jan 07, 2011 10:36 AM
Links are broken!!.


ReplExcel
http://rapidshare.com/files/441396864/RepExcel.zip

Regards
Anser
Posts: 244
Joined: Fri Oct 28, 2005 06:29 PM
Re: REPORT export to Excel
Posted: Fri Jan 07, 2011 01:47 PM

Thanks for the links!

Best regards

Alejandro Cebolido

Buenos Aires, Argentina
Posts: 417
Joined: Tue Feb 23, 2010 03:09 PM
Re: REPORT export to Excel
Posted: Fri Jan 14, 2011 08:39 PM

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?

FWH 11.11, Harbour 3.1 and Borland C++ 5.82
Posts: 990
Joined: Thu Nov 17, 2005 05:49 PM
Re: REPORT export to Excel
Posted: Mon Jan 17, 2011 03:26 PM

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.

Posts: 1279
Joined: Mon Feb 06, 2006 04:28 PM
Re: REPORT export to Excel
Posted: Tue Jan 18, 2011 01:55 PM

viewtopic.php?f=17t=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. :)

&

Saludos/Regards,

José Murugosa

"Los errores en programación, siempre están entre la silla, el teclado y la IA!!"

Continue the discussion