Generate a excel from ORACLE DB

[Anonymous]

Hello all,

I'm triyng to export to excel file base a oracle sql statement and getting the error below:

I'm sending the error and job screen attached

[vboppudi]

Please provide the ExcelFile properties screen shot. I think you have some issue with settings.

Regards,

[mks02]

@richardl
It seems from DB table, a column contain a string with \ character (escape character in Java) which is trying to write in excel file. So if you want this escape character \ in your string, you need to escape the escape character and type \\ for avoid this error.


Hope it helps!

Thanks,

[manodwhb · Accepted solution]

@richardl,when you were generating Excelfile,in file name you might have "\",please replace "\" with "/" and check.