Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
DataTable Import/Formula One error
#1
Solved: 11 Years, 4 Months, 4 Weeks ago
I saved and xlsfrom TOAD to a shared network drive where QTP could pick it up. When I run the script and QTP attempts to import it as a runtime dt I get the following error.

The DataTable.ImportSheet operation failed. File contains a feature not supported by Formula One.

It appears if I open the file and re-save it, the script and import works without a problem. Is there a way to get rid of this error without having to add this extra step?

Thanks
Charles
Reply
#2
Solved: 11 Years, 4 Months, 4 Weeks ago
May be your xls contains a formula which is not supported by QTP.
just identify the cell where that formula is and if possible try not to have that when you export it from TOAD.

Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Error as Global Not defined while trying to retrieve value from Datatable siddharth1609 0 986 09-11-2019, 02:52 PM
Last Post: siddharth1609
  How import final calculated values by cell formula from Excel not the formula itself. qtped 1 4,894 01-17-2017, 04:05 PM
Last Post: sagar.raythatha
  Datatable.importsheet error niks19 2 3,432 08-21-2015, 12:00 AM
Last Post: ADITI1992
  Datatable import error Prashanth 7 16,424 11-19-2014, 06:53 PM
Last Post: praveen.g3
  How to import .xlsx file type to QTP qtped 3 6,721 03-27-2014, 01:33 PM
Last Post: Ankur

Forum Jump:


Users browsing this thread: 1 Guest(s)