+ Start a Discussion

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.

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!