X-Original-To: pgsql-interfaces@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 536984762A2
	for <pgsql-interfaces@postgresql.org>;
	Fri, 11 Apr 2003 18:05:38 -0400 (EDT)
Received: from news.hub.org (news.hub.org [64.49.215.80])
	by postgresql.org (Postfix) with ESMTP id CA98E4761BC
	for <pgsql-interfaces@postgresql.org>;
	Fri, 11 Apr 2003 18:05:37 -0400 (EDT)
Received: by news.hub.org (Postfix, from userid 8)
	id B29C643A89E; Fri, 11 Apr 2003 18:05:37 -0400 (EDT)
From: jmcnamara@cpan.org (John McNamara)
X-Newsgroups: comp.databases.postgresql.interfaces
Subject: Re: export to excel format
Date: 11 Apr 2003 15:05:34 -0700
Organization: http://groups.google.com/
Lines: 30
Message-ID: <8cceb2da.0304111405.26ecc247@posting.google.com>
References: <20030411142918.GA26041@wolff.to>
Content-Type: text/plain; charset=ISO-8859-1
X-Complaints-To: groups-abuse@google.com
To: pgsql-interfaces@postgresql.org
Content-Transfer-Encoding: quoted-printable
X-Spam-Status: No, hits=-29.3 required=5.0
	tests=BAYES_01,EMAIL_ATTRIBUTION,QUOTED_EMAIL_TEXT,REFERENCES,
	REPLY_WITH_QUOTES autolearn=ham	version=2.50
X-Spam-Level: 
X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp)
X-Archive-Number: 200304/116
X-Sequence-Number: 4055

bruno@wolff.to (Bruno Wolff III) wrote:

> I wrote a perl program that gets data from
> the database and writes excel spreadsheets. It uses Spreadsheet::WriteExc=
el
> which you can get from CPAN. It seems to be pretty slow. It takes about
> 3 minutes to produce a 4MB spreadsheet.


Are you sure that the delay is caused by Spreadsheet::WriteExcel. The
following program produces a 4MB file in 3 seconds on a P700:


    #!/usr/bin/perl -w

    use strict;
    use Spreadsheet::WriteExcel;

    my $workbook  =3D Spreadsheet::WriteExcel->new("4mb.xls");
    my $worksheet =3D $workbook->addworksheet();

    for my $row (0 .. 8_100) {
        $worksheet->write($row, 0, "Test string " x 20);
        $worksheet->write($row, 1, "Test string " x 20);
    }

    __END__


John.
--