Error "Invalid File" occurs when importing an Excel file

Document ID:KM00703118
Creation Date:07-Jan-2014
Modified Date:24-Feb-2014
- Micro Focus Products:
  functional testing 11.52

Summary

When customer attempts to import a Excel file into Unified Functional Testing (UFT), an error occurs saying "Invalid File"

Error

Error: "Invalid File" can occur if your Excel file extension is type "xls", due containing visible or invisible format related data, or non supported data.

Cause

This error occurs when the excel file being imported into UFT, contains visible or invisible format related data, or non supported cell formats mentioned in the user guide.

Reference:
UFT 11.5x User Guide
p.264: "Combo box and list cells, conditional formatting, and other special cell formats are not supported in the Data pane."
p. 2749: Data Table >Parameter name(column header. For tests and scripted components)
➤ Must be unique in the sheet.
➤ Must begin with a letter or underscore.
➤ Can only contain the following:
    Letters
    Numbers
    Periods
    Underscores

Fix

1. Ensure your UFT is updated to 11.52 or higher.
2. Convert your Excel file from "xls" to "xlsx".
3. Import the newly converted "xlsx" file.