Problem with AutoIT and Excel

[kctvt 0]

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

[JoHanatCent 13]

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

[kctvt 0]

_ExcelReadSheetToArray ???

Umm... can you give me an example more clearly ?

[water 2,420]

The AutoIt help file has examples for every function.

In SciTE press F1 and go to User Defined Functions -> Excel