Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Row or Column order data when Pasting from CopyTableToClipboard

Does anyone know what order a table would be written into Excel with a paste from data in the CopyTableToClipboard?

I have a script which collates data from several sources, opens an Excel template, writes 3 tables to an existing page, copies 2 larger tables each to its own new sheet, and then saves the template to a different network folder with a .xlsm filename based on data.

However, on the sheet added last, I believe the last column may not finish pasting before the save occurs.  Putting in a delay before the save doesn't seem to have any effect.  (Perhaps the delay is just spun out to another core via multi-threading?)

The last table has the most data elements at 38 columns by about 10,000 rows.

I'm wondering what data is written last in the paste.  Do I need compare the last row or column of the source table to the destination excel row/column before allowing the Save?  Or perhaps just check the lower, right cell of that sheet?

Any better suggestions?

Community Browser