XLSperl v0.3 released

jj on 2007-04-09T19:00:23

As part of the Birmingham Perl Mongers World Tour, I recently gave my "Excel on the Command Line" talk to the Gloucester Linux User Group.

A few days later I received an email from one of the attendees who'd tried out the accompanying software, XLSperl (which lets you use Perl one-liners to process Microsoft Excel files), with a few suggestions.

So, after a few train journeys spent hacking code I've released a new version which has the following improvements:

  • The %F and @F variables (in autosplit mode) are tied, so modifying $F{A} also changes $F[0]
  • You can now create Excel files from XLSperl, using the new "XLSprint" command
  • XLSperl can now process plain text as well as Excel files (for easy conversion of text data into XLS format)
Source code and binaries for Linux x86, Windows, and Mac OS X (Intel) can be downloaded from http://perl.jonallen.info/projects/xlstools.