I am using Excel spreadsheets for data tables in QTP.
I am seeing something very strange with some Office-2003 Excel spreadsheets I am trying to manipulate.
My spreadsheets contain many sheets (tabs), many with long names
When I make copies of these spreadsheets the names of some of the sheets get changed, i.e. truncated.
This is a problem for me because QTP is using the names of the sheets to parse data.
Are you aware of any issues in Excel which might cause something like this?
The issue has only become apparent recently, spreadsheets created last year did not suffer from this
Maybe it was introduced by a recent service pack to Office-2003?
I installed OPENOFFICE 2.2 on my machine.
This a free counterpart of Microsoft office, available from http://www.openoffice.org
When I manipulate spreadsheets in OpenOffice, the sheet name is preserved.
When I exit Excel after opening a spreadsheet saved in OpenOffice, Excel asks me if I want to save it in
the "new" Excel format …. Of course the correct answer is "no".
However When I launch QTP using a spreadsheet saved in Openoffice, Excel interrupts the QTP test and ask
to resave the file in the new format.
When I click "no", the test then hangs.
So I still do not have a solution to the problem.
I need to investigate some more, maybe I can find a way to get QTP to use OpenOffice instead of Microsoft
Or does Microsoft have a fix for this?
Quality Control Analyst at Syntel Inc
Project Test Lead for client Daimler Trucks - North America.
Interested in testing dot net web services and SOA systems.
Charles F. Radley
Excel does have a limit for sheet names - in Excel 2007 the limit appears to be 31 characters
I do not think that this is a bug its more of a feature.
I have not failed. I've just found 10,000 ways that won't work" --Thomas Edison
I think the quickest fix is to keep your sheet names to 31 chars or less, for Excel 2003 or earlier. I do not know what Excel-2007 allows.
You would need to contact MS for a "fix". My guess is that they would tell you it is not a defect.
Changing worksheet names is going to be a lot of work, we have dozens of test actions.
In essence, I would have to throw out nine months worth of effort on a test harness and start from scratch.
Is it possible to integrate QTP with OpenOffice instead of Excel?