dannydy Posted January 20, 2012 Share Posted January 20, 2012 (edited) Hi Guys, need some helps here.i was doing some codes for reading cell from excel file. The file was opened in excel file from sharepoint #include <Excel.au3> #include <IE.au3> #include <Excel.au3>dim $cellvalueLocal $oIE = _IECreate("My sharepoint URL", Default, 1) Do Local $oDiv = _IEGetObjById($oIE,"ctl00_PlaceHolderMain_m_excelWebRenderer_ewaCtl_m_readModeToolbar_m_openInExcel") until isObj($oDiv) ; i get the HTML object ask it to open in excel file on my local machine sleep (5000) _IEAction($oDiv,"click") sleep (5000) Send("{DOWN}") send("{DOWN}{DOWN}{TAB}{ENTER}") ; there's a pop up asking me whether wanna make edition or open as read-only sleep (15000) Local $oExcel = ObjGet("Summary","Excel.Application") if @error Then msgbox(0, "Exceltest", "Error Getting an active Excel Object. Error Code : " & hex(@error,8)) Exit EndIf send("^d") sleep (5000) $cellvalue = _ExcelReadcell($oExcel,1,1) msgbox (0,"",$cellvalue)Local $oExcel = ObjGet("Summary","Excel.Application")if @error Thenmsgbox(0, "Exceltest", "Error Getting an active Excel Object. Error Code : " & hex(@error,8))ExitEndIfThis is where i hit the problem, the file open in excel successfully on my local machine, but i cant get it read the cell value.Appreciate if anyone could help up. Many thanks Edited January 20, 2012 by dannydy Link to comment Share on other sites More sharing options...
water Posted January 20, 2012 Share Posted January 20, 2012 AutoIt has a builtin Excel UDF - which you have already included in your script. Try function _ExcelReadCell after doing a _ExcelBookAttach. My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
dannydy Posted January 20, 2012 Author Share Posted January 20, 2012 Many Thanks...i did it. 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