tag:blogger.com,1999:blog-29399536.post4462873695835772170..comments2024-02-10T03:17:37.879-05:00Comments on Dave Richards - City of Largo Work Blog: We Have Print DataDave Richardshttp://www.blogger.com/profile/06403055794363134691noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-29399536.post-70672530798818881332011-05-21T06:17:33.389-04:002011-05-21T06:17:33.389-04:00s/Deptartment/Department
but you probably already...s/Deptartment/Department<br /><br />but you probably already fixed that...sdfnoreply@blogger.comtag:blogger.com,1999:blog-29399536.post-14309743787222087432011-05-20T10:33:03.204-04:002011-05-20T10:33:03.204-04:00natxete:
Here is a snip of the perl code, this li...natxete:<br /><br />Here is a snip of the perl code, this library is awesome and so easy:<br /><br />use OpenOffice::OODoc;<br /># define output file<br />my $doc = odfDocument(file=>'/tmp/drichard_dept.ods',create=>'spreadsheet',part=>'content' );<br /># define the physical size of the cells<br />my $sheet = $doc->expandTable(0, 15, 3);<br /># Write out headers<br />$doc->cellValue($sheet,0,0,'Department');<br />$doc->cellValue($sheet,0,1,'Number Pages');<br />$doc->cellValue($sheet,0,2,'Cost');<br /># write out text<br />$doc->cellValue($sheet,1,0,'pd');<br /># write out integers, a bit more tricky<br />my $cell = $doc->getCell($sheet,1, 1);<br />$doc->cellValueType($cell, 'float');<br />$doc->updateCell($sheet,1,1,3809);<br />my $cell = $doc->getCell($sheet,1, 2);<br />$doc->cellValueType($cell, 'float');<br />$doc->updateCell($sheet,1,2,671);<br />$doc->save;Dave Richardshttps://www.blogger.com/profile/06403055794363134691noreply@blogger.comtag:blogger.com,1999:blog-29399536.post-83279948158969920412011-05-20T03:00:36.801-04:002011-05-20T03:00:36.801-04:00and the name of this Perl library is ... ?
:-) ju...and the name of this Perl library is ... ?<br /><br />:-) just curious, nice combination of Python for the gui stuff and Perl for the data munging.natxetehttps://www.blogger.com/profile/02980020813805676256noreply@blogger.com