Apex Code Development You need to sign in to do that
Don't have an account?
Jayesh_Tejwani How to merge xml in an existing excel as sheet2 using Apex
I have an excel which is unzipped and stored in Salesforce using the method described in the blog (https://andyinthecloud.com/2012/12/09/handling-office-files-and-zip-files-in-apex-part-2/ ). I have some data received in form of XML in Salesforce which I need to store in the same excel as sheet 2. How can I achieve this through Apex? Please let me know. Thank you in advance
May I suggest you please check with below link which might be helpful for you to accelerate with the above requirement.
- http://neerajgupta999.blogspot.sg/2012/06/multisheet-excel-from-apex.html
Please let us know if this helps.Thanks,
Nagendra
Thank you for the response but I have already looked at this option, it gives the option of taking existing data from Salesforce objects and creating multiple excel sheets.
But my requirement is different. I already have an excel with sheet 1 attached in Salesforce and I received XML which I need to process and read the data from it and store it in Sheet 2 of the excel. Thanks!