in reply to Need to process Excel sheet through Perl

So basically I am looking for a method to extract the default header names like 'A', 'B', 'C', 'D' etc.

  • Comment on Re: Need to process Excel sheet through Perl

Replies are listed 'Best First'.
Re^2: Need to process Excel sheet through Perl
by Ratazong (Monsignor) on Dec 04, 2009 at 13:16 UTC
    So you want to have a way to convert the column-number to the A..XY-column-naming in Excel? This can be done by a simple algorithm (and without even "looking" at the spreadsheet...)
    A way how to do this can be found here .
    (Translating this visual-basic-script to perl is left as an exercise to the reader ;-)

    HTH Rata
[reply]

In Section Seekers of Perl Wisdom