kctvt 0 Posted April 27, 2011 Problem with AutoIT and Excel Hi there, I creating a soft help me do something in Excel. I want to creat a soft help me manage salary. In below Piture, you will see what I want to do.I have 3 Table.- General Data.- Data Employees.- Data Commission. I want to know the Commission when I use Autoit with Excel. This is my code : expandcollapse popup#include <IE.au3> #include <File.au3> #include <Array.au3> #include <Date.au3> #Include <Excel.au3> #include <Word.au3> #include <FTPEx.au3> $partDataEmployees = "E:\DataEmployees.xls" $partDataGeneral = "E:\DataGeneral.xls" $partDataCommission = "E:\DataCommission.xls" $oExcelDataEmployees = _ExcelBookOpen($partDataEmployees) $oExcelDataGeneral = _ExcelBookOpen($partDataGeneral) $oExcelDataCommission = _ExcelBookOpen($partDataCommission) $b = 3 Do IF _ExcelReadCell($oExcelDataGeneral,$b,9) = "" then _ExcelReadCell($oExcelDataGeneral,$b,5) _ExcelReadCell($oExcelDataGeneral,$b,6) _ExcelReadCell($oExcelDataGeneral,$b,7) _ExcelReadCell($oExcelDataGeneral,$b,8) $a = 17 Do $Name = _ExcelReadCell($oExcelDataEmployees,$a,2) $Phone = _ExcelReadCell($oExcelDataEmployees,$a,3) $Email = _ExcelReadCell($oExcelDataEmployees,$a,4) If $Name = _ExcelReadCell($oExcelDataGeneral,$a,8) and _ExcelReadCell($oExcelGeneral,$a,10) = "" then [color="#FF0000"][b]Start count total service of that saler, and count commission. Such as : - Tom have 2 Hosting not paid yet, 1 host paid --> Commission is 20$/hosting. - Luci have 5 hosting not paid yet, 2 hosting paid ---> Commission is 40$/hosting. ===> I dont know how to do this. Count hosting. [/b][/color]This is my problem. Hope everybody'll help me. Thanks Share this post Link to post Share on other sites
JoHanatCent 13 Posted April 28, 2011 (edited) Problem with AutoIT and Excel This is my problem. Hope everybody'll help me. Thanks Did you try to use _ExcelReadSheetToArray ? Edited April 28, 2011 by JoHanatCent Share this post Link to post Share on other sites
kctvt 0 Posted April 28, 2011 _ExcelReadSheetToArray ??? Umm... can you give me an example more clearly ? Share this post Link to post Share on other sites
water 2,424 Posted April 28, 2011 The AutoIt help file has examples for every function. In SciTE press F1 and go to User Defined Functions -> Excel My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2021-04-14 - Version 1.5.3.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX (NEW 2021-04-13 - Version 1.6.4.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (NEW 2021-04-13 - Version 1.4.0.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