Read a excel file

[UQOII]

I already know how i must write in an excel file

$oExcel.ActiveWorkBook.ActiveSheet.Cells(3,3).Value="test"

How can autoit read a excel file?

Example:

a msg box wil appear with the text of C3, so that will be ''test'' (Just like the write script)

[Locodarwin]

$sCell = $oExcel.ActiveWorkBook.ActiveSheet.Cells(3,3).Value

...will place the value of C3 into variable $sCell.

-S

[UQOII]

thank you

[UQOII]

n00bie question

$oExcel = ObjCreate("Excel.Application")

this is to start a excel window but i need to start TEST.xls

so how can is start TEST.xls

[UQOII]

i already found it, thanx help file

[UQOII]

i do something wrong but id ont know what....

this is the script (this is only the read section )

$oExcel = ObjGet("C:\Testfile.xls","Excel.Application")
$testline = $oExcel.ActiveWorkBook.ActiveSheet3.Cells(3,3).Value

GUICreate("Show excel line",950,700,-1,-1)
$list = GUICtrlCreateListView("Line",1,1,948,998,$WS_EX_ACCEPTFILES)
$item = GUICtrlCreateListViewItem($testline,2)
GUISetState()

[UQOII]

Also another question

How can autoit read from another tab (not the active tab but Tab 2)