topic Re: Macro export excel - simulation break in QlikView

Macro export excel - simulation break

Wed, 04 Feb 2015 14:31:21 GMT

Hi all,

I'm currently implementing Macro module to realized a custom Excel export.

In details, we have a QlikView table where each element in the column A (we can call it father) can has, in the column B, one or more rows (we can call it children). After the export, if the table is too long to fit in an excel page, we should split the exceeded rows in an other page. Implementing this export,I want to avoid to break the table splitting in two different page, children belong to the same father.

Do you know if is there any way/library/function to achieve my goal? Thank you!

Re: Macro export excel - simulation break

alexandros17 — Wed, 04 Feb 2015 14:39:18 GMT

Isn't it easyer to install Excel 2010 in which there are more than 1 million rows?

If you need Greater pages then maybe Excel id not the best choose.

Let me know

Re: Macro export excel - simulation break

Wed, 04 Feb 2015 16:07:30 GMT

Hi,

the problem is not the limitation in the number of exported rows but how they are exported. Please see attached files that show the output result that I would need. Thank you.