+ Start a Discussion
Karan Khanna 6Karan Khanna 6 

Generate excel file from apex with Macro

Hi, I have this peculiar scenario where end user need an ability to export Deal and line items details from the Salesforce UI in excel format (it will look like Deal details in starting rows then line items details below it in table format).

so far it's fine as I can create a VFPage which will show details in this format and then render it as excel.

Issue is they want the ability to do some updates in that excel file and import it in Salesforce.

One way I could think of doing this is have a Macro on the excel file which will convert the excel into csv format which then user can load in salesforce but I would have to put that Macro while creating that excel and I can't seem to find a way to put Macro in salesforce.

any other ideas of achieving it is also welcome.

thanks in advance!