Could AutoIt be used to read an Excel spreadsheet and compare the data in it?

[cdorobantu]

Hi there,

I would like to know if (and how I should go about) it's possible to use AutoIt to read information from an Excel spreadsheet, compare the difference Excel entries and output the results in a GUI. I want to create a program in which the user can enter a store number and the hours of operations are displayed for that particular store. Now, I want to also be able to compare two store operating hours -> the program would display only the longer hours of the second store.

Your help is appreciated.

Catalin

[Zedna]

Use ExcelCOM UDF for reading data from Excel (into array).

Then do compare logic in AutoIt's arrays and visualize results in AutoIt's ListView.

GUICtrlCreateListView, GUICtrlCreateListViewItem

Edited September 14, 2007 by Zedna