topic Row or Column order data when Pasting from CopyTableToClipboard in QlikView https://community.qlik.com/t5/QlikView/Row-or-Column-order-data-when-Pasting-from-CopyTableToClipboard/m-p/804816#M661904 <HTML><HEAD></HEAD><BODY><P>Does anyone know what order a table would be written into Excel with a paste from data in the CopyTableToClipboard?</P><P></P><P>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. </P><P></P><P>However, on the sheet added last, I believe the last column may not finish pasting before the save occurs.&nbsp; Putting in a delay before the save doesn't seem to have any effect.&nbsp; (Perhaps the delay is just spun out to another core via multi-threading?)</P><P></P><P>The last table has the most data elements at 38 columns by about 10,000 rows.</P><P></P><P>I'm wondering what data is written last in the paste.&nbsp; Do I need compare the last row or column of the source table to the destination excel row/column before allowing the Save?&nbsp; Or perhaps just check the lower, right cell of that sheet? </P><P></P><P>Any better suggestions?</P></BODY></HTML> Sun, 15 Mar 2015 21:29:19 GMT 2015-03-15T21:29:19Z Row or Column order data when Pasting from CopyTableToClipboard https://community.qlik.com/t5/QlikView/Row-or-Column-order-data-when-Pasting-from-CopyTableToClipboard/m-p/804816#M661904 <HTML><HEAD></HEAD><BODY><P>Does anyone know what order a table would be written into Excel with a paste from data in the CopyTableToClipboard?</P><P></P><P>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. </P><P></P><P>However, on the sheet added last, I believe the last column may not finish pasting before the save occurs.&nbsp; Putting in a delay before the save doesn't seem to have any effect.&nbsp; (Perhaps the delay is just spun out to another core via multi-threading?)</P><P></P><P>The last table has the most data elements at 38 columns by about 10,000 rows.</P><P></P><P>I'm wondering what data is written last in the paste.&nbsp; Do I need compare the last row or column of the source table to the destination excel row/column before allowing the Save?&nbsp; Or perhaps just check the lower, right cell of that sheet? </P><P></P><P>Any better suggestions?</P></BODY></HTML> Sun, 15 Mar 2015 21:29:19 GMT https://community.qlik.com/t5/QlikView/Row-or-Column-order-data-when-Pasting-from-CopyTableToClipboard/m-p/804816#M661904 2015-03-15T21:29:19Z