Re: Variables in $Excel->Workbooks->Open

> Dear All, > > I am having an XLSX file in server and my OS in Win7. The first open > statement is working fine in which we have give the actual file name. > > 2nd open function is not working where we have given the file name as > variable. > > Please help in resolving this error. > > > use

Re: Variables in $Excel->Workbooks->Open

On May 7, 2013, at 1:48 AM, Ganesh Babu N wrote: > I tried your method but it showing the same error. Which method? I made two suggestions. It is always helpful to post the exact program that you tried and the exact error message you are getting. As I explained, I do not have a Windows system

Re: Variables in $Excel->Workbooks->Open

I tried your method but it showing the same error. Ganesh On Mon, May 6, 2013 at 8:58 PM, Jim Gibson wrote: > > On May 6, 2013, at 6:42 AM, Ganesh Babu N wrote: > > > > > Dear All, > > > > I am having an XLSX file in server and my OS in Win7. The first open > statement is working fine in which

Re: Variables in $Excel->Workbooks->Open

I make promish when i learn to perl, i'll help the more people has possible. I hope i don't forget!! On Mon, May 6, 2013 at 4:28 PM, Jim Gibson wrote: > > On May 6, 2013, at 6:42 AM, Ganesh Babu N wrote: > > > > > Dear All, > > > > I am having an XLSX file in server and my OS in Win

Re: Variables in $Excel->Workbooks->Open

On May 6, 2013, at 6:42 AM, Ganesh Babu N wrote: > > Dear All, > > I am having an XLSX file in server and my OS in Win7. The first open > statement is working fine in which we have give the actual file name. > > 2nd open function is not working where we have given the file name as > variable

Re: Variables disappearing in code

On 10/09/2012 08:20 AM, Mark Haney wrote: So, this is obviously a problem bigger than just this one routine. But bugger me if I know where to go from here. I don't even know what to say now. I have it working. I'm not entirely sure /why/ it works, but it does. Just for fun, I changed th

Re: Variables disappearing in code

On 10/05/2012 11:38 AM, Shlomi Fish wrote: Hi Mark, please include a self-contained, minimalised, reproducing example, so we can see what you are doing wrong. Moreover, sometimes minimalising the code to something more self-contained helps you find the problem. Regards, Shlomi Fis

Re: Variables disappearing in code

Hi Mark, On Fri, 05 Oct 2012 11:25:01 -0400 Mark Haney wrote: > On 10/04/2012 03:23 PM, Shlomi Fish wrote: > > On Thu, 4 Oct 2012 18:11:50 + > > Mark Haney wrote: > > > > This may be a culprit - it seems to be a reference to a scalar that > > is itself an array reference. Usually just doing

Re: Variables disappearing in code

On 10/04/2012 02:11 PM, Mark Haney wrote: I've got a Template Toolkit template that is driving me insane. I've hit the TT list, but it seems more and more like the problem may be more perl related than a templating issue. I've attached the offending files so now let me show what the problem

Re: Variables disappearing in code

On Thu, 4 Oct 2012 18:11:50 + Mark Haney wrote: > I've got a Template Toolkit template that is driving me insane. I've > hit the TT list, but it seems more and more like the problem may be > more perl related than a templating issue. I've attached the > offending files so now let me show wh

Re: variables and sql-statements within perlscripts

On Sep 28, 2009, at 11:01 AM, Ruprecht Helms wrote: Hi, How have I to write the sql-statement if I want to use variables like this: Don't.http://xkcd.com/327/ The value of the variable can have the value of another recordsetloop or a value come from outsite the script. Regards,

Re: variables gets shared to child but resets back after exiting fork

s. Another problem solved!!! Till next time! --- On Wed, 5/27/09, Chas. Owens wrote: > From: Chas. Owens > Subject: Re: variables gets shared to child but resets back after exiting fork > To: "Michael Alipio" > Cc: "begginers perl.org" > Date: Wedn

Re: variables gets shared to child but resets back after exiting fork

On Wed, May 27, 2009 at 07:24, Michael Alipio wrote: > > Sorry about the indention... must be the mail client i'm using. > I need to fork because the external program I want to run inside the child > runs infinitely. I want to have a timer running in the parent and after that, > kill the child.

Re: variables gets shared to child but resets back after exiting fork

;m reading the perlipc now.. nothing so far.. --- On Wed, 5/27/09, Chas. Owens wrote: > From: Chas. Owens > Subject: Re: variables gets shared to child but resets back after exiting fork > To: "Michael Alipio" > Cc: "begginers perl.org" > Date: Wednesday, May 2

Re: variables gets shared to child but resets back after exiting fork

On Wed, May 27, 2009 at 05:42, Michael Alipio wrote: > > Hi, > > I have to run an external program but the program does not termination on > some conditions, e.g, ping, will not exit unless you specify -c or some other > circumstances. > > > Now I what I want to do is: > > my @array; > die "Cann

RE: Variables initialization

[EMAIL PROTECTED] asked; > How is it possible to initialize variable using 0 or '' and > not having undef warning later on using them? my $variable = 0; # <= initial value goes here HTH, Thomas -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] http

