SAP EP Portal & Excel VBA

[Former Member]

Hi,

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 ?

Thanks.

Jean-Marc Denoyel

[Former Member · Accepted solution]

Hi

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.

regards,

Guillaume PATRY