I'm having problems creating an Excel export that has more than 2 tabs (worksheets). Is this a known problem?
Excel multiple tabs(7 posts) (3 voices)
Generating multiple worksheets should work just fine. If you are having problems with it, please send a example report to support, so we can take a look at it.
How to do multiple worksheets? I need to export multiple results set in a single excel file with each worksheet for each result set.
Please guide! TIA
You can use the
select 'dbr.export.options','worksheet', 'First worksheet'; select ...
from mytable select 'dbr.export.options','worksheet', 'Second worksheet'; select ...
Now, if you can help with this then it will be wonderful!
Let's take an example: I need to send last day booking details via a scheduled task that send an email with an attachment of three CSV i.e:
1. transaction details of pending bookings
2. transaction details of complete bookings
3. transaction details of cancelled bookings
This can be done by calling and single report three times with change it's parameter (booking status). But this will add three separate CSV in the email. Where I actually want to send a single excel file with three worksheets in it.
How can I achieve this?
I'm using 'dbr.mail.attach' and then that report URL.
Do you want to send CSV files or an Excel file (a CSV file does not have any worksheets)?
If you send an Excel file, just do single report that does the three queries (or a loop if you just change the status) separated with the worksheet-export option.
I want to send an excel file.
Ok Got it! Thanks for the support team.
You must log in to post.