Reading multiple columns with Excel UDF ( ExcelCom.au3 ) R1C1 Reference?

[qwertyking]

I am trying to use Excel UDF to read cells from excel. I need to read in 31 columns from a certain rows. I considered changing the columns to ascii values but the problem would be after column "Z" such as AA or AB. I wanted to use R1C1 reference so I can just may a simple for loop to read through the columns, but I cannot send R1C1 references to ExcelCom.au3

[randallc]

Hi,

It IS possible to do;[the $column" parm AND $row parm m will both accept a number variable from a loop; the "row" is ony ignored if the column is a range]

but who would bother?;

You will find, if you are reading and manipulating data from one or 2 sheets only at a time, that reading the sheet to an array is fast [using _XLArrayRead func]; then manipulate it in AutoIt; then save back the array [_XLArrayWrite] - see examples for use.

Read Exel lines without run(exel)Best, randall Edited August 30, 2006 by randallc