{"id":7928,"date":"2025-10-19T02:00:54","date_gmt":"2025-10-18T20:30:54","guid":{"rendered":"https:\/\/www.sapewmhelp.com\/?question=xco_cp_xlsx-package-read-excel-sheet"},"modified":"2025-10-19T02:00:54","modified_gmt":"2025-10-18T20:30:54","slug":"xco_cp_xlsx-package-read-excel-sheet","status":"publish","type":"question","link":"https:\/\/www.sapewmhelp.com\/?question=xco_cp_xlsx-package-read-excel-sheet","title":{"rendered":"xco_cp_xlsx package – Read Excel Sheet"},"content":{"rendered":"

SAP\u2019s XCO Library<\/strong> provides APIs for working with Office documents, including Excel (XLSX) \u2014 via the xco_cp_xlsx<\/code> package<\/p>\n

 <\/p>\n

CLASS zcl_read_employee_excel DEFINITION
\nPUBLIC
\nFINAL
\nCREATE PUBLIC.<\/p>\n

PUBLIC SECTION.
\nMETHODS read_employee_excel.
\nENDCLASS.<\/p>\n

CLASS zcl_read_employee_excel IMPLEMENTATION.<\/p>\n

METHOD read_employee_excel.<\/p>\n

“—————————————————
\n” Step 1: Define employee structure and table
\n“—————————————————
\nTYPES: BEGIN OF ty_employee,
\nempid TYPE string,
\nname TYPE string,
\ndepartment TYPE string,
\nsalary TYPE string,
\nEND OF ty_employee.<\/p>\n

DATA lt_employee TYPE STANDARD TABLE OF ty_employee.
\nDATA ls_employee TYPE ty_employee.<\/p>\n

“—————————————————
\n” Step 2: Load Excel file (binary content)
\n” Replace file path with your actual file location
\n“—————————————————
\nDATA(lv_file_path) = ‘C:\\Temp\\employees.xlsx’.
\nDATA(lv_xstring) TYPE xstring.<\/p>\n

TRY.
\ncl_gui_frontend_services=>gui_upload_xstring(
\nEXPORTING
\nfilename = lv_file_path
\nIMPORTING
\ndata = lv_xstring
\n).
\nCATCH cx_root INTO DATA(lx_err).
\nWRITE: \/ ‘Error reading file:’, lx_err->get_text( ).
\nRETURN.
\nENDTRY.<\/p>\n

“—————————————————
\n” Step 3: Parse Excel using XCO Library
\n“—————————————————
\nDATA(lo_excel_doc) = xco_cp_xlsx=>document->from_binary( lv_xstring ).<\/p>\n

” Get first sheet
\nDATA(lo_sheet) = lo_excel_doc->sheets->get_by_index( 1 ).<\/p>\n

“—————————————————
\n” Step 4: Read data row by row (skip header)
\n“—————————————————
\nDATA(lt_rows) = lo_sheet->rows->all( ).
\nLOOP AT lt_rows INTO DATA(lo_row) INDEX DATA(lv_index).<\/p>\n

IF lv_index = 1.
\nCONTINUE. ” Skip header row
\nENDIF.<\/p>\n

DATA(lt_cells) = lo_row->cells->all( ).<\/p>\n

CLEAR ls_employee.
\nLOOP AT lt_cells INTO DATA(lo_cell) INDEX DATA(lv_col_index).
\nCASE lv_col_index.
\nWHEN 1. ls_employee-empid = lo_cell->value->to_string( ).
\nWHEN 2. ls_employee-name = lo_cell->value->to_string( ).
\nWHEN 3. ls_employee-department = lo_cell->value->to_string( ).
\nWHEN 4. ls_employee-salary = lo_cell->value->to_string( ).
\nENDCASE.
\nENDLOOP.<\/p>\n

APPEND ls_employee TO lt_employee.<\/p>\n

ENDLOOP.<\/p>\n

“—————————————————
\n” Step 5: Display results
\n“—————————————————
\nULINE.
\nWRITE: \/ ‘EMPID’, 10 ‘NAME’, 30 ‘DEPARTMENT’, 50 ‘SALARY’.
\nULINE.
\nLOOP AT lt_employee INTO ls_employee.
\nWRITE: \/ ls_employee-empid UNDER ‘EMPID’,
\nls_employee-name UNDER ‘NAME’,
\nls_employee-department UNDER ‘DEPARTMENT’,
\nls_employee-salary UNDER ‘SALARY’.
\nENDLOOP.
\nULINE.<\/p>\n

ENDMETHOD.<\/p>\n

ENDCLASS.<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","question-category":[158],"question_tags":[178,447,177,446],"class_list":["post-7928","question","type-question","status-publish","hentry","question-category-abap","question_tags-abap","question_tags-excel-sheet","question_tags-sap","question_tags-xco-library"],"_links":{"self":[{"href":"https:\/\/www.sapewmhelp.com\/index.php?rest_route=\/wp\/v2\/question\/7928","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sapewmhelp.com\/index.php?rest_route=\/wp\/v2\/question"}],"about":[{"href":"https:\/\/www.sapewmhelp.com\/index.php?rest_route=\/wp\/v2\/types\/question"}],"author":[{"embeddable":true,"href":"https:\/\/www.sapewmhelp.com\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sapewmhelp.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=7928"}],"wp:attachment":[{"href":"https:\/\/www.sapewmhelp.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7928"}],"wp:term":[{"taxonomy":"question-category","embeddable":true,"href":"https:\/\/www.sapewmhelp.com\/index.php?rest_route=%2Fwp%2Fv2%2Fquestion-category&post=7928"},{"taxonomy":"question_tags","embeddable":true,"href":"https:\/\/www.sapewmhelp.com\/index.php?rest_route=%2Fwp%2Fv2%2Fquestion_tags&post=7928"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}