obaid_shirwani wrote:
Hi,
I had the below code working absolutely fine in TestComplete version 10. I have revisited it only to find it not working in version 12.
//No Issue
var book = Excel.Workbooks.Open(inputFileName);
As Sherlock Holmes once said, when you eliminate possibilities, whatever is left, however improbable, must be the case.
The above code you won't necessarily get an error if it fails. If it fails to open the workbook, it may just return a workbook object that has no Sheets or anything associated with it. So, it's possible that this is the cause of all your other issues. So, I'd start your investigation here... drop a breakpoint in to see if you are actually getting a valid "Workbook" object. If the object being returned is null, than "Sheets" would not be a recognized function.
Please upload the snapshot photo that you promised so we can help further, but I think I'd start first with investigating why the workbook isn't actually opening.
Hi Martin,
I had obviously checked that before posting. The returned Workbooks object holds the number of Sheets available in the file. So i think that is not the issue. I am attaching the screenshot for the object returned.
The visible class is throwing error. I assume it might be some version conflict or the driver issue.
Best regards,
Shirwani
var sheet = book.Sheets(desiredSheetName)
Instead of this line, Can you try using below,
var sheet = book.Sheets.Item(desiredSheetName);
It works fine for me long time.
Hy Shankar,
I am unable to access 'book.Sheets' alone... it crashes here. How am i supposed to get past it?
Please view the attached images in previous posts and read the text again under "//Issue 02 (Intellisense popup)".
Thanks & regards,
Shirwani
This error is not related TestComplete use case, It is part of Excel settings.
I tried the same code with my machine it is working fine. [TC 12.42].
Does your excel sheet have any Macros?
When you open your excel workbook, does is shows Enable Editing?
Are there any recent Excel upgrade you did?
