pcsoft.us.windevCopyright 2026, PC SOFT16 Jan 2019 07:35:20 Z17 Oct 2014 10:16:00 ZHi, I use tabletoexcel to export a large table to excel. I use WD14 and it takes a long time to export all rows in one excel file. If I split it in 20.000-row pieces the process run faster. Is there any way to merge these excel files after that in one file with any windev version ??30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48529-wdxx-merge-excel-files/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)excelsynkronizerpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48529-wdxx-merge-excel-files-66947/read.awp16 Jan 2019 07:35:20 ZI Think you should Try Some Dedicated Excel Tool Like Synkronizer. It is a Microsoft Excel Add-in which is used for Compare & Me…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48529-wdxx-merge-excel-files-66947/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48529-wdxx-merge-excel-files-66947/read.awp[WDXX] Merge Excel filesguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48529-wdxx-merge-excel-files-48650/read.awp24 Oct 2014 15:29:00 ZIn WD14 "tabletotext" it takes also (like tabletoexcel) a loooong time. Finaly the only way is to split it into 20.000 line p…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48529-wdxx-merge-excel-files-48650/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48529-wdxx-merge-excel-files-48650/read.awp[WDXX] Merge Excel filesguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48529-wdxx-merge-excel-files-48647/read.awp24 Oct 2014 13:13:00 ZHi Paulo, In V19 my table with 105.000 lines crashes.https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48529-wdxx-merge-excel-files-48647/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48529-wdxx-merge-excel-files-48647/read.awp[WDXX] Merge Excel filesguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48529-wdxx-merge-excel-files-48645/read.awp24 Oct 2014 12:20:00 ZI did one quick test in V14 & V18 with tabletoexcel using one table with 68995 lines and the result was: V14 - the excel only h…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48529-wdxx-merge-excel-files-48645/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48529-wdxx-merge-excel-files-48645/read.awp[WDXX] Merge Excel filesguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48529-wdxx-merge-excel-files-48644/read.awp24 Oct 2014 12:05:00 ZI have the same problem in WD14, i didn't test in WD18 yet. In my case i generate CSV files instead using tabletotexthttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48529-wdxx-merge-excel-files-48644/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48529-wdxx-merge-excel-files-48644/read.awp[WDXX] Merge Excel filesguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48529-wdxx-merge-excel-files-48643/read.awp24 Oct 2014 11:53:00 Z[!!!!IMPORTANT UPDATE !!!!] Although the support *.XLSX Files (which can have approx. 1 Million rows) it seems that internall…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48529-wdxx-merge-excel-files-48643/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48529-wdxx-merge-excel-files-48643/read.awp[WDXX] Merge Excel filesguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48529-wdxx-merge-excel-files-48565/read.awp20 Oct 2014 16:24:00 ZHi Paulo, nope. The help says: If the XLS file already exists, merges the existing content with the new content: the fo…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48529-wdxx-merge-excel-files-48565/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48529-wdxx-merge-excel-files-48565/read.awp[WDXX] Merge Excel filesguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48529-wdxx-merge-excel-files-48564/read.awp20 Oct 2014 16:03:00 ZProbably you can do it using TableToExcel function just use taMerge option. TableToExcel(your_table , ".....\your_xls.xls" ,t…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48529-wdxx-merge-excel-files-48564/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48529-wdxx-merge-excel-files-48564/read.awp[WDXX] Merge Excel filestbc92pcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48529-wdxx-merge-excel-files-48535/read.awp17 Oct 2014 14:52:27 ZHi You say it is too slow. How long is this treatment ? And what is the maximum delay you accept ? Build a loop : for each …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48529-wdxx-merge-excel-files-48535/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48529-wdxx-merge-excel-files-48535/read.awp[WDXX] Merge Excel filesguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48529-wdxx-merge-excel-files-48533/read.awp17 Oct 2014 11:30:00 ZHi Fabrice, I test all availible table2anything functions in WD14, nothing works for the whole table. The only way to get a g…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48529-wdxx-merge-excel-files-48533/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48529-wdxx-merge-excel-files-48533/read.awp[WDXX] Merge Excel filesguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48529-wdxx-merge-excel-files-48532/read.awp17 Oct 2014 11:24:00 ZHi Michael for a big file, there is a significant degradation in performance with the excel functions... So it may be faster …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48529-wdxx-merge-excel-files-48532/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/48529-wdxx-merge-excel-files-48532/read.awp[WDXX] Merge Excel files