<div class="header-panel member">
<h2><span class="identifier">WorkSheet</span> Class</h2>
<dl class="dl-horizontal">
<dt>File</dt><dd class="filename">wijmo.xlsx.js</dd>
<dt>Module</dt><dd><a href="topic/wijmo.xlsx.Module.html"><span class="identifier">wijmo.xlsx</span></a></dd>
<dt>Implements</dt><dd><a href="topic/wijmo.xlsx.IWorkSheet.Interface.html"><span class="identifier">IWorkSheet</span></a></dd>
</dl>
<div class="comment"><p>Represents the Workbook Object Model sheet definition that includes sheet
properties and data.</p>
<p>The sheet cells are stored in row objects and are accessible using JavaScript
expressions like <b>sheet.rows[i].cells[j]</b>.</p></div>
</div>
<div class="member-panel class members" ng-class="{ 'show-inherited' : ctx.showInherited, 'show-raisers' : ctx.showRaisers }">
<h3 class="node">Constructor</h3>
<ul>
<li class="mmethod"><a href="topic/wijmo.xlsx.WorkSheet.Class.html/#constructor">constructor</a></li>
</ul>
<h3 class="node">Properties</h3>
<ul>
<li class="mproperty"><a href="topic/wijmo.xlsx.WorkSheet.Class.html/#columns">columns</a></li>
<li class="mproperty"><a href="topic/wijmo.xlsx.WorkSheet.Class.html/#frozenPane">frozenPane</a></li>
<li class="mproperty"><a href="topic/wijmo.xlsx.WorkSheet.Class.html/#name">name</a></li>
<li class="mproperty"><a href="topic/wijmo.xlsx.WorkSheet.Class.html/#rows">rows</a></li>
<li class="mproperty"><a href="topic/wijmo.xlsx.WorkSheet.Class.html/#style">style</a></li>
<li class="mproperty"><a href="topic/wijmo.xlsx.WorkSheet.Class.html/#summaryBelow">summaryBelow</a></li>
<li class="mproperty"><a href="topic/wijmo.xlsx.WorkSheet.Class.html/#tables">tables</a></li>
<li class="mproperty"><a href="topic/wijmo.xlsx.WorkSheet.Class.html/#visible">visible</a></li>
</ul>
</div>
<h3>Constructor</h3>
<div id="constructor" class="member-panel mmethod">
<h3>constructor</h3>
<pre>constructor(): <a href="topic/wijmo.xlsx.WorkSheet.Class.html"><span class="identifier">WorkSheet</span></a></pre>
<div class="comment"><p>Initializes a new instance of the <a href="topic/wijmo.xlsx.WorkSheet.Class.html"><span class="identifier">WorkSheet</span></a> class.</p></div>
<dl class="dl-horizontal">
  <dt>Returns</dt><dd><a href="topic/wijmo.xlsx.WorkSheet.Class.html"><span class="identifier">WorkSheet</span></a></dd>
</dl>
</div>
<h3 class="node">Properties</h3>
<div class="member-list" ng-class="{ 'show-inherited' : ctx.showInherited, 'show-raisers' : ctx.showRaisers }">
<div id="columns" class="member-panel mproperty">
<h3>columns</h3>
<div class="comment"><p>Gets or sets an array of sheet columns definitions.</p>
<p>Each <a href="topic/wijmo.xlsx.WorkbookColumn.Class.html"><span class="identifier">WorkbookColumn</span></a> object in the array describes a column
at the corresponding position in xlsx sheet, i.e. the column with index 0
corresponds to xlsx sheet column with index A, object with
index 1 defines sheet column with index B, and so on. If certain column
has no description in xlsx file, then corresponding array element
is undefined for both export and import operations.</p>
<p>If <a href="topic/wijmo.xlsx.WorkbookColumn.Class.html"><span class="identifier">WorkbookColumn</span></a> object in the array doesn't specify the
<b>width</b> property value, then the default column width is applied.</p></div>
<dl class="dl-horizontal">
  <dt>Type</dt><dd><a href="topic/wijmo.xlsx.WorkbookColumn.Class.html"><span class="identifier">WorkbookColumn</span></a>[]</dd>
