I wrote a program to do exactly this. This is very bad code, as it was mostly a one-off for a batch process, and after I got it working, I moved on. I was also not very good with Perl at the time. 

#!/usr/bin/perl

use strict;
use warnings;

use Spreadsheet::ParseExcel::Simple;
use Text::CSV_XS;
use IO::File;
use File::Spec;

for (@ARGV) {
    for (glob $_) {
        next unless m/\.xls$/i;
        next unless -r $_;
        dump_books($_);
    }
}

sub dump_books {
    my ($vol, $path, $file) = File::Spec->splitpath(shift);
    my $eBook = Spreadsheet::ParseExcel::Simple->read(File::Spec->catp
+ath($vol,$path,$file));
    my @sheet = $eBook->sheets;
    for (0..@sheet-1) {
        next unless $sheet[$_]->has_data();
        my $sfn = $file;
        $sfn =~ s?\.xls$??i;
        $sfn.= ((@sheet > 1) ? sprintf(".%02i",$_) : "").'.csv';
        
        my $io = IO::File->new();
        $io->open('<'.$sfn) or do {
            warn "Unable to write to $sfn";
            next;
        };
        
        my $csv = Text::CSV->new;
        
        while ($sheet[$_]->has_data) { 
            my @row = $sheet[$_]->next_row;
            $csv->print($io, \@row);
        }
        
        $io->close;
    }
}

[download]

This only really works with ActiveState Perl, but could be tweaked by altering the parameters to the Text::CSV_XS new() call. There's lots of error handling and process improvement that could go on here, and it will fail miserably on complex XLS books.

On the upside, each sheet in an Excel book will end up in its own CSV file. Hopefully this will give you a place to start.

<-radiant.matrix->
Larry Wall is Yoda: there is no try{} (ok, except in Perl6; way to ruin a joke, Larry! ;P)
The Code that can be seen is not the true Code
"In any sufficiently large group of people, most are idiots" - Kaa's Law

In reply to Re: Changing a file from XLS format to CSV. by radiantmatrix
in thread Changing a file from XLS format to CSV. by TASdvlper

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.