This is complete nonsense:
> $xls->set_column(6, 7, 50);
please read the docs:
Perl/site/lib/Spreadsheet/WriteExcel/doc/WriteExcel.html#set_column_first_col_last_col
--
Andreas Schmitz http://www.medialsoft.de
_ _ _ _ ° _ _ _ _ _
| | ||_ | \|| || _| (_)|- |
| | ||_ |_/||-||__
This is getting pretty OT as well. So possibly you can either ask in
person, or on comp.lang.perl.misc
Thanks.
Ilya
-Original Message-
From: NIPP, SCOTT V (SBCSI)
To: Sterin, Ilya; ''Jeff Zucker' '; 'dbi-users '
Sent: 10/3/02 8:29 AM
Subject: RE: Databas
Where did you get the set_column method, I don't even see one in perldoc?
Ilya
-Original Message-
From: NIPP, SCOTT V (SBCSI)
To: Sterin, Ilya; ''Jeff Zucker' '; 'dbi-users '
Sent: 10/3/02 8:29 AM
Subject: RE: Database to Excel script...
I am t
CSI); ''Jeff Zucker' '; 'dbi-users '
Subject: RE: Database to Excel script...
Actually I can set up some event handlers in DBIx::Dump, which will allow
you to assign an even handler to handle transformations.
Give me until tomorrow noon.
Ilya
-Original Message---
PM
Subject: RE: Database to Excel script...
OK... I am stuck once again. I am to pull the data from the
database and export it directly to an Excel file. Now, I am trying to
figure out the formatting... The first problem I am running into is
reformatting dates from the output of My
> From: "NIPP, SCOTT V (SBCSI)" <[EMAIL PROTECTED]>
> Subject: RE: Database to Excel script...
>
> OK... I am stuck once again. I am to pull the data from the
> database and export it directly to an Excel file. Now, I am trying to
> figure out the formatting.
)739-4409 Fax: (302)739-6242
www.dnrec.state.de.us/
-Original Message-
From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 02, 2002 16:46
To: 'Jeff Zucker'; Sterin, Ilya; dbi-users
Subject: RE: Database to Excel script...
OK... I am stuck
a; dbi-users
> Subject: RE: Database to Excel script...
>
> OK... I am stuck once again. I am to pull the data from the
> database and export it directly to an Excel file. Now, I am trying to
> figure out the formatting... The first problem I am running into is
> reform
format. Any help would be greatly
appreciated.
-Original Message-
From: Jeff Zucker [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 01, 2002 6:51 PM
To: Sterin, Ilya; dbi-users
Subject: Re: Database to Excel script...
Sterin, Ilya wrote:
> Jeff, that's helpful:-)
>
> but
Sterin, Ilya wrote:
> Jeff, that's helpful:-)
>
> but that does not pupulat the excel spreadsheet with data from a select
> query, rather you have to select and loop while do()ing it.
>
> There is lot of overhead for certain things, I just though a simple mod
> would help to just dump data, and
Sent: Tuesday, October 01, 2002 11:14 AM
> To: NIPP, SCOTT V (SBCSI)
> Cc: '[EMAIL PROTECTED]'
> Subject: Re: Database to Excel script...
> $dbh->trace( 2, "dbitrace.log" );
> # trace verfolgung
# trace pursuit
>
KAWAI,Takanori wrote:
> $hDbE->func('dump.xls', 'save');
Hmm, forget my patch, I missed that somehow :-(. Actually the one part
of the patch you might want to keep is the part that creates a new .xls
file if the one in the connect doesn't exist yet. Here's the patch for
that part. (Please
- Original Message -
From: "NIPP, SCOTT V (SBCSI)" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, October 02, 2002 12:04 AM
Subject: Database to Excel script...
> I have a MySQL database that I have a few Perl scripts working on.
> I am now looking into doing some reporting
AIL PROTECTED]>
Sent: Wednesday, October 02, 2002 6:41 AM
Subject: Re: Database to Excel script...
> Ilya Sterin wrote:
> >
> >Jeff Zucker wrote
> >>
>
> >>With Kawai Takanori's DBD::Excel (on CPAN).
> >
> >Yes, but DBD::Excel allow
t: 10/1/02 3:41 PM
Subject: Re: Database to Excel script...
Ilya Sterin wrote:
>
>Jeff Zucker wrote
>>
>>With Kawai Takanori's DBD::Excel (on CPAN).
>
>Yes, but DBD::Excel allows you to query Excel files, not dump them.
Here's a somewhat simple minded patch to
Ilya Sterin wrote:
>
>Jeff Zucker wrote
>>
>>With Kawai Takanori's DBD::Excel (on CPAN).
>
>Yes, but DBD::Excel allows you to query Excel files, not dump them.
Here's a somewhat simple minded patch to DBD::Excel that allows one to
create and populate an Excel file with standard SQL CREATE
DBIx::Dump :-)
https://pause.perl.org/pub/PAUSE/authors/id/I/IS/ISTERIN/DBIx-Dump-0.01.tar
Ilya
-Original Message-
From: NIPP, SCOTT V (SBCSI)
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Sent: 10/1/02 9:39 AM
Subject: RE: Database to Excel script...
Yes, but DBD::Excel allows you to query Excel files, not dump them.
Ilya
-Original Message-
From: Jeff Zucker [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 01, 2002 11:37 AM
To: dbi-users
Subject: Re: Database to Excel script...
Sterin, Ilya wrote:
> You can easily accompl
PROTECTED]]
Sent: Tuesday, October 01, 2002 11:14 AM
To: NIPP, SCOTT V (SBCSI)
Cc: '[EMAIL PROTECTED]'
Subject: Re: Database to Excel script...
Here we go:
>
> I have a MySQL database that I have a few Perl scripts working on.
> I am now looking into doing some reportin
Sterin, Ilya wrote:
> You can easily accomplish that by dumpin into a CSV (comma separated file)
> with .csv extension which will open in excel as you want.
Here's one for the FAQ:
How do I use DBI with Excel?
With Kawai Takanori's DBD::Excel (on CPAN). It provides a DBI interface
on top of
); ''[EMAIL PROTECTED]' '
Subject: RE: Database to Excel script...
You can easily accomplish that by dumpin into a CSV (comma separated file)
with .csv extension which will open in excel as you want.
Ilya
-Original Message-
From: NIPP, SCOTT V (SBCSI)
To: '[EMAI
Here we go:
>
> I have a MySQL database that I have a few Perl scripts working on.
> I am now looking into doing some reporting on these database tables. I
> would really like to find a script that queries the database and the uses
> the Spreadsheet::WriteExcel module to output the data
You can easily accomplish that by dumpin into a CSV (comma separated file)
with .csv extension which will open in excel as you want.
Ilya
-Original Message-
From: NIPP, SCOTT V (SBCSI)
To: '[EMAIL PROTECTED]'
Sent: 10/1/02 9:04 AM
Subject: Database to Excel script...
I have a My
23 matches
Mail list logo
