Jump to content
Sign in to follow this  
qwertyking

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

Recommended Posts

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

Share this post


Link to post
Share on other sites
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 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  

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.