<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<title>The Vtiful\Kernel\Excel class</title>
</head>
<body><div class="manualnavbar" style="text-align: center;">
<div class="prev" style="text-align: left; float: left;"><a href="xlswriter.constants.html">Predefined Constants</a></div>
<div class="next" style="text-align: right; float: right;"><a href="vtiful-kernel-excel.addSheet.html">Vtiful\Kernel\Excel::addSheet</a></div>
<div class="up"><a href="book.xlswriter.html">XLSWriter</a></div>
<div class="home"><a href="index.html">PHP Manual</a></div>
</div><hr /><div id="class.vtiful-kernel-excel" class="reference">
<h1 class="title">The Vtiful\Kernel\Excel class</h1>
<div class="partintro"><p class="verinfo">(PHP 7 >= 7.0.0, PECL xlswriter >= 1.2.1)</p>
<div class="section" id="vtiful-kernel-excel.intro">
<h2 class="title">Introduction</h2>
<p class="para">
Create xlsx files and set cells and output xlsx files
</p>
</div>
<div class="section" id="vtiful-kernel-excel.synopsis">
<h2 class="title">Class synopsis</h2>
<div class="classsynopsis">
<div class="ooclass"></div>
<div class="classsynopsisinfo">
<span class="ooclass">
<strong class="classname">Vtiful\Kernel\Excel</strong>
</span>
{</div>
<div class="classsynopsisinfo classsynopsisinfo_comment">/* Methods */</div>
<div class="methodsynopsis dc-description">
<span class="modifier">public</span> <span class="methodname"><a href="vtiful-kernel-excel.addSheet.html" class="methodname">addSheet</a></span>
( <span class="methodparam"><span class="type">string</span> <code class="parameter">$sheetName</code></span>
)</div>
<div class="methodsynopsis dc-description">
<span class="modifier">public</span> <span class="methodname"><a href="vtiful-kernel-excel.autoFilter.html" class="methodname">autoFilter</a></span>
( <span class="methodparam"><span class="type">string</span> <code class="parameter">$scope</code></span>
)</div>
<div class="methodsynopsis dc-description">
<span class="modifier">public</span> <span class="methodname"><a href="vtiful-kernel-excel.constMemory.html" class="methodname">constMemory</a></span>
( <span class="methodparam"><span class="type">string</span> <code class="parameter">$fileName</code></span>
[, <span class="methodparam"><span class="type">string</span> <code class="parameter">$sheetName</code></span>
] )</div>
<div class="methodsynopsis dc-description">
<span class="modifier">public</span> <span class="methodname"><a href="vtiful-kernel-excel.construct.html" class="methodname">__construct</a></span>
( <span class="methodparam"><span class="type">array</span> <code class="parameter">$config</code></span>
)</div>
<div class="methodsynopsis dc-description">
<span class="modifier">public</span> <span class="methodname"><a href="vtiful-kernel-excel.data.html" class="methodname">data</a></span>
( <span class="methodparam"><span class="type">array</span> <code class="parameter">$data</code></span>
)</div>
<div class="methodsynopsis dc-description">
<span class="modifier">public</span> <span class="methodname"><a href="vtiful-kernel-excel.filename.html" class="methodname">fileName</a></span>
( <span class="methodparam"><span class="type">string</span> <code class="parameter">$fileName</code></span>
[, <span class="methodparam"><span class="type">string</span> <code class="parameter">$sheetName</code></span>
] )</div>
<div class="methodsynopsis dc-description">
<span class="modifier">public</span> <span class="methodname"><a href="vtiful-kernel-excel.getHandle.html" class="methodname">getHandle</a></span>
( <span class="methodparam">void</span>
)</div>
<div class="methodsynopsis dc-description">
<span class="modifier">public</span> <span class="methodname"><a href="vtiful-kernel-excel.header.html" class="methodname">header</a></span>
( <span class="methodparam"><span class="type">array</span> <code class="parameter">$headerData</code></span>
)</div>
<div class="methodsynopsis dc-description">
<span class="modifier">public</span> <span class="methodname"><a href="vtiful-kernel-excel.insertFormula.html" class="methodname">insertFormula</a></span>
( <span class="methodparam"><span class="type">int</span> <code class="parameter">$row</code></span>
, <span class="methodparam"><span class="type">int</span> <code class="parameter">$column</code></span>
, <span class="methodparam"><span class="type">string</span> <code class="parameter">$formula</code></span>
)</div>
<div class="methodsynopsis dc-description">
<span class="modifier">public</span> <span class="methodname"><a href="vtiful-kernel-excel.insertImage.html" class="methodname">insertImage</a></span>
( <span class="methodparam"><span class="type">int</span> <code class="parameter">$row</code></span>
, <span class="methodparam"><span class="type">int</span> <code class="parameter">$column</code></span>
, <span class="methodparam"><span class="type">string</span> <code class="parameter">$localImagePath</code></span>
)</div>
<div class="methodsynopsis dc-description">
<span class="modifier">public</span> <span class="methodname"><a href="vtiful-kernel-excel.insertText.html" class="methodname">insertText</a></span>
( <span class="methodparam"><span class="type">int</span> <code class="parameter">$row</code></span>
, <span class="methodparam"><span class="type">int</span> <code class="parameter">$column</code></span>
, <span class="methodparam"><span class="type">string</span><span class="type">int</span><span class="type">double</span> <code class="parameter">$data</code></span>
[, <span class="methodparam"><span class="type">string</span> <code class="parameter">$format</code></span>
] )</div>
<div class="methodsynopsis dc-description">
<span class="modifier">public</span> <span class="methodname"><a href="vtiful-kernel-excel.mergeCells.html" class="methodname">mergeCells</a></span>
( <span class="methodparam"><span class="type">string</span> <code class="parameter">$scope</code></span>
, <span class="methodparam"><span class="type">string</span> <code class="parameter">$data</code></span>
)</div>
<div class="methodsynopsis dc-description">
<span class="modifier">public</span> <span class="methodname"><a href="vtiful-kernel-excel.output.html" class="methodname">output</a></span>
( <span class="methodparam">void</span>
)</div>
<div class="methodsynopsis dc-description">
<span class="modifier">public</span> <span class="methodname"><a href="vtiful-kernel-excel.setColumn.html" class="methodname">setColumn</a></span>
( <span class="methodparam"><span class="type">string</span> <code class="parameter">$range</code></span>
, <span class="methodparam"><span class="type">float</span> <code class="parameter">$width</code></span>
[, <span class="methodparam"><span class="type">resource</span> <code class="parameter">$format</code></span>
] )</div>
<div class="methodsynopsis dc-description">
<span class="modifier">public</span> <span class="methodname"><a href="vtiful-kernel-excel.setRow.html" class="methodname">setRow</a></span>
( <span class="methodparam"><span class="type">string</span> <code class="parameter">$range</code></span>
, <span class="methodparam"><span class="type">float</span> <code class="parameter">$height</code></span>
[, <span class="methodparam"><span class="type">resource</span> <code class="parameter">$format</code></span>
] )</div>
}</div>
</div>
</div>
<h2>Table of Contents</h2><ul class="chunklist chunklist_reference"><li><a href="vtiful-kernel-excel.addSheet.html">Vtiful\Kernel\Excel::addSheet</a> — Vtiful\Kernel\Excel addSheet</li><li><a href="vtiful-kernel-excel.autoFilter.html">Vtiful\Kernel\Excel::autoFilter</a> — Vtiful\Kernel\Excel autoFilter</li><li><a href="vtiful-kernel-excel.constMemory.html">Vtiful\Kernel\Excel::constMemory</a> — Vtiful\Kernel\Excel constMemory</li><li><a href="vtiful-kernel-excel.construct.html">Vtiful\Kernel\Excel::__construct</a> — Vtiful\Kernel\Excel constructor</li><li><a href="vtiful-kernel-excel.data.html">Vtiful\Kernel\Excel::data</a> — Vtiful\Kernel\Excel data</li><li><a href="vtiful-kernel-excel.filename.html">Vtiful\Kernel\Excel::fileName</a> — Vtiful\Kernel\Excel fileName</li><li><a href="vtiful-kernel-excel.getHandle.html">Vtiful\Kernel\Excel::getHandle</a> — Vtiful\Kernel\Excel getHandle</li><li><a href="vtiful-kernel-excel.header.html">Vtiful\Kernel\Excel::header</a> — Vtiful\Kernel\Excel header</li><li><a href="vtiful-kernel-excel.insertFormula.html">Vtiful\Kernel\Excel::insertFormula</a> — Vtiful\Kernel\Excel insertFormula</li><li><a href="vtiful-kernel-excel.insertImage.html">Vtiful\Kernel\Excel::insertImage</a> — Vtiful\Kernel\Excel insertImage</li><li><a href="vtiful-kernel-excel.insertText.html">Vtiful\Kernel\Excel::insertText</a> — Vtiful\Kernel\Excel insertText</li><li><a href="vtiful-kernel-excel.mergeCells.html">Vtiful\Kernel\Excel::mergeCells</a> — Vtiful\Kernel\Excel mergeCells</li><li><a href="vtiful-kernel-excel.output.html">Vtiful\Kernel\Excel::output</a> — Vtiful\Kernel\Excel output</li><li><a href="vtiful-kernel-excel.setColumn.html">Vtiful\Kernel\Excel::setColumn</a> — Vtiful\Kernel\Excel setColumn</li><li><a href="vtiful-kernel-excel.setRow.html">Vtiful\Kernel\Excel::setRow</a> — Vtiful\Kernel\Excel setRow</li></ul>
</div>
<hr /><div class="manualnavbar" style="text-align: center;">
<div class="prev" style="text-align: left; float: left;"><a href="xlswriter.constants.html">Predefined Constants</a></div>
<div class="next" style="text-align: right; float: right;"><a href="vtiful-kernel-excel.addSheet.html">Vtiful\Kernel\Excel::addSheet</a></div>
<div class="up"><a href="book.xlswriter.html">XLSWriter</a></div>
<div class="home"><a href="index.html">PHP Manual</a></div>
</div></body></html>
