60 PerlMonks - Newest Nodes New nodes appearing on PerlMonks http://perlmonks.org/index.pl?node_id=30175 http://blogs.law.harvard.edu/tech/rss PerlMonks Newest Nodes XML Generator 961 PerlMonks 2014-07-11 14:33:18 rss,clean Fri Jul 11 04:33:18 2014 30 20140711043318 Fri Jul 11 04:33:18 2014 http://perlmonks.org/ Anonymous Monk Spreadsheet::XLSX date format problem Anonymous Monk http://perlmonks.org/index.pl?node_id=1093231 Hi there Monks! I am using Spreadsheet::XLSX module to read the data from a .xlsx(spreadsheet) file. Source file value : 10/23/2013 The actual data once parsed : 41570 ( T... perlquestion Fri, 11 Jul 2014 14:21:03 +0000 http://perlmonks.org/index.pl?node_id=1093231 1093231 961 2014-07-11 10:21:03 Anonymous Monk Append new line in excel sheets perl_new_b http://perlmonks.org/index.pl?node_id=1093222 Hi, I want to insert(append) a new row at the end of excel file which contains multiple worksheets. I can't use Win32::OLE as the machine on which I'm working doesn't have MS Office. Kindly s... perlquestion Fri, 11 Jul 2014 12:54:37 +0000 http://perlmonks.org/index.pl?node_id=1093222 1093222 1093052 2014-07-11 08:54:37 perl_new_b local packages in windows Arthfael http://perlmonks.org/index.pl?node_id=1093212 Hi, I am a complete Perl noob and my experience of scripting is limited to some R data analysis. My cmd-line-fu is virtually non-existent. I have been trying to run a perl program I downloaded for ... perlquestion Fri, 11 Jul 2014 10:55:39 +0000 http://perlmonks.org/index.pl?node_id=1093212 1093212 1093209 2014-07-11 06:55:39 Arthfael Re: Spreadsheet::XLSX date format problem Corion http://perlmonks.org/index.pl?node_id=1093232 Don't use ->{Val}. It contains the unformatted value. Use ->value() to get the formatted value.... note Fri, 11 Jul 2014 14:27:02 +0000 http://perlmonks.org/index.pl?node_id=1093232 1093232 5348 2014-07-11 10:27:02 Corion Re: accessing elements of reference to hash of arrays kcott http://perlmonks.org/index.pl?node_id=1093230 G'day <a href="?node=johnguillory">John</a>, Look very carefully at the double-quotes in the code that you posted. Compare: $ perl -Mstrict -Mwarnings -le 'my $x = &#91;&#93;; print re... note Fri, 11 Jul 2014 14:13:30 +0000 http://perlmonks.org/index.pl?node_id=1093230 1093230 861371 2014-07-11 10:13:30 kcott Re: Append new line in excel sheets kcott http://perlmonks.org/index.pl?node_id=1093225 G'day <a href="?node=perl_new_b">perl_new_b</a>, Welcome to the monastery. Take a look at <a href="http://search.cpan.org/perldoc?Spreadsheet%3A%3AWriteExcel">Spreadsheet::WriteExcel</a> and, in particular, its &#91;http:/... note Fri, 11 Jul 2014 13:22:22 +0000 http://perlmonks.org/index.pl?node_id=1093225 1093225 861371 2014-07-11 09:22:22 kcott Re: Append new line in excel sheets roboticus http://perlmonks.org/index.pl?node_id=1093224 <a href="?node=perl_new_b">perl_new_b</a>: If you can't use office, then you'll have to use something like <a href="http://search.cpan.org/search?mode=module&amp;query=Spreadsheet%3A%3AXLSX">Spreadsheet::XLSX</a> to read the spreadsheet, and <a href="http://search.cpan.org/search?mode=module&amp;query=Excel%3A%3AWriter%3A%3AXLSX">Excel::Writer::XLSX</a> to write the new one. If ... note Fri, 11 Jul 2014 13:13:46 +0000 http://perlmonks.org/index.pl?node_id=1093224 1093224 533863 2014-07-11 09:13:46 roboticus Re^4: Regex trouble w/ embedded 0s? AnomalousMonk http://perlmonks.org/index.pl?node_id=1093223 But that doesn't differentiate between the first 36 chars and the subsequent whatsit, and includes the \0\0\0, and needs the use of $& or a <a href="http://perldoc.perl.org/functions/substr.html">substr</a> operation to access what... note Fri, 11 Jul 2014 13:00:40 +0000 http://perlmonks.org/index.pl?node_id=1093223 1093223 634253 2014-07-11 09:00:40 AnomalousMonk Re^3: poll ideas quest jonix http://perlmonks.org/index.pl?node_id=1093221 Right! Interesting, some of the distros on the list are still popular now more then eight years later. :-) ... note Fri, 11 Jul 2014 12:46:16 +0000 http://perlmonks.org/index.pl?node_id=1093221 1093221 500548 2014-07-11 08:46:16 jonix Re^3: local packages in windows roboticus http://perlmonks.org/index.pl?node_id=1093220 <a href="?node=Arthfael">Arthfael</a>: Ugh! It looks like someone round-tripped the McCarthy-SourceData.txt file through Excel. The ninth column looks as if it's been munged (12/18 being turned into 18-Dec, etc.).... note Fri, 11 Jul 2014 12:40:48 +0000 http://perlmonks.org/index.pl?node_id=1093220 1093220 533863 2014-07-11 08:40:48 roboticus Re^3: Regex trouble w/ embedded 0s? choroba http://perlmonks.org/index.pl?node_id=1093219 I dunno, prolly /^.{36,}?\0\0\0/ &#1604;&#1405;&#4285; &#6514;&#6482;&#9... note Fri, 11 Jul 2014 12:40:13 +0000 http://perlmonks.org/index.pl?node_id=1093219 1093219 832495 2014-07-11 08:40:13 choroba Re^3: local packages in windows marto http://perlmonks.org/index.pl?node_id=1093218 This script requires the <a href="http://search.cpan.org/perldoc?BioPerl">BioPerl</a> suite of modules. I'm running Strawberry Perl 5.18.2 on Windows 7 64bit, DWIM perl ships with Strawberry 5.14, which isn't anything to worry about. To insta... note Fri, 11 Jul 2014 12:32:51 +0000 http://perlmonks.org/index.pl?node_id=1093218 1093218 324763 2014-07-11 08:32:51 marto Re^3: Out of Memory while using Spreadsheet::XLSX sn1987a http://perlmonks.org/index.pl?node_id=1093217 Thanks for the update <a href="?node=runrig">runrig</a>. I was unable to check that at the time I made my response.... note Fri, 11 Jul 2014 12:29:00 +0000 http://perlmonks.org/index.pl?node_id=1093217 1093217 1070463 2014-07-11 08:29:00 sn1987a Re^2: Regex trouble w/ embedded 0s? roboticus http://perlmonks.org/index.pl?node_id=1093216 <a href="?node=Laurent_R">Laurent_R</a>: I'm dismantling a large (5GB) binary file archive, and the first 36 bytes of each file entry is stuff I haven't determined the purpose of. Then comes the filename (variable le... note Fri, 11 Jul 2014 12:25:34 +0000 http://perlmonks.org/index.pl?node_id=1093216 1093216 533863 2014-07-11 08:25:34 roboticus Re^2: local packages in windows Arthfael http://perlmonks.org/index.pl?node_id=1093215 Thanks for the quick reply ^^ "it sounds like you've made this problem overly complex" I probably have, but this is the result of reading tutorials on the web... everyone seems to assume that ... note Fri, 11 Jul 2014 12:10:02 +0000 http://perlmonks.org/index.pl?node_id=1093215 1093215 1093209 2014-07-11 08:10:02 Arthfael Re^2: Regex trouble w/ embedded 0s? AnomalousMonk http://perlmonks.org/index.pl?node_id=1093214 If you wanted to grab the first 36 chars from the start of a string, then grab the first subsequent group that was terminated by (and did not contain) a \0\0\0 sequence, what regex would... note Fri, 11 Jul 2014 12:09:24 +0000 http://perlmonks.org/index.pl?node_id=1093214 1093214 634253 2014-07-11 08:09:24 AnomalousMonk Re: local packages in windows marto http://perlmonks.org/index.pl?node_id=1093213 Greetings! I'll be honest and say that it sounds like you've made this problem overly complex. Can you please provide a link to the module you're trying to install? That way people can better advis... note Fri, 11 Jul 2014 11:00:30 +0000 http://perlmonks.org/index.pl?node_id=1093213 1093213 324763 2014-07-11 07:00:30 marto Re^2: display new options based on checkbox inputs Anonymous Monk http://perlmonks.org/index.pl?node_id=1093211 Well Thanks to all Monks who helped on this. was able to find out a way to do this, without using JavaScript. That is javascript ... and pseudocode :) Why are you mixing functi... note Fri, 11 Jul 2014 10:37:39 +0000 http://perlmonks.org/index.pl?node_id=1093211 1093211 961 2014-07-11 06:37:39 Anonymous Monk Re^2: How do i color font in a listbox? Anonymous Monk http://perlmonks.org/index.pl?node_id=1093208 You my friend, are about to be introduced to the wonderful world of css in conventional apps. ... Um, no. Whatever issues Gtk3 brought have been fixed and there is nothing for wxPerl/wx... note Fri, 11 Jul 2014 10:30:52 +0000 http://perlmonks.org/index.pl?node_id=1093208 1093208 961 2014-07-11 06:30:52 Anonymous Monk Re: display new options based on checkbox inputs Anonymous Monk http://perlmonks.org/index.pl?node_id=1093207 Well Thanks to all Monks who helped on this. was able to find out a way to do this, without using JavaScript. print header; &load($cgi); sub load() { $cgi = shift; if (!$cgi->param... note Fri, 11 Jul 2014 10:07:37 +0000 http://perlmonks.org/index.pl?node_id=1093207 1093207 961 2014-07-11 06:07:37 Anonymous Monk Re: Compress a entire directory DrHyde http://perlmonks.org/index.pl?node_id=1093206 That you couldn't even be arsed to look at the manpages for tar(1), zip(1), Archive::Tar and Archive::Zip indicates to me that you don't actually care enough for me to bother helping you. You would... note Fri, 11 Jul 2014 10:07:20 +0000 http://perlmonks.org/index.pl?node_id=1093206 1093206 84630 2014-07-11 06:07:20 DrHyde Re: How do i color font in a listbox? zentara http://perlmonks.org/index.pl?node_id=1093205 You my friend, are about to be introduced to the wonderful world of css in conventional apps. As one of the benefits to using of the newer toolkits, and since Wx is usually built on Gtk+ libs, yo... note Fri, 11 Jul 2014 09:44:15 +0000 http://perlmonks.org/index.pl?node_id=1093205 1093205 131741 2014-07-11 05:44:15 zentara Re^4: [Win32] Overriding dmake's $(AS) syphilis http://perlmonks.org/index.pl?node_id=1093204 You've described an excellent case for it being so Yes, I think you're right. I'll research it a bit more and then run it by p5p and see what happens. There may be a view that... note Fri, 11 Jul 2014 09:18:46 +0000 http://perlmonks.org/index.pl?node_id=1093204 1093204 524150 2014-07-11 05:18:46 syphilis Re^2: mod_perl odd behaviour with system() or exec() call or backticks pucek http://perlmonks.org/index.pl?node_id=1093203 Thank you for your feedback. Unfortunately my virtual host was already using ModPerl::PerlRun as PerlResponseHandler.... note Fri, 11 Jul 2014 09:12:58 +0000 http://perlmonks.org/index.pl?node_id=1093203 1093203 1093005 2014-07-11 05:12:58 pucek Re^8: How do I space out each radio button horizontally in Perl/Tk Janish http://perlmonks.org/index.pl?node_id=1093200 Thanks a bunch stefbv (your " Make a new Frame for the radio buttons" do the trick :)) and those all who contributed your ideas. I finally able to get what I looks for with slightly modification ... note Fri, 11 Jul 2014 08:38:57 +0000 http://perlmonks.org/index.pl?node_id=1093200 1093200 1091138 2014-07-11 04:38:57 Janish Re^2: installation of FireFox :: Mechanize fails - [again] Perlbeginner1 http://perlmonks.org/index.pl?node_id=1093199 hello - thx for the hint to use another package. i will give it a try later the weekend. Thx for the constructive comment in the thread. ;-) This is very supportive ... note Fri, 11 Jul 2014 08:33:40 +0000 http://perlmonks.org/index.pl?node_id=1093199 1093199 861402 2014-07-11 04:33:40 Perlbeginner1 rdellison rdellison http://perlmonks.org/index.pl?node_id=1093228 user Fri, 11 Jul 2014 14:11:26 +0000 http://perlmonks.org/index.pl?node_id=1093228 1093228 1093228 2014-07-11 10:11:26 rdellison Cor10n Cor10n http://perlmonks.org/index.pl?node_id=1093226 A sock puppet for a one-time joke in the chatterbox. Delete account whenever appropriate, I (<a href="?node=roboticus">roboticus</a>) won't be posting any permanent nodes.... user Fri, 11 Jul 2014 13:34:54 +0000 http://perlmonks.org/index.pl?node_id=1093226 1093226 1093226 2014-07-11 09:34:54 Cor10n Arthfael Arthfael http://perlmonks.org/index.pl?node_id=1093209 user Fri, 11 Jul 2014 10:32:53 +0000 http://perlmonks.org/index.pl?node_id=1093209 1093209 1093209 2014-07-11 06:32:53 Arthfael dgeorgievd dgeorgievd http://perlmonks.org/index.pl?node_id=1093201 user Fri, 11 Jul 2014 09:09:52 +0000 http://perlmonks.org/index.pl?node_id=1093201 1093201 1093201 2014-07-11 05:09:52 dgeorgievd