topic Re: NPrinting Excel preview error in Qlik NPrinting

NPrinting Excel preview error

jsobrinho — Sat, 16 Nov 2024 03:41:44 GMT

HI guys,

I have a generic error in QlikNpriting preview and task using excel template.

When I try to run the preview from an app, I have this error, so much generic ... I try to put TB01 and the fields and I have the same error.

I send the table to excel in qlikview and my excel file has 10 columns and 1048576 of rows per sheet (Qlikview give an excel with 4 Sheets each one with 1048576 ), this is a problem? I don't know where start investigates the problem.

Re: NPrinting Excel preview error

Frank_S — Thu, 02 May 2019 17:38:55 GMT

Hi,

1048576 is the maximum number of rows that excel can export. Your actual out put is likely higher that thus not able to be processed by NPrinting.

NPrinting may be timing out or unable to process the additional rows due the the row maximum limitation in MS Excel.

https://support.qlik.com/articles/000002491

I suggest using an Nprinting filter to ensure that less than 1 million rows appears in your output.

Hope this helps...

Re: NPrinting Excel preview error

jsobrinho — Fri, 03 May 2019 15:41:35 GMT

Thank you.

Re: NPrinting Excel preview error

Frank_S — Mon, 06 May 2019 18:03:09 GMT

Glad we could help!