What file format should i pass to WDA Upload UI to upload data

[Former Member]

Hi,

I am new to Webdynpro Abap. I am trying to upload an Excel sheet with extension XLS by using a WDA application.

But when i pass the Xstring data recieved by get attribute method to Xstring to string convert FM, it's giving me a junk value. So does it mean, i can not upload a data from XLS sheet by using WDA. ( Where as i am able to do it using OLE in normal ABAP report).

So if not, then what format I should ask my supplier to send me the file. It must be Excel file, so may be CSV format?

Please advise on this!!

Thanks PG

Edited by: PG on Nov 12, 2010 4:29 PM

[Former Member]

Hi PG ,

Both excel and word formats are Microsoft propertiery formats , so you cannot use a "x-string to string" FM to covert them to string because , the data in them is not exactly in xstring formats.

There are many threads on this topic..you should be able to find them.\

Here is one such thread [link|].

Thanks,

Aditya.

Edited by: Aditya Karanth on Nov 12, 2010 12:56 PM

[Former Member]

Hi Aditya,

Thanks for your reply.

But unfortunately, the link given by you does not made a clear point for my issue( Or may be I am not able to get it.)

So my basic question is, If I need to upload the data from an Excel File by using WDA, then how should i achieve it.

Should I ask Customer to provide CSV format Excel sheet ( Since Text file is not an option for me).

Right now I am facing this issue, that what file format I shoud ask to customer to give data .

I hope i did not make my question a bit confusive.

Thanks

PG

[Former Member]

hi,PG.

Unfortunately, now you can not upload/manipulate EXCEL format-file, as the upper expert said XLS is special format you can not do it directly. There are many threads about this topic in this forum, you can search using the key word"Webdynpro EXCEL"..

So, i do suggest you: ask your customer to provide u the CSV format file, such txt..Then you can handle it in WD4A.

Best wishes.

Good luck.

[Former Member]

Hi Tang,

Thanks for your reply.

In my business case, I have to upload a Excelsheet which is actually coming from supllier of my customer. Since this process is happening from many year, It's not possible to change the file format ( Hard to convience customer about these technical issues).

So I actually need a Web application which can, upload an Excel sheet. So If it's not possible by using WDA, may be I would look for BSP.

Thanks for your Help.

Regards

PG

[Former Member]

Hi,

I just found that, incase of BSP also , we need to first convert XLS file into CSV and then only we can upload them.

Regards

PG