I am trying to integrate an Excel application with VBA macros reading Excel data files and I was wondering what is the best solution to execute this Excel/VBA apllication within the SAP EP 6.0.
Is there any Excel plugin for SAP EP 6.0 so that the Excel/VBA is executed on the server ? (the client should be able to see the Excel result without Excel installed)
Is there any way to launch this Excel/VBA file from a Java web client integrated in teh portal ?
If you use POI (a jakarta lib, freely downloadble), you can read an Excel file (containing a macro), put some data in it, and then export it to the user's browser.
Depending on the user configuration and the way you transmit it (header : 'inline' or 'attachement'), the Excel sheet will show in the browser with Exceln, or will have to be saved.
I dont think there is a way to transmit data from excel to the portal.