Re: Variables initialization

On Mon, Mar 17, 2008 at 6:51 AM, <[EMAIL PROTECTED]> wrote: > How is it possible to initialize variable using 0 or '' and not having > undef warning later on using them? snip Well, you can say my $var = 0; but that doesn't prevent the variable from being set to undef later, so if it is possibl

Re: Variables initialization

On Mar 17, 2008, at 11:51 , [EMAIL PROTECTED] wrote: How is it possible to initialize variable using 0 or '' and not having undef warning later on using them? Not reassigning to undef. -- fxn -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] htt

Re: Variables not replaced

On 5/14/07, tannhauser <[EMAIL PROTECTED]> wrote: snip My problem: I also want to replace quotions, depending whether they are at the beginning or the end of a word. For example "tick" should become ``tick''. Annoyingly, my script just gives me ``$1ic$1''. Any ideas? snip The problem here is t

Re: Variables not replaced

Please don't care that the replacement right now is deleting the whitespace (yes, that's not wanted). i copied the wrong version. but that doesn't affect the problem i described. thanks tannhauser. -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: Variables in replace regex

On 8/23/05, Jurgens du Toit <[EMAIL PROTECTED]> wrote: > Hey all... > > I want to use groupings, (TEST), and replacement > variables, $1, $2, etc, in a replacement regex, but > the replacement is built into a variable. Like so: > > #!/usr/bin/perl > > my $replace = "urgent \$1"; > my $string = "

Re: Variables in replace regex

On Tue, 23 Aug 2005 06:30:07 -0700, I wrote: > > $string = s/(TEST)/qq("$replace")/giee; I mean =~ of course. Wups. -- Peter Scott http://www.perlmedic.com/ http://www.perldebugged.com/ -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: Variables in replace regex

On Tue, 23 Aug 2005 14:02:03 +0100, Jurgens du Toit wrote: > I want to use groupings, (TEST), and replacement > variables, $1, $2, etc, in a replacement regex, but > the replacement is built into a variable. Like so: > > #!/usr/bin/perl > > my $replace = "urgent \$1"; > my $string = "This is a TE

Re: $variables in a string

On May 15, Paul D. Kraus said: Hello, my $image = Image::Magick->new; # trouble open(IMAGE, 'open(IMAGE, "That needs to be open(IMAGE, " That's because the variable name is 'sku', not 'sku_unprocessed'. -- Jeff "japhy" Pinyan % How can we ever be the sold short or RPI Acacia Brother #734

Re: $variables in a string

> Hello, > > > my $image = Image::Magick->new; > > # trouble > > open(IMAGE, ' open(IMAGE, " > You need to use double quotes if you want it to use the variable. > or if you reall wanted single quotes you could have done it like this > > ' > > $image->Read(file=>\*IMAGE); > > close(IMAGE); > > #

Re: $variables in a string

Hello, > my $image = Image::Magick->new; > # trouble > open(IMAGE, ' $image->Read(file=>\*IMAGE); > close(IMAGE); > # trouble > $image->Resize(geometry=>'"$height"x"$width"'); this should be written (geometry => "$heightx$width") > # trouble > $image->Write(filename=>'/var/www/localhost/htdocs/"$

Re: Variables and MySQL

Dave Kettmann wrote: Hi List, Hello, I have a script that takes input ( Formatted: +1## ). What it does with the input is read thru a database table and try to find a match. Here is an example to help clarify this: +--+--+ | alias

Re: Variables and MySQL

Aww, dangit --- I should have not used __TARGET__ as the replacement tag -- there is just too much room for confusion with reserved words like __PACKAGE__ or __LINE__ ... Everyone take out your erasers and change that to --TARGET-- please :) --L -- To unsubscribe, e-mail: [EMAIL PROTECTED] For

Re: Variables and MySQL

