Jump to content
Sign in to follow this  
Chimaera

Beginners Excel question

Recommended Posts

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

Share this post


Link to post
Share on other sites
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.


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2018-12-03 - Version 1.4.11.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-10-31 - Version 1.3.4.1) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
 
Tutorials:

ADO - Wiki

 

Share this post


Link to post
Share on other sites
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!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×