Sign in to follow this  
Followers 0
dannydy

Read Cell from Excel file

3 posts in this topic

#1 ·  Posted (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 $cellvalue

Local $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 Then

msgbox(0, "Exceltest", "Error Getting an active Excel Object. Error Code : " & hex(@error,8))

Exit

EndIf

This 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 by dannydy

Share this post


Link to post
Share on other sites



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 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

Many Thanks...i did it.

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0