SAP JAVA Gui fails to load Excel File FM 'ALSM_EXCEL_TO_INTERNAL_TABLE'

[Former Member]

Hi All,

I am trying to read an Ecxel File from the Local Machine using the function Module 'ALSM_EXCEL_TO_INTERNAL_TABLE'. The program works fine when I am using the Windows GUI, but when it is executed through portal (via JAVA GUI), the function Module raises an Exception 'Upload OLE'. I tried using another function module ''KCD_EXCEL_OLE_TO_INT_CONVERT' which has the same functionality and it also raises the same exception. Is there a JAVA GUI and OLE compadability issue?

Please help! The object will only be used using the JAVA GUI (PORTAL).

Thanks.

Ahmed.

[RMW]

Hello Ahmed,

this does not work with SAP GUI for Java because it does not include OLE automation. Please keep in mind that SAP GUI for Java is targeting many platforms and there is both low demand and little occasion for platform specific features.

Best regards

Rolf-Martin

[Former Member]

HI Rolf ,

I am also facing same problem.. When i try in SRM R/3 Platform its working fine . But when i try to run through SRM portal

I am facing this problem . Any solution for this.

Please let me know if any other solutions. Its very urgent requirement.

Thanks,

Shankar

Edited by: Shankar SB on Nov 3, 2011 10:50 AM

Edited by: Shankar SB on Nov 4, 2011 5:10 AM

[RMW]

Hello Shankar,

unfortunately the description is too vague to tell anything.

In case you want us to investigate this, please generate a trace file while reproducing the issue like described in [note 683960|https://service.sap.com/sap/support/notes/683960], create an [official bug report|https://service.sap.com/message] on component BC-FES-JAV and attach the trace file.

Best regards

Rolf-Martin

[Former Member]

Hi Rolf ,

Thanks for your reply

We have created a Program in SRM R/3 environment for uploading Shopping Cart . we ar publishing same T-code to portal using transaction view . When i tried to execute the transaction from portal its throws a exception UPLOAD_OLE and gives a dump . Please let me know how read the excel file from portal . Any other function module to read Excel file from presentation server

.

Thanks,

Shankar.

[RMW]

Hello Shankar,

inside the transaction view, which kind of SAP GUI is configured to be used there?

Best regards

Rolf-Martin

[Former Member]

I have the same issue and I'm using SAP GUI for HTML.

[jude_bradley]

Hello Ted,

sorry to say,but only SAPGUI for Windows can handle this function module.

[http://service.sap.com/support/sap/notes/314568]

Regards,

Jude