Jump to content
Sign in to follow this  
Automan Empire

Excel Read with ExcelCom

Recommended Posts

Automan Empire

Greetings all,

I am trying to read and write from an excel file using AutoIt v3, SciTE, and ExcelCom. I have copied ExcelCom.au3 to the includes folder, and here is a scrap that I am attempting to run...

#include<ExcelCom.au3>
$sFilePath="samplexls.XLS"
$Sheet="Sheet1"
$Column="A"
$Row="1"
$cellread= _XLread($sFilePath,$Sheet,$Column,$Row)
MsgBox(0, "", $cellread )

and I get the following:

ERROR: can't open include file <GuiListView.au3>

Any suggestions?


"I've seen your work in the past, and it's novice at best..." SmOke_N

Share this post


Link to post
Share on other sites
Automan Empire

Hmmm

I have read that this is only supported in the beta version. Downloading it now. If true, then I will only need to work on my attrocious syntax errors!


"I've seen your work in the past, and it's novice at best..." SmOke_N

Share this post


Link to post
Share on other sites
seandisanti

Greetings all,

I am trying to read and write from an excel file using AutoIt v3, SciTE, and ExcelCom. I have copied ExcelCom.au3 to the includes folder, and here is a scrap that I am attempting to run...

#include<ExcelCom.au3>
$sFilePath="samplexls.XLS"
$Sheet="Sheet1"
$Column="A"
$Row="1"
$cellread= _XLread($sFilePath,$Sheet,$Column,$Row)
MsgBox(0, "", $cellread )

and I get the following:

ERROR: can't open include file <GuiListView.au3>

Any suggestions?

i actually got this error with SciTE the other day, except with IE.au3. the file was good, the include directory was good, i could open the ie.au3 file with SciTE, and just couldn't get around that error. What i ended up doing, was copying all of the script from the file i was writing, then deleting the file i was writing, and pasting the script into a new file with the same name. same script, no error. i wasn't able to figure out what caused it, but that was the only way i got around it, even after i tried replacing the IE.au3, restarting SciTE, renaming the script i was writing with save as....

Share this post


Link to post
Share on other sites
randallc

Hi,

you have reminded me that this happened to me the other day on a computer i don't usuall use.

I woinder if it is because the beta is inconsistently referring to "autoIt3\Include" files, or "autoIt3\Beta\Include" files; I can't work it out?...

Randall

Share this post


Link to post
Share on other sites
Automan Empire

Hi,

Should work if you give full path

[$sFilePath=@ScriptDir&"\ListView.xls"]

See syntax in example scripts in the ExcelCom link in my signature.

best, Randall

Randall,

Thank you very much. It worked. You are The Man.


"I've seen your work in the past, and it's novice at best..." SmOke_N

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  

×