Re: Excel::Writer on OpenVMS
[email protected] ("Craig A. Berry") Mon, 02 Nov 2015 18:54:22 +0000 (GMT)
| Newsgroups | perl.vmsperl |
|---|---|
| Message-ID | <[email protected]> |
--Boundary_(ID_RXk0HJofRbyHGf2dXuEL9w) Content-type: text/plain; CHARSET=US-ASCII; format=flowed Content-transfer-encoding: 7BIT --Boundary_(ID_RXk0HJofRbyHGf2dXuEL9w) Content-type: multipart/related; boundary="Boundary_(ID_6SFBS6+aGog5HNiIwERzCw)"; type="text/html" --Boundary_(ID_6SFBS6+aGog5HNiIwERzCw) Content-type: text/html; CHARSET=US-ASCII Content-transfer-encoding: quoted-printable <html><body><div><br></div><div><br>On Nov 02, 2015, at 12:46 PM, Brian Schenkenberger= <[email protected]> wrote:<br><br><div><blockquote type=3D"cite"><d= iv class=3D"msg-quote"><div class=3D"_stretch"><span class=3D"body-text-co= ntent">On Mon, 2015-11-02 at 18:39 +0000, Craig A. Berry wrote:<br><blockq= uote type=3D"cite" class=3D"quoted-plain-text"><br></blockquote><blockquot= e type=3D"cite" class=3D"quoted-plain-text"><br></blockquote><blockquote t= ype=3D"cite" class=3D"quoted-plain-text"><br></blockquote><blockquote type= =3D"cite" class=3D"quoted-plain-text">On Nov 02, 2015, at 11:09 AM, Brian = Schenkenberger <[email protected]></blockquote><blockquote type=3D"c= ite" class=3D"quoted-plain-text">wrote:</blockquote><blockquote type=3D"ci= te" class=3D"quoted-plain-text">> > -----Original Message-----</bloc= kquote><blockquote type=3D"cite" class=3D"quoted-plain-text">> > Fro= m: Craig A. Berry [mailto:[email protected]]</blockquote><blockquote type= =3D"cite" class=3D"quoted-plain-text"><br></blockquote><blockquote type=3D= "cite" class=3D"quoted-plain-text">> > $ gdiff -pu lib/Excel/Writer/= XLSX/Workbook.pm;-0</blockquote><blockquote type=3D"cite" class=3D"quoted-= plain-text">> > lib/Excel/Writer/XLSX/Workbook.pm</blockquote><block= quote type=3D"cite" class=3D"quoted-plain-text">> > --- lib/Excel/Wr= iter/XLSX/Workbook.pm;-0 2015-10-29</blockquote><blockquote type=3D"cite" = class=3D"quoted-plain-text">> > 14:09:16 -0500</blockquote><blockquo= te type=3D"cite" class=3D"quoted-plain-text">> > +++ lib/Excel/Write= r/XLSX/Workbook.pm 2015-10-30 13:07:34 -0500</blockquote><blockquote type=3D= "cite" class=3D"quoted-plain-text">> > @@ -964,7 +964,7 @@ sub _stor= e_workbook {</blockquote><blockquote type=3D"cite" class=3D"quoted-plain-t= ext">> > # with File::Find and pass each one to addFile().</blockquo= te><blockquote type=3D"cite" class=3D"quoted-plain-text"><br></blockquote>= <blockquote type=3D"cite" class=3D"quoted-plain-text"><br></blockquote><bl= ockquote type=3D"cite" class=3D"quoted-plain-text">Whatever version of the= package was current on the CPAN the day you</blockquote><blockquote type=3D= "cite" class=3D"quoted-plain-text">originally posted. Apparently that's be= en 0.86 since 18 October.</blockquote><blockquote type=3D"cite" class=3D"q= uoted-plain-text"><br></blockquote><blockquote type=3D"cite" class=3D"quot= ed-plain-text">> Line 964 in mine is not:</blockquote><blockquote type=3D= "cite" class=3D"quoted-plain-text"><br></blockquote><blockquote type=3D"ci= te" class=3D"quoted-plain-text">> sub _store_workbook {</blockquote><bl= ockquote type=3D"cite" class=3D"quoted-plain-text"><br></blockquote><block= quote type=3D"cite" class=3D"quoted-plain-text"><br></blockquote><blockquo= te type=3D"cite" class=3D"quoted-plain-text">No, of course not, but it is = *within* the _store_workbook function.</blockquote><blockquote type=3D"cit= e" class=3D"quoted-plain-text">The part after the second "@@" in a GNU uni= fied diff section header is</blockquote><blockquote type=3D"cite" class=3D= "quoted-plain-text">just a hint to the patch program and/or the human read= er.</blockquote><br>I didn't realize that those line numbers were only hin= ts.</span></div></div></blockquote></div><div><span><br data-mce-bogus=3D"= 1"></span></div><div><span>The line numbers are exact for the context line= s they refer to. The hint is the function name in which those lines = occur. I would have sent a DIFFERENCES/SLP if I'd known the GNU diff= would confuse you :-).<br></span></div><div><span> <br></span><blockquote= type=3D"cite"><div class=3D"msg-quote"><div class=3D"_stretch"><span clas= s=3D"body-text-content">I was able to make the edits from what you'd poste= d and it works.<br>However, the one CSV file has over 35K lines giving an = out of memory<br>error.<br></span></div></div></blockquote></div><div><spa= n><br data-mce-bogus=3D"1"></span></div><div><span>Have you tried the set_= optimization() method as recommended here:</span></div><div><span><br data= -mce-bogus=3D"1"></span></div><div><span><<a href=3D"http://search.cpan= .org/~jmcnamara/Excel-Writer-XLSX-0.86/lib/Excel/Writer/XLSX.pm#SPEED_AND_= MEMORY_USAGE>">http://search.cpan.org/~jmcnamara/Excel-Writer-XLSX-0.86/li= b/Excel/Writer/XLSX.pm#SPEED_AND_MEMORY_USAGE></a><br data-mce-bogus=3D= "1"></span></div><div><span><br data-mce-bogus=3D"1"></span></div><div><sp= an>?<br data-mce-bogus=3D"1"></span></div></div></body></html>= --Boundary_(ID_6SFBS6+aGog5HNiIwERzCw)-- --Boundary_(ID_RXk0HJofRbyHGf2dXuEL9w)--