Sign in to follow this  
Followers 0
Automan Empire

Excel Read with ExcelCom

6 posts in this topic

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



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

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....

1100111 00001011101111 00011101101111 00010111100100 00001111110100 00110111110010 00101101111001 0011100i didn't make up this form of encryption, but i like it.credit to the lvl 6 challenge on arcanum.co.nz

Share this post


Link to post
Share on other sites

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

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  
Followers 0