problem with excel file

[Former Member]

Hi

when am uploading a file in web dynpro am having problem with excel file ..

please some body help on this.

[Gowtham]

Hi Naveen,

Requesting you to have a look at the following links:

Excel File Upload And Display Data Using Web DynPro ABAP - Web Dynpro ABAP - SCN Wiki

SAPTechnical.COM - Uploading excel file using WebDynpro for ABAP

- Gowtham

[Former Member]

am getting garbage values if am uploading excel file

it is working for flat file only

[Former Member]

ya but its getting dumped because the character conversion not possible..

[Former Member]

its getting Dumped

* get single attribute

   wd_context->get_attribute(

     EXPORTING

       name =  `DATASOURCE`

     IMPORTING

       value = l_Xstring ).

   CALL FUNCTION 'HR_KR_XSTRING_TO_STRING'

     EXPORTING

       in_xstring = l_xstring

     IMPORTING

       out_string = l_string.

   find cl_abap_char_utilities=>CR_LF IN L_STRING.

   IF SY-SUBRC = 0.

   SPLIT l_string  AT cl_abap_char_utilities=>CR_LF  INTO TABLE i_data.

endif.

getting dumped

• The following error occurred in system PMD : Unable to interpret PK   # # ###!#q 9+ as a number.
• The error occurred on application server enggdev-qa_PMD_10 and in work process 9 .
• The termination type was: RABAX_STATE
• The ABAP call stack was:
  Method: IF_WD_CONTEXT_ELEMENT~SET_ATTRIBUTE of program CL_WDR_CONTEXT_ELEMENT========CP
  Method: CONSTRUCTOR of program CL_WDR_CONTEXT_ELEMENT========CP
  Method: IF_WD_CONTEXT_NODE~BIND_TABLE of program CL_WDR_CONTEXT_NODE_VAL=======CP
  Method: IF_WD_CONTEXT_NODE~BIND_TABLE of program CL_WDR_CONTEXT_NODE_MAP=======CP
  Method: ONACTIONUPLOAD of program /1BCWDY/YYNI53SL0QBMX4NWN41R==CP
  Method: IF_WDR_VIEW_DELEGATE~WD_INVOKE_EVENT_HANDLER of program /1BCWDY/YYNI53SL0QBMX4NWN41R==CP
  Method: INVOKE_EVENTHANDLER of program CL_WDR_DELEGATING_VIEW========CP
  Method: IF_WDR_ACTION~FIRE of program CL_WDR_ACTION=================CP
  Method: DO_HANDLE_ACTION_EVENTS of program CL_WDR_WINDOW_PHASE_MODEL=====CP
  Method: PROCESS_REQUEST of program CL_WDR_WINDOW_PHASE_MODEL=====C

[Former Member]

Hi,

Try the below code.

DATA CONTENT                TYPE STRING.

CONV = CL_ABAP_CONV_IN_CE=>CREATE( INPUT =  l_Xstring ).

    TRY.

        CONV->READ( IMPORTING  DATA = CONTENT ).

      CATCH CX_SY_CONVERSION_CODEPAGE.



    ENDTRY.

    SPLIT CONTENT AT CL_ABAP_CHAR_UTILITIES=>CR_LF INTO TABLE IDATA.

Hope this helps you. Else try to look into the attached code

Thanks

KH

[Former Member]

Hi,

What problem are you facing?.

Thanks

KH