| Server IP : 195.130.67.5 / Your IP : 216.73.217.154 Web Server : Microsoft-IIS/10.0 System : Windows NT WEBSERVER1 10.0 build 17763 (Windows Server 2016) i586 User : IUSR ( 0) PHP Version : 7.4.19 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /inetpub/wwwroot/business/applynow_DONE/excel/Documentation/API/PHPExcel/ |
Upload File : |
<html>
<head>
<title>Docs For Class PHPExcel</title>
<link rel="stylesheet" type="text/css" href="../media/style.css">
</head>
<body>
<table border="0" cellspacing="0" cellpadding="0" height="48" width="100%">
<tr>
<td class="header_top">PHPExcel</td>
</tr>
<tr><td class="header_line"><img src="../media/empty.png" width="1" height="1" border="0" alt="" /></td></tr>
<tr>
<td class="header_menu">
[ <a href="../classtrees_PHPExcel.html" class="menu">class tree: PHPExcel</a> ]
[ <a href="../elementindex_PHPExcel.html" class="menu">index: PHPExcel</a> ]
[ <a href="../elementindex.html" class="menu">all elements</a> ]
</td>
</tr>
<tr><td class="header_line"><img src="../media/empty.png" width="1" height="1" border="0" alt="" /></td></tr>
</table>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr valign="top">
<td width="200" class="menu">
<div id="todolist">
<p><a href="../todolist.html">Todo List</a></p>
</div>
<b>Packages:</b><br />
<a href="../li_PHPExcel.html">PHPExcel</a><br />
<a href="../li_JAMA.html">JAMA</a><br />
<a href="../li_Math_Stats.html">Math_Stats</a><br />
<a href="../li_PHPExcel_CachedObjectStorage.html">PHPExcel_CachedObjectStorage</a><br />
<a href="../li_PHPExcel_Calculation.html">PHPExcel_Calculation</a><br />
<a href="../li_PHPExcel_Cell.html">PHPExcel_Cell</a><br />
<a href="../li_PHPExcel_Chart.html">PHPExcel_Chart</a><br />
<a href="../li_PHPExcel_Chart_Renderer.html">PHPExcel_Chart_Renderer</a><br />
<a href="../li_PHPExcel_Reader.html">PHPExcel_Reader</a><br />
<a href="../li_PHPExcel_Reader_Excel5.html">PHPExcel_Reader_Excel5</a><br />
<a href="../li_PHPExcel_Reader_Excel2007.html">PHPExcel_Reader_Excel2007</a><br />
<a href="../li_PHPExcel_RichText.html">PHPExcel_RichText</a><br />
<a href="../li_PHPExcel_Settings.html">PHPExcel_Settings</a><br />
<a href="../li_PHPExcel_Shared.html">PHPExcel_Shared</a><br />
<a href="../li_PHPExcel_Shared_Escher.html">PHPExcel_Shared_Escher</a><br />
<a href="../li_PHPExcel_Shared_OLE.html">PHPExcel_Shared_OLE</a><br />
<a href="../li_PHPExcel_Shared_Trend.html">PHPExcel_Shared_Trend</a><br />
<a href="../li_PHPExcel_Shared_ZipArchive.html">PHPExcel_Shared_ZipArchive</a><br />
<a href="../li_PHPExcel_Style.html">PHPExcel_Style</a><br />
<a href="../li_PHPExcel_Worksheet.html">PHPExcel_Worksheet</a><br />
<a href="../li_PHPExcel_Worksheet_Drawing.html">PHPExcel_Worksheet_Drawing</a><br />
<a href="../li_PHPExcel_Writer.html">PHPExcel_Writer</a><br />
<a href="../li_PHPExcel_Writer_Excel5.html">PHPExcel_Writer_Excel5</a><br />
<a href="../li_PHPExcel_Writer_Excel2007.html">PHPExcel_Writer_Excel2007</a><br />
<br /><br />
<b>Files:</b><br />
<div class="package">
<a href="../PHPExcel/_PHPExcel---Autoloader.php.html"> Autoloader.php
</a><br>
<a href="../PHPExcel/_PHPExcel---Comment.php.html"> Comment.php
</a><br>
<a href="../PHPExcel/_PHPExcel---DocumentProperties.php.html"> DocumentProperties.php
</a><br>
<a href="../PHPExcel/_PHPExcel---DocumentSecurity.php.html"> DocumentSecurity.php
</a><br>
<a href="../PHPExcel/_PHPExcel---Exception.php.html"> Exception.php
</a><br>
<a href="../PHPExcel/_PHPExcel---HashTable.php.html"> HashTable.php
</a><br>
<a href="../PHPExcel/_PHPExcel---IComparable.php.html"> IComparable.php
</a><br>
<a href="../PHPExcel/_PHPExcel---IOFactory.php.html"> IOFactory.php
</a><br>
<a href="../PHPExcel/_PHPExcel---Shared---JAMA---examples---LagrangeInterpolation.php.html"> LagrangeInterpolation.php
</a><br>
<a href="../PHPExcel/_PHPExcel---Shared---JAMA---examples---LagrangeInterpolation2.php.html"> LagrangeInterpolation2.php
</a><br>
<a href="../PHPExcel/_PHPExcel---Shared---JAMA---examples---LevenbergMarquardt.php.html"> LevenbergMarquardt.php
</a><br>
<a href="../PHPExcel/_PHPExcel---Shared---JAMA---examples---LMQuadTest.php.html"> LMQuadTest.php
</a><br>
<a href="../PHPExcel/_PHPExcel---NamedRange.php.html"> NamedRange.php
</a><br>
<a href="../PHPExcel/_PHPExcel---Shared---PCLZip---pclzip.lib.php.html"> pclzip.lib.php
</a><br>
<a href="../PHPExcel/_PHPExcel.php.html"> PHPExcel.php
</a><br>
<a href="../PHPExcel/_PHPExcel---Shared---JAMA---examples---polyfit.php.html"> polyfit.php
</a><br>
<a href="../PHPExcel/_PHPExcel---ReferenceHelper.php.html"> ReferenceHelper.php
</a><br>
<a href="../PHPExcel/_PHPExcel---Shared---JAMA---tests---TestMatrix.php.html"> TestMatrix.php
</a><br>
<a href="../PHPExcel/_PHPExcel---Shared---JAMA---examples---tile.php.html"> tile.php
</a><br>
<a href="../PHPExcel/_PHPExcel---WorksheetIterator.php.html"> WorksheetIterator.php
</a><br>
</div><br />
<b>Interfaces:</b><br />
<div class="package">
<a href="../PHPExcel/PHPExcel_IComparable.html">PHPExcel_IComparable</a><br />
</div>
<b>Classes:</b><br />
<div class="package">
<a href="../PHPExcel/LagrangeInterpolation.html">LagrangeInterpolation</a><br />
<a href="../PHPExcel/LevenbergMarquardt.html">LevenbergMarquardt</a><br />
<a href="../PHPExcel/LMQuadTest.html">LMQuadTest</a><br />
<a href="../PHPExcel/PclZip.html">PclZip</a><br />
<a href="../PHPExcel/PHPExcel.html">PHPExcel</a><br />
<a href="../PHPExcel/PHPExcel_Autoloader.html">PHPExcel_Autoloader</a><br />
<a href="../PHPExcel/PHPExcel_Comment.html">PHPExcel_Comment</a><br />
<a href="../PHPExcel/PHPExcel_DocumentProperties.html">PHPExcel_DocumentProperties</a><br />
<a href="../PHPExcel/PHPExcel_DocumentSecurity.html">PHPExcel_DocumentSecurity</a><br />
<a href="../PHPExcel/PHPExcel_Exception.html">PHPExcel_Exception</a><br />
<a href="../PHPExcel/PHPExcel_HashTable.html">PHPExcel_HashTable</a><br />
<a href="../PHPExcel/PHPExcel_IOFactory.html">PHPExcel_IOFactory</a><br />
<a href="../PHPExcel/PHPExcel_NamedRange.html">PHPExcel_NamedRange</a><br />
<a href="../PHPExcel/PHPExcel_ReferenceHelper.html">PHPExcel_ReferenceHelper</a><br />
<a href="../PHPExcel/PHPExcel_WorksheetIterator.html">PHPExcel_WorksheetIterator</a><br />
<a href="../PHPExcel/TestMatrix.html">TestMatrix</a><br />
</div>
</td>
<td>
<table cellpadding="10" cellspacing="0" width="100%" border="0"><tr><td valign="top">
<h1>Class: PHPExcel</h1>
Source Location: /PHPExcel.php<br /><br />
<table width="100%" border="0">
<tr><td valign="top">
<h3><a href="#class_details">Class Overview</a></h3>
<pre></pre><br />
<div class="description">PHPExcel</div><br /><br />
<h4>Author(s):</h4>
<ul>
</ul>
<h4>Copyright:</h4>
<ul>
<li>Copyright (c) 2006 - 2012 PHPExcel (http://www.codeplex.com/PHPExcel)</li>
</ul>
</td>
<td valign="top">
<h3><a href="#class_methods">Methods</a></h3>
<ul>
<li><a href="../PHPExcel/PHPExcel.html#method__construct">__construct</a></li>
<li><a href="../PHPExcel/PHPExcel.html#methodaddCellStyleXf">addCellStyleXf</a></li>
<li><a href="../PHPExcel/PHPExcel.html#methodaddCellXf">addCellXf</a></li>
<li><a href="../PHPExcel/PHPExcel.html#methodaddExternalSheet">addExternalSheet</a></li>
<li><a href="../PHPExcel/PHPExcel.html#methodaddNamedRange">addNamedRange</a></li>
<li><a href="../PHPExcel/PHPExcel.html#methodaddSheet">addSheet</a></li>
<li><a href="../PHPExcel/PHPExcel.html#methodcopy">copy</a></li>
<li><a href="../PHPExcel/PHPExcel.html#methodcreateSheet">createSheet</a></li>
<li><a href="../PHPExcel/PHPExcel.html#methoddisconnectWorksheets">disconnectWorksheets</a></li>
<li><a href="../PHPExcel/PHPExcel.html#methodgarbageCollect">garbageCollect</a></li>
<li><a href="../PHPExcel/PHPExcel.html#methodgetActiveSheet">getActiveSheet</a></li>
<li><a href="../PHPExcel/PHPExcel.html#methodgetActiveSheetIndex">getActiveSheetIndex</a></li>
<li><a href="../PHPExcel/PHPExcel.html#methodgetAllSheets">getAllSheets</a></li>
<li><a href="../PHPExcel/PHPExcel.html#methodgetCellStyleXfByHashCode">getCellStyleXfByHashCode</a></li>
<li><a href="../PHPExcel/PHPExcel.html#methodgetCellStyleXfByIndex">getCellStyleXfByIndex</a></li>
<li><a href="../PHPExcel/PHPExcel.html#methodgetCellStyleXfCollection">getCellStyleXfCollection</a></li>
<li><a href="../PHPExcel/PHPExcel.html#methodgetCellXfByHashCode">getCellXfByHashCode</a></li>
<li><a href="../PHPExcel/PHPExcel.html#methodgetCellXfByIndex">getCellXfByIndex</a></li>
<li><a href="../PHPExcel/PHPExcel.html#methodgetCellXfCollection">getCellXfCollection</a></li>
<li><a href="../PHPExcel/PHPExcel.html#methodgetCellXfSupervisor">getCellXfSupervisor</a></li>
<li><a href="../PHPExcel/PHPExcel.html#methodgetDefaultStyle">getDefaultStyle</a></li>
<li><a href="../PHPExcel/PHPExcel.html#methodgetIndex">getIndex</a></li>
<li><a href="../PHPExcel/PHPExcel.html#methodgetNamedRange">getNamedRange</a></li>
<li><a href="../PHPExcel/PHPExcel.html#methodgetNamedRanges">getNamedRanges</a></li>
<li><a href="../PHPExcel/PHPExcel.html#methodgetProperties">getProperties</a></li>
<li><a href="../PHPExcel/PHPExcel.html#methodgetSecurity">getSecurity</a></li>
<li><a href="../PHPExcel/PHPExcel.html#methodgetSheet">getSheet</a></li>
<li><a href="../PHPExcel/PHPExcel.html#methodgetSheetByName">getSheetByName</a></li>
<li><a href="../PHPExcel/PHPExcel.html#methodgetSheetCount">getSheetCount</a></li>
<li><a href="../PHPExcel/PHPExcel.html#methodgetSheetNames">getSheetNames</a></li>
<li><a href="../PHPExcel/PHPExcel.html#methodgetWorksheetIterator">getWorksheetIterator</a></li>
<li><a href="../PHPExcel/PHPExcel.html#methodremoveCellStyleXfByIndex">removeCellStyleXfByIndex</a></li>
<li><a href="../PHPExcel/PHPExcel.html#methodremoveCellXfByIndex">removeCellXfByIndex</a></li>
<li><a href="../PHPExcel/PHPExcel.html#methodremoveNamedRange">removeNamedRange</a></li>
<li><a href="../PHPExcel/PHPExcel.html#methodremoveSheetByIndex">removeSheetByIndex</a></li>
<li><a href="../PHPExcel/PHPExcel.html#methodsetActiveSheetIndex">setActiveSheetIndex</a></li>
<li><a href="../PHPExcel/PHPExcel.html#methodsetActiveSheetIndexByName">setActiveSheetIndexByName</a></li>
<li><a href="../PHPExcel/PHPExcel.html#methodsetIndexByName">setIndexByName</a></li>
<li><a href="../PHPExcel/PHPExcel.html#methodsetProperties">setProperties</a></li>
<li><a href="../PHPExcel/PHPExcel.html#methodsetSecurity">setSecurity</a></li>
<li><a href="../PHPExcel/PHPExcel.html#methodsheetNameExists">sheetNameExists</a></li>
<li><a href="../PHPExcel/PHPExcel.html#method__clone">__clone</a></li>
</ul>
</td>
</tr></table>
<hr />
<table width="100%" border="0"><tr>
</tr></table>
<hr />
<a name="class_details"></a>
<h3>Class Details</h3>
<div class="tags">
[line 43]<br />
PHPExcel<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>copyright:</b> </td><td>Copyright (c) 2006 - 2012 PHPExcel (http://www.codeplex.com/PHPExcel)</td>
</tr>
</table>
</div>
</div><br /><br />
<div class="top">[ <a href="#top">Top</a> ]</div><br />
<hr />
<a name="class_methods"></a>
<h3>Class Methods</h3>
<div class="tags">
<hr />
<a name="method__construct"></a>
<h3>constructor __construct <span class="smalllinenumber">[line 104]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>PHPExcel __construct(
)</code>
</td></tr></table>
</td></tr></table><br />
Create a new PHPExcel with one Worksheet<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodaddCellStyleXf"></a>
<h3>method addCellStyleXf <span class="smalllinenumber">[line 718]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>void addCellStyleXf(
PHPExcel_Style
$pStyle)</code>
</td></tr></table>
</td></tr></table><br />
Add a cellStyleXf to the workbook<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type"><a href="../PHPExcel_Style/PHPExcel_Style.html">PHPExcel_Style</a> </td>
<td><b>$pStyle</b> </td>
<td></td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodaddCellXf"></a>
<h3>method addCellXf <span class="smalllinenumber">[line 629]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>void addCellXf(
PHPExcel_Style
$style)</code>
</td></tr></table>
</td></tr></table><br />
Add a cellXf to the workbook<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type"><a href="../PHPExcel_Style/PHPExcel_Style.html">PHPExcel_Style</a> </td>
<td><b>$style</b> </td>
<td></td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodaddExternalSheet"></a>
<h3>method addExternalSheet <span class="smalllinenumber">[line 440]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> addExternalSheet(
PHPExcel_Worksheet
$pSheet, [int|null
$iSheetIndex = null])</code>
</td></tr></table>
</td></tr></table><br />
Add external sheet<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>throws:</b> </td><td>Exception</td>
</tr>
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type"><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> </td>
<td><b>$pSheet</b> </td>
<td>External sheet to add</td>
</tr>
<tr>
<td class="type">int|null </td>
<td><b>$iSheetIndex</b> </td>
<td>Index where sheet should go (0,1,..., or null for last)</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodaddNamedRange"></a>
<h3>method addNamedRange <span class="smalllinenumber">[line 480]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../PHPExcel/PHPExcel.html">PHPExcel</a> addNamedRange(
<a href="../PHPExcel/PHPExcel_NamedRange.html">PHPExcel_NamedRange</a>
$namedRange)</code>
</td></tr></table>
</td></tr></table><br />
Add named range<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type"><a href="../PHPExcel/PHPExcel_NamedRange.html">PHPExcel_NamedRange</a> </td>
<td><b>$namedRange</b> </td>
<td></td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodaddSheet"></a>
<h3>method addSheet <span class="smalllinenumber">[line 227]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> addSheet(
PHPExcel_Worksheet
$pSheet, [int|null
$iSheetIndex = NULL])</code>
</td></tr></table>
</td></tr></table><br />
Add sheet<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>throws:</b> </td><td>Exception</td>
</tr>
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type"><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> </td>
<td><b>$pSheet</b> </td>
<td></td>
</tr>
<tr>
<td class="type">int|null </td>
<td><b>$iSheetIndex</b> </td>
<td>Index where sheet should go (0,1,..., or null for last)</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodcopy"></a>
<h3>method copy <span class="smalllinenumber">[line 550]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../PHPExcel/PHPExcel.html">PHPExcel</a> copy(
)</code>
</td></tr></table>
</td></tr></table><br />
Copy workbook (!= clone!)<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodcreateSheet"></a>
<h3>method createSheet <span class="smalllinenumber">[line 201]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> createSheet(
[int|null
$iSheetIndex = NULL])</code>
</td></tr></table>
</td></tr></table><br />
Create sheet and add it to this workbook<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>throws:</b> </td><td>Exception</td>
</tr>
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">int|null </td>
<td><b>$iSheetIndex</b> </td>
<td>Index where sheet should go (0,1,..., or null for last)</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methoddisconnectWorksheets"></a>
<h3>method disconnectWorksheets <span class="smalllinenumber">[line 135]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>void disconnectWorksheets(
)</code>
</td></tr></table>
</td></tr></table><br />
Disconnect all worksheets from this PHPExcel workbook object,<br /><br /><p>typically so that the PHPExcel object can be unset</p><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodgarbageCollect"></a>
<h3>method garbageCollect <span class="smalllinenumber">[line 743]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>void garbageCollect(
)</code>
</td></tr></table>
</td></tr></table><br />
Eliminate all unneeded cellXf and afterwards update the xfIndex for all cells<br /><br /><p>and columns in the workbook</p><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodgetActiveSheet"></a>
<h3>method getActiveSheet <span class="smalllinenumber">[line 189]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> getActiveSheet(
)</code>
</td></tr></table>
</td></tr></table><br />
Get active sheet<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodgetActiveSheetIndex"></a>
<h3>method getActiveSheetIndex <span class="smalllinenumber">[line 377]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>int getActiveSheetIndex(
)</code>
</td></tr></table>
</td></tr></table><br />
Get active sheet index<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>return:</b> </td><td>Active sheet index</td>
</tr>
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodgetAllSheets"></a>
<h3>method getAllSheets <span class="smalllinenumber">[line 297]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>PHPExcel_Worksheet[] getAllSheets(
)</code>
</td></tr></table>
</td></tr></table><br />
Get all sheets<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodgetCellStyleXfByHashCode"></a>
<h3>method getCellStyleXfByHashCode <span class="smalllinenumber">[line 703]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../PHPExcel_Style/PHPExcel_Style.html">PHPExcel_Style</a>|false getCellStyleXfByHashCode(
[string
$pValue = ''])</code>
</td></tr></table>
</td></tr></table><br />
Get cellStyleXf by hash code<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">string </td>
<td><b>$pValue</b> </td>
<td></td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodgetCellStyleXfByIndex"></a>
<h3>method getCellStyleXfByIndex <span class="smalllinenumber">[line 692]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../PHPExcel_Style/PHPExcel_Style.html">PHPExcel_Style</a> getCellStyleXfByIndex(
[int
$pIndex = 0])</code>
</td></tr></table>
</td></tr></table><br />
Get cellStyleXf by index<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">int </td>
<td><b>$pIndex</b> </td>
<td></td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodgetCellStyleXfCollection"></a>
<h3>method getCellStyleXfCollection <span class="smalllinenumber">[line 681]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>PHPExcel_Style[] getCellStyleXfCollection(
)</code>
</td></tr></table>
</td></tr></table><br />
Get the workbook collection of cellStyleXfs<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodgetCellXfByHashCode"></a>
<h3>method getCellXfByHashCode <span class="smalllinenumber">[line 600]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../PHPExcel_Style/PHPExcel_Style.html">PHPExcel_Style</a>|false getCellXfByHashCode(
[string
$pValue = ''])</code>
</td></tr></table>
</td></tr></table><br />
Get cellXf by hash code<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">string </td>
<td><b>$pValue</b> </td>
<td></td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodgetCellXfByIndex"></a>
<h3>method getCellXfByIndex <span class="smalllinenumber">[line 589]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../PHPExcel_Style/PHPExcel_Style.html">PHPExcel_Style</a> getCellXfByIndex(
[int
$pIndex = 0])</code>
</td></tr></table>
</td></tr></table><br />
Get cellXf by index<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">int </td>
<td><b>$pIndex</b> </td>
<td></td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodgetCellXfCollection"></a>
<h3>method getCellXfCollection <span class="smalllinenumber">[line 578]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>PHPExcel_Style[] getCellXfCollection(
)</code>
</td></tr></table>
</td></tr></table><br />
Get the workbook collection of cellXfs<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodgetCellXfSupervisor"></a>
<h3>method getCellXfSupervisor <span class="smalllinenumber">[line 671]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../PHPExcel_Style/PHPExcel_Style.html">PHPExcel_Style</a> getCellXfSupervisor(
)</code>
</td></tr></table>
</td></tr></table><br />
Get the cellXf supervisor<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodgetDefaultStyle"></a>
<h3>method getDefaultStyle <span class="smalllinenumber">[line 616]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../PHPExcel_Style/PHPExcel_Style.html">PHPExcel_Style</a> getDefaultStyle(
)</code>
</td></tr></table>
</td></tr></table><br />
Get default style<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>throws:</b> </td><td>Exception</td>
</tr>
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodgetIndex"></a>
<h3>method getIndex <span class="smalllinenumber">[line 328]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>Sheet getIndex(
PHPExcel_Worksheet
$pSheet)</code>
</td></tr></table>
</td></tr></table><br />
Get index for sheet<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>return:</b> </td><td>index</td>
</tr>
<tr>
<td><b>throws:</b> </td><td>Exception</td>
</tr>
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type"><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> </td>
<td><b>$pSheet</b> </td>
<td></td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodgetNamedRange"></a>
<h3>method getNamedRange <span class="smalllinenumber">[line 498]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../PHPExcel/PHPExcel_NamedRange.html">PHPExcel_NamedRange</a>|null getNamedRange(
string
$namedRange, [PHPExcel_Worksheet
$pSheet = null])</code>
</td></tr></table>
</td></tr></table><br />
Get named range<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">string </td>
<td><b>$namedRange</b> </td>
<td></td>
</tr>
<tr>
<td class="type"><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a>|null </td>
<td><b>$pSheet</b> </td>
<td>Scope. Use null for global scope</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodgetNamedRanges"></a>
<h3>method getNamedRanges <span class="smalllinenumber">[line 470]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>PHPExcel_NamedRange[] getNamedRanges(
)</code>
</td></tr></table>
</td></tr></table><br />
Get named ranges<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodgetProperties"></a>
<h3>method getProperties <span class="smalllinenumber">[line 149]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../PHPExcel/PHPExcel_DocumentProperties.html">PHPExcel_DocumentProperties</a> getProperties(
)</code>
</td></tr></table>
</td></tr></table><br />
Get properties<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodgetSecurity"></a>
<h3>method getSecurity <span class="smalllinenumber">[line 169]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../PHPExcel/PHPExcel_DocumentSecurity.html">PHPExcel_DocumentSecurity</a> getSecurity(
)</code>
</td></tr></table>
</td></tr></table><br />
Get security<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodgetSheet"></a>
<h3>method getSheet <span class="smalllinenumber">[line 283]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> getSheet(
[int
$pIndex = 0])</code>
</td></tr></table>
</td></tr></table><br />
Get sheet by index<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>throws:</b> </td><td>Exception</td>
</tr>
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">int </td>
<td><b>$pIndex</b> </td>
<td>Sheet index</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodgetSheetByName"></a>
<h3>method getSheetByName <span class="smalllinenumber">[line 309]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> getSheetByName(
[string
$pName = ''])</code>
</td></tr></table>
</td></tr></table><br />
Get sheet by name<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>throws:</b> </td><td>Exception</td>
</tr>
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">string </td>
<td><b>$pName</b> </td>
<td>Sheet name</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodgetSheetCount"></a>
<h3>method getSheetCount <span class="smalllinenumber">[line 367]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>int getSheetCount(
)</code>
</td></tr></table>
</td></tr></table><br />
Get sheet count<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodgetSheetNames"></a>
<h3>method getSheetNames <span class="smalllinenumber">[line 421]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>string[] getSheetNames(
)</code>
</td></tr></table>
</td></tr></table><br />
Get sheet names<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodgetWorksheetIterator"></a>
<h3>method getWorksheetIterator <span class="smalllinenumber">[line 541]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../PHPExcel/PHPExcel_WorksheetIterator.html">PHPExcel_WorksheetIterator</a> getWorksheetIterator(
)</code>
</td></tr></table>
</td></tr></table><br />
Get worksheet iterator<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodremoveCellStyleXfByIndex"></a>
<h3>method removeCellStyleXfByIndex <span class="smalllinenumber">[line 730]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>void removeCellStyleXfByIndex(
[int
$pIndex = 0])</code>
</td></tr></table>
</td></tr></table><br />
Remove cellStyleXf by index<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>throws:</b> </td><td>Exception</td>
</tr>
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">int </td>
<td><b>$pIndex</b> </td>
<td></td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodremoveCellXfByIndex"></a>
<h3>method removeCellXfByIndex <span class="smalllinenumber">[line 641]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>void removeCellXfByIndex(
[int
$pIndex = 0])</code>
</td></tr></table>
</td></tr></table><br />
Remove cellXf by index. It is ensured that all cells get their xf index updated.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>throws:</b> </td><td>Exception</td>
</tr>
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">int </td>
<td><b>$pIndex</b> </td>
<td>Index to cellXf</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodremoveNamedRange"></a>
<h3>method removeNamedRange <span class="smalllinenumber">[line 523]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../PHPExcel/PHPExcel.html">PHPExcel</a> removeNamedRange(
string
$namedRange, [PHPExcel_Worksheet
$pSheet = null])</code>
</td></tr></table>
</td></tr></table><br />
Remove named range<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">string </td>
<td><b>$namedRange</b> </td>
<td></td>
</tr>
<tr>
<td class="type"><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a>|null </td>
<td><b>$pSheet</b> </td>
<td>Scope: use null for global scope.</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodremoveSheetByIndex"></a>
<h3>method removeSheetByIndex <span class="smalllinenumber">[line 261]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>void removeSheetByIndex(
[int
$pIndex = 0])</code>
</td></tr></table>
</td></tr></table><br />
Remove sheet by index<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>throws:</b> </td><td>Exception</td>
</tr>
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">int </td>
<td><b>$pIndex</b> </td>
<td>Active sheet index</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodsetActiveSheetIndex"></a>
<h3>method setActiveSheetIndex <span class="smalllinenumber">[line 389]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> setActiveSheetIndex(
[int
$pIndex = 0])</code>
</td></tr></table>
</td></tr></table><br />
Set active sheet index<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>throws:</b> </td><td>Exception</td>
</tr>
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">int </td>
<td><b>$pIndex</b> </td>
<td>Active sheet index</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodsetActiveSheetIndexByName"></a>
<h3>method setActiveSheetIndexByName <span class="smalllinenumber">[line 406]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> setActiveSheetIndexByName(
[string
$pValue = ''])</code>
</td></tr></table>
</td></tr></table><br />
Set active sheet index by name<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>throws:</b> </td><td>Exception</td>
</tr>
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">string </td>
<td><b>$pValue</b> </td>
<td>Sheet title</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodsetIndexByName"></a>
<h3>method setIndexByName <span class="smalllinenumber">[line 345]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>New setIndexByName(
string
$sheetName, int
$newIndex)</code>
</td></tr></table>
</td></tr></table><br />
Set index for sheet by sheet name.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>return:</b> </td><td>sheet index</td>
</tr>
<tr>
<td><b>throws:</b> </td><td>Exception</td>
</tr>
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">string </td>
<td><b>$sheetName</b> </td>
<td>Sheet name to modify index for</td>
</tr>
<tr>
<td class="type">int </td>
<td><b>$newIndex</b> </td>
<td>New index for the sheet</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodsetProperties"></a>
<h3>method setProperties <span class="smalllinenumber">[line 159]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>void setProperties(
<a href="../PHPExcel/PHPExcel_DocumentProperties.html">PHPExcel_DocumentProperties</a>
$pValue)</code>
</td></tr></table>
</td></tr></table><br />
Set properties<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type"><a href="../PHPExcel/PHPExcel_DocumentProperties.html">PHPExcel_DocumentProperties</a> </td>
<td><b>$pValue</b> </td>
<td></td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodsetSecurity"></a>
<h3>method setSecurity <span class="smalllinenumber">[line 179]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>void setSecurity(
<a href="../PHPExcel/PHPExcel_DocumentSecurity.html">PHPExcel_DocumentSecurity</a>
$pValue)</code>
</td></tr></table>
</td></tr></table><br />
Set security<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type"><a href="../PHPExcel/PHPExcel_DocumentSecurity.html">PHPExcel_DocumentSecurity</a> </td>
<td><b>$pValue</b> </td>
<td></td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="methodsheetNameExists"></a>
<h3>method sheetNameExists <span class="smalllinenumber">[line 214]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>boolean sheetNameExists(
string
$pSheetName)</code>
</td></tr></table>
</td></tr></table><br />
Chech if a sheet with a specified name already exists<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<h4>Parameters:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="type">string </td>
<td><b>$pSheetName</b> </td>
<td>Name of the worksheet to check</td>
</tr>
</table>
</div><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
<hr />
<a name="method__clone"></a>
<h3>method __clone <span class="smalllinenumber">[line 565]</span></h3>
<div class="function">
<table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
<table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
<code>void __clone(
)</code>
</td></tr></table>
</td></tr></table><br />
Implement PHP __clone to create a deep clone, not just a shallow copy.<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><b>access:</b> </td><td>public</td>
</tr>
</table>
</div>
<br /><br />
<div class="top">[ <a href="#top">Top</a> ]</div>
</div>
</div><br />
<div class="credit">
<hr />
Documentation generated on Fri, 12 Oct 2012 00:17:26 +0200 by <a href="http://www.phpdoc.org">phpDocumentor 1.4.4</a>
</div>
</td></tr></table>
</td>
</tr>
</table>
</body>
</html>