how to open a excel sheet

[venkat]

Hi,

I have a excel file in d:\sla\test1.xls. how to open the file and read values from a certain column and row.

Thanks in advance,

Regards,

venkatraman

[Zedna]

There is Excel UDF.

Search forum and look in AutoIt helpfile (from version 3.3 this UDF is included as standard UDF)

Edited May 8, 2009 by Zedna

[venkat]

There is Excel UDF.

Search forum and look in AutoIt helpfile (from version 3.3 this UDF is included as standard UDF)

$sFilePath1 = @ScriptDir & "\test1.xls" ;This file should already exist

$oExcel = _ExcelBookOpen($sFilePath1)

i tried this. but the file is not opening.

[Juvigy]

$sFilePath1 =" d:\sla\test1.xls" 
$oExcel = _ExcelBookOpen($sFilePath1)