+ Start a Discussion
Jayesh_TejwaniJayesh_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
NagendraNagendra (Salesforce Developers) 
Hi Jayesh,

May I suggest you please check with below link which might be helpful for you to accelerate with the above requirement. Please let us know if this helps.

Thanks,
Nagendra
Jayesh_TejwaniJayesh_Tejwani
Hello 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!