ps124

Hi,
I am working on a project that requires me to check for accuracy of data in certain excel files. I need to write a program to make those checks. The files are huge, with around 5000 rows in each, and at times I also need to compare two-three files at the same time, to make comparisons. I need to figure out which language would be most suitable for this type of manipulation. It needs to be something that would be good for manipulating large amount of words/numbers and should be easy to use with excel files. Could I please have some suggestions?
Thanks a lot.

DaWei

VBA. Check the help docs for Excel, specifically the VB/Macro part.

__________________
The person who coined the phrase, "There's no such thing as a stupid question," hasn't hung around here much.

Contributor's Corner: Grumpy on C++ Exceptions DaWei on Pointers
Politically Incorrect

ps124

Thank you for your reply. Can you please tell me if VBA macro would be a good solution for multiple simultaneous inputs, since I need to be making quite a number of comparisons?

CoderGuru

Using the default Excel com objects isn't always ideal. 1) It is memory intense and 2) Requires excel to be installed, which isn't always the case.

There are excel classes out there though for almost every language that will allow you to read and write excel files, ranging from free to extremely expensive, depending on what you need. Example: If you need to know the value after calucations are eventuated, such as Cell F4 is "55" not "=C3+B3" then your likely going to want to get licensed software, but if you only care to know Cell F5 holds "=C3+B3" then any of the open source options should work.

Basically figure out what exactly you need and what language you feel most comfortable with, and chances are you can find something that will work for it.

__________________
Dallas Web Design | Texas Web Design | www.ChillAxen.com | Renee C. Greco Fund

charlieangles

I made some projects in which I had modified the excel File by using the VB6 programming. You can easily modify the excel Sheet by using the VB6, VB.Net. Now it is up-to you, which language you know most.

__________________
Web Design Kent