Overview

Namespaces

  • PHP
  • SimpleExcel
    • Enums
    • Parser
    • Spreadsheet
    • Writer

Classes

  • Cell
  • Workbook
  • Worksheet
  • Overview
  • Namespace
  • Class
  • Tree

Class Worksheet

SimpleExcel class for constructing worksheet

Namespace: SimpleExcel\Spreadsheet
Package: SimpleExcel
Author: Faisalman
Located at Spreadsheet/Worksheet.php
Methods summary
public
# __construct( )
public SimpleExcel\Spreadsheet\Cell
# getCell( integer $rowIndex, integer $colIndex )

Get a specified cell

Get a specified cell

Parameters

$rowIndex
integer
$rowIndex Row number of specified cell
$colIndex
integer
$colIndex Column number of specified cell

Returns

SimpleExcel\Spreadsheet\Cell
public array
# getColumn( integer $index )

Get array of cells from a specified column

Get array of cells from a specified column

Parameters

$index
integer
$index Column number

Returns

array
public array
# getRow( integer $index )

Get array of cells from a specified row

Get array of cells from a specified row

Parameters

$index
integer
$index Row number

Returns

array
public array
# getRecords( )

Get all cells

Get all cells

Returns

array
public
# insertRecord( array $record )

Insert a record to worksheet

Insert a record to worksheet

Parameters

$record
array
$record Array of cells to be inserted
public
# removeRecord( integer $index )

Remove specified record from worksheet

Remove specified record from worksheet

Parameters

$index
integer
$index Row number
public
# setCell( integer $rowIndex, integer $colIndex, SimpleExcel\Spreadsheet\Cell $cell )

Set specified cell value

Set specified cell value

Parameters

$rowIndex
integer
$rowIndex Row number
$colIndex
integer
$colIndex Column number
$cell
SimpleExcel\Spreadsheet\Cell
$cell New Cell
public
# setRecord( integer $index, array $record )

Set specified record values

Set specified record values

Parameters

$index
integer
$index Row number
$record
array
$record Record values
public
# setRecords( array $records )

Set record values all at once

Set record values all at once

Parameters

$records
array
$record Two-dimensional array Cell values
Properties summary
protected array $records
#
API documentation generated by ApiGen 2.8.0