function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Raja ReddyRaja Reddy 

Upload the excel having multiple worksheets

Hi Friends

I went through  https://developer.salesforce.com/forums/?id=906F000000092rPIAQ and able to upload 1 worksheet  with 1 object in excel but the  requirement is that i need to upload the excel data (Contains multiple worksheets) into salesforce (Using Visualforce pages /Data Loader)

NOTE:  Each worksheet contains two different objetcs (lets say Opportunity and Contacts) in excel.

Any help would be appreciated.

Thanks,
Raja.
sfdcsushilsfdcsushil
I have used Apache POI API in the past for reading word documents in Java. I am sure they do have API for Excel. 
But i am not sure how we can utilize that API in SFDC.