Corrupted XLSX with BIND_TABLE and numeric column in TOP_LEFT_COLUMN

[sandraros]

Source: https://community.sap.com/t5/technology-q-a/abap2xlsx-problem-downloading-file/qaq-p/13681256

Program to reproduce the bug:

REPORT.
DATA gc_save_file_name TYPE string VALUE 'abap_issue_1215.xlsx'.
INCLUDE zdemo_excel_outputopt_incl.
START-OF-SELECTION.
  DATA(lo_excel) = NEW zcl_excel( ).
  DATA(lo_worksheet) = lo_excel->get_active_worksheet( ).
  SELECT msehi, msehl
      FROM t006a
      WHERE spras = 'E'
        AND msehi LIKE 'T%'
      INTO TABLE @DATA(t006_lines).
  lo_worksheet->bind_table(
      ip_table            = t006_lines
      is_table_settings   = VALUE #( top_left_column = 1 
                                     top_left_row    = 1 ) ).
  lcl_output=>output( lo_excel ).

Solution:

• Workaround: the right way to call bind_table is to use the alphabetical column name instead of the number:

  lo_worksheet->bind_table(
      ip_table            = t006_lines
      is_table_settings   = VALUE #( top_left_column = 'A'
                                     top_left_row    = 1 ) ).
  

• Do a fix: I would recommend to accept a number in the parameter TOP_LEFT_COLUMN and write its equivalent alphabetical name to the XLSX file instead of a number.
  Note that the parameter BOTTOM_RIGHT_COLUMN is not concerned because it's always ignored, as the bottom right position is calculated by the method calculate_table_bottom_right.