Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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.