Sign in to follow this  
Followers 0
SAMSashi

Write to Excel File without opening it

5 posts in this topic

Hi Guys,

I want to write the details of pages i navigate into an Excel file through my AutoIT v3 script.

Problem I am facing : I am able to navigate Internet pages from one page to other through script.But if i start to write to Excel file using-

#include <Excel.au3>

$sFilePath1 = @ScriptDir & "\TimeDetails.xls"

$oExcel = _ExcelBookOpen($sFilePath1)

$iBegin_Login_Page = TimerInit()

;; doing some work

$nTimetaken = TimerDiff($iBegin_Login_Page)

_ExcelWriteCell($oExcel,"$iBegin_Login_Page",2,3)

Want to go back to resume my page navigation work and gathering the information to write in Excel file;

I am not able to do that. Can you just help in resolving this.

Regards,

SAM

Share this post


Link to post
Share on other sites



Hi Guys,

I want to write the details of pages i navigate into an Excel file through my AutoIT v3 script.

Problem I am facing : I am able to navigate Internet pages from one page to other through script.But if i start to write to Excel file using-

#include <Excel.au3>

$sFilePath1 = @ScriptDir & "\TimeDetails.xls"

$oExcel = _ExcelBookOpen($sFilePath1)

$iBegin_Login_Page = TimerInit()

;; doing some work

$nTimetaken = TimerDiff($iBegin_Login_Page)

_ExcelWriteCell($oExcel,"$iBegin_Login_Page",2,3)

Want to go back to resume my page navigation work and gathering the information to write in Excel file;

I am not able to do that. Can you just help in resolving this.

Regards,

SAM

If you make the excel bit into a function, you could call it between each of your actions elsewhere in the script. How are you navigating between pages?

William

Share this post


Link to post
Share on other sites

I meant for page navigation as the IE pages. With the help of 'Autoit Windows Info', i get the Title and then Send(TAB+ENTER) to go to next page thats it. Thanks for the information.

SAM

Share this post


Link to post
Share on other sites

I meant for page navigation as the IE pages. With the help of 'Autoit Windows Info', i get the Title and then Send(TAB+ENTER) to go to next page thats it. Thanks for the information.

SAM

Anybody can help me if i want to check whether the Excel sheet is open or not how can i check that.

Thanks,

SAM

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0