[29893] in Perl-Users-Digest
Perl-Users Digest, Issue: 1136 Volume: 11
daemon@ATHENA.MIT.EDU (Perl-Users Digest)
Fri Dec 21 11:09:44 2007
Date: Fri, 21 Dec 2007 08:09:08 -0800 (PST)
From: Perl-Users Digest <Perl-Users-Request@ruby.OCE.ORST.EDU>
To: Perl-Users@ruby.OCE.ORST.EDU (Perl-Users Digest)
Perl-Users Digest Fri, 21 Dec 2007 Volume: 11 Number: 1136
Today's topics:
Re: How about csh-like (nested, etc)? Re: How to get th <bik.mido@tiscalinet.it>
Re: Problem installing DBD::mysql <thepoet_nospam@arcor.de>
Re: Problem installing DBD::mysql <newsmanDELETE@REMOVEdahl-stamnes.net>
Re: Problem installing DBD::mysql <m@rtij.nl.invlalid>
Re: Problem installing DBD::mysql <thepoet_nospam@arcor.de>
Re: Problem installing DBD::mysql <newsmanDELETE@REMOVEdahl-stamnes.net>
Re: Problem installing DBD::mysql <m@rtij.nl.invlalid>
Re: Which editor for Perl hacking are you using <gamo@telecable.es>
Re: Which editor for Perl hacking are you using <p.lepin@ctncorp.com>
Re: Which editor for Perl hacking are you using <bik.mido@tiscalinet.it>
Re: Which editor for Perl hacking are you using <m@rtij.nl.invlalid>
Re: Which editor for Perl hacking are you using <usenet@larseighner.com>
Re: Which editor for Perl hacking are you using <devliegendehollander@attempt-at-not-applicable-domain-name.com>
Re: Which editor for Perl hacking are you using <joost@zeekat.nl>
Re: Which editor for Perl hacking are you using <yankeeinexile@gmail.com>
Re: Which editor for Perl hacking are you using <stoupa@practisoft.cz>
Re: WriteExcel module, reopening a file <tadmc@seesig.invalid>
Re: WriteExcel module, reopening a file jmcnamara13@gmail.com
Digest Administrivia (Last modified: 6 Apr 01) (Perl-Users-Digest Admin)
----------------------------------------------------------------------
Date: Fri, 21 Dec 2007 13:19:06 +0100
From: Michele Dondi <bik.mido@tiscalinet.it>
Subject: Re: How about csh-like (nested, etc)? Re: How to get the string Cartesian Products of 2 list
Message-Id: <lmbnm35fhg2141c2jq226cv5pmin8d1mo4@4ax.com>
On Fri, 21 Dec 2007 03:38:19 +0000 (UTC), dkcombs@panix.com (David
Combs) wrote:
>>Give 2 string list such as: a..b and 1..3, i want to get a list which
>>is (a1, a2, a3, b1, b2, b3). Is there an elegant way in perl to
>>fullfill this withou using loop BLOCK? Or Is there a elegant one line
>>expression to get this?
>
>Lots of neat solutions to *this* problem in this thread!
>
>Now, how about generalizing it to eg what csh, etc, has:
>
> {a, b, c, {e, f, g}{1,2}, x}{" hello", "goodbye"} etc
>
>How to even *approach* this problem, or even *think* about it.
Well Perl 6 should have that. I know because I once asked in p6l,
however I can't remember the syntax offhand, and it may have changed
in the meanwhile. Currently, we have Algorithm::Loops::NestedLoops().
Michele
--
{$_=pack'B8'x25,unpack'A8'x32,$a^=sub{pop^pop}->(map substr
(($a||=join'',map--$|x$_,(unpack'w',unpack'u','G^<R<Y]*YB='
.'KYU;*EVH[.FHF2W+#"\Z*5TI/ER<Z`S(G.DZZ9OX0Z')=~/./g)x2,$_,
256),7,249);s/[^\w,]/ /g;$ \=/^J/?$/:"\r";print,redo}#JAPH,
------------------------------
Date: Fri, 21 Dec 2007 13:58:12 +0100
From: Christian Winter <thepoet_nospam@arcor.de>
Subject: Re: Problem installing DBD::mysql
Message-Id: <476bb86a$0$16668$9b4e6d93@newsspool3.arcor-online.net>
Jørn Dahl-Stamnes schrieb:
> Christian Winter wrote:
>> Jørn Dahl-Stamnes schrieb:
>>> Checking if your kit is complete...
>>> Looks good
>>> Using DBI 1.48 (for perl 5.008006 on x86_64-linux-thread-multi) installed
>>> in /usr/lib64/perl5/vendor_perl/5.8.6/x86_64-linux-thread-multi/auto/DBI/
>>> Writing Makefile for DBD::mysql
>>> cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm
>>> cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm
>>> cp lib/Mysql.pm blib/lib/Mysql.pm
>>> cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod
>>> cp lib/Mysql/Statement.pm blib/lib/Mysql/Statement.pm
>>> cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm
>>> gcc -c
>>> -I/usr/lib64/perl5/vendor_perl/5.8.6/x86_64-linux-thread-multi/auto/DBI/
>>> -I/usr/include/mysql -g -pipe -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -m32
>> The "-m32" above and the "-march=i386" following that one point to the
>> culprit. It looks as if the mysql libraries gcc tries to link against
>> are 32bit, with the offending arguments steming from the output of the
>> "mysql_config" script.
>>
>>> -march=i386 -mtune=pentium4 -fasynchronous-unwind-tables -D_GNU_SOURCE
>>> -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -fno-strict-aliasing
>>> -DDBD_MYSQL_WITH_SSL -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -D_REENTRANT
>>> -D_GNU_SOURCE -DDEBUGGING -fno-strict-aliasing -pipe -I/usr/local/include
>>> -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g
>>> -pipe -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -m64 -mtune=nocona
>>> -DVERSION=\"2.9008\" -DXS_VERSION=\"2.9008\" -fPIC
>>> "-I/usr/lib64/perl5/5.8.6/x86_64-linux-thread-multi/CORE" dbdimp.c
>>> dbdimp.c:1: error: CPU you selected does not support x86-64 instruction
>>> set
>> So the error message is quite precise. I'm not familiar enough with
>> fedora, but basically you need to make sure that you have 64bit libs
>> installed and a mysql_config that returns the correct values for the
>> 64bit libraries. Then you should at least be able to do a manual install
>> of DBD::mysql with
>> perl Makefile.PL mysql_config=/path/to/correct/mysql_config
>
> After doing this, I checked the Makefile and found the line:
>
> LIBC = /lib/libc-2.3.4.so
>
> But there is no such file on my system. The one I got is /lib/libc-2.3.5.so
> I tried to change this, but no changes - same error when doing 'make'.
>
> I'm not sure which libraries that are missing/wrong.
So your system is likely mixed up a bit with libraries/tools that
have been linked against different glibc versions. It might be possible
to update/recompile everything linked against 2.3.4, though that's
often a PITA with older distributions and packages that have a lot of
interdepencenies. The LIBC setting above should stem from the perl
binary itself ('perl -V | grep libc' should confirm that). So most
probably you need a newer Perl rpm or compile it again to link against
your current environment.
-Chris
------------------------------
Date: Fri, 21 Dec 2007 14:17:05 +0100
From: =?ISO-8859-1?Q?J=F8rn?= Dahl-Stamnes <newsmanDELETE@REMOVEdahl-stamnes.net>
Subject: Re: Problem installing DBD::mysql
Message-Id: <476bbcd1@news.broadpark.no>
Christian Winter wrote:
> So your system is likely mixed up a bit with libraries/tools that
> have been linked against different glibc versions. It might be possible
> to update/recompile everything linked against 2.3.4, though that's
> often a PITA with older distributions and packages that have a lot of
> interdepencenies. The LIBC setting above should stem from the perl
> binary itself ('perl -V | grep libc' should confirm that). So most
> probably you need a newer Perl rpm or compile it again to link against
> your current environment.
[root@jedi DBD-mysql-4.005]# perl -V | grep libc
libc=/lib/libc-2.3.4.so, so=so, useshrplib=true, libperl=libperl.so
gnulibc_version='2.3.5'
I also tried to upgrade perl by using yum, but that does not work very well
(see below). Perhaps I need to install perl from source?
[root@jedi ~]# yum upgrade perl-*
Setting up Upgrade Process
Setting up repositories
Reading repository metadata in from local files
Resolving Dependencies
--> Populating transaction set with selected packages. Please wait.
---> Downloading header for perl-DBD-MySQL to pack into transaction set.
perl-DBD-MySQL-2.9007-1.x 100% |=========================| 7.4 kB 00:00
---> Package perl-DBD-MySQL.x86_64 0:2.9007-1 set to be updated
--> Running transaction check
--> Processing Dependency: libmysqlclient.so.14()(64bit) for package:
perl-DBD-MySQL
--> Restarting Dependency Resolution with new changes.
--> Populating transaction set with selected packages. Please wait.
---> Downloading header for mysql to pack into transaction set.
http://download.fedoraproject.org/pub/fedora/linux/core/updates/4/x86_64/mysql-4.1.20-1.FC4.1.x86_64.rpm:
[Errno 4] IOError: HTTP Error 502: Date: Fri, 21 Dec 2007 13:14:04 GMT
Content-Length: 490
Content-Type: text/html; charset=iso-8859-1
Trying other mirror.
mysql-4.1.20-1.FC4.1.x86_ 100% |=========================| 39 kB 00:00
---> Package mysql.x86_64 0:4.1.20-1.FC4.1 set to be updated
--> Running transaction check
Dependencies Resolved
=============================================================================
Package Arch Version Repository Size
=============================================================================
Updating:
perl-DBD-MySQL x86_64 2.9007-1 base 139 k
Installing for dependencies:
mysql x86_64 4.1.20-1.FC4.1 updates-released 2.9 M
Transaction Summary
=============================================================================
Install 1 Package(s)
Update 1 Package(s)
Remove 0 Package(s)
Total download size: 3.0 M
Is this ok [y/N]: y
Downloading Packages:
(1/2): mysql-4.1.20-1.FC4 100% |=========================| 2.9 MB 00:06
(2/2): perl-DBD-MySQL-2.9 100% |=========================| 139 kB 00:00
Running Transaction Test
Finished Transaction Test
Transaction Check Error: file /usr/share/info/mysql.info.gz from install
of mysql-4.1.20-1.FC4.1 conflicts with file from package mysql-4.1.11-2
file /usr/share/man/man1/mysql.1.gz from install of mysql-4.1.20-1.FC4.1
conflicts with file from package mysql-4.1.11-2
file /usr/share/man/man1/mysqlaccess.1.gz from install of
mysql-4.1.20-1.FC4.1 conflicts with file from package mysql-4.1.11-2
.
. (lot of lines deleted)
.
file /usr/share/mysql/ukrainian/errmsg.txt from install of
mysql-4.1.20-1.FC4.1 conflicts with file from package mysql-4.1.11-2
--
Jørn Dahl-Stamnes
http://www.dahl-stamnes.net/dahls/
------------------------------
Date: Fri, 21 Dec 2007 14:48:00 +0100
From: Martijn Lievaart <m@rtij.nl.invlalid>
Subject: Re: Problem installing DBD::mysql
Message-Id: <pan.2007.12.21.13.48.00@rtij.nl.invlalid>
On Fri, 21 Dec 2007 14:17:05 +0100, Jørn Dahl-Stamnes wrote:
> I also tried to upgrade perl by using yum, but that does not work very
> well (see below). Perhaps I need to install perl from source?
No, you need to straighten out your install. You have a non-FC install of
mysql that conflicts with the FC package. Uninstall mysql* and reinstall.
HTH,
M4
------------------------------
Date: Fri, 21 Dec 2007 16:01:53 +0100
From: Christian Winter <thepoet_nospam@arcor.de>
Subject: Re: Problem installing DBD::mysql
Message-Id: <476bd565$0$16575$9b4e6d93@newsspool1.arcor-online.net>
Martijn Lievaart schrieb:
> On Fri, 21 Dec 2007 14:17:05 +0100, Jørn Dahl-Stamnes wrote:
>
>> I also tried to upgrade perl by using yum, but that does not work very
>> well (see below). Perhaps I need to install perl from source?
>
> No, you need to straighten out your install. You have a non-FC install of
> mysql that conflicts with the FC package. Uninstall mysql* and reinstall.
That won't solve the original problem, that Perl is linked against
a glibc version that isn't available any longer, therefore breaking
the mechanism ExtUtils::MakeMaker uses to determine linker paramters.
I've sometimes seen symptoms like that on systems where a dist upgrade
failed halfway through, or when uncleanly backported packages or foreign
repositories were used. Either way, on most systems the best course of
action was to do a fresh OS install. Otherwise, it means tracking down
each and every binary and library linked against the wrong libs, to
avoid stumbling over unexpected errors later on.
-Chris
------------------------------
Date: Fri, 21 Dec 2007 16:13:39 +0100
From: =?ISO-8859-1?Q?J=F8rn?= Dahl-Stamnes <newsmanDELETE@REMOVEdahl-stamnes.net>
Subject: Re: Problem installing DBD::mysql
Message-Id: <476bd824@news.broadpark.no>
Martijn Lievaart wrote:
> On Fri, 21 Dec 2007 14:17:05 +0100, Jørn Dahl-Stamnes wrote:
>
>> I also tried to upgrade perl by using yum, but that does not work very
>> well (see below). Perhaps I need to install perl from source?
>
> No, you need to straighten out your install. You have a non-FC install of
> mysql that conflicts with the FC package. Uninstall mysql* and reinstall.
Hmm.. where does that one come from? I have installed FC from scratch (from
CDs) and then tried to install the perl modules. I have not done anything
else to install mysql.
--
Jørn Dahl-Stamnes
http://www.dahl-stamnes.net/dahls/
------------------------------
Date: Fri, 21 Dec 2007 16:32:10 +0100
From: Martijn Lievaart <m@rtij.nl.invlalid>
Subject: Re: Problem installing DBD::mysql
Message-Id: <pan.2007.12.21.15.32.10@rtij.nl.invlalid>
On Fri, 21 Dec 2007 16:01:53 +0100, Christian Winter wrote:
> Martijn Lievaart schrieb:
>> On Fri, 21 Dec 2007 14:17:05 +0100, Jørn Dahl-Stamnes wrote:
>>
>>> I also tried to upgrade perl by using yum, but that does not work very
>>> well (see below). Perhaps I need to install perl from source?
>>
>> No, you need to straighten out your install. You have a non-FC install
>> of mysql that conflicts with the FC package. Uninstall mysql* and
>> reinstall.
>
> That won't solve the original problem, that Perl is linked against a
> glibc version that isn't available any longer, therefore breaking the
> mechanism ExtUtils::MakeMaker uses to determine linker paramters.
It might solve it, as that allows to upgrade to the latest Perl. As
suggested by you.
M4
------------------------------
Date: Fri, 21 Dec 2007 12:26:04 +0100
From: gamo <gamo@telecable.es>
Subject: Re: Which editor for Perl hacking are you using
Message-Id: <Pine.LNX.4.64.0712211220430.8426@jvz.es>
On Fri, 21 Dec 2007, John Bokma wrote:
> Please no editor war, but I am curious, what's the editor of choice you're
> using to write Perl, and why (if you want to share).
>
JED is a wonderful editor. Especially in EDT mode.
If you try it and learn how to use the numeric keypad
to operate, you will be assimilated.
--
http://www.telecable.es/personales/gamo/
perl -E 'say 111_111_111**2;'
------------------------------
Date: Fri, 21 Dec 2007 13:47:31 +0200
From: Pavel Lepin <p.lepin@ctncorp.com>
Subject: Re: Which editor for Perl hacking are you using
Message-Id: <fkg946$7r4$1@aioe.org>
John Bokma <john@castleamber.com> wrote in
<Xns9A0CE8B10A2Ecastleamber@130.133.1.4>:
> Please no editor war...
I'll specifically mention then that there is an awful lot of
good editors and IDEs of all stripes out there, and I
imagine most of them would work well for writing in Perl.
> but I am curious, what's the editor of choice you're using
> to write Perl...
gvim
> and why (if you want to share).
It does everything I need from a text editor, it does it
well, it's lightweight, powerful, ubiquitous, and good for
reducing repetitive strain injury due to it's non-reliance
on chords, and most features being invokable without moving
your hands away from the home row.
elisp sounds like a wonderful idea, but I'm too lazy to move
to a different editor when I have one that works so well
for me. Getting acquainted with vile is on my TODO-list,
though.
--
...also, I submit that we all must honourably commit seppuku
right now rather than serve the Dark Side by producing the
HTML 5 spec.
------------------------------
Date: Fri, 21 Dec 2007 13:24:57 +0100
From: Michele Dondi <bik.mido@tiscalinet.it>
Subject: Re: Which editor for Perl hacking are you using
Message-Id: <e0cnm3titbgvee481ftr3o9t3fb6ca8lng@4ax.com>
On 21 Dec 2007 04:52:26 GMT, John Bokma <john@castleamber.com> wrote:
>Please no editor war, but I am curious, what's the editor of choice you're
jed
>using to write Perl, and why (if you want to share).
I stumbled upon it. (Long story not worth, but I was searching for
emacs, go figure!)
It suits my needs.
(As someone else also wrote:) inertia.
It has Borland's IDE's like keybindings which I got used to many years
ago.
Michele
--
{$_=pack'B8'x25,unpack'A8'x32,$a^=sub{pop^pop}->(map substr
(($a||=join'',map--$|x$_,(unpack'w',unpack'u','G^<R<Y]*YB='
.'KYU;*EVH[.FHF2W+#"\Z*5TI/ER<Z`S(G.DZZ9OX0Z')=~/./g)x2,$_,
256),7,249);s/[^\w,]/ /g;$ \=/^J/?$/:"\r";print,redo}#JAPH,
------------------------------
Date: Fri, 21 Dec 2007 13:56:05 +0100
From: Martijn Lievaart <m@rtij.nl.invlalid>
Subject: Re: Which editor for Perl hacking are you using
Message-Id: <pan.2007.12.21.12.56.05@rtij.nl.invlalid>
On Fri, 21 Dec 2007 09:31:31 +0000, RedGrittyBrick wrote:
> John Bokma wrote:
>> Please no editor war, but I am curious, what's the editor of choice
>> you're using to write Perl,
>
> vim
Emacs
>
>> and why (if you want to share).
>
> a) It was the Unix editor I learned concurrent with learning Perl.
Ditto.
> b) It's good.
Ditto.
> c) It's available on most operating systems.
It's available on all machines I use. Here Vi has an advantage and vim a
slight advantage.
> d) Inertia.
Ditto.
>
> If I'd started with Emacs I imagine I'd still be using Emacs.
>
I hated vi and I hated Emacs. But Emacs let me do what I wanted to do and
vi didn't. Nowadays, there is not much between vim and Emacs, but in
those days there was.
>> I am currently using Textpad, but in the very near future I am moving
>> to GNU/Linux. I've some experience with using vi(m) for editing work,
>> and have printed both the emacs and vim manual, but not sure which one
>> to start reading first.
>
> If you've some experience with vim, I suggest you continue on that path.
Learning Emacs is rewarding, but it's learning curve is even steeper than
vim.
>> I've had a short peek at Komodo Edit, but considered the start up time
>> way too high. Ages ago I had a peek at Eclipse, but not sure if I am
>> the IDE kind of guy (I manage quite ok with a "perldoc" keymark in
>> Firefox, and perldoc on the cli most of the time).
Like you I don't have use for an IDE, except as a language aware editor.
With the current crop of IDEs, maybe there is a good one you like. A good
modern IDE should be usuable out of the box, while both vim and Emacs
mean you have some learning and getting used to ahead.
HTH,
M4
------------------------------
Date: 21 Dec 2007 13:01:06 GMT
From: Lars Eighner <usenet@larseighner.com>
Subject: Re: Which editor for Perl hacking are you using
Message-Id: <slrnfmne5g.2lim.usenet@debranded.larseighner.com>
In our last episode, <Xns9A0CE8B10A2Ecastleamber@130.133.1.4>, the lovely
and talented John Bokma broadcast on comp.lang.perl.misc:
> Please no editor war, but I am curious, what's the editor of choice you're
> using to write Perl, and why (if you want to share).
Joe. What's not to like? Color for just about any language you can think
of, "modeless" so it doesn't have the steep (yeah, I know, really shallow)
learning curve of vi, unlike emacs it is completely customizable so if you
want to avoid cramps in your left hand you can, powerful and easy macros.
--
Lars Eighner <http://larseighner.com/> usenet@larseighner.com
Countdown: 396 days to go.
------------------------------
Date: Fri, 21 Dec 2007 14:18:04 +0100
From: De Vliegende Hollander <devliegendehollander@attempt-at-not-applicable-domain-name.com>
Subject: Re: Which editor for Perl hacking are you using
Message-Id: <476bbcf8$0$4231$e4fe514c@dreader24.news.xs4all.nl>
The sentient life form John Bokma posted the following:
> Please no editor war, but I am curious, what's the editor of choice you're
> using to write Perl, and why (if you want to share).
gvim/vim with Perl syntax highlighting.
Very powerful and it's available for many, many platforms, so that I can
always use it.
------------------------------
Date: Fri, 21 Dec 2007 15:10:47 +0100
From: Joost Diepenmaat <joost@zeekat.nl>
Subject: Re: Which editor for Perl hacking are you using
Message-Id: <87bq8k9lzs.fsf@zeekat.nl>
John Bokma <john@castleamber.com> writes:
> Please no editor war, but I am curious, what's the editor of choice you're
> using to write Perl, and why (if you want to share).
The last two years I've been using emacs exclusively (I've used it on
and off for much longer) and forced myself to really get to know
it. This takes time, but IMHO it's definitely worth it.
I'm also working on my Lisp knowledge, so having an editor that's
programmable* in Lisp is cool.
If you want to try emacs for perl hacking, make sure you use cperl-mode
instead of perl-mode. Other cool things I've found useful:
additional minor modes - the following work with many major modes, not
just perl:
compile-mode: run your perl code from emacs and jump to errors / warnings.
imenu-mode: adds a pulldown menu with package/function declarations in
the current file. Very simple but useful if you want a short file
overview/navigation and haven't got to grips with all the keyboard
commands.
outline-mode: takes the idea of imenu-mode but lets you fold/move
packages and functions around. Very useful when you've got a large file
and you want to have an overview of the file's structure / group related
functions together / move to some other part of the file. The default
keyboard commands are too complex, though. You really want to set them up
differently.
cedet: makes emacs look more like an IDE: adds buffers with speedbar /
file browser / package inspection etc. Also does some auto-completion
though that seems to be tuned more for static languages like C++ / Java.
All of these you can find from EmacsWiki:
http://www.emacswiki.org/
http://www.emacswiki.org/cgi-bin/wiki/PerlLanguage
Just recently I've been looking at Sepia, which IMO could become the
best thing that's happend to perl/emacs in years: real autocompletion,
live inspection etc. Based on the Lisp/Slime interactive development style.
http://search.cpan.org/dist/Sepia/
* This is a huge understatement. Gnu/X Emacsen really aren't
programmable editors. They're environments for running/building
interactive applications that involve text editing.
Joost.
------------------------------
Date: 21 Dec 2007 09:27:51 -0600
From: Lawrence Statton <yankeeinexile@gmail.com>
Subject: Re: Which editor for Perl hacking are you using
Message-Id: <87ir2sqd8o.fsf@hummer.cluon.com>
John Bokma <john@castleamber.com> writes:
> Please no editor war, but I am curious, what's the editor of choice you're
> using to write Perl, and why (if you want to share).
Emacs w/ psvn, cperl, tramp and MMM (for mason/html). Mostly because
I've used emacs for darn-near-everything since 1987.
--
Lawrence Statton - lawrenabae@abaluon.abaom s/aba/c/g
Computer software consists of only two components: ones and
zeros, in roughly equal proportions. All that is required is to
place them into the correct order.
------------------------------
Date: Fri, 21 Dec 2007 16:09:09 +0100
From: "Petr Vileta" <stoupa@practisoft.cz>
Subject: Re: Which editor for Perl hacking are you using
Message-Id: <fkgmj7$i55$3@ns.felk.cvut.cz>
John Bokma wrote:
> Please no editor war, but I am curious, what's the editor of choice
> you're using to write Perl, and why (if you want to share).
>
> I've had a short peek at Komodo Edit, but considered the start up
> time way too high. Ages ago I had a peek at Eclipse, but not sure if
> I am the IDE kind of guy (I manage quite ok with a "perldoc" keymark
> in Firefox, and perldoc on the cli most of the time).
I'm using Komodo on Win and Linux because this is a more then and editor only.
I use Komodo debugger for debug my Perl and PHP scripts and I'm happy ;-)
--
Petr Vileta, Czech republic
(My server rejects all messages from Yahoo and Hotmail. Send me your
mail from another non-spammer site please.)
Please reply to <petr AT practisoft DOT cz>
------------------------------
Date: Fri, 21 Dec 2007 05:42:10 -0600
From: Tad J McClellan <tadmc@seesig.invalid>
Subject: Re: WriteExcel module, reopening a file
Message-Id: <slrnfmn9ki.m04.tadmc@tadmc30.sbcglobal.net>
dn.perl@gmail.com <dn.perl@gmail.com> wrote:
>
> I create an excel file 'myfile.xls' using WriteExcel module.
> I would like to reopen this sheet for over/writing, and write a string
> 'new string' to its cell (10, 1). Or overwrite cell (2,2) with string
> 'new string'.
> But I am interested in knowing whether
> the module WriteExcel (or a Win32 module) allows me to reopen an
> existing excel file for over/writing.
Have you read the documentation for the module that you are using?
This module cannot be used to write to an existing Excel file.
When I needed to do a similar thing at work[1], the only solution I
could find was to use the POI Java library.
http://poi.apache.org/
After a few days of Java programming, I needed to lick dirt to
get the bad taste out of my mouth. :-)
[1] And it needed to run on a Linux web server, so win32 modules were not an option.
--
Tad McClellan
email: perl -le "print scalar reverse qq/moc.noitatibaher\100cmdat/"
------------------------------
Date: Fri, 21 Dec 2007 06:51:13 -0800 (PST)
From: jmcnamara13@gmail.com
Subject: Re: WriteExcel module, reopening a file
Message-Id: <a8539699-0458-47e9-94fb-f8084b0c2676@n20g2000hsh.googlegroups.com>
On Dec 21, 6:33 am, "dn.p...@gmail.com" <dn.p...@gmail.com> wrote:
> I create an excel file 'myfile.xls' usingWriteExcelmodule. It has a
> tab named 'Name1', and its first (say) 10 rows have some data.
>
> I would like to reopen this sheet for over/writing, and write a string
> 'new string' to its cell (10, 1). Or overwrite cell (2,2) with string
> 'new string'.
Hi,
See the following Spreadsheet::WriteExcel FAQ. "How do I update an
existing Excel file":
http://groups.google.com/group/spreadsheet-writeexcel/browse_frm/thread/15e131d2f5d012b4
Note you will have to patch the latest version of SaveParser to get it
to work (see link below) or put a "use Spreadsheet::ParseExcel;" at
the top of your program.
http://rt.cpan.org/Public/Bug/Display.html?id=31380
John.
--
------------------------------
Date: 6 Apr 2001 21:33:47 GMT (Last modified)
From: Perl-Users-Request@ruby.oce.orst.edu (Perl-Users-Digest Admin)
Subject: Digest Administrivia (Last modified: 6 Apr 01)
Message-Id: <null>
Administrivia:
#The Perl-Users Digest is a retransmission of the USENET newsgroup
#comp.lang.perl.misc. For subscription or unsubscription requests, send
#the single line:
#
# subscribe perl-users
#or:
# unsubscribe perl-users
#
#to almanac@ruby.oce.orst.edu.
NOTE: due to the current flood of worm email banging on ruby, the smtp
server on ruby has been shut off until further notice.
To submit articles to comp.lang.perl.announce, send your article to
clpa@perl.com.
#To request back copies (available for a week or so), send your request
#to almanac@ruby.oce.orst.edu with the command "send perl-users x.y",
#where x is the volume number and y is the issue number.
#For other requests pertaining to the digest, send mail to
#perl-users-request@ruby.oce.orst.edu. Do not waste your time or mine
#sending perl questions to the -request address, I don't have time to
#answer them even if I did know the answer.
------------------------------
End of Perl-Users Digest V11 Issue 1136
***************************************
