Excel Read with ExcelCom

[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?

[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!

[randallc]

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

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

[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

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