</dl>
</div>
<div id="frozenPane" class="member-panel mproperty">
<h3>frozenPane</h3>
<div class="comment"><p>Gets or sets the <a href="topic/wijmo.xlsx.WorkbookFrozenPane.Class.html"><span class="identifier">WorkbookFrozenPane</span></a> settings.</p></div>
<dl class="dl-horizontal">
  <dt>Type</dt><dd><a href="topic/wijmo.xlsx.WorkbookFrozenPane.Class.html"><span class="identifier">WorkbookFrozenPane</span></a></dd>
</dl>
</div>
<div id="name" class="member-panel mproperty">
<h3>name</h3>
<div class="comment"><p>Gets or sets the sheet name.</p></div>
<dl class="dl-horizontal">
  <dt>Type</dt><dd><a href="https://developer.mozilla.org/en/docs/Web/JavaScript/Reference/Global_Objects/String" target="_blank"><span class="identifier">string</span></a></dd>
</dl>
</div>
<div id="rows" class="member-panel mproperty">
<h3>rows</h3>
<div class="comment"><p>Gets an array of sheet rows definition.</p>
<p>Each <a href="topic/wijmo.xlsx.WorkbookRow.Class.html"><span class="identifier">WorkbookRow</span></a> object in the array describes a row at the corresponding
position in xlsx sheet, i.e. the row with index 0 corresponds to excel sheet
row with index 1, object with index 1 defines sheet row with index 2, and so on.
If certain row has no properties and data in xlsx file, then corresponding array
element is undefined for both export and import operations.</p>
<p>If <a href="topic/wijmo.xlsx.WorkbookRow.Class.html"><span class="identifier">WorkbookRow</span></a> object in the array doesn't specify the <b>height</b> property
value, then the default row height is applied.</p></div>
<dl class="dl-horizontal">
  <dt>Type</dt><dd><a href="topic/wijmo.xlsx.WorkbookRow.Class.html"><span class="identifier">WorkbookRow</span></a>[]</dd>
</dl>
</div>
<div id="style" class="member-panel mproperty">
<h3>style</h3>
<div class="comment"><p>Gets or sets the row style.</p>
<p>The property defines the style for all cells in the worksheet, and
can be overridden by the specific cell styles.</p></div>
<dl class="dl-horizontal">
  <dt>Type</dt><dd><a href="topic/wijmo.xlsx.WorkbookStyle.Class.html"><span class="identifier">WorkbookStyle</span></a></dd>
</dl>
</div>
<div id="summaryBelow" class="member-panel mproperty">
<h3>summaryBelow</h3>
<div class="comment"><p>Gets or sets a value indicating whether summary rows appear below or
above detail rows.</p></div>
<dl class="dl-horizontal">
  <dt>Type</dt><dd><a href="https://developer.mozilla.org/en/docs/Web/JavaScript/Reference/Global_Objects/Boolean" target="_blank"><span class="identifier">boolean</span></a></dd>
</dl>
</div>
<div id="tables" class="member-panel mproperty">
<h3>tables</h3>
<div class="comment"><p>Gets the name of tables refered in this worksheet.</p></div>
<dl class="dl-horizontal">
  <dt>Type</dt><dd><a href="topic/wijmo.xlsx.WorkbookTable.Class.html"><span class="identifier">WorkbookTable</span></a>[]</dd>
</dl>
</div>
<div id="visible" class="member-panel mproperty">
<h3>visible</h3>
<div class="comment"><p>Gets or sets the worksheet visibility.</p></div>
<dl class="dl-horizontal">
  <dt>Type</dt><dd><a href="https://developer.mozilla.org/en/docs/Web/JavaScript/Reference/Global_Objects/Boolean" target="_blank"><span class="identifier">boolean</span></a></dd>
</dl>
</div>
</div>
