We are building a new experience for our SmartBear Community.
This site is now read-only. You can still browse and search as usual. Learn More

Forum Discussion

Juls's avatar
Juls
Occasional Contributor
14 years ago

Open Excel worksheets in c# script

Hello,

I would like to define which worksheet should be used next in different tests.

I tried it like this, but it doesn´t work right: 



l_Excel = Sys["OleObject"]("Excel.Application");

l_Excel["Workbooks"]["Open"](\\...)["Worksheets"]("Sheet1")["Active"];

 



It takes the sheet which was last opened in the file, but not the sheet which I´ve defined in the function (sheet1).

Anyone an idea?



Thanks a lot!

Juls

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    13 years ago

    Hi Juls,



    I think you need to use http://msdn.microsoft.com/en-us/library/office/ff838003.aspx instead of Active.