How To Fix FDT_EXCEL_API009 - Invalid value in row number &1, column number &2

SAP Error Message - Details

• Message type: E = Error

• Message class: FDT_EXCEL_API - Messages related to SFDT_EXCEL_API Package

• Message number: 009

• Message text: Invalid value in row number &1, column number &2

What causes this issue?

You have tried to import table data from a Microsoft Excel file.
However, the cell in row &v1&/column &v2& contains data that does not
match the type of the value in the corresponding cell of the decision
table.
Note that the row number and column number refer to the row and column
in the Excel file, not in the decision table.

System Response

The file cannot be imported. Existing data in the decision table remain
unchanged.

How to fix this error?

Correct the data in the Excel file. Then, repeat the import.

Procedure for System Administrators

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message FDT_EXCEL_API009 - Invalid value in row number &1, column number &2 ?

  The SAP error message FDT_EXCEL_API009 indicates that there is an invalid value in a specific row and column of an Excel file that is being processed by the SAP system. This error typically occurs when the data being imported or processed does not conform to the expected format or data type.
  Cause:
  
  Invalid Data Type: The value in the specified cell may not match the expected data type (e.g., text instead of a number).
  Out of Range Values: The value in the cell may be outside the acceptable range for that field.
  Empty Cells: The cell may be empty when a value is required.
  Incorrect Formatting: The cell may have formatting issues, such as leading/trailing spaces or special characters that are not allowed.
  Excel Limitations: The row or column number may exceed the limits of Excel (e.g., trying to access a row beyond the maximum number of rows in Excel).
  
  Solution:
  
  Check Data Types: Ensure that the data in the specified row and column matches the expected data type. For example, if a numeric value is expected, make sure the cell contains a number.
  Validate Values: Check if the values in the specified cell are within the acceptable range. If there are any constraints on the data, ensure that the values meet those constraints.
  Handle Empty Cells: If the cell is required to have a value, make sure it is not empty. Fill in the necessary data.
  Correct Formatting: Remove any unwanted characters, leading/trailing spaces, or formatting issues from the cell.
  Review Excel Limits: Ensure that you are not trying to access a row or column that exceeds Excel's limits (e.g., more than 1,048,576 rows or 16,384 columns).
  Use SAP Tools: If available, use SAP tools or transaction codes that can help validate the Excel file before importing it into the system.
  
  Related Information:
  
  SAP Notes: Check for any relevant SAP Notes or documentation that may provide additional insights or updates regarding this error.
  Excel File Format: Ensure that the Excel file is saved in a compatible format (e.g., .xlsx) that SAP can process.
  Data Mapping: Review the data mapping between the Excel file and the SAP fields to ensure that all required fields are correctly aligned.
  Testing: If possible, test with a smaller dataset to isolate the issue and identify which specific values are causing the error.
  
  By following these steps, you should be able to identify and resolve the issue causing the FDT_EXCEL_API009 error in SAP.