[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 628
  • Last Modified:

Export multiple queries to different excel worksheet with customized worksheet name

I have an .sql script that runs 5 queries. I would like to automatically export the result of all 5 queries to a single excel file in 5 different worksheet, each worksheet having a given name (a customized one not the default one). Does anybody know how to do that? Thank you!
0
b75mihai
Asked:
b75mihai
1 Solution
 
NelliosCommented:
There is no direct approach for doing this.
You will need to use an intermidiate software to do this for you:
Crystal Reports maybe a good approach.

But I think that you will have issues merging 5 reports into a single EXCEL on different Sheets.
So for that I would suggest you to use something like POI.

Hope that helps
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now