Does WD4A support Excel upload directly ??

[former_member445557]

Hi Experts,

I search whole the SDN forums, I know Dynpro ABAP don't support upload Excel format file directly.

( Binary format not tab-separated or XML format ) .

So I issue a SAP support note several days ago. SAP says this is our program issue, not standard issue or bug.

According to SAP's answer, It's seem that it's possible to upload excel files.

Can anyone teach me how to upload excel file directly ?

[ChrisPaine]

Hi Eric,

not yet....

but there is work afoot - see [Blog - abap2xlsx - Generate your professional Excel spreadsheet from ABAP|http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/20046] [original link is broken] [original link is broken] [original link is broken];

Ivan et al are also looking to build XLSX2ABAP at some time in the future. Until then, there is no way to read data from an Excel document into ABAP.

I think if/when they do deliver it will change quite a lot of the way that we build user interfaces!

Cheers,

Chris

[former_member445557]

Hi ,

here is SAP's answer , the answer is NO.

By the wayt I'm very disappointed at SAP's answer and attitude .

***********************************

Dear Ciustomer,

It's not a problem of "Upload" or WDA

you can upload any file to the server

but any another manipulation with this file

save to the table .... it's not responsibility of WDA,

i close this message because it's not a bug

we never declared or supported this "Excel upload function"

and we have not any plan to do it.

Regards,

Vitaly

***********************************

Hello xxxxx,

the binary EXEL format is not open

therefore SAP have not any standard functionality for it.

if you need exel in frontend you can use OfficeControl UI element

Regards,

Vitaly

[thomas_jung]

>By the wayt I'm very disappointed at SAP's answer and attitude .

What attitude? You entered a support ticket for something that wasn't a bug or defect. You may want this feature added, but support tickets aren't the correct way to make feature requests or ask a consulting question. Support responded as they should have to something that was either a feature request or a consulting request.

The facts - there is no SAP supplied functionality to process binary Excel files. You can upload and store such files in their binary format, but you can't process them - by process I mean extract the source data. Binary Excel is a Microsoft propriatery format and there are no libraries in ABAP for processing this format. Even in the SAPGUI we use OLE Automation to take control of Microsoft Office in order to process Binary Excel files. Such OLE control would not be possible/feasible within a web browser.

General recommendations - convert the Excel file to something more standards based - Text Tab Delimited or one of the later Excel formats that are XML based. You can then use fairly standard ABAP processing (XSLT, iXML, or just splits and substrings) to process the file.

[former_member445557]

Hi Thomas,

sorry, I don't agree your point.

In our compnay, we have WebSphere Portal / SAP Portal two products .

In WebSphere Portal platform, Java can upload binary excel files directly .

The Dynpro Java programmer tell me they also can upload files directly.

I can't understand why Dynpro ABAP can't ?

In the web world, it's very strange that portal can't support excel upload.

Our company spend much money, and end users always always challenge us why they can't upload excel files ?

If you were me , how do you answer to end user ?

I know this is not SAP bug or and standard program issue,

chould you tell me how to tell SAP they should develop the function ?

PS. sorry for my poor english, I don't use Eng. often.

Edited by: eric yang on Aug 3, 2010 1:24 AM