Ado export to Excel, html, txt and csv

[joseluispalma]

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]

FW_AdoToExcel( oRs/cSql ) --> oExcelSheet

[joseluispalma]

Thank you.

What about html, txt and csv?

[nageswaragunupudi]

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: Select all  Expand view

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