FORM refresh_alv. DATA go_gui_alv_grid TYPE REF TO cl_gui_alv_grid. * Get the current grid control instance CALL FUNCTION 'GET_GLOBALS_FROM_SLVC_FULLSCR' IMPORTING e_grid = go_gui_alv_grid. "Set layout again to optimize column width with new data DATA ls_layout TYPE lvc_s_layo. ls_layout-zebra = 'X'. ls_layout-cwidth_opt = 'X'. ls_layout-box_fname = 'SEL'. go_gui_alv_grid->set_frontend_layout( is_layout = ls_layout ). * Refresh go_gui_alv_grid->refresh_table_display( ). ENDFORM.
Class ZCL_CONVERT_EXCEL_TO_ITAB class ZCL_CONVERT_EXCEL_TO_ITAB definition public final create public . public section. class-methods GET_ITAB importing !FILENAME type STRING !WORKSHEET type STRING optional !BEGIN_COL type I default 1 !BEGIN_ROW type I default 1 changing !ITAB type ANY TABLE exceptions…