Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

use Perl Log In

Log In

[ Create a new account ]

jj (2990)

jj
  (email not shown publicly)
http://perl.jonallen.info/

Software development manager for OpusVL [opusvl.com], member of Birmingham Perl Mongers [pm.org] and maintainer of http://perldoc.perl.org [perl.org].

Follow me on Twitter at twitter.com/JJ_Perl [twitter.com].

Journal of jj (2990)

Monday April 09, 2007
02:00 PM

XLSperl v0.3 released

[ #32947 ]

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.

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.