krishpun 0 Posted April 5, 2011 (edited) 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 Share this post Link to post Share on other sites
hannes08 39 Posted April 5, 2011 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. Regards,Hannes[spoiler]If you can't convince them, confuse them![/spoiler] Share this post Link to post Share on other sites
water 2,389 Posted April 5, 2011 (edited) 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 My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2020-10-10 - Version 1.5.2.1) - Download - General Help & Support - Example Scripts - WikiOutlookEX (NEW 2020-12-15 - Version 1.6.3.1) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2020-06-27 - Version 1.3.2.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsPowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & SupportExcel - Example Scripts - WikiWord - WikiTask Scheduler (2019-12-03 - Version 1.5.1.0) - Download - General Help & Support - WikiTutorials:ADO - Wiki, WebDriver - Wiki Share this post Link to post Share on other sites
dmob 38 Posted April 5, 2011 (edited) 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 Share this post Link to post Share on other sites