Alfred Vahau wrote:
> The Spreadsheet::ParseExcel will dump all the worksheets one after the
> other into one big file. Is this your observation.
> The first line of the file will be the first row of worksheet 1. From
> this the last column can be extracted which contains the
> file name.
>
> If t
The Spreadsheet::ParseExcel will dump all the worksheets one after the
other into one big file. Is this your observation.
The first line of the file will be the first row of worksheet 1. From
this the last column can be extracted which contains the
file name.
If the user still insists on the fil
David Van Ginneken wrote:
> This node may help you.
>
> http://www.perlmonks.org/index.pl?node_id=379743
>
> Basically you create a custom cell handler. The one I use looks
> something like this.
David responded but only to me, but if you need to work with Excel and
only need to search
On Wed, 30 Mar 2005 09:04:23 -0800, Wagner, David --- Senior
Programmer Analyst --- WGO wrote:
>
> Sorry for not being clear. I can find the files I want, but to open
> them takes way too long.
> On my test node, to open the four files and get the first line of worksheet 1
> took almo
Kevin Old wrote:
> On Tue, 29 Mar 2005 13:30:57 -0800, Wagner, David --- Senior
> Programmer Analyst --- WGO <[EMAIL PROTECTED]> wrote:
>> I have a directory which has output reports in them. The
>> big problem is that they are just a bunch of letters and numbers
>> like 2781424330fdac47c9
On Tue, 29 Mar 2005 13:30:57 -0800, Wagner, David --- Senior
Programmer Analyst --- WGO <[EMAIL PROTECTED]> wrote:
> I have a directory which has output reports in them. The big problem
> is that they are just a bunch of letters and numbers like
> 2781424330fdac47c916.xls. So the user w
I have a directory which has output reports in them. The big problem
is that they are just a bunch of letters and numbers like
2781424330fdac47c916.xls. So the user would like a more recognizable file name.
This is to run on Solaris w/ Perl 5.8.3. I have tried the following
t
