Re:Excel and SQL
by regularfry on Friday May 24, 2013 @07:05AM
(#5762108)
There are many, many organisations which use Excel sheets as de facto standard interfaces, or "applications" you have to use, because it's the only common tool the people with the domain knowledge have access to and are trained in, and sharing them is trivial - just email a .xlsx. I've seen government regulators supply template Excel sheets as the mandated standard by which private companies must, legally, submit data.
Being able to interact with those spreadsheets in a sensible language with a front-end that doesn't suck would be huge.
In this case you have someone that understands SQL and Python, but still wants to use a spreadsheet. Applying the predicates at the start, this person should dump Excel entirely - they can get much better integrity using SQL and Python alone.