Exporting two or more tables into different sheets in a single xlsx file.

4 posts / 0 new
Last post
talebi
Offline
Joined: 11/23/2021 - 14:15
Exporting two or more tables into different sheets in a single xlsx file.

Hi everyone,
I wanted to know if there is any way to export my tables as Excel format (each should be in a separate sheet) into a single Excel file. Tables a, b, and c should be exported as different sheets into an Excel file named "X".
 
Thanks,
 

Images: 
klmi
Offline
Joined: 02/13/2019 - 08:41
Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

Hi Talebi,

If you have V11 or higher installed you can download load the utilities SmartAnalyzer app from passport as it has a utilitie to do just this.

You are looking for the Export Multiple Databases to a Single Excel file, run this and you will be asked which files you want to export.

talebi
Offline
Joined: 11/23/2021 - 14:15

Thanks Brian,
I have installed and run this app on my IDEA. It is helping me but I think it is better to add a feature like other apps to just select an Excel file and then define different work sheet names so we can add different sheets in the same file without replacing existing main file!
Thanks,