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

talebi

Forums

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,
 

Brian Element Thu, 01/13/2022 - 06:52

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 Thu, 01/13/2022 - 11:42

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,