Processing Excel Forms

I've recently been tasked to process a great many excel forms (around 400). My job is now merely to scrape the information and place the info in four different documents. I believe a short script would serve my needs perfectly, but I want to stay the hell away from VBA if I can. Any suggestions about how to go about this and what language to choose (I don't mind learning something new)?

Answers


I would recommend Python as the language the fits your problem because it's easy to learn, scriptable, and has the right language features (in this case objects and GUI libraries) to turn your work into an application for others to use if it turns into something more than just an occasion task for you.

As for the actual Excel processing, there's a set of Python libraries. The link also includes a 50+ PDF documentation manual with usage examples for reading, writing and manipulating workbooks.


Have you considered Perl?


Need Your Help

Bundling virus protection for your .exe

exe

Is there a way i could bundle virus protection(a kind of virus shield) for my final .exe?

How make a cross-browser custom list-style markers?

css

I need to make a custom list-style markers. Now it's done by adding element before li, but exist one problem. The remaining lines should be aligned with the text for the marker, such as normal marked

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.