title: Best language to parse extremely large Excel 2007 files
body: <p>My boss has a habit of performing queries on our databases that return tens of thousands of rows and saving them into excel files.  I, being the intern, constantly have to write scripts that work with the information from these files.  Thus far I've tried VBScript and Powershell for my scripting needs.  Both of these can take several minutes to perform even the simplest of tasks, which would mean that the script when finished would take most of an 8 hour day.</p>
  
  <p>My workaround right now is simply to write a PowerShell script that removes all of the commas and newline characters from an xlsx file, saves the .xlsx files to .csv, and then have a Java program handle the data gathering and output, and have my script clean up the .csv files when finished.  This runs in a matter of seconds for my current project, but I can't help but wonder if there's a more elegant alternative for my next one.  Any suggestions?</p>