You need to sign in to do that
Don't have an account?
Glenn Nyhan 54
Pushing Data to Multiple Sheets in a Single Workbook
We are running multiple events with registrations coming into the system. Ideally we would like to push the registrations out to a single workbook with each event's attendee's being listed on an indivdual worksheet in the workbook. Is there a way to accomplish this using a third party tool, Data Loader batch processing, or by writing SOQL queries and pushing the data pulled by the queries to individual worksheets in a single workbook?
Greetings to you.
Please refer to this free app on AppExchange:
https://appexchange.salesforce.com/appxListingDetail?listingId=a0N3A00000EJg2hUAD
Also, Please refer to the below link with a similar discussion which might help you further with the above issue.
http://neerajgupta999.blogspot.com/2012/06/multisheet-excel-from-apex.html
https://salesforce.stackexchange.com/questions/34261/how-to-generate-excel-files-with-the-multiple-sheets-in-visualforce
http://www.sfdcpoint.com/salesforce/export-excel-multiple-worksheets-visualforce/
https://eltoro.secure.force.com/CreateExcelFilesWithMultipleTabs
I hope it helps you.
Kindly let me know if it helps you and close your query by marking it as solved so that it can help others in the future.
Thanks and Regards,
Khan Anas
All Answers
Greetings to you.
Please refer to this free app on AppExchange:
https://appexchange.salesforce.com/appxListingDetail?listingId=a0N3A00000EJg2hUAD
Also, Please refer to the below link with a similar discussion which might help you further with the above issue.
http://neerajgupta999.blogspot.com/2012/06/multisheet-excel-from-apex.html
https://salesforce.stackexchange.com/questions/34261/how-to-generate-excel-files-with-the-multiple-sheets-in-visualforce
http://www.sfdcpoint.com/salesforce/export-excel-multiple-worksheets-visualforce/
https://eltoro.secure.force.com/CreateExcelFilesWithMultipleTabs
I hope it helps you.
Kindly let me know if it helps you and close your query by marking it as solved so that it can help others in the future.
Thanks and Regards,
Khan Anas
Thanks for all of this! Much appreciated, I will review. I also discovered a connector app called XappeX XL-connector and tested that yesterday. Very good application. Very fast and easy to install/use.
Bowing in gratitude,
Glenn