topic Re: problem : Using Qlik Application Automation to create and distribute Excel reports in Office 365 in Qlik Automate

problem : Using Qlik Application Automation to create and distribute Excel reports in Office 365

Alejandro-juarez22 — Tue, 04 Oct 2022 20:12:10 GMT

empty table

real information

Re: problem : Using Qlik Application Automation to create and distribute Excel reports in Office 365

MattGrayndler — Tue, 04 Oct 2022 20:30:58 GMT

I might be easier if you add any issues with this specific automation to the comments of the automation template, that way others encountering similar issues will be able to see.

From other comments in that thread, this issue is often caused by double quote (") or backslash characters (\) existing in your source table.

I can see that you have quotes “ in your source table. This breaks the formatting of the request that we send to excel which looks like this “Value1”,”Value2”. The quotes encapsulate each string and help to ensure the comma acts as a delimiter between cells. Having quotes in your data breaks this expected formatting and the Excel API doesn’t know what to do with the request.

Re: problem : Using Qlik Application Automation to create and distribute Excel reports in Office 365

gardenierbi — Wed, 27 Mar 2024 12:54:49 GMT

Hi @MattGrayndler , what is the best practice to handle double quotes from the source table? Is there an escape character available to handle the double quotes?

Re: problem : Using Qlik Application Automation to create and distribute Excel reports in Office 365

TheLazyDevelopr — Wed, 27 Mar 2024 15:27:40 GMT

Ran into a similar issue in the past with updating users in NPrinting API. I ended up just using the replace function in the data load editor to edit any users names that have a single/double quotes with a space.