开发者

Processing Excel Forms

开发者 https://www.devze.com 2023-01-28 18:23 出处：网络

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 wou

相关专题：excel

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 d开发者_C百科on't mind learning something new)?

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?