Beginners Excel question

[Chimaera]

Ive always used excel over the years but more played with it than used it properly

A friend has asked me to automate an excel sheet

It has about 17.000 products from different companes that he needs to check the status of a given company

So its a large one for what im normally used to

What he wants to do is send an update to suppliers then copy the update back in to the main sheet and then sort the updated products for each company on separate tabs.

So from browsing im looking at

ExcelBookOpen

ExcelReadSheetToArray << read the whole updated sheet

How do i search for the specifics i need to create the new tab do i just access the array or are there special excel things i need to do?

ExcelWriteSheetFromArray << write the single company results to a tab

ExcelBookSave

ExcelBookClose

[water]

The Excel UDF that comes with AutoIt is very, very slow on larger sheets (> a few hundred cells).

If you have a lot of time you could start with my rewrite of the Excel UDF. It is much faster. But still in Beta.

I would be happy to test the new UDF in a bigger project and will assist to solve all uprising problems.

[DarkLordZim]

this sounds very similar to one of the problems i'm being asked to solve.

we've ALWAYS loaded an Excel sheet to an array, then search that array... but now, they want me to search a spreadsheet with more than 14k rows, and at least 20 collumns...

I know it would be 100 times easier through using an Access database, but at present, that data isn't available to me in .mdb form.

is there a way to either, convert a spreadsheet to an access database through scripting (i can do it manually, but that doesn't meet the project scope)

or to search the spreadsheet without loading the whole thing into memory?

right now, i'm stuck trying to figure out what approach is going to be best or easiest.

Thanks!

[gruntydatsun]

http://stackoverflow.com/questions/4572064/how-can-i-programmatically-import-excel-data-into-an-access-table

hope this helps