<html xmlns:v="urn:schemas-microsoft-com:vml"
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=windows-1252">
<meta name=ProgId content=Word.Document>
<meta name=Generator content="Microsoft Word 9">
<meta name=Originator content="Microsoft Word 9">
<link rel=File-List href="./PhpToXls_fichiers/filelist.xml">
<title> Project : ABG Framework</title>
<!--[if gte mso 9]><xml>
<o:DocumentProperties>
<o:Author>gib.abg</o:Author>
<o:LastAuthor>Gib</o:LastAuthor>
<o:Revision>2</o:Revision>
<o:TotalTime>187</o:TotalTime>
<o:LastPrinted>2011-03-27T16:58:00Z</o:LastPrinted>
<o:Created>2011-03-27T18:27:00Z</o:Created>
<o:LastSaved>2011-03-27T18:27:00Z</o:LastSaved>
<o:Pages>2</o:Pages>
<o:Words>535</o:Words>
<o:Characters>3051</o:Characters>
<o:Company>ABG-Soft</o:Company>
<o:Lines>25</o:Lines>
<o:Paragraphs>6</o:Paragraphs>
<o:CharactersWithSpaces>3746</o:CharactersWithSpaces>
<o:Version>9.2812</o:Version>
</o:DocumentProperties>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:Zoom>110</w:Zoom>
<w:HyphenationZone>21</w:HyphenationZone>
<w:DoNotOptimizeForBrowser/>
</w:WordDocument>
</xml><![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;
mso-font-charset:2;
mso-generic-font-family:auto;
mso-font-pitch:variable;
mso-font-signature:0 268435456 0 0 -2147483648 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";}
h1
{mso-style-next:Normal;
margin-top:9.0pt;
margin-right:0cm;
margin-bottom:3.0pt;
margin-left:0cm;
mso-pagination:widow-orphan;
page-break-after:avoid;
mso-outline-level:1;
font-size:14.0pt;
mso-bidi-font-size:16.0pt;
font-family:Arial;
mso-font-kerning:16.0pt;}
h2
{mso-style-next:Normal;
margin-top:6.0pt;
margin-right:0cm;
margin-bottom:2.0pt;
margin-left:8.5pt;
mso-pagination:widow-orphan;
page-break-after:avoid;
mso-outline-level:2;
font-size:12.0pt;
mso-bidi-font-size:14.0pt;
font-family:Arial;
mso-bidi-font-style:italic;
text-decoration:underline;
text-underline:single;}
h3
{mso-style-next:Normal;
margin-top:3.0pt;
margin-right:0cm;
margin-bottom:1.0pt;
margin-left:14.2pt;
mso-pagination:widow-orphan;
page-break-after:avoid;
mso-outline-level:3;
font-size:13.0pt;
font-family:Arial;
font-weight:normal;
mso-bidi-font-weight:bold;
text-decoration:underline;
text-underline:single;}
h4
{mso-style-next:Normal;
margin:0cm;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
page-break-after:avoid;
mso-outline-level:4;
font-size:12.0pt;
font-family:Arial;
mso-ansi-language:EN-GB;}
h5
{mso-style-next:Normal;
margin-top:0cm;
margin-right:240.0pt;
margin-bottom:0cm;
margin-left:0cm;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
page-break-after:avoid;
mso-outline-level:5;
border:none;
mso-border-alt:solid windowtext .5pt;
padding:0cm;
mso-padding-alt:1.0pt 4.0pt 1.0pt 4.0pt;
font-size:12.0pt;
font-family:Arial;
mso-ansi-language:EN-GB;}
p.MsoHeader, li.MsoHeader, div.MsoHeader
{margin:0cm;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
tab-stops:center 8.0cm right 16.0cm;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
p.MsoFooter, li.MsoFooter, div.MsoFooter
{margin:0cm;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
tab-stops:center 8.0cm right 16.0cm;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
p.MsoBodyText, li.MsoBodyText, div.MsoBodyText
{margin-top:0cm;
margin-right:627.0pt;
margin-bottom:0cm;
margin-left:0cm;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
tab-stops:963.0pt;
mso-layout-grid-align:none;
text-autospace:none;
border:none;
mso-border-alt:solid windowtext .5pt;
padding:0cm;
mso-padding-alt:1.0pt 31.0pt 1.0pt 4.0pt;
font-size:10.0pt;
font-family:"Courier New";
mso-fareast-font-family:"Times New Roman";
color:green;
mso-ansi-language:EN-GB;
font-style:italic;}
p.MsoBodyText2, li.MsoBodyText2, div.MsoBodyText2
{margin-top:0cm;
margin-right:753.0pt;
margin-bottom:0cm;
margin-left:0cm;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
tab-stops:963.0pt;
mso-layout-grid-align:none;
text-autospace:none;
font-size:10.0pt;
font-family:"Courier New";
mso-fareast-font-family:"Times New Roman";
color:green;
mso-ansi-language:EN-GB;
font-style:italic;}
p.q4, li.q4, div.q4
{mso-style-name:q4;
margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:68.4pt;
margin-bottom:.0001pt;
text-indent:-20.4pt;
mso-pagination:widow-orphan;
mso-list:l2 level1 lfo1;
tab-stops:list 68.4pt;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
@page Section1
{size:595.3pt 841.9pt;
margin:1.0cm 15.9pt 1.0cm 1.0cm;
mso-header-margin:14.2pt;
mso-footer-margin:14.2pt;
mso-paper-source:0;}
div.Section1
{page:Section1;}
/* List Definitions */
@list l0
{mso-list-id:106200084;
mso-list-type:hybrid;
mso-list-template-ids:-234987302 67895297 67895299 67895301 67895297 67895299 67895301 67895297 67895299 67895301;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:66.0pt;
mso-level-number-position:left;
margin-left:66.0pt;
text-indent:-18.0pt;
font-family:Symbol;}
@list l1
{mso-list-id:960723319;
mso-list-type:hybrid;
mso-list-template-ids:1453606038 67895297 67895299 67895301 67895297 67895299 67895301 67895297 67895299 67895301;}
@list l1:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:45.05pt;
mso-level-number-position:left;
margin-left:45.05pt;
text-indent:-18.0pt;
font-family:Symbol;}
@list l2
{mso-list-id:1683243058;
mso-list-type:hybrid;
mso-list-template-ids:-234987302 630763118 67895299 67895301 67895297 67895299 67895301 67895297 67895299 67895301;}
@list l2:level1
{mso-level-number-format:bullet;
mso-level-style-link:q4;
mso-level-text:\F0D6;
mso-level-tab-stop:68.4pt;
mso-level-number-position:left;
margin-left:68.4pt;
text-indent:-20.4pt;
font-family:Symbol;
mso-bidi-font-family:"Times New Roman";}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="2050"/>
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1"/>
</o:shapelayout></xml><![endif]-->
</head>
<body lang=FR style='tab-interval:35.4pt'>
<div class=Section1>
<div style='border:solid windowtext .5pt;padding:1.0pt 0cm 1.0pt 5.0pt'>
<p class=MsoNormal style='margin-top:0cm;margin-right:167.55pt;margin-bottom:
0cm;margin-left:8.5pt;margin-bottom:.0001pt;border:none;mso-border-alt:solid windowtext .5pt;
padding:0cm;mso-padding-alt:1.0pt 0cm 1.0pt 5.0pt'><span lang=EN-GB
style='font-size:8.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;mso-ansi-language:
EN-GB'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></p>
<h5 style='margin-top:0cm;margin-right:167.55pt;margin-bottom:0cm;margin-left:
8.5pt;margin-bottom:.0001pt;border:none;mso-border-alt:solid windowtext .5pt;
padding:0cm;mso-padding-alt:1.0pt 0cm 1.0pt 5.0pt'><span lang=EN-GB>ABG_PhpToXls<span
style="mso-spacerun: yes"> </span>:<span style="mso-spacerun: yes">
</span>PHP class to export PHP array to Excel file</span></h5>
<p class=MsoNormal style='margin-top:0cm;margin-right:167.55pt;margin-bottom:
0cm;margin-left:8.5pt;margin-bottom:.0001pt;border:none;mso-border-alt:solid windowtext .5pt;
padding:0cm;mso-padding-alt:1.0pt 0cm 1.0pt 5.0pt'><span lang=EN-GB
style='font-family:Arial;mso-ansi-language:EN-GB'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></p>
<p class=MsoNormal style='margin-top:0cm;margin-right:167.55pt;margin-bottom:
0cm;margin-left:8.5pt;margin-bottom:.0001pt;border:none;mso-border-alt:solid windowtext .5pt;
padding:0cm;mso-padding-alt:1.0pt 0cm 1.0pt 5.0pt'><span lang=EN-GB
style='font-family:Arial;mso-ansi-language:EN-GB'>Project : ABG Framework<o:p></o:p></span></p>
<p class=MsoHeader style='margin-top:0cm;margin-right:167.55pt;margin-bottom:
0cm;margin-left:8.5pt;margin-bottom:.0001pt;tab-stops:35.4pt;border:none;
mso-border-alt:solid windowtext .5pt;padding:0cm;mso-padding-alt:1.0pt 0cm 1.0pt 5.0pt'><span
lang=EN-GB style='font-family:Arial;mso-ansi-language:EN-GB'>File:
ABG_PhpToXls.cls.php<o:p></o:p></span></p>
<p class=MsoNormal style='margin-top:0cm;margin-right:167.55pt;margin-bottom:
0cm;margin-left:8.5pt;margin-bottom:.0001pt;border:none;mso-border-alt:solid windowtext .5pt;
padding:0cm;mso-padding-alt:1.0pt 0cm 1.0pt 5.0pt'><span lang=EN-GB
style='font-family:Arial;mso-ansi-language:EN-GB'>V1.0.0 27/03/2011<o:p></o:p></span></p>
<p class=MsoNormal style='margin-top:0cm;margin-right:167.55pt;margin-bottom:
0cm;margin-left:8.5pt;margin-bottom:.0001pt;border:none;mso-border-alt:solid windowtext .5pt;
padding:0cm;mso-padding-alt:1.0pt 0cm 1.0pt 5.0pt'><span style='font-family:
Arial'>© G. BENABOU / ABG Soft PARIS FRANCE<o:p></o:p></span></p>
<p class=MsoNormal style='margin-top:0cm;margin-right:167.55pt;margin-bottom:
0cm;margin-left:8.5pt;margin-bottom:.0001pt;border:none;mso-border-alt:solid windowtext .5pt;
padding:0cm;mso-padding-alt:1.0pt 0cm 1.0pt 5.0pt'><b><span lang=EN-GB
style='font-size:8.0pt;mso-bidi-font-size:12.0pt;font-family:Arial;mso-ansi-language:
EN-GB'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></b></p>
</div>
<h1><span lang=EN-GB style='mso-ansi-language:EN-GB'>Presentation<o:p></o:p></span></h1>
<p class=MsoNormal style='margin-left:9.0pt'><b><span lang=EN-GB
style='font-family:Arial;mso-ansi-language:EN-GB'>ABG_PhpToXls</span></b><span
lang=EN-GB style='font-family:Arial;mso-ansi-language:EN-GB'> is a PHP class to
generate Excel data from 2 dimensions PHP arrays in form of:<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:9.0pt'><b><span lang=EN-GB
style='font-size:11.0pt;mso-bidi-font-size:12.0pt;font-family:"Courier New";
mso-ansi-language:EN-GB'>$PhpArray = array( array(CellA1, CellB1, </span></b><b><span
lang=EN-GB style='font-family:Arial;mso-ansi-language:EN-GB'>
</span></b><b><span
lang=EN-GB style='font-size:11.0pt;mso-bidi-font-size:12.0pt;font-family:"Courier New";
mso-ansi-language:EN-GB'>),<o:p></o:p></span></b></p>
<p class=MsoNormal style='margin-left:9.0pt'><b><span style='font-size:11.0pt;
mso-bidi-font-size:12.0pt;font-family:"Courier New"'><span style="mso-spacerun:
yes"> </span>array(CellA2, CellB2, </span></b><b><span
style='font-family:Arial'>
</span></b><b><span style='font-size:11.0pt;
mso-bidi-font-size:12.0pt;font-family:"Courier New"'>),<o:p></o:p></span></b></p>
<p class=MsoNormal style='margin-left:9.0pt'><b><span style='font-size:11.0pt;
mso-bidi-font-size:12.0pt;font-family:"Courier New"'><span style="mso-spacerun:
yes"> </span></span></b><b><span lang=EN-GB style='font-family:
Arial;mso-ansi-language:EN-GB'>. . . . . . . . .<o:p></o:p></span></b></p>
<p class=MsoNormal style='margin-left:9.0pt'><b><span lang=EN-GB
style='font-size:11.0pt;mso-bidi-font-size:12.0pt;font-family:"Courier New";
mso-ansi-language:EN-GB'><span style="mso-spacerun: yes">
</span>array(CellAn, CellBn, </span></b><b><span lang=EN-GB style='font-family:
Arial;mso-ansi-language:EN-GB'>
</span></b><b><span lang=EN-GB
style='font-size:11.0pt;mso-bidi-font-size:12.0pt;font-family:"Courier New";
mso-ansi-language:EN-GB'>)<o:p></o:p></span></b></p>
<p class=MsoNormal style='margin-left:9.0pt'><b><span lang=EN-GB
style='font-size:11.0pt;mso-bidi-font-size:12.0pt;font-family:"Courier New";
mso-ansi-language:EN-GB'><span style="mso-spacerun: yes">
</span>);<o:p></o:p></span></b></p>
<p class=MsoNormal style='margin-left:9.0pt'><b><span lang=EN-GB
style='font-size:11.0pt;mso-bidi-font-size:12.0pt;font-family:"Courier New";
mso-ansi-language:EN-GB'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></b></p>
<p class=MsoNormal style='margin-left:9.0pt'><span lang=EN-GB style='font-family:
Arial;mso-ansi-language:EN-GB'>Where <b>CellXn</b> data will be stored in the
corresponding sheet cell.<o:p></o:p></span></p>
<p class=MsoNormal style='margin-top:0cm;margin-right:0cm;margin-bottom:6.0pt;
margin-left:9.05pt'><span lang=EN-GB style='font-family:Arial;mso-ansi-language:
EN-GB'>Values accepted are:<o:p></o:p></span></p>
<table border=0 cellspacing=0 cellpadding=0 style='margin-left:17.6pt;
border-collapse:collapse;mso-padding-alt:0cm 3.5pt 0cm 3.5pt'>
<tr>
<td width=95 valign=top style='width:71.6pt;padding:0cm 3.5pt 0cm 3.5pt'>
<p class=MsoNormal><span lang=EN-GB style='font-family:Arial;mso-ansi-language:
EN-GB'>Integer</span><b><span lang=EN-GB style='font-size:11.0pt;mso-bidi-font-size:
12.0pt;font-family:"Courier New";mso-ansi-language:EN-GB'><o:p></o:p></span></b></p>
</td>
<td width=613 valign=top style='width:459.45pt;padding:0cm 3.5pt 0cm 3.5pt'>
<p class=MsoNormal><span lang=EN-GB style='font-family:Arial;mso-ansi-language:
EN-GB'>: double word</span><b><span lang=EN-GB style='font-size:11.0pt;
mso-bidi-font-size:12.0pt;font-family:"Courier New";mso-ansi-language:EN-GB'><o:p></o:p></span></b></p>
</td>
</tr>
<tr>
<td width=95 valign=top style='width:71.6pt;padding:0cm 3.5pt 0cm 3.5pt'>
<p class=MsoNormal><span lang=EN-GB style='font-family:Arial;mso-ansi-language:
EN-GB'>Float</span><b><span lang=EN-GB style='font-size:11.0pt;mso-bidi-font-size:
12.0pt;font-family:"Courier New";mso-ansi-language:EN-GB'><o:p></o:p></span></b></p>
</td>
<td width=613 valign=top style='width:459.45pt;padding:0cm 3.5pt 0cm 3.5pt'>
<p class=MsoNormal><span lang=EN-GB style='font-family:Arial;mso-ansi-language:
EN-GB'>: 64 bits</span><b><span lang=EN-GB style='font-size:11.0pt;
mso-bidi-font-size:12.0pt;font-family:"Courier New";mso-ansi-language:EN-GB'><o:p></o:p></span></b></p>
</td>
</tr>
<tr>
<td width=95 valign=top style='width:71.6pt;padding:0cm 3.5pt 0cm 3.5pt'>
<p class=MsoNormal><span lang=EN-GB style='font-family:Arial;mso-ansi-language:
EN-GB'>Boolean</span><b><span lang=EN-GB style='font-size:11.0pt;mso-bidi-font-size:
12.0pt;font-family:"Courier New";mso-ansi-language:EN-GB'><o:p></o:p></span></b></p>
</td>
<td width=613 valign=top style='width:459.45pt;padding:0cm 3.5pt 0cm 3.5pt'>
<p class=MsoNormal><span lang=EN-GB style='font-family:Arial;mso-ansi-language:
EN-GB'>: converted to 0(false) and 1 (true)</span><b><span lang=EN-GB
style='font-size:11.0pt;mso-bidi-font-size:12.0pt;font-family:"Courier New";
mso-ansi-language:EN-GB'><o:p></o:p></span></b></p>
</td>
</tr>
<tr>
<td width=95 valign=top style='width:71.6pt;padding:0cm 3.5pt 0cm 3.5pt'>
<p class=MsoNormal><span lang=EN-GB style='font-family:Arial;mso-ansi-language:
EN-GB'>Strings</span><b><span lang=EN-GB style='font-size:11.0pt;mso-bidi-font-size:
12.0pt;font-family:"Courier New";mso-ansi-language:EN-GB'><o:p></o:p></span></b></p>
</td>
<td width=613 valign=top style='width:459.45pt;padding:0cm 3.5pt 0cm 3.5pt'>
<p class=MsoNormal><span lang=EN-GB style='font-family:Arial;mso-ansi-language:
EN-GB'>: up to 65535 chars</span><b><span lang=EN-GB style='font-size:11.0pt;
mso-bidi-font-size:12.0pt;font-family:"Courier New";mso-ansi-language:EN-GB'><o:p></o:p></span></b></p>
</td>
</tr>
</table>
<p class=MsoNormal style='margin-top:0cm;margin-right:0cm;margin-bottom:6.0pt;
margin-left:9.05pt'><span lang=EN-GB style='font-family:Arial;mso-ansi-language:
EN-GB'>Any other types are converted to Excel null cells<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:9.05pt'><span lang=EN-GB
style='font-family:Arial;mso-ansi-language:EN-GB'>Generated Excel data may be
sent to :<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:26.9pt;text-indent:-9.05pt;mso-list:l1 level1 lfo4;
tab-stops:list -9.0pt'><![if !supportLists]><span lang=EN-GB style='font-family:
Symbol;mso-bidi-font-family:Arial;mso-ansi-language:EN-GB'>·<span
style='font:7.0pt "Times New Roman"'> </span></span><![endif]><span
lang=EN-GB style='font-family:Arial;mso-ansi-language:EN-GB'>Disk file under
specified path<o:p></o:p></span></p>
<p class=MsoNormal style='margin-top:0cm;margin-right:0cm;margin-bottom:6.0pt;
margin-left:27.0pt;text-indent:-9.0pt;mso-list:l1 level1 lfo4;tab-stops:list -9.0pt'><![if !supportLists]><span
lang=EN-GB style='font-family:Symbol;mso-bidi-font-family:Arial;mso-ansi-language:
EN-GB'>·<span style='font:7.0pt "Times New Roman"'> </span></span><![endif]><span
lang=EN-GB style='font-family:Arial;mso-ansi-language:EN-GB'>Requesting user
browser (via HTTP) for Opening/Downloading<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:9.05pt'><span lang=EN-GB
style='font-family:Arial;mso-ansi-language:EN-GB'>In addition, a full set of
checks is made on parameters to, via exception mechanism, inform user<o:p></o:p></span></p>
<h1><span lang=EN-GB style='mso-ansi-language:EN-GB'>Properties<o:p></o:p></span></h1>
<p class=MsoNormal style='margin-top:0cm;margin-right:0cm;margin-bottom:6.0pt;
margin-left:9.05pt'><span lang=EN-GB style='font-family:Arial;mso-ansi-language:
EN-GB'>Properties are accessed trough magic __get and __set PHP methods wich
hide tbe corresponding private attributes<o:p></o:p></span></p>
<table border=0 cellspacing=0 cellpadding=0 style='margin-left:17.6pt;
border-collapse:collapse;mso-padding-alt:0cm 3.5pt 0cm 3.5pt'>
<tr>
<td width=95 valign=top style='width:71.6pt;padding:0cm 3.5pt 0cm 3.5pt'>
<p class=MsoNormal><span lang=EN-GB style='font-family:Arial;mso-ansi-language:
EN-GB'>PhpArray</span><b><span lang=EN-GB style='font-size:11.0pt;mso-bidi-font-size:
12.0pt;font-family:"Courier New";mso-ansi-language:EN-GB'><o:p></o:p></span></b></p>
</td>
<td width=613 valign=top style='width:459.45pt;padding:0cm 3.5pt 0cm 3.5pt'>
<p class=MsoNormal><span lang=EN-GB style='font-family:Arial;mso-ansi-language:
EN-GB'>: Source array for Xls data</span><b><span lang=EN-GB
style='font-size:11.0pt;mso-bidi-font-size:12.0pt;font-family:"Courier New";
mso-ansi-language:EN-GB'><o:p></o:p></span></b></p>
</td>
</tr>
<tr>
<td width=95 valign=top style='width:71.6pt;padding:0cm 3.5pt 0cm 3.5pt'>
<p class=MsoNormal><span lang=EN-GB style='font-family:Arial;mso-ansi-language:
EN-GB'>XlsDir</span><b><span lang=EN-GB style='font-size:11.0pt;mso-bidi-font-size:
12.0pt;font-family:"Courier New";mso-ansi-language:EN-GB'><o:p></o:p></span></b></p>
</td>
<td width=613 valign=top style='width:459.45pt;padding:0cm 3.5pt 0cm 3.5pt'>
<p class=MsoNormal><span lang=EN-GB style='font-family:Arial;mso-ansi-language:
EN-GB'>: Output directory for Xls file; default to <b>current directory</b></span><b><span
lang=EN-GB style='font-size:11.0pt;mso-bidi-font-size:12.0pt;font-family:
"Courier New";mso-ansi-language:EN-GB'><o:p></o:p></span></b></p>
</td>
</tr>
<tr>
<td width=95 valign=top style='width:71.6pt;padding:0cm 3.5pt 0cm 3.5pt'>
<p class=MsoNormal><span lang=EN-GB style='font-family:Arial;mso-ansi-language:
EN-GB'>FileName</span><b><span lang=EN-GB style='font-size:11.0pt;mso-bidi-font-size:
12.0pt;font-family:"Courier New";mso-ansi-language:EN-GB'><o:p></o:p></span></b></p>
</td>
<td width=613 valign=top style='width:459.45pt;padding:0cm 3.5pt 0cm 3.5pt'>
<p class=MsoNormal><span lang=EN-GB style='font-family:Arial;mso-ansi-language:
EN-GB'>: Name for Xls file; default to <b>ABG.xls</b></span><b><span
lang=EN-GB style='font-size:11.0pt;mso-bidi-font-size:12.0pt;font-family:
"Courier New";mso-ansi-language:EN-GB'><o:p></o:p></span></b></p>
</td>
</tr>
</table>
<h1><span lang=EN-GB style='mso-ansi-language:EN-GB'>Methods<o:p></o:p></span></h1>
<h2><span lang=EN-GB style='mso-ansi-language:EN-GB'>Public __construct<o:p></o:p></span></h2>
<h3><span lang=EN-GB style='mso-ansi-language:EN-GB'>Description and signature<o:p></o:p></span></h3>
<p class=MsoNormal style='margin-left:27.0pt'><span lang=EN-GB
style='font-family:Arial;mso-ansi-language:EN-GB'>Initialize class & set
properties<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:27.0pt'><i><span lang=EN-GB
style='font-family:Arial;mso-ansi-language:EN-GB'>object</span></i><span
lang=EN-GB style='font-family:Arial;mso-ansi-language:EN-GB'> function
__construct(<i>array</i> PhpArray, <i>str</i> XlsDir, FileName, <i>bool</i>
PrtMsg)<o:p></o:p></span></p>
<h3><span lang=EN-GB style='mso-ansi-language:EN-GB'>Parameters<o:p></o:p></span></h3>
<table border=0 cellspacing=0 cellpadding=0 style='margin-left:17.6pt;
border-collapse:collapse;mso-padding-alt:0cm 3.5pt 0cm 3.5pt'>
<tr>
<td width=95 valign=top style='width:71.6pt;padding:0cm 3.5pt 0cm 3.5pt'>
<p class=MsoNormal><span lang=EN-GB style='font-family:Arial;mso-ansi-language:
EN-GB'>PhpArray</span><b><span lang=EN-GB style='font-size:11.0pt;mso-bidi-font-size:
12.0pt;font-family:"Courier New";mso-ansi-language:EN-GB'><o:p></o:p></span></b></p>
</td>
<td width=613 valign=top style='width:459.45pt;padding:0cm 3.5pt 0cm 3.5pt'>
<p class=MsoNormal><span lang=EN-GB style='font-family:Arial;mso-ansi-language:
EN-GB'>: Source array for Xls data; default to <b>null</b></span><b><span
lang=EN-GB style='font-size:11.0pt;mso-bidi-font-size:12.0pt;font-family:
"Courier New";mso-ansi-language:EN-GB'><o:p></o:p></span></b></p>
</td>
</tr>
<tr>
<td width=95 valign=top style='width:71.6pt;padding:0cm 3.5pt 0cm 3.5pt'>
<p class=MsoNormal><span lang=EN-GB style='font-family:Arial;mso-ansi-language:
EN-GB'>XlsDir</span><b><span lang=EN-GB style='font-size:11.0pt;mso-bidi-font-size:
12.0pt;font-family:"Courier New";mso-ansi-language:EN-GB'><o:p></o:p></span></b></p>
</td>
<td width=613 valign=top style='width:459.45pt;padding:0cm 3.5pt 0cm 3.5pt'>
<p class=MsoNormal><span lang=EN-GB style='font-family:Arial;mso-ansi-language:
EN-GB'>: Output directory for Xls file; default to <b>null</b></span><b><span
lang=EN-GB style='font-size:11.0pt;mso-bidi-font-size:12.0pt;font-family:
"Courier New";mso-ansi-language:EN-GB'><o:p></o:p></span></b></p>
</td>
</tr>
<tr>
<td width=95 valign=top style='width:71.6pt;padding:0cm 3.5pt 0cm 3.5pt'>
<p class=MsoNormal><span lang=EN-GB style='font-family:Arial;mso-ansi-language:
EN-GB'>FileName</span><b><span lang=EN-GB style='font-size:11.0pt;mso-bidi-font-size:
12.0pt;font-family:"Courier New";mso-ansi-language:EN-GB'><o:p></o:p></span></b></p>
</td>
<td width=613 valign=top style='width:459.45pt;padding:0cm 3.5pt 0cm 3.5pt'>
<p class=MsoNormal><span lang=EN-GB style='font-family:Arial;mso-ansi-language:
EN-GB'>: Name for Xls file; default to <b>null</b></span><b><span lang=EN-GB
style='font-size:11.0pt;mso-bidi-font-size:12.0pt;font-family:"Courier New";
mso-ansi-language:EN-GB'><o:p></o:p></span></b></p>
</td>
</tr>
<tr>
<td width=95 valign=top style='width:71.6pt;padding:0cm 3.5pt 0cm 3.5pt'>
<p class=MsoNormal><span lang=EN-GB style='font-family:Arial;mso-ansi-language:
EN-GB'>PrtMsg</span><b><span lang=EN-GB style='font-size:11.0pt;mso-bidi-font-size:
12.0pt;font-family:"Courier New";mso-ansi-language:EN-GB'><o:p></o:p></span></b></p>
</td>
<td width=613 valign=top style='width:459.45pt;padding:0cm 3.5pt 0cm 3.5pt'>
<p class=MsoNormal><span lang=EN-GB style='font-family:Arial;mso-ansi-language:
EN-GB'>: Validate printing exit message in SaveFile; default to false</span><b><span
lang=EN-GB style='font-size:11.0pt;mso-bidi-font-size:12.0pt;font-family:
"Courier New";mso-ansi-language:EN-GB'><o:p></o:p></span></b></p>
</td>
</tr>
<tr>
<td width=95 valign=top style='width:71.6pt;padding:0cm 3.5pt 0cm 3.5pt'>
<h4><span lang=EN-GB>RETURN</span><span lang=EN-GB style='font-size:11.0pt;
mso-bidi-font-size:12.0pt;font-family:"Courier New"'><o:p></o:p></span></h4>
</td>
<td width=613 valign=top style='width:459.45pt;padding:0cm 3.5pt 0cm 3.5pt'>
<p class=MsoNormal><span lang=EN-GB style='font-family:Arial;mso-ansi-language:
EN-GB'>: ABG_PhpToXls object </span><b><span lang=EN-GB style='font-size:
11.0pt;mso-bidi-font-size:12.0pt;font-family:"Courier New";mso-ansi-language:
EN-GB'><o:p></o:p></span></b></p>
</td>
</tr>
</table>
<h2><span lang=EN-GB style='mso-ansi-language:EN-GB'>Public BuildXls<o:p></o:p></span></h2>
<h3><span lang=EN-GB style='mso-ansi-language:EN-GB'>Description and signature<o:p></o:p></span></h3>
<p class=MsoNormal style='margin-left:27.0pt'><span lang=EN-GB
style='font-family:Arial;mso-ansi-language:EN-GB'>Main loop on PhpArray to
build xls cells<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:27.0pt'><i><span lang=EN-GB
style='font-family:Arial;mso-ansi-language:EN-GB'>Str</span></i><span
lang=EN-GB style='font-family:Arial;mso-ansi-language:EN-GB'> function
BuildXls(<i>array</i> PhpArray)<o:p></o:p></span></p>
<h3><span lang=EN-GB style='mso-ansi-language:EN-GB'>Parameters<o:p></o:p></span></h3>
<table border=0 cellspacing=0 cellpadding=0 style='margin-left:17.6pt;
border-collapse:collapse;mso-padding-alt:0cm 3.5pt 0cm 3.5pt'>
<tr>
<td width=95 valign=top style='width:71.6pt;padding:0cm 3.5pt 0cm 3.5pt'>
<p class=MsoNormal><span lang=EN-GB style='font-family:Arial;mso-ansi-language:
EN-GB'>PhpArray</span><b><span lang=EN-GB style='font-size:11.0pt;mso-bidi-font-size:
12.0pt;font-family:"Courier New";mso-ansi-language:EN-GB'><o:p></o:p></span></b></p>
</td>
<td width=613 valign=top style='width:459.45pt;padding:0cm 3.5pt 0cm 3.5pt'>
<p class=MsoNormal><span lang=EN-GB style='font-family:Arial;mso-ansi-language:
EN-GB'>: Optional; array to parse</span><b><span lang=EN-GB style='font-size:
11.0pt;mso-bidi-font-size:12.0pt;font-family:"Courier New";mso-ansi-language:
EN-GB'><o:p></o:p></span></b></p>
</td>
</tr>
<tr>
<td width=95 valign=top style='width:71.6pt;padding:0cm 3.5pt 0cm 3.5pt'>
<h4><span lang=EN-GB>RETURN</span><span lang=EN-GB style='font-size:11.0pt;
mso-bidi-font-size:12.0pt;font-family:"Courier New"'><o:p></o:p></span></h4>
</td>
<td width=613 valign=top style='width:459.45pt;padding:0cm 3.5pt 0cm 3.5pt'>
<p class=MsoNormal><span lang=EN-GB style='font-family:Arial;mso-ansi-language:
EN-GB'>: Xls data (also in XlsData attribute)</span><b><span lang=EN-GB
style='font-size:11.0pt;mso-bidi-font-size:12.0pt;font-family:"Courier New";
mso-ansi-language:EN-GB'><o:p></o:p></span></b></p>
</td>
</tr>
</table>
<h2><span lang=EN-GB style='mso-ansi-language:EN-GB'>Public SaveFile<o:p></o:p></span></h2>
<h3><span lang=EN-GB style='mso-ansi-language:EN-GB'>Description and signature<o:p></o:p></span></h3>
<p class=MsoNormal style='margin-left:27.0pt'><span lang=EN-GB
style='font-family:Arial;mso-ansi-language:EN-GB'>Utility to write xls file to
disk<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:27.0pt'><i><span lang=EN-GB
style='font-family:Arial;mso-ansi-language:EN-GB'>void</span></i><span
lang=EN-GB style='font-family:Arial;mso-ansi-language:EN-GB'> function
SaveFile()<o:p></o:p></span></p>
<h2><span lang=EN-GB style='mso-ansi-language:EN-GB'>Public SendFile<o:p></o:p></span></h2>
<h3><span lang=EN-GB style='mso-ansi-language:EN-GB'>Description and signature<o:p></o:p></span></h3>
<p class=MsoNormal style='margin-left:27.0pt'><span lang=EN-GB
style='font-family:Arial;mso-ansi-language:EN-GB'>Utility to send (HTTP) xls
data to caller<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:27.0pt'><i><span lang=EN-GB
style='font-family:Arial;mso-ansi-language:EN-GB'>Void</span></i><span
lang=EN-GB style='font-family:Arial;mso-ansi-language:EN-GB'> function
SendFile()<o:p></o:p></span></p>
<h2><span lang=EN-GB style='mso-ansi-language:EN-GB'>Static Public ExceptPrint<o:p></o:p></span></h2>
<h3><span lang=EN-GB style='mso-ansi-language:EN-GB'>Description and signature<o:p></o:p></span></h3>
<p class=MsoNormal style='margin-left:27.0pt'><span lang=EN-GB
style='font-family:Arial;mso-ansi-language:EN-GB'>Utility to print error
message from exceptions<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:27.0pt'><i><span lang=EN-GB
style='font-family:Arial;mso-ansi-language:EN-GB'>Void</span></i><span
lang=EN-GB style='font-family:Arial;mso-ansi-language:EN-GB'> function </span><span
lang=EN-GB style='mso-bidi-font-size:14.0pt;font-family:Arial;mso-ansi-language:
EN-GB'>ExceptPrint</span><span lang=EN-GB style='font-family:Arial;mso-ansi-language:
EN-GB'> (<i>Exception</i> Except)<o:p></o:p></span></p>
<h3><span lang=EN-GB style='mso-ansi-language:EN-GB'>Parameters<o:p></o:p></span></h3>
<table border=0 cellspacing=0 cellpadding=0 style='margin-left:17.6pt;
border-collapse:collapse;mso-padding-alt:0cm 3.5pt 0cm 3.5pt'>
<tr>
<td width=95 valign=top style='width:71.6pt;padding:0cm 3.5pt 0cm 3.5pt'>
<p class=MsoNormal><span lang=EN-GB style='font-family:Arial;mso-ansi-language:
EN-GB'>Except</span><b><span lang=EN-GB style='font-size:11.0pt;mso-bidi-font-size:
12.0pt;font-family:"Courier New";mso-ansi-language:EN-GB'><o:p></o:p></span></b></p>
</td>
<td width=613 valign=top style='width:459.45pt;padding:0cm 3.5pt 0cm 3.5pt'>
<p class=MsoNormal><span lang=EN-GB style='font-family:Arial;mso-ansi-language:
EN-GB'>: Exception object generated </span><b><span lang=EN-GB
style='font-size:11.0pt;mso-bidi-font-size:12.0pt;font-family:"Courier New";
mso-ansi-language:EN-GB'><o:p></o:p></span></b></p>
</td>
</tr>
</table>
<p class=MsoNormal style='margin-left:27.0pt'><span lang=EN-GB
style='font-family:Arial;mso-ansi-language:EN-GB'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></p>
<h1><span lang=EN-GB style='mso-ansi-language:EN-GB'>Exceptions<o:p></o:p></span></h1>
<p class=MsoNormal style='margin-left:9.05pt'><span lang=EN-GB
style='font-family:Arial;mso-ansi-language:EN-GB'>Exceptions are raised during
execution on faulty situations.<o:p></o:p></span></p>
<p class=MsoNormal style='margin-top:0cm;margin-right:0cm;margin-bottom:6.0pt;
margin-left:9.05pt'><span lang=EN-GB style='font-family:Arial;mso-ansi-language:
EN-GB'>It is advisable to embed the class utilization into a try/catch
structure like in the following code.<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:18.0pt;mso-layout-grid-align:none;
text-autospace:none'><b><span lang=EN-GB style='font-size:11.0pt;mso-bidi-font-size:
10.0pt;font-family:"Courier New";color:navy;mso-ansi-language:EN-GB'>try</span></b><b><span
lang=EN-GB style='font-size:11.0pt;mso-bidi-font-size:10.0pt;font-family:"Courier New";
color:black;mso-ansi-language:EN-GB'>{</span></b><b><span lang=EN-GB
style='font-size:11.0pt;mso-bidi-font-size:10.0pt;font-family:"Courier New";
mso-ansi-language:EN-GB'><o:p></o:p></span></b></p>
<p class=MsoNormal style='margin-left:18.0pt;mso-layout-grid-align:none;
text-autospace:none'><b><span lang=EN-GB style='font-size:11.0pt;mso-bidi-font-size:
10.0pt;font-family:"Courier New";color:black;mso-ansi-language:EN-GB'><span
style="mso-spacerun: yes"> </span>$PhpToXls = new ABG_PhpToXls($TestArray,
null, 'Sample', true);<o:p></o:p></span></b></p>
<p class=MsoNormal style='margin-left:18.0pt;mso-layout-grid-align:none;
text-autospace:none'><b><i><span lang=EN-GB style='font-size:11.0pt;mso-bidi-font-size:
10.0pt;font-family:"Courier New";color:black;mso-ansi-language:EN-GB'>//<span
style="mso-spacerun: yes"> </span>$PhpToXls->SendFile();</span></i></b><b><span
lang=EN-GB style='font-size:11.0pt;mso-bidi-font-size:10.0pt;font-family:"Courier New";
color:black;mso-ansi-language:EN-GB'><o:p></o:p></span></b></p>
<p class=MsoNormal style='margin-left:18.0pt;mso-layout-grid-align:none;
text-autospace:none'><b><span lang=EN-GB style='font-size:11.0pt;mso-bidi-font-size:
10.0pt;font-family:"Courier New";color:black;mso-ansi-language:EN-GB'><span
style="mso-spacerun: yes"> </span>$PhpToXls->SaveFile();<o:p></o:p></span></b></p>
<p class=MsoNormal style='margin-left:18.0pt;mso-layout-grid-align:none;
text-autospace:none'><b><span lang=EN-GB style='font-size:11.0pt;mso-bidi-font-size:
10.0pt;font-family:"Courier New";color:black;mso-ansi-language:EN-GB'>}<o:p></o:p></span></b></p>
<p class=MsoNormal style='margin-left:18.0pt;mso-layout-grid-align:none;
text-autospace:none'><b><span lang=EN-GB style='font-size:11.0pt;mso-bidi-font-size:
10.0pt;font-family:"Courier New";color:black;mso-ansi-language:EN-GB'>catch(Exception
$Except){<o:p></o:p></span></b></p>
<p class=MsoNormal style='margin-left:18.0pt;mso-layout-grid-align:none;
text-autospace:none'><b><span lang=EN-GB style='font-size:11.0pt;mso-bidi-font-size:
10.0pt;font-family:"Courier New";color:black;mso-ansi-language:EN-GB'><span
style="mso-spacerun: yes"> </span>ABG_PhpToXls::ExceptPrint($Except);<o:p></o:p></span></b></p>
<p class=MsoNormal style='margin-left:18.0pt;mso-layout-grid-align:none;
text-autospace:none'><b><span lang=EN-GB style='font-size:11.0pt;mso-bidi-font-size:
10.0pt;font-family:"Courier New";color:black;mso-ansi-language:EN-GB'>}<o:p></o:p></span></b></p>
<p class=MsoNormal style='margin-left:9.05pt'><span lang=EN-GB
style='font-family:Arial;mso-ansi-language:EN-GB'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:9.05pt'><span lang=EN-GB
style='font-family:Arial;mso-ansi-language:EN-GB'>This code will generate an
Excel file (<b>sample.xls</b>) from the <b>TestArray</b>, in the directory of
the script.<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:9.05pt'><span lang=EN-GB
style='font-family:Arial;mso-ansi-language:EN-GB'>Alternatively, invoking <b>SendFile()</b>
method will generate a Open/Download dialog in the user browser.<o:p></o:p></span></p>
<p class=MsoNormal style='margin-top:0cm;margin-right:0cm;margin-bottom:6.0pt;
margin-left:9.05pt'><span lang=EN-GB style='font-family:Arial;mso-ansi-language:
EN-GB'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></p>
<table border=1 cellspacing=0 cellpadding=0 style='margin-left:17.6pt;
border-collapse:collapse;border:none;mso-border-alt:solid windowtext .5pt;
mso-padding-alt:0cm 3.5pt 0cm 3.5pt'>
<tr>
<td width=156 valign=top style='width:117.05pt;border:solid windowtext .5pt;
border-bottom:double windowtext 1.5pt;padding:0cm 3.5pt 0cm 3.5pt'>
<h4><span style='mso-ansi-language:FR'>Source</span><span style='font-size:
11.0pt;mso-bidi-font-size:12.0pt;mso-ansi-language:FR'><o:p></o:p></span></h4>
</td>
<td width=204 valign=top style='width:153.0pt;border-top:solid windowtext .5pt;
border-left:none;border-bottom:double windowtext 1.5pt;border-right:solid windowtext .5pt;
mso-border-left-alt:solid windowtext .5pt;padding:0cm 3.5pt 0cm 3.5pt'>
<p class=MsoNormal><b><span style='font-family:Arial'>Message<o:p></o:p></span></b></p>
</td>
<td width=348 valign=top style='width:261.0pt;border-top:solid windowtext .5pt;
border-left:none;border-bottom:double windowtext 1.5pt;border-right:solid windowtext .5pt;
mso-border-left-alt:solid windowtext .5pt;padding:0cm 3.5pt 0cm 3.5pt'>
<p class=MsoNormal><b><span style='font-family:Arial'>Comment<o:p></o:p></span></b></p>
</td>
<![if !supportMisalignedRows]>
<td style='border:none' width=0><p class='MsoNormal'> </td>
<![endif]>
</tr>
<tr>
<td width=156 valign=top style='width:117.05pt;border:solid windowtext .5pt;
border-top:none;mso-border-top-alt:double windowtext 1.5pt;padding:0cm 3.5pt 0cm 3.5pt'>
<p class=MsoNormal><span style='font-family:Arial'>__Get()<o:p></o:p></span></p>
</td>
<td width=204 valign=top style='width:153.0pt;border-top:none;border-left:
none;border-bottom:solid windowtext .5pt;border-right:solid windowtext .5pt;
mso-border-top-alt:double windowtext 1.5pt;mso-border-left-alt:solid windowtext .5pt;
padding:0cm 3.5pt 0cm 3.5pt'>
<p class=MsoNormal><span lang=EN-GB style='font-family:Arial;mso-ansi-language:
EN-GB'>Unknown GET attribute<o:p></o:p></span></p>
</td>
<td width=348 rowspan=2 valign=top style='width:261.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext .5pt;border-right:solid windowtext .5pt;
mso-border-top-alt:double windowtext 1.5pt;mso-border-left-alt:solid windowtext .5pt;
padding:0cm 3.5pt 0cm 3.5pt'>
<p class=MsoHeader style='margin-top:6.0pt;tab-stops:35.4pt'><span
lang=EN-GB style='font-family:Arial;mso-ansi-language:EN-GB'>Specified
attribute is not a property<o:p></o:p></span></p>
</td>
<![if !supportMisalignedRows]>
<td style='border:none' width=0><p class='MsoNormal'> </td>
<![endif]>
</tr>
<tr>
<td width=156 valign=top style='width:117.05pt;border:solid windowtext .5pt;
border-top:none;mso-border-top-alt:solid windowtext .5pt;padding:0cm 3.5pt 0cm 3.5pt'>
<p class=MsoNormal><span style='font-family:Arial'>__Set()<o:p></o:p></span></p>
</td>
<td width=204 valign=top style='width:153.0pt;border-top:none;border-left:
none;border-bottom:solid windowtext .5pt;border-right:solid windowtext .5pt;
mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
padding:0cm 3.5pt 0cm 3.5pt'>
<p class=MsoNormal><span style='font-family:Arial'>Unknown SET attribute<o:p></o:p></span></p>
</td>
<span style='font-size:12.0pt;font-family:Arial;mso-fareast-font-family:"Times New Roman";
mso-ansi-language:FR;mso-fareast-language:FR;mso-bidi-language:AR-SA'><![if !supportMisalignedRows]>
<td style='border:none' width=0><p class='MsoNormal'> </td>
<![endif]></span>
</tr>
<tr>
<td width=156 valign=top style='width:117.05pt;border:solid windowtext .5pt;
border-top:none;mso-border-top-alt:solid windowtext .5pt;padding:0cm 3.5pt 0cm 3.5pt'>
<p class=MsoNormal><span style='font-family:Arial'>__Set(</span><span
lang=EN-GB style='font-family:Arial;mso-ansi-language:EN-GB'>XlsDir,
</span><span
style='font-family:Arial'>)<o:p></o:p></span></p>
</td>
<td width=204 valign=top style='width:153.0pt;border-top:none;border-left:
none;border-bottom:solid windowtext .5pt;border-right:solid windowtext .5pt;
mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
padding:0cm 3.5pt 0cm 3.5pt'>
<p class=MsoNormal><span style='font-family:Arial'>Unable to create directory<o:p></o:p></span></p>
</td>
<td width=348 valign=top style='width:261.0pt;border-top:none;border-left:
none;border-bottom:solid windowtext .5pt;border-right:solid windowtext .5pt;
mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
padding:0cm 3.5pt 0cm 3.5pt'>
<p class=MsoNormal><span lang=EN-GB style='font-family:Arial;mso-ansi-language:
EN-GB'>Failure while buiding <b>XlsDir</b> directory<o:p></o:p></span></p>
</td>
<![if !supportMisalignedRows]>
<td style='border:none' width=0><p class='MsoNormal'> </td>
<![endif]>
</tr>
<tr>
<td width=156 valign=top style='width:117.05pt;border:solid windowtext .5pt;
border-top:none;mso-border-top-alt:solid windowtext .5pt;padding:0cm 3.5pt 0cm 3.5pt'>
<p class=MsoNormal><span lang=EN-GB style='font-family:Arial;mso-ansi-language:
EN-GB'>__Set(FileName, ...)<o:p></o:p></span></p>
</td>
<td width=204 valign=top style='width:153.0pt;border-top:none;border-left:
none;border-bottom:solid windowtext .5pt;border-right:solid windowtext .5pt;
mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
padding:0cm 3.5pt 0cm 3.5pt'>
<p class=MsoNormal><span lang=EN-GB style='font-family:Arial;mso-ansi-language:
EN-GB'>Invalid Xls file name<o:p></o:p></span></p>
</td>
<td width=348 valign=top style='width:261.0pt;border-top:none;border-left:
none;border-bottom:solid windowtext .5pt;border-right:solid windowtext .5pt;
mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
padding:0cm 3.5pt 0cm 3.5pt'>
<p class=MsoNormal><span lang=EN-GB style='font-family:Arial;mso-ansi-language:
EN-GB'>ill formatted name<o:p></o:p></span></p>
</td>
<![if !supportMisalignedRows]>
<td style='border:none' width=0><p class='MsoNormal'> </td>
<![endif]>
</tr>
<tr>
<td width=156 rowspan=2 valign=top style='width:117.05pt;border:solid windowtext .5pt;
border-top:none;mso-border-top-alt:solid windowtext .5pt;padding:0cm 3.5pt 0cm 3.5pt'>
<p class=MsoHeader style='margin-top:6.0pt;tab-stops:35.4pt'><span
style='font-family:Arial'>SaveFile()</span><span lang=EN-GB style='font-family:
Arial;mso-ansi-language:EN-GB'><o:p></o:p></span></p>
</td>
<td width=204 valign=top style='width:153.0pt;border-top:none;border-left:
none;border-bottom:solid windowtext .5pt;border-right:solid windowtext .5pt;
mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
padding:0cm 3.5pt 0cm 3.5pt'>
<p class=MsoNormal><span lang=EN-GB style='font-family:Arial;mso-ansi-language:
EN-GB'>Unable to open Xls file<o:p></o:p></span></p>
</td>
<td width=348 valign=top style='width:261.0pt;border-top:none;border-left:
none;border-bottom:solid windowtext .5pt;border-right:solid windowtext .5pt;
mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
padding:0cm 3.5pt 0cm 3.5pt'>
<p class=MsoNormal><span lang=EN-GB style='font-family:Arial;mso-ansi-language:
EN-GB'>Failure while opening Xls file for writing<o:p></o:p></span></p>
</td>
<![if !supportMisalignedRows]>
<td style='border:none' width=0><p class='MsoNormal'> </td>
<![endif]>
</tr>
<tr style='height:13.8pt'>
<td width=204 rowspan=2 valign=top style='width:153.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext .5pt;border-right:solid windowtext .5pt;
mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
padding:0cm 3.5pt 0cm 3.5pt;height:13.8pt'>
<p class=MsoHeader style='margin-top:6.0pt;tab-stops:35.4pt'><span
lang=EN-GB style='font-family:Arial;mso-ansi-language:EN-GB'>Xls </span><span
style='font-family:Arial'>data</span><span lang=EN-GB style='font-family:
Arial;mso-ansi-language:EN-GB'> not available<o:p></o:p></span></p>
</td>
<td width=348 rowspan=2 valign=top style='width:261.0pt;border-top:none;
border-left:none;border-bottom:solid windowtext .5pt;border-right:solid windowtext .5pt;
mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
padding:0cm 3.5pt 0cm 3.5pt;height:13.8pt'>
<p class=MsoHeader style='margin-top:6.0pt;tab-stops:35.4pt'><span
style='font-family:Arial'>Assignement</span><span lang=EN-GB
style='font-family:Arial;mso-ansi-language:EN-GB'> of PhpArray property never
made<o:p></o:p></span></p>
</td>
<![if !supportMisalignedRows]>
<td style='height:13.8pt;border:none' width=0 height=18></td>
<![endif]>
</tr>
<tr>
<td width=156 valign=top style='width:117.05pt;border:solid windowtext .5pt;
border-top:none;mso-border-top-alt:solid windowtext .5pt;padding:0cm 3.5pt 0cm 3.5pt'>
<p class=MsoNormal><span style='font-family:Arial'>SendFile()</span><span
lang=EN-GB style='font-family:Arial;mso-ansi-language:EN-GB'><o:p></o:p></span></p>
</td>
<span lang=EN-GB style='font-size:12.0pt;font-family:Arial;mso-fareast-font-family:
"Times New Roman";mso-ansi-language:EN-GB;mso-fareast-language:FR;mso-bidi-language:
AR-SA'><![if !supportMisalignedRows]>
<td style='border:none' width=0><p class='MsoNormal'> </td>
<![endif]></span>
</tr>
<tr>
<td width=156 valign=top style='width:117.05pt;border:solid windowtext .5pt;
border-top:none;mso-border-top-alt:solid windowtext .5pt;padding:0cm 3.5pt 0cm 3.5pt'>
<p class=MsoNormal><span style='font-family:Arial'>BuildXl()s<o:p></o:p></span></p>
</td>
<td width=204 valign=top style='width:153.0pt;border-top:none;border-left:
none;border-bottom:solid windowtext .5pt;border-right:solid windowtext .5pt;
mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
padding:0cm 3.5pt 0cm 3.5pt'>
<p class=MsoNormal><span style='font-family:Arial'>Null PHP input array:<o:p></o:p></span></p>
</td>
<td width=348 valign=top style='width:261.0pt;border-top:none;border-left:
none;border-bottom:solid windowtext .5pt;border-right:solid windowtext .5pt;
mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
padding:0cm 3.5pt 0cm 3.5pt'>
<p class=MsoNormal><span lang=EN-GB style='font-family:Arial;mso-ansi-language:
EN-GB'>Source array is null<o:p></o:p></span></p>
</td>
<![if !supportMisalignedRows]>
<td style='border:none' width=0><p class='MsoNormal'> </td>
<![endif]>
</tr>
</table>
<p class=MsoHeader style='tab-stops:35.4pt'><span lang=EN-GB style='font-family:
Arial;mso-ansi-language:EN-GB'><span style="mso-spacerun: yes"> </span><o:p></o:p></span></p>
</div>
</body>
</html>