Has anyone done Excel file generation in Salesforce with bit complex formatting? If so appreciate any guidance or reference.
I already tried formatting with CSS and having the
contentType="application/vnd.ms-excel" which doesn't give me the correct formatting always.
I wanted to try XML option as described here but the generated XML file is always having the text
SfdcApp.Visualforce.viewstate.ViewstateSender.sendViewstate('https://cs58.salesforce.com', 'StackingPlanExcelMadhura'); at the end and due to that Excel can't open the file.
Correction for these two options or any other option would be appreciated.