+ Start a Discussion
Glenn Nyhan 54Glenn 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? 
Best Answer chosen by Glenn Nyhan 54
Khan AnasKhan Anas (Salesforce Developers) 
Hi Glenn,

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

Khan AnasKhan Anas (Salesforce Developers) 
Hi Glenn,

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
This was selected as the best answer
Glenn Nyhan 54Glenn Nyhan 54
Hi Khan,

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