Excel Upload Problems

[Former Member]

Hi all

I know this is an old trouble, but have searched and still am not able to do it.

I'm trying to upload an excel but it's popping the error "Error occurred during character conversion".

Now I'm using the code already suggested at many places.

* get single attribute
  wd_context->get_attribute( EXPORTING  name =  `DATASOURCE`
    IMPORTING      value = l_xstring ).

  CALL FUNCTION 'ECATT_CONV_XSTRING_TO_STRING'  "this is where the dump happens
   EXPORTING
     im_xstring        = l_xstring      "TYPE xstring
     im_encoding       = 'UTF-8'
   IMPORTING
     ex_string         = l_string.      "TYPE string

I can sdee many trailing Fs in l_xstring.

It works well for csv files but not for xls. Why is it happening?

Thanks

Pushpraj

[Former Member]

Hi

I've found a note : 1167875

You have replaced the Microsoft Office 2003 products with the Microsoft Office 2007 products. In A Web Dynpro (WD) ABAP application, you download Office data. A dump occurs in the backend.

I'd try this to see if it helps.

[uday_gubbala2]

Hi Pushparaj,

I guess you are trying to use the FileUpload ui element to upload an excel file. This doesn't work out. You would have to save the excel file as an tab delimited or CSV file and then use the FileUpload element. There are already many threads over this issue. Try check these 2 threads ([Thread 1|; & [Thread 2|😉 Thomas Jung's replied in them.

Regards,

Uday

[Former Member]

thnks Uday

tab delimited it is from now on!