Forum Discussion

srinivas_yadati's avatar
srinivas_yadati
Occasional Contributor
11 years ago
Solved

Is There Is any way to Acess the Excel Sheet when Data dynamically changes Every Day

Hi  I want help for accessing the data from external sources when data of the excel sheet chages everyday. for ex: i am using Today() function in excel sheet the cvariable i created throu...
  • Colin_McCrae's avatar
    Colin_McCrae
    11 years ago
    If you're using Excel as a COM object you can disable the notifications popups ....



    app.DisplayAlerts = False



    Should do it in your case.
srinivas_yadati's avatar
srinivas_yadati
Occasional Contributor
11 years ago
Hi

Thanks for the Reply!!!!

actually i am using some functions in the excel sheet like Today().

So it is not updating the values of that cells , another day when i run the test ,It is only taking the old values which is assigned earlier or first run the test.

I tried all the methods like ALE Driver and COM objects ,but  there is no effect on the excell cells updation.

Only thing i found is we have to open the sheet every time before run the test(manually or Through script) ,it is working some way..