UQOII Posted June 16, 2007 Share Posted June 16, 2007 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) [center]uqoii.nl[/center] Link to comment Share on other sites More sharing options...
Locodarwin Posted June 17, 2007 Share Posted June 17, 2007 $sCell = $oExcel.ActiveWorkBook.ActiveSheet.Cells(3,3).Value ...will place the value of C3 into variable $sCell. -S (Yet Another) ExcelCOM UDF"A human being should be able to change a diaper, plan an invasion, butcher a hog, conn a ship, design a building, write a sonnet, balance accounts, build a wall, set a bone, comfort the dying, take orders, give orders, cooperate, act alone, solve equations, analyze a new problem, pitch manure, program a computer, cook a tasty meal, fight efficiently, die gallantly...[indent]...specialization is for insects." - R. A. Heinlein[/indent] Link to comment Share on other sites More sharing options...
UQOII Posted June 17, 2007 Author Share Posted June 17, 2007 thank you [center]uqoii.nl[/center] Link to comment Share on other sites More sharing options...
UQOII Posted June 17, 2007 Author Share Posted June 17, 2007 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 [center]uqoii.nl[/center] Link to comment Share on other sites More sharing options...
UQOII Posted June 17, 2007 Author Share Posted June 17, 2007 i already found it, thanx help file [center]uqoii.nl[/center] Link to comment Share on other sites More sharing options...
UQOII Posted June 18, 2007 Author Share Posted June 18, 2007 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() [center]uqoii.nl[/center] Link to comment Share on other sites More sharing options...
UQOII Posted June 19, 2007 Author Share Posted June 19, 2007 Also another question How can autoit read from another tab (not the active tab but Tab 2) [center]uqoii.nl[/center] Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now