Imported Action creates invalid Excel Content
It's kind of nice to open up the datatable spreadsheet in Excel to delete unused sheets and reorder sheets in a logical order for tests with a lot of actions. However, if you import an action from another test and use a local version of the datasheet, QTP creates an excel sheet with square brackets (ex. "Mytest [Mytest]"). However, Excel sees the square bracket as invalid content: "Excel found unreadable content in 'Default.xls'. Do you want to recover..." Recover coverts the square brackets to curly. Anyone have a work around?
Using QTP 10, Office 2007,
Re: Imported Action creates invalid Excel Content
Load the data in excel sheet into a data base and then try reading the records using sql connection.