|
Posted by Kiloran on February 6, 2006, 5:00 am
Please log in for more thread options
>
> >> I am creating file using the module and
> >> these files are sent to another server which uses Microsoft ADO
> >> Jet Drivers but is unable to open the files.
> >
> > Try the most recent version of the Spreadsheet::WriteExcel, 2.15, which
> > produces files in the Excel 97 format.
> >
> > This behaves better with ODBC, and hopefully with Jet as well.
> >
> > John.
>
> Thanks John...I did do this and it did the trick. I am now having an
issue
> with creating files with a large number of lines. I used to create files
> with 14000 lines, but it seems to be giving me problems now. This is the
> loop that creates the worksheets:
>
> # Process the output
> foreach my $flds (@report) {
> next unless $flds;
> for(my $i=0;$i<scalar(@$flds);$i++) {
> if (0==$row) {
> $sheet->write($row,$i,$flds->[$i],$heading);
> next;
> }
> $sheet->write($row,$i,$flds->[$i], $font_size);
> }
> $row++;
> }
>
> Can you see why this would work for a few rows but not for even 5000?
>
> Thanks
> Raj
>
Look at use Spreadsheet::WriteExcel::Big
http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel-2.16/lib/Spreadsheet/WriteExcel/Big.pm
Regards,
Alan
| 
XML Sitemap