topic-39832

Board index FiveWin for Harbour/xHarbour Ado export to Excel, html, txt and csv

Posts: 109

Joined: Mon Apr 30, 2012 09:10 AM

Ado export to Excel, html, txt and csv
Posted: Tue Jan 05, 2021 02:51 AM

Hello,

Happy New Year first. I would like to know if Fivewin already has a set of ADO functions to export the table to Excel, html, txt and csv. Thank you and greetings

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: Ado export to Excel, html, txt and csv
Posted: Wed Jan 06, 2021 09:23 PM

FW_AdoToExcel( oRs/cSql ) --> oExcelSheet

Regards

G. N. Rao.

Hyderabad, India

joseluispalma

Posts: 109

Joined: Mon Apr 30, 2012 09:10 AM

Re: Ado export to Excel, html, txt and csv
Posted: Thu Jan 07, 2021 01:18 PM

Thank you.

What about html, txt and csv?

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: Ado export to Excel, html, txt and csv
Posted: Thu Jan 07, 2021 08:16 PM

Once we have oExcelSheet object, we can save it as HTML, csv, or text.

Now that we see your interest in these features, we are adding individual function for export to xlsx, HTML, csv, txt and pdf both with and without using excel.

Meanwhile, you may like to test this:

Code (fw): Select all Collapse

   ? oRs:GetString( AdoDefault(), 2 )
   ? oRs:GetString( 2, AdoDefault(), ",", CRLF, "" )

Regards

G. N. Rao.

Hyderabad, India

FiveTech Support Forums

Continue the discussion