Page 1 of 1
Ado export to Excel, html, txt and csv
Posted: Tue Jan 05, 2021 2:51 am
by 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
Re: Ado export to Excel, html, txt and csv
Posted: Wed Jan 06, 2021 9:23 pm
by nageswaragunupudi
FW_AdoToExcel( oRs/cSql ) --> oExcelSheet
Re: Ado export to Excel, html, txt and csv
Posted: Thu Jan 07, 2021 1:18 pm
by joseluispalma
Thank you.
What about html, txt and csv?
Re: Ado export to Excel, html, txt and csv
Posted: Thu Jan 07, 2021 8:16 pm
by 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
? oRs:GetString( AdoDefault(), 2 )
? oRs:GetString( 2, AdoDefault(), ",", CRLF, "" )