need help with SpreadSheet::Parse perl module
Hi,
Following is the piece of code
my $parser =
Spreadsheet::ParseExcel::Workbook-Parse('tablle2sheet.xls');;
#parseexcel method that would open the file for writing
my $sheet= $parser-Worksheet($Worksheet);
my $rw=$sheet-{MaxRow}+1;
print rowcount:$rw\n;
something like-sheet3-write(0,0,'xyz'); doesn't work here
in the above code I get the max row count of my sheet by reading it using
the Spreadsheet::ParseExcel::Workbook module of cpan.
then I want to open the same tablle2sheet.xls for writing.but currently I am
not able to find any module which allows me to do that.
Can someone help/
Thanks and Regards,
Manasi Bopardikar
s/w Engineer
Persistent SystemsLtd
(+91)(020)(30234497)|9371059891
[EMAIL PROTECTED]
DISCLAIMER
==
This e-mail may contain privileged and confidential information which is the
property of Persistent Systems Ltd. It is intended only for the use of the
individual or entity to which it is addressed. If you are not the intended
recipient, you are not authorized to read, retain, copy, print, distribute or
use this message. If you have received this communication in error, please
notify the sender and delete all copies of this message. Persistent Systems
Ltd. does not accept any liability for virus infected mails.
page refresh
Hi, I am using cgi perl and wondered if there is any way to refresh a table(element ) on a web page without refreshing the entire page. This is an HTML tag to refresh a page on click of button.-- input type=button value=Reload Page onClick=window.location.reload() Thanks and Regards, Manasi Bopardikar|s/w Engineer|Persistent SystemsLtd (+91)(020)(30234497)|9371059891 [EMAIL PROTECTED] DISCLAIMER == This e-mail may contain privileged and confidential information which is the property of Persistent Systems Ltd. It is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you are not authorized to read, retain, copy, print, distribute or use this message. If you have received this communication in error, please notify the sender and delete all copies of this message. Persistent Systems Ltd. does not accept any liability for virus infected mails.
RE: use variables from another file
Hi, I think the best way this can be done is using perl module or .pm file and then using it(use .pm ) and then calling functions. -Original Message- From: Noah [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2008 4:15 PM To: Perl Beginners Subject: use variables from another file Hi there, I have created a common perl file that other perl programs can refer to so I only have one place to set the values for many different perl programs. all perl programs will call this common perl file. How can this be done? Cheers, Noah -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] http://learn.perl.org/ DISCLAIMER == This e-mail may contain privileged and confidential information which is the property of Persistent Systems Ltd. It is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you are not authorized to read, retain, copy, print, distribute or use this message. If you have received this communication in error, please notify the sender and delete all copies of this message. Persistent Systems Ltd. does not accept any liability for virus infected mails. -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] http://learn.perl.org/
RE: use variables from another file
I think try doing %elementList instead of @elementListin your .pm file.Then
use
while ( my ($key, $value) = each(%$hash) )
{
print $key = $value\n;
}
In your main.pl
-Original Message-
From: Noah [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 08, 2008 5:00 PM
To: Manasi Bopardikar
Cc: beginners@perl.org
Subject: Re: use variables from another file
okay something still is not working for me. What am I doing wrong?
main.pl
--- snip
#!/usr/bin/perl
#
use Expect;
use strict;
use elements;
#
#
for my $element (@elementList) {
from elements.pm
snip
#
package elements;
my @elementList = (
{
x = 'blah',
y = 'blah2',
reserved = 'blah3',
z = 'globs',
aa = 'wish',
bb = 'w',
},
);
--- snip ---
./main.pl
Global symbol @elementList requires explicit package name at ./main.pl
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
http://learn.perl.org/
DISCLAIMER
==
This e-mail may contain privileged and confidential information which is the
property of Persistent Systems Ltd. It is intended only for the use of the
individual or entity to which it is addressed. If you are not the intended
recipient, you are not authorized to read, retain, copy, print, distribute or
use this message. If you have received this communication in error, please
notify the sender and delete all copies of this message. Persistent Systems
Ltd. does not accept any liability for virus infected mails.
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
http://learn.perl.org/
any errors in this perl module?
Hi,
Just wanted to show you a small piece of code I have written.Are there
any apparent issues here?
package TWiki::Plugins::DumbPlugin;
use strict;
use vars qw( $VERSION $RELEASE $SHORTDESCRIPTION $debug $pluginName
$NO_PREFS_IN_TOPIC );
$VERSION = '0.1';
$RELEASE = '0.1';
$SHORTDESCRIPTION = 'Dumb plugin that does nothing at all';
$NO_PREFS_IN_TOPIC = 0;
$pluginName = 'DumbPlugin';
sub initPlugin {
my( $topic, $web, $user, $installWeb ) = @_;
TWiki::Func::registerTagHandler( 'HELLOWORLD', \_HELLOWORLD );
TWiki::Func::registerTagHandler( 'HELLOSOMEONE', \_HELLOSOMEONE );
return 1;
}
sub _HELLOWORLD{
my($session, $params, $theTopic, $theWeb) = @_;
return(Hello World);
}
sub _HELLOSOMEONE {
my($session, $params, $theTopic, $theWeb) = @_;
my $defaulttext = $params-{_DEFAULT} || '';
my $someoneelse = $params-{someoneelse} || '';
my $yetanother = $params-{yetanother} || '';
my $text = '';
$text .= $defaulttext if $defaulttext;
$text .= and if ($text $someoneelse);
$text .= $someoneelse if $someoneelse;
$text .= and if ($text $yetanother );
$text .= $yetanother if $yetanother;
$text = Hello . $text;
return $text;
}
Thanks and Regards,
Manasi Bopardikar|s/w Engineer|Persistent SystemsLtd
(+91)(020)(30234497)|9371059891
[EMAIL PROTECTED]
DISCLAIMER
==
This e-mail may contain privileged and confidential information which is the
property of Persistent Systems Ltd. It is intended only for the use of the
individual or entity to which it is addressed. If you are not the intended
recipient, you are not authorized to read, retain, copy, print, distribute or
use this message. If you have received this communication in error, please
notify the sender and delete all copies of this message. Persistent Systems
Ltd. does not accept any liability for virus infected mails.
change the ownership of my script
Hi, I want to change the ownership of my perl script through my script.Currently it is root .I want to change it to apache. I am using system(chown apache:apache simple.pl); Simple.pl is the name of my perl script Can anyone help me out? Thanks and Regards, Manasi Bopardikar|s/w Engineer|Persistent SystemsLtd (+91)(020)(30234497)|9371059891 [EMAIL PROTECTED] DISCLAIMER == This e-mail may contain privileged and confidential information which is the property of Persistent Systems Ltd. It is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you are not authorized to read, retain, copy, print, distribute or use this message. If you have received this communication in error, please notify the sender and delete all copies of this message. Persistent Systems Ltd. does not accept any liability for virus infected mails.
Need help with developing Twiki plugins
Hi, I need some help developing Twiki plugins.Can anyone give me some comprehensive information on Twiki and step by step of how to deveop a plugin using standard twiki functions? Thanks and Regards, Manasi Bopardikar|s/w Engineer|Persistent SystemsLtd (+91)(020)(30234497)|9371059891 [EMAIL PROTECTED] DISCLAIMER == This e-mail may contain privileged and confidential information which is the property of Persistent Systems Ltd. It is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you are not authorized to read, retain, copy, print, distribute or use this message. If you have received this communication in error, please notify the sender and delete all copies of this message. Persistent Systems Ltd. does not accept any liability for virus infected mails.
Get the last entry of log file
I have a log file- | 15 Sep 2008 - 06:37 | TWikiGuest | view | TWiki.WebHome | Mozilla | 10.88.68.26 | | 15 Sep 2008 - 06:37 | TWikiGuest | view | TWiki.TWikiFAQ | Mozilla | 10.88.68.26 | | 15 Sep 2008 - 06:38 | TWikiGuest | view | TWiki.TWikiTutorial | Mozilla | 10.88.68.26 | | 15 Sep 2008 - 06:42 | TWikiGuest | view | TWiki.TWikiUsersGuide | Mozilla | 10.88.68.26 | | 15 Sep 2008 - 06:42 | TWikiGuest | view | TWiki.TWikiFAQ | Mozilla | 10.88.68.26 | | 15 Sep 2008 - 06:44 | TWikiGuest | view | TWiki.ATasteOfTWiki | Mozilla | 10.88.68.26 | | 15 Sep 2008 - 06:46 | TWikiGuest | view | TWiki.WebHome | Mozilla | 10.88.68.26 | | 16 Sep 2008 - 04:06 | KailasMhase | save | Main.TestNewGroup | | 10.88.68.26 | | 16 Sep 2008 - 04:30 | TWikiGuest | view | Main.WebHome | Mozilla | 10.77.224.12 | | 16 Sep 2008 - 04:30 | TWikiGuest | view | TWiki.WebHome | Mozilla | 10.77.224.12 | | 16 Sep 2008 - 04:30 | TWikiGuest | view | TWiki.InstalledPlugins | Mozilla | 10.77.224.12 | | 16 Sep 2008 - 04:30 | TWikiGuest | view | TWiki.SpreadSheetPlugin | Mozilla | 10.77.224.12 | | 16 Sep 2008 - 04:32 | TWikiGuest | view | TWiki.TwistyPlugin | Mozilla | 10.77.224.12 | | 16 Sep 2008 - 04:32 | TWikiGuest | view | TWiki.WebHome | Mozilla | 10.77.224.12 | | 16 Sep 2008 - 04:32 | TWikiGuest | view | TWiki.InstalledPlugins | Mozilla | 10.77.224.12 | | 16 Sep 2008 - 04:33 | TWikiGuest | view | TWiki.SlideShowPlugin | Mozilla | 10.77.224.12 | | 16 Sep 2008 - 04:34 | TWikiGuest | view | TWiki.InstalledPlugins | Mozilla | 10.77.224.12 | | 16 Sep 2008 - 04:50 | TWikiGuest | view | TWiki.InstalledPlugins | Mozilla | 10.88.68.26 | | 17 Sep 2008 - 04:54 | TWikiGuest | view | TWiki.TWikiFuncDotPm | Mozilla | 10.88.68.26 | How can I get the last entry of this file?(highlighted in blue) Thanks and Regards, Manasi Bopardikar|s/w Engineer|Persistent SystemsLtd (+91)(020)(30234497)|9371059891 [EMAIL PROTECTED] DISCLAIMER == This e-mail may contain privileged and confidential information which is the property of Persistent Systems Ltd. It is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you are not authorized to read, retain, copy, print, distribute or use this message. If you have received this communication in error, please notify the sender and delete all copies of this message. Persistent Systems Ltd. does not accept any liability for virus infected mails.
refresh a page
I am new to CGI programming.I do not know how to refresh a web page every 15 min.I would like to know the script for the same. Thanks and Regards, Manasi Bopardikar|s/w Engineer|Persistent SystemsLtd (+91)(020)(30234497)|9371059891 [EMAIL PROTECTED] DISCLAIMER == This e-mail may contain privileged and confidential information which is the property of Persistent Systems Ltd. It is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you are not authorized to read, retain, copy, print, distribute or use this message. If you have received this communication in error, please notify the sender and delete all copies of this message. Persistent Systems Ltd. does not accept any liability for virus infected mails.
find_all_links
Hi, Does anyone know details about find_all_links method of the mechanize module. Thanks and Regards, Manasi Bopardikar|s/w Engineer|Persistent SystemsLtd (+91)(020)(30234497)|9767218759 [EMAIL PROTECTED] DISCLAIMER == This e-mail may contain privileged and confidential information which is the property of Persistent Systems Ltd. It is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you are not authorized to read, retain, copy, print, distribute or use this message. If you have received this communication in error, please notify the sender and delete all copies of this message. Persistent Systems Ltd. does not accept any liability for virus infected mails.
Extract the desired value from a regex
Hi, I have a regex --- $array[3]=~/[M|T|W|TR|F]\s[M|T|W|TR|F]\s(.*?)/; I want to extract the value of expression highlighted in red.Is there any way to do it. -I tried $1 does not work.Why doesn't it work I do not understand. Is there any other way to do it. Thanks and Regards, Manasi Bopardikar|s/w Engineer|Persistent SystemsLtd (+91)(020)(30234497)|9767218759 [EMAIL PROTECTED] DISCLAIMER == This e-mail may contain privileged and confidential information which is the property of Persistent Systems Ltd. It is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you are not authorized to read, retain, copy, print, distribute or use this message. If you have received this communication in error, please notify the sender and delete all copies of this message. Persistent Systems Ltd. does not accept any liability for virus infected mails.
Handling ignore case and single line in pattern matchin
Hi, Does anyone know how to handle ignore case(i) and single line(s) on a regular expression. Thanks and Regards, Manasi Bopardikar|s/w Engineer|Persistent SystemsLtd (+91)(020)(30234497)|9767218759 [EMAIL PROTECTED] DISCLAIMER == This e-mail may contain privileged and confidential information which is the property of Persistent Systems Ltd. It is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you are not authorized to read, retain, copy, print, distribute or use this message. If you have received this communication in error, please notify the sender and delete all copies of this message. Persistent Systems Ltd. does not accept any liability for virus infected mails.
removing '*' from *****STAFF*****
Does anyone know how do I remove the beginning and the trailing * from *STAFF* Thanks and Regards, Manasi Bopardikar|s/w Engineer|Persistent SystemsLtd (+91)(020)(30234497)|9767218759 [EMAIL PROTECTED] DISCLAIMER == This e-mail may contain privileged and confidential information which is the property of Persistent Systems Ltd. It is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you are not authorized to read, retain, copy, print, distribute or use this message. If you have received this communication in error, please notify the sender and delete all copies of this message. Persistent Systems Ltd. does not accept any liability for virus infected mails.
Regular expressin
Anyone knows regex for---option value=ACE Athletic Coaching Education (ACE )/option Thanks and Regards, Manasi Bopardikar|s/w Engineer|Persistent SystemsLtd (+91)(020)(30234497)|9767218759 [EMAIL PROTECTED] DISCLAIMER == This e-mail may contain privileged and confidential information which is the property of Persistent Systems Ltd. It is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you are not authorized to read, retain, copy, print, distribute or use this message. If you have received this communication in error, please notify the sender and delete all copies of this message. Persistent Systems Ltd. does not accept any liability for virus infected mails.
doubt in my web spider
http://sac.edu/Schedule/search/results.asp?semester=Fall2008 http://sac.edu/Schedule/search/results.asp?semester=Fall2008department=Acc ountingAddTitle=-+BrowseRtnURL=%2Fschedule%2Fbrowse.asp?Selected=Fall2008 RtnTxt=New+Browse department=AccountingAddTitle=-+BrowseRtnURL=%2Fschedule%2Fbrowse.asp?Sel ected=Fall2008RtnTxt=New+Browse I need to scrape unique id fields viz 0103501 etc and 'AND' following it under QUICKBOOKS to be put in one record and then write it to output file.is there a simple way to do it. Manasi Bopardikar Software Engineer Persistent Systems Ltd Cell No:(+91)9767218759 Extn:+91-020-3023(4497) Email:[EMAIL PROTECTED] DISCLAIMER == This e-mail may contain privileged and confidential information which is the property of Persistent Systems Ltd. It is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you are not authorized to read, retain, copy, print, distribute or use this message. If you have received this communication in error, please notify the sender and delete all copies of this message. Persistent Systems Ltd. does not accept any liability for virus infected mails.
