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

FDT_EXCEL_API009 - Overview

• 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