Hacker News Reader

My own job has some form requirements, one of which is a spreadsheet in Excel. Looks like I just found a way to automate that...

View on HN

Python also has excellent Excel libraries for reading and writing Excel documents natively. http://www.python-excel.org/

Why not just use VBA?

Well, I have an Excel version of this: [1]

When I order a part, I have to enter all of this data. Most of the parts I order are repeat orders; I have all of my previous ones on file. I have a program right now that makes a LaTeX document for another form I have to fill out; I put in the NSN, and it populates the form with all of the rest of the information.

Up until now, I'd thought that I wouldn't be able to do the same thing with an Excel spreadsheet, and I haven't been able to build a table like that in LaTeX. So, this extension to Python seems to be the best option.

[1] (PDF) http://www.dtic.mil/whs/directives/infomgt/forms/eforms/dd13...

so, you're willing to pay USD $500.00 just for that?

Damn it, I thought it was freeware. That throws a monkey wrench in there...

Look into xlrd3/xlwt3. They're free and platform independent, not as smooth interfacing as DataNitro though.

sincere question - what do you value your time at?

because there's a better, more powerful tool, which is also easier to use

Reply on news.ycombinator.com