topic Re: Export Straight Table Data as Excel with Formatted in Integration, Extension & APIs

Export Straight Table Data as Excel with Formatted

Anonymous — Wed, 02 Aug 2023 12:50:50 GMT

Hi all,

I am connect to Qlik Engine with Qlik .Net SDK also, export data from straight table as excel file with ExportData method but table formatting and sum row disappear in excel. QlikSense has been supported export to straight table as excel with formatted since february 2022.I clould'nt see anyhing about export data with formatted in .Net SDK documentation. Can Anyone help about that.

Thanks.

Re: Export Straight Table Data as Excel with Formatted

alex_colombo — Tue, 08 Aug 2023 12:10:38 GMT

Hi @Anonymous are you using CM or SaaS version? If you are using CM version Capability APIs/Engine APIs are not reflecting what happen on native export functionality because recently the export functionality has changed behind the scenes. Basically, the product now is using the new reporting API available in SaaS version, here some info.

As far as I can tell you cannot export excel file with formatting in CM version, let's see if we will have this in future CM releases.

Re: Export Straight Table Data as Excel with Formatted

Anonymous — Tue, 08 Aug 2023 12:28:19 GMT

Hi, @alex_colombo I'am using CM version.

Thanks for reply.