<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-2">
<meta name=ProgId content=Word.Document>
<meta name=Generator content="Microsoft Word 10">
<meta name=Originator content="Microsoft Word 10">
<link rel=File-List href="cid:filelist.xml@01C452CB.DA1F2750">
<!--[if gte mso 9]><xml>
<o:OfficeDocumentSettings>
<o:DoNotRelyOnCSS/>
</o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:SpellingState>Clean</w:SpellingState>
<w:GrammarState>Clean</w:GrammarState>
<w:DocumentKind>DocumentEmail</w:DocumentKind>
<w:HyphenationZone>21</w:HyphenationZone>
<w:EnvelopeVis/>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SnapToGridInCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
</w:Compatibility>
<w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
</w:WordDocument>
</xml><![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;
mso-font-charset:238;
mso-generic-font-family:swiss;
mso-font-pitch:variable;
mso-font-signature:536871559 0 0 0 415 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-parent:"";
margin:0cm;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;
text-underline:single;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;
text-underline:single;}
p
{mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
span.StylWiadomociEmail17
{mso-style-type:personal-compose;
mso-style-noshow:yes;
mso-ansi-font-size:10.0pt;
mso-bidi-font-size:10.0pt;
font-family:Arial;
mso-ascii-font-family:Arial;
mso-hansi-font-family:Arial;
mso-bidi-font-family:Arial;
color:windowtext;}
span.SpellE
{mso-style-name:"";
mso-spl-e:yes;}
span.GramE
{mso-style-name:"";
mso-gram-e:yes;}
@page Section1
{size:595.3pt 841.9pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;
mso-header-margin:35.4pt;
mso-footer-margin:35.4pt;
mso-paper-source:0;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 10]>
<style>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:Standardowy;
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-parent:"";
mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
mso-para-margin:0cm;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:"Times New Roman";}
</style>
<![endif]-->
</head>
<body lang=PL link=blue vlink=purple style='tab-interval:35.4pt'>
<div class=Section1>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-US style='font-size:
10.0pt;font-family:Arial;mso-ansi-language:EN-US'>Sorry for disturbing you but
I’m completely new to object-oriented <span class=SpellE>Perl</span>, and
I’ve got a problem that completely not able to cope with:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-US style='font-size:
10.0pt;font-family:Arial;mso-ansi-language:EN-US'>What I <span class=SpellE>wanna</span>
do is put some data about tickets into Excel file (<span class=SpellE>sth</span>
like a report done with Search in RT).<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-US style='font-size:
10.0pt;font-family:Arial;mso-ansi-language:EN-US'>I’m downloaded <span
class=SpellE>Spreadsheet::WriteExcel</span> library and tried to make <span
class=SpellE>sth</span> using it. I managed to mage a file starting a <span
class=SpellE>perl</span> script from command line so the library is working.
But I really can’t make it working with my RT.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-US style='font-size:
10.0pt;font-family:Arial;mso-ansi-language:EN-US'>Can anybody show me how to
run this in RT using for instance a very simple <span class=GramE>code:</span><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-US style='font-size:
10.0pt;font-family:Arial;mso-ansi-language:EN-US'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><font
size=2 face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"'>#!/<span
class=SpellE><span class=GramE>usr</span></span>/<span class=SpellE>bin</span>/perl
-w<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><font
size=2 face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><span
class=GramE><font size=2 face="Courier New"><span lang=EN-US style='font-size:
10.0pt;font-family:"Courier New";mso-ansi-language:EN-US'>use</span></font></span><font
size=2 face="Courier New"><span lang=EN-US style='font-size:10.0pt;font-family:
"Courier New";mso-ansi-language:EN-US'> strict;<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><span
class=GramE><font size=2 face="Courier New"><span lang=EN-US style='font-size:
10.0pt;font-family:"Courier New";mso-ansi-language:EN-US'>use</span></font></span><font
size=2 face="Courier New"><span lang=EN-US style='font-size:10.0pt;font-family:
"Courier New";mso-ansi-language:EN-US'> <span class=SpellE>Spreadsheet::WriteExcel</span>;<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><font
size=2 face="Courier New"><span lang=EN-US style='font-size:10.0pt;font-family:
"Courier New";mso-ansi-language:EN-US'># Create a new Excel workbook called
perl.xls<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><span
class=GramE><font size=2 face="Courier New"><span lang=EN-US style='font-size:
10.0pt;font-family:"Courier New";mso-ansi-language:EN-US'>my</span></font></span><font
size=2 face="Courier New"><span lang=EN-US style='font-size:10.0pt;font-family:
"Courier New";mso-ansi-language:EN-US'> $workbook = <span class=SpellE>Spreadsheet::WriteExcel</span>->new("perl.xls");<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><span
class=GramE><font size=2 face="Courier New"><span lang=EN-US style='font-size:
10.0pt;font-family:"Courier New";mso-ansi-language:EN-US'>my</span></font></span><font
size=2 face="Courier New"><span lang=EN-US style='font-size:10.0pt;font-family:
"Courier New";mso-ansi-language:EN-US'> $worksheet = $workbook-><span
class=SpellE>addworksheet</span>();<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><font
size=2 face="Courier New"><span lang=EN-US style='font-size:10.0pt;font-family:
"Courier New";mso-ansi-language:EN-US'># Write some text and some numbers<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><font
size=2 face="Courier New"><span lang=EN-US style='font-size:10.0pt;font-family:
"Courier New";mso-ansi-language:EN-US'># Row and column are zero indexed<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><font
size=2 face="Courier New"><span lang=EN-US style='font-size:10.0pt;font-family:
"Courier New";mso-ansi-language:EN-US'>$worksheet-><span class=GramE>write(</span>0,
0, "The <span class=SpellE>Perl</span> Journal");<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><font
size=2 face="Courier New"><span lang=EN-US style='font-size:10.0pt;font-family:
"Courier New";mso-ansi-language:EN-US'>$worksheet-><span class=GramE>write(</span>1,
0, "One" );<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><font
size=2 face="Courier New"><span lang=EN-US style='font-size:10.0pt;font-family:
"Courier New";mso-ansi-language:EN-US'>$worksheet-><span class=GramE>write(</span>2,
0, "Two" );<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><font
size=2 face="Courier New"><span lang=EN-US style='font-size:10.0pt;font-family:
"Courier New";mso-ansi-language:EN-US'>$worksheet-><span class=GramE>write(</span>3,
0, 3 );<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><font
size=2 face="Courier New"><span lang=EN-US style='font-size:10.0pt;font-family:
"Courier New";mso-ansi-language:EN-US'>$worksheet-><span class=GramE>write(</span>4,
0, 4.0000001 );<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><font
size=2 face="Courier New"><span lang=EN-US style='font-size:10.0pt;font-family:
"Courier New";mso-ansi-language:EN-US'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><font
size=2 face="Courier New"><span lang=EN-US style='font-size:10.0pt;font-family:
"Courier New";mso-ansi-language:EN-US'>How to make it working run from ‘/opt/rt3/share/html/Search/’
directory in my <span class=GramE>RT ?</span><o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><font
size=2 face="Courier New"><span lang=EN-US style='font-size:10.0pt;font-family:
"Courier New";mso-ansi-language:EN-US'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><font
size=2 face="Courier New"><span lang=EN-US style='font-size:10.0pt;font-family:
"Courier New";mso-ansi-language:EN-US'>When I try to start it just putting ‘%’
before every line I get:<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><font
size=2 face="Courier New"><span lang=EN-US style='font-size:10.0pt;font-family:
"Courier New";mso-ansi-language:EN-US'><o:p> </o:p></span></font></p>
<p align=center style='text-align:center'><b><font size=3 face=Verdana><span
style='font-size:12.0pt;font-family:Verdana;font-weight:bold'>System <span
class=SpellE>error</span></span></font></b><o:p></o:p></p>
<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0
style='mso-cellspacing:0cm'>
<tr style='mso-yfti-irow:0'>
<td nowrap valign=top style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span class=SpellE><span class=GramE><b><font size=1
face=Verdana><span style='font-size:7.5pt;font-family:Verdana;font-weight:
bold'>error</span></font></b></span></span><b><font size=1 face=Verdana><span
style='font-size:7.5pt;font-family:Verdana;font-weight:bold'>:</span></font></b><font
size=1 face=Verdana><span style='font-size:7.5pt;font-family:Verdana'> </span></font><o:p></o:p></p>
</td>
<td valign=top style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><font size=1 face=Verdana><span lang=EN-US
style='font-size:7.5pt;font-family:Verdana;mso-ansi-language:EN-US'>Can't
call method "<span class=SpellE>addworksheet</span>" on an
undefined value at /opt/rt3/share/html/Search/ListingExcel2Report.html line
5.</span></font><span lang=EN-US style='mso-ansi-language:EN-US'><o:p></o:p></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:1;mso-yfti-lastrow:yes'>
<td nowrap valign=top style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span class=SpellE><span class=GramE><b><font size=1
face=Verdana><span style='font-size:7.5pt;font-family:Verdana;font-weight:
bold'>context</span></font></b></span></span><b><font size=1 face=Verdana><span
style='font-size:7.5pt;font-family:Verdana;font-weight:bold'>:</span></font></b><font
size=1 face=Verdana><span style='font-size:7.5pt;font-family:Verdana'> </span></font><o:p></o:p></p>
</td>
<td nowrap valign=top style='padding:.75pt .75pt .75pt .75pt'>
<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0
style='mso-cellspacing:0cm;mso-padding-alt:0cm 0cm 0cm 0cm'>
<tr style='mso-yfti-irow:0'>
<td nowrap valign=top style='padding:0cm 0cm 0cm 0cm'>
<p class=MsoNormal><b><font size=1 face=Verdana><span style='font-size:
7.5pt;font-family:Verdana;font-weight:bold'>1:</span></font></b><font
size=1 face=Verdana><span style='font-size:7.5pt;font-family:Verdana'> </span></font><o:p></o:p></p>
</td>
<td nowrap valign=top style='padding:0cm 0cm 0cm 0cm'>
<p class=MsoNormal><font size=1 face=Verdana><span style='font-size:7.5pt;
font-family:Verdana'>%<span class=SpellE>use</span> <span class=SpellE>strict</span>;
</span></font><o:p></o:p></p>
</td>
</tr>
<tr style='mso-yfti-irow:1'>
<td nowrap valign=top style='padding:0cm 0cm 0cm 0cm'>
<p class=MsoNormal><b><font size=1 face=Verdana><span style='font-size:
7.5pt;font-family:Verdana;font-weight:bold'>2:</span></font></b><font
size=1 face=Verdana><span style='font-size:7.5pt;font-family:Verdana'> </span></font><o:p></o:p></p>
</td>
<td nowrap valign=top style='padding:0cm 0cm 0cm 0cm'>
<p class=MsoNormal><font size=1 face=Verdana><span style='font-size:7.5pt;
font-family:Verdana'>%<span class=SpellE>use</span> <span class=SpellE>Spreadsheet::WriteExcel</span>;
</span></font><o:p></o:p></p>
</td>
</tr>
<tr style='mso-yfti-irow:2'>
<td nowrap valign=top style='padding:0cm 0cm 0cm 0cm'>
<p class=MsoNormal><b><font size=1 face=Verdana><span style='font-size:
7.5pt;font-family:Verdana;font-weight:bold'>3:</span></font></b><font
size=1 face=Verdana><span style='font-size:7.5pt;font-family:Verdana'> </span></font><o:p></o:p></p>
</td>
<td nowrap valign=top style='padding:0cm 0cm 0cm 0cm'>
<p class=MsoNormal><font size=1 face=Verdana><span lang=EN-US
style='font-size:7.5pt;font-family:Verdana;mso-ansi-language:EN-US'>%#
Create a new Excel workbook called perl.xls </span></font><span lang=EN-US
style='mso-ansi-language:EN-US'><o:p></o:p></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:3'>
<td nowrap valign=top style='padding:0cm 0cm 0cm 0cm'>
<p class=MsoNormal><b><font size=1 face=Verdana><span style='font-size:
7.5pt;font-family:Verdana;font-weight:bold'>4:</span></font></b><font
size=1 face=Verdana><span style='font-size:7.5pt;font-family:Verdana'> </span></font><o:p></o:p></p>
</td>
<td nowrap valign=top style='padding:0cm 0cm 0cm 0cm'>
<p class=MsoNormal><font size=1 face=Verdana><span lang=EN-US
style='font-size:7.5pt;font-family:Verdana;mso-ansi-language:EN-US'>%my
$workbook = <span class=SpellE>Spreadsheet::WriteExcel</span>->new("perl.xls");
</span></font><span lang=EN-US style='mso-ansi-language:EN-US'><o:p></o:p></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:4'>
<td nowrap valign=top style='padding:0cm 0cm 0cm 0cm'>
<p class=MsoNormal><b><font size=1 face=Verdana><span style='font-size:
7.5pt;font-family:Verdana;font-weight:bold'>5:</span></font></b><font
size=1 face=Verdana><span style='font-size:7.5pt;font-family:Verdana'> </span></font><o:p></o:p></p>
</td>
<td nowrap valign=top style='padding:0cm 0cm 0cm 0cm'>
<p class=MsoNormal><font size=1 color=red face=Verdana><span
style='font-size:7.5pt;font-family:Verdana;color:red'>%my $<span
class=SpellE>worksheet</span> = $<span class=SpellE>workbook->addworksheet</span>();
</span></font><o:p></o:p></p>
</td>
</tr>
<tr style='mso-yfti-irow:5'>
<td nowrap valign=top style='padding:0cm 0cm 0cm 0cm'>
<p class=MsoNormal><b><font size=1 face=Verdana><span style='font-size:
7.5pt;font-family:Verdana;font-weight:bold'>6:</span></font></b><font
size=1 face=Verdana><span style='font-size:7.5pt;font-family:Verdana'> </span></font><o:p></o:p></p>
</td>
<td nowrap valign=top style='padding:0cm 0cm 0cm 0cm'>
<p class=MsoNormal><font size=1 face=Verdana><span lang=EN-US
style='font-size:7.5pt;font-family:Verdana;mso-ansi-language:EN-US'>%#
Write some text and some numbers </span></font><span lang=EN-US
style='mso-ansi-language:EN-US'><o:p></o:p></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:6'>
<td nowrap valign=top style='padding:0cm 0cm 0cm 0cm'>
<p class=MsoNormal><b><font size=1 face=Verdana><span style='font-size:
7.5pt;font-family:Verdana;font-weight:bold'>7:</span></font></b><font
size=1 face=Verdana><span style='font-size:7.5pt;font-family:Verdana'> </span></font><o:p></o:p></p>
</td>
<td nowrap valign=top style='padding:0cm 0cm 0cm 0cm'>
<p class=MsoNormal><font size=1 face=Verdana><span lang=EN-US
style='font-size:7.5pt;font-family:Verdana;mso-ansi-language:EN-US'>%# Row
and column are zero indexed </span></font><span lang=EN-US
style='mso-ansi-language:EN-US'><o:p></o:p></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:7'>
<td nowrap valign=top style='padding:0cm 0cm 0cm 0cm'>
<p class=MsoNormal><b><font size=1 face=Verdana><span style='font-size:
7.5pt;font-family:Verdana;font-weight:bold'>8:</span></font></b><font
size=1 face=Verdana><span style='font-size:7.5pt;font-family:Verdana'> </span></font><o:p></o:p></p>
</td>
<td nowrap valign=top style='padding:0cm 0cm 0cm 0cm'>
<p class=MsoNormal><font size=1 face=Verdana><span lang=EN-US
style='font-size:7.5pt;font-family:Verdana;mso-ansi-language:EN-US'>%$worksheet->write(0,
0, "The <span class=SpellE>Perl</span> Journal"); </span></font><span
lang=EN-US style='mso-ansi-language:EN-US'><o:p></o:p></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:8'>
<td nowrap valign=top style='padding:0cm 0cm 0cm 0cm'>
<p class=MsoNormal><b><font size=1 face=Verdana><span style='font-size:
7.5pt;font-family:Verdana;font-weight:bold'>9:</span></font></b><font
size=1 face=Verdana><span style='font-size:7.5pt;font-family:Verdana'> </span></font><o:p></o:p></p>
</td>
<td nowrap valign=top style='padding:0cm 0cm 0cm 0cm'>
<p class=MsoNormal><font size=1 face=Verdana><span style='font-size:7.5pt;
font-family:Verdana'>%$<span class=SpellE>worksheet->write</span>(1, 0,
"<span class=GramE>One" ); </span></span></font><o:p></o:p></p>
</td>
</tr>
<tr style='mso-yfti-irow:9;mso-yfti-lastrow:yes'>
<td nowrap valign=top style='padding:0cm 0cm 0cm 0cm'>
<p class=MsoNormal><b><font size=1 face=Verdana><span style='font-size:
7.5pt;font-family:Verdana;font-weight:bold'>...</span></font></b><font
size=1 face=Verdana><span style='font-size:7.5pt;font-family:Verdana'> </span></font><o:p></o:p></p>
</td>
<td style='padding:0cm 0cm 0cm 0cm'>
<p class=MsoNormal><font size=2 face="Times New Roman"><span
style='font-size:10.0pt'><o:p> </o:p></span></font></p>
</td>
</tr>
</table>
<p class=MsoNormal><font size=1 face=Verdana><span style='font-size:7.5pt;
font-family:Verdana'><o:p></o:p></span></font></p>
</td>
</tr>
</table>
<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><font
size=2 face="Courier New"><span lang=EN-US style='font-size:10.0pt;font-family:
"Courier New";mso-ansi-language:EN-US'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='mso-layout-grid-align:none;text-autospace:none'><font
size=2 face="Courier New"><span lang=EN-US style='font-size:10.0pt;font-family:
"Courier New";mso-ansi-language:EN-US'>Lost of thanks in advance – you’ll
give me a great birthday present ;)<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial;mso-no-proof:
yes'>Greets</span></font><span style='mso-no-proof:yes'><o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><strong><b><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial;mso-no-proof:
yes'>Krzysztof Opała</span></font></b></strong><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial;mso-no-proof:yes'><br>
Comarch Kraków S.A.<br>
Poland<o:p></o:p></span></font></p>
</div>
</body>
</html>