saveas method allow to save the resultSet object in different formats
result.save(format,filename)
Data always saved in Encoding UTF 8 format
Format |
Description |
psr |
save data with format in psr file format |
xml |
save data in xml format |
csv |
save data in csv format |
clipboard |
copy data to clipboard |
dbase3 |
save data in dbase 3 format |
json |
save as json |
text |
Tab-separated columns with a return at the end of each row |
xls |
save in Excel 8 (xls) format |
sqlinsert |
export as SQL syntax with insert commands |
htmltable |
save as html table with TABLE, TR and TD elements |