2
How can i export the results of an Oracle query (oracleXe with Apex) to a javascript or vbscript array ?
i am using oracleXe with apex. I want to export the results of a query to excel while retaining formatting. This is possible if i export the results of the query to a javascript or vbscript array and use activex to export the results to excel.
You can make JAVA read the query results and create a .cvs file with the results. You might need JAVA to separate these query results with a comma so that it is in cvs format.
Then when it creates the cvs file, you can open it with excel and excel has the ability to parse the cvs file and it will display the results.
then just format the excel file the way you want and save it as an excel form.
EDIT: This is how I use JAVA to do it, I dont know if you can use the same method using VB. This is just an idea of what you can do.
Was this answer helpful?
LikeDislikeYou don’t need to go through all that.
Using Oravle Objects for OLE, you can push your data directly into an Excel spreadsheet.
Alternatively, you could do it the hard way with Odbc.
Was this answer helpful?
LikeDislike