Sign in to follow this  
Followers 0
qwertyking

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

2 posts in this topic

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

Share this post


Link to post
Share on other sites



#2 ·  Posted (edited)

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 by randallc

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