ZDEMO_EXCEL43 short dumps if input Excel file has more than 1 column / outputs only 1st character if 1 column

[sandraros]

To reproduce, run the program ZDEMO_EXCEL43:

• Case 1 (short dumps if input Excel file has more than 1 column):
  • select this Excel file below (has more than 1 column), and the below short dump is raised.
    Several columns.xlsx

    UNCAUGHT_EXCEPTION
    ZCX_EXCEL
    ...
    Chain of Exception Objects
    ...
    Level    1     Class    ZCX_EXCEL
    ...
    Internal table has less columns than excel
    ...
    ERROR                          Internal table has less columns than excel
    ...
    Active Calls/Events
    ...
    3 METHOD       ZCX_EXCEL=====================CP    ZCX_EXCEL=====================CM005     2
      ZCX_EXCEL=>RAISE_TEXT
    2 METHOD       ZCL_EXCEL_WORKSHEET===========CP    ZCL_EXCEL_WORKSHEET===========CM01M    63
      ZCL_EXCEL_WORKSHEET=>GET_TABLE
    1 EVENT        ZDEMO_EXCEL43                       ZDEMO_EXCEL43                          48
      START-OF-SELECTION
    

• Case 2 (outputs only 1st character if 1 column)
  • Select this Excel file below: One column.xlsx Actual result by ZDEMO_EXCEL43

Expected results:

• Case 1: change the program ZDEMO_EXCEL43 so that:
  • the user can choose the number of columns for the internal table (selection screen parameter)
  • any exception is displayed instead of a short dump
• Case 2:
  • the columns of the internal table are of type string instead of 1 character, or let the user choose the type of each column.