Write to Excel File without opening it

[SAMSashi]

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

[saywell]

  On 12/28/2010 at 10:03 AM, 'SAMSashi said:

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

[SAMSashi]

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

[SAMSashi]

  On 12/30/2010 at 9:14 AM, 'SAMSashi said:

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

[bolopaneer]

see this

Determine If A Process is Running

in this link

http://dailycupoftech.com/useful-autoit-scriptlets/