topic Re: Generate a excel from ORACLE DB in Talend Studio

Generate a excel from ORACLE DB

Anonymous — Wed, 09 May 2018 19:09:32 GMT

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

Re: Generate a excel from ORACLE DB

vboppudi — Wed, 09 May 2018 20:05:45 GMT

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

Regards,

Re: Generate a excel from ORACLE DB

mks02 — Wed, 09 May 2018 20:23:52 GMT

@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,

Re: Generate a excel from ORACLE DB

manodwhb — Thu, 10 May 2018 13:42:44 GMT

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