issue with reading multiple sheets from excel in web dynpro

[Tomas_Buryanek]

Hello Experts,

I created a web dynpro app to read multiple sheets.

Web dynpro layout:

Based on check box i read a sheets from excel file. ( View_Names are sheet names)

My code is working perfectly upto 18 sheets, but more than 18 sheets it throws an error as shown as below:

500 SAP Internal Server Error

ERROR: Field symbol has not been assigned yet. (termination: RABAX_STATE)

i try to find out where the error occurs using TCODE: ST22

Error occured inside a method.

Source code extraction: at the line 76 error occuring.

My code:

* Call method to get list of worksheets in the .xlsx file

  lref_excel->if_fdt_doc_spreadsheet~get_worksheet_names(
      IMPORTING
        worksheet_names = lt_worksheets ).

* Condition to check whether .xlsx file has any active worksheets

  IF lt_worksheets IS NOT INITIAL.

  ELSE.

*<< Display error message >>

    RETURN.
  ENDIF.
*---------------------------------------------------------------------------------------
*loop into the sheets

loop at lt_worksheets into ls_view. 

if ls_view-check_box ne 'X'.
  CONTINUE.
  ENDIF.
  lv_name = ls_view-view_name.
  CONDENSE lv_name.

  lref_data = lref_excel->if_fdt_doc_spreadsheet~get_itab_from_worksheet( lv_name ).

* Fetch all records in the active worksheet

  ASSIGN lref_data->* TO <ft_excel_data>.

----- Some logics-----
*
*
*
*
endloop.

How to solve this error?

is there is any limitations for reading sheets

Any suggestions please....

Thanks in advance....

[Tomas_Buryanek]

Will it dump if you try read just the 19th sheet?

[former_member383962]

Hello @Tomas

I can read 19th sheet alone.. so sheet is not a problem... I can't read continuously from 1st sheet to 19th sheet...

[DoanManhQuynh]

you could set debug there to findout why the building of dynamic table failed for 19th sheets, is it have different column with the others?

[former_member383962]

Hello quynh.doanmanh ,

all the sheets are having different columns... that's not a problem...

I debugged it and i found a error occurence reason. i.e.,

GENERATE_SUBPOOL_DIR_FULL

How to solve this issue...

[DoanManhQuynh]

kabilarasan : well now you have exception and you may search google for it. I did that and find out it about limitation of CL_ALV_TABLE_CREATE. my suggestion is somehow refresh your class inside the loop (sorry i dont have those class so idk this work or not but you could try)

[former_member383962]

Hello Experts,

Thanks for your response....

I solved my issue.. by taking a copy of that standard class "CL_FDT_XL_SPREADSHEET" and modifying that ...

Thanks to all...