Location: PHPKode > scripts > ABG PHP To XLS > ABG_PhpToXls.htm
<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]>&nbsp;<![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]>&nbsp;<![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]>&nbsp;<![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]>&nbsp;<![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"'>&nbsp;&nbsp; </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"'>&nbsp;&nbsp; </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 &amp; 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]>&nbsp;<![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-&gt;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-&gt;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]>&nbsp;<![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]>&nbsp;<![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'>&nbsp;</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'>&nbsp;</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'>&nbsp;</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'>&nbsp;</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'>&nbsp;</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'>&nbsp;</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'>&nbsp;</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'>&nbsp;</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>
Return current item: ABG PHP To XLS