Excel question

[saywell]

I'm a very basic excel user, and have never before needed to use the Excel UDF.

I have now been asked to write a script that will process a very large csv file, which will mean working through each cell column by column, altering its content according to set rules.

This looks quite easy using _ExcelReadArray and its write equivalent, then looping through it doing what's necessary.

However, the files are huge - the first is over 12,000 rows and will get bigger each quarter through the year.

My question is; how do I get the number of rows?

_ExcelReadSheetToArray gives the number of rows in [0][0] but it takes ages to read in [hence my doing it one column at a time]. the ReadArray function requires the number of rows to be provided.

Is there a more elegant way of getting this value?

Regards,

William

[water]

You could use _ExcelBookOpen and specify the CSV file to open. $oExcel.ActiveSheet.UsedRange.Rows.Count should tell you how many rows to process.

[saywell]

Thanks, water, that works a treat!!

Regards,

William

[water]