Is it possible to output or export data from multiple gINT tables to Excel so each table is exported into distinct Excel worksheet? I`m able to setup excel output but I can`t find any solution to create excel table with more than one worksheet. Any advice would be much appreciated.
Thank you all for your replies. I forgot to mention that the export need to be with excel worksheet named in different way than in gINT. I will use corespondence file pointed out by szang.
As Aparna M states, gINT will automatically create multiple worksheets in a single excel workbook. Each gINT table will be exported to a worksheet of the same name in the excel file. You can select as many tables to export as you want in the export dialog, if you select no tables, all tables in the project will be exported to excel. You can control the names of the worksheet, what gets exported, the column headings, and many other things using a correspondence file. You can also combine data from several tables into one sheet or separate data from one gINT table into multiple excel worksheets just by carefully building the correspondence file. GINT has a correspondence file editor and creator in the Data Design tab.
If what you are trying to do is to create multiple excel workbook files with different names, for example export each boring to a separate excel file named TB-1.xls, TB-2.xls, TB-3.xls, etc. This can be done manually or using a script file as Phil Wade suggests. I have provided an example of a way to automatically create the desired script file in the following post.
(2) How to export point tab data to excel using a script - gINT Forum - OpenGround | gINT | Keynetix - Bentley Communities
If you are looking to do something else, please provide more details and I can provide more specific advice.
Answer Verified By: Jakub Hruška
You could write a gINT Rule, or write a script file to do this. If it is only a few tables and always the same tables a script is the easiest approach.
Phil WadeDatgelBentley Channel Partner and Developer PartnerE: phil.wade@datgel.com | T: +61 2 8202 8600 & +65 6631 9780
Get the most out of gINT with Datgel Tools.
Hi Jakub, gINT does create multiple sheets of tables in the same gINT file based on the different tables in the input. However, if you want to have multiple worksheets/files of different tables, you will have to choose select Table option and save each of them separately.