Excel file management

[krishpun]

Can you please let me know

1)how to count the number of rows having data in a column in a excel file?

2)how to insert formula for substraction dynamically in a excel sheet?

regards,

Krishna

Edited April 5, 2011 by krishpun

[hannes08]

Hi Krishna,

please have a look at the help file in the sections: _ExcelReadArray and _ExcelWrite.

if you read a range / column to an array, you can easily check which ones are empty.

[water]

2)how to insert formula for substraction dynamically in a excel sheet?

To insert formulas please use function _ExcelWriteFormula of the Excel UDF built into AutoIt. Edited April 6, 2011 by water

[dmob]

Hi Krishna,

please have a look at the help file in the sections: _ExcelReadArray and _ExcelWrite.

if you read a range / column to an array, you can easily check which ones are empty.

Or you could use the ExcelUsedRangeGet function in the Excel_COM UDF.

Edited April 5, 2011 by dmob