> Hi List, > > I have a script that takes input ( Formatted: +1## ). What it does wi > th the input is read thru a database table and try to find a match. Here is a > n example to help clarify this: > Here is the cleaned up version of what you're doing -- since I don't have your databas

Re: VARIABLES

http://www.perl.com/pub/a/2004/06/18/variables.html On Fri, 18 Jun 2004 12:38:43 -0400, <[EMAIL PROTECTED]> wrote: All, Does perl have built in variable names such as in awk? Here are the ones in awk I know perl uses ARGV, but what about: ARGC # of command lines arguments FILENAME name of current

Re: VARIABLES

On Fri, 18 Jun 2004 12:38:43 -0400, <[EMAIL PROTECTED]> wrote: All, Does perl have built in variable names such as in awk? Here are the ones in awk I know perl uses ARGV, but what about: ARGC # of command lines arguments - In the array @ARGV FILENAME name of current input file - current input file

Re: Variables in qw?

Gohaku wrote: > > Hi everyone, Hello, > I was just curious if there is someway to add a variable when using qw. > I am trying to do the following: > #Testing qw > $string_variable = "abc"; > @array = qw( string_literal1 string_literal2 $string_variable ) > print join(" ",@array); > #Would li

RE: Variables in qw?

gohaku <[EMAIL PROTECTED]> wrote: : Hi everyone, : I was just curious if there is someway to add a : variable when using qw. I am trying to do the : following: [snip] my $foo = 'bar'; my @arr = ( qw(foo bar), $foo ); HTH, Charles K. Clarkson -- Mobile Homes Specialist 254 968-8328 -- To

Re: VARIABLES

On Fri, 18 Jun 2004 [EMAIL PROTECTED] wrote: > All, > > Does perl have built in variable names such as in awk? Here are the ones > in awk > I know perl uses ARGV, but what about: > > ARGC # of command lines arguments For that you use scalar(@ARGV). > FILENAME name of current input file That's

Re: VARIABLES

Hello, If you're coming from awk or interested in porting awk scripts, take a look also at perldoc perltrap (section on awk traps) man a2p I'd also take a look at perldoc perlvar for a complete list of predefined variables. Brian -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional com

Re: VARIABLES

perldoc perlvar On Fri, Jun 18, 2004 at 12:38:43PM -0400, [EMAIL PROTECTED] wrote: > All, > > Does perl have built in variable names such as in awk? Here are the ones > in awk > I know perl uses ARGV, but what about: > > ARGC # of command lines arguments > FILENAME name of current input file >

RE: VARIABLES

[EMAIL PROTECTED] wrote: > All, > > Does perl have built in variable names such as in awk? Yes, it has many of the same. They are documented in perldoc perlvar. They have short names like $/, $", etc. There is a standard module called English.pm that aliases them to longer names more like the aw

Re: variables in regexp

Adriano Allora wrote: > > Hi to all, Hello, > I feel myself very stupid, but I've tried to do it in different ways > and I cannot do it. > I need to clear a text, to tokenize it, for instance to delete some > things and to transform some others: > .. at this time I use this regexp: > a) to dele

Re: variables in regexp

Adriano Allora wrote: > b) to transform > s/-+/-/g; > s/\*+/\*/g; > s/\^+/\^/g; > s/\_+/\_/g; > s/ +/ /g; (this one doesn't works very well: at the end there are > several blank spaces) > > and I used this one: s/\s+/ /g; but I understand this is not very > useful: I need to change a multiple

Re: Variables and databases

Janek Schleicher wrote at Tue, 09 Jul 2002 18:48:00 +0200: > rand($#chars) gives a random > number in the range of 0 .. $#chars-1 Sorry not completely correct, rand($#chars) gives a random number < $#chars, what is in chars[ rand($#chars) ] implicitly rounded down. However, the last element of

Re: Variables and databases

jffusion wrote at Tue, 09 Jul 2002 17:33:35 +0200: > Hi > > I have my script to generate a random username and password and print it in the >browser window > > print 'Username: ', random_string(), "\n"; > print 'Password: ', random_string(), "\n"; > > sub random_string { > > my($string) =

Re: Variables and databases

From: [EMAIL PROTECTED] > Now I need to define the username and password generated so that they > are written to the htaccess, htpasswd, and members.db file > > here is the script > > # everything ok, let's write to database and send welcome email > open (DATABASE, ">>$databas

Re: Variables and databases

On Jul 9, [EMAIL PROTECTED] said: >print 'Username: ', random_string(), "\n"; >print 'Password: ', random_string(), "\n"; > [snip] > ># everything ok, let's write to database and send welcome email >open (DATABASE, ">>$database"); >flock (DATABASE, 2); >print DATABASE "$username|$password\n"; >fl

Re: Variables and Modules

On Monday, April 8, 2002, at 11:56 , Kevin Old wrote: > Hello all, > > Quick question about variables. I am editing a few scripts written by > another programmer and he programs every variable surrounded in brackets, > like ${var_name}. > > Is there any advantage to this? in it's self this is

RE: Variables and Modules

probably he was following some kind of house standard or was used to doing it that way with shell script, in which is a little more common. the reason remains the same, you can see when the variable name starts and stops, that's all. > -Original Message- > From: Kevin Old [SMTP:[EMAIL PR

Re: Variables and Modules

Kevin Old wrote: > > Hello all, Hello, > Quick question about variables. I am editing a few scripts written by > another programmer and he programs every variable surrounded in brackets, > like ${var_name}. > > Is there any advantage to this? If you are interpolating a variable in a text str

RE: Variables and Modules

Perhaps he/she smoked lots of crack and had a hard time seeing the variables and liked to use emacs for syntax highlighting. Or perhaps he/she had too much crack and was confused if the script should really be a Makefile. > -Original Message- > From: Kevin Old [mailto:[EMAIL PROTECTED]] >

Re: Variables not being deleted from memory.. I think.

On Thu, Dec 20, 2001 at 09:31:20AM +1030, Daniel Falkenberg wrote: > Now the problem is is that the code never updates. Ie if I happed to add > a * in front username with a GID of 45 in /etc/passwd then then code below > won't read from it and remove it from my hash? If I restart the daemon > th