dannydy 2 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 Share this post Link to post Share on other sites
water 2,386 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 2020-10-10 - Version 1.5.2.1) - Download - General Help & Support - Example Scripts - WikiOutlookEX (NEW 2020-12-15 - Version 1.6.3.1) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2020-06-27 - Version 1.3.2.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsPowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & SupportExcel - Example Scripts - WikiWord - WikiTask Scheduler (2019-12-03 - Version 1.5.1.0) - Download - General Help & Support - WikiTutorials:ADO - Wiki, WebDriver - Wiki Share this post Link to post Share on other sites
dannydy 2 Posted January 20, 2012 Many Thanks...i did it. Share this post Link to post Share on other sites