Gitee
\
app
admin
controller
model
validate
base
controller
chengji
controller
model
validate
event
facade
index
controller
kaohao
controller
model
validate
Kaoshi
controller
model
kaoshi
controller
model
validate
keti
controller
model
validate
Keti
model
listener
login
controller
validate
luru
controller
middleware
rongyu
controller
model
validate
student
controller
model
validate
studentSearchChengji
controller
system
controller
model
validate
teach
controller
model
validate
teacher
controller
model
validate
teacherSearchChengji
controller
tools
controller
model
zhengli
controller
Complex
Composer
Autoload
League
Flysystem
Adapter
Polyfill
Cached
Storage
Plugin
Util
liliuwei
think
Matrix
Operators
Opis
Closure
Overtrue
Pinyin
Phinx
Db
Adapter
Table
Migration
Seed
Util
PhpOffice
PhpSpreadsheet
Calculation
Engine
Token
Cell
Chart
Renderer
Collection
Document
Helper
Reader
Ods
Security
Xls
Color
Style
Xlsx
RichText
Shared
Escher
DgContainer
SpgrContainer
DggContainer
BstoreContainer
BSE
JAMA
OLE
PPS
Trend
Style
Worksheet
AutoFilter
Column
Drawing
Writer
Ods
Cell
Pdf
Xls
Xlsx
Psr
Cache
Container
Log
Test
SimpleCache
Samples
Sample09
Sample10
Sample12
Sample14
spec
League
Flysystem
Cached
Symfony
Component
VarDumper
Caster
Cloner
Command
Descriptor
Dumper
Exception
Server
Test
Polyfill
Mbstring
Php72
think
app
command
cache
driver
captcha
facade
console
command
make
optimize
input
output
descriptor
driver
formatter
question
contract
db
concern
connector
exception
event
exception
facade
file
filesystem
driver
helper
initializer
log
driver
middleware
migration
command
factory
migrate
seed
db
model
concern
relation
paginator
driver
response
route
dispatch
service
session
driver
template
driver
exception
taglib
tests
trace
validate
view
driver
WhiteHat101
Crypt

\PhpOffice\PhpSpreadsheet\WorksheetColumnCellIterator

Summary

Methods
Properties
Constants
__destruct()
getIterateOnlyExistingCells()
setIterateOnlyExistingCells()
__construct()
resetStart()
resetEnd()
seek()
rewind()
current()
key()
next()
prev()
valid()
No public properties found
No constants found
adjustForExistingOnlyRange()
$worksheet
$onlyExistingCells
N/A
No private methods found
$currentRow
$columnIndex
$startRow
$endRow
N/A

Properties

$worksheet

$worksheet : \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet

Worksheet to iterate.

Type

\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet

$onlyExistingCells

$onlyExistingCells : boolean

Iterate only existing cells.

Type

boolean

$currentRow

$currentRow : integer

Current iterator position.

Type

integer

$columnIndex

$columnIndex : string

Column index.

Type

string

$startRow

$startRow : integer

Start position.

Type

integer

$endRow

$endRow : integer

End position.

Type

integer

Methods

__destruct()

__destruct()

Destructor.

getIterateOnlyExistingCells()

getIterateOnlyExistingCells() : boolean

Get loop only existing cells.

Returns

boolean

setIterateOnlyExistingCells()

setIterateOnlyExistingCells(boolean  $value)

Set the iterator to loop only existing cells.

Parameters

boolean $value

Throws

\PhpOffice\PhpSpreadsheet\Exception

__construct()

__construct(\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet  $subject = null, string  $columnIndex = 'A', integer  $startRow = 1, integer  $endRow = null)

Create a new row iterator.

Parameters

\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $subject

The worksheet to iterate over
string $columnIndex

The column that we want to iterate
integer $startRow

The row number at which to start iterating
integer $endRow

Optionally, the row number at which to stop iterating

resetStart()

resetStart(integer  $startRow = 1) : $this

(Re)Set the start row and the current row pointer.

Parameters

integer $startRow

The row number at which to start iterating

Throws

\PhpOffice\PhpSpreadsheet\Exception

Returns

$this

resetEnd()

resetEnd(integer  $endRow = null) : $this

(Re)Set the end row.

Parameters

integer $endRow

The row number at which to stop iterating

Throws

\PhpOffice\PhpSpreadsheet\Exception

Returns

$this

seek()

seek(integer  $row = 1) : $this

Set the row pointer to the selected row.

Parameters

integer $row

The row number to set the current pointer at

Throws

\PhpOffice\PhpSpreadsheet\Exception

Returns

$this

rewind()

rewind()

Rewind the iterator to the starting row.

current()

current() : null|\PhpOffice\PhpSpreadsheet\Cell\Cell

Return the current cell in this worksheet column.

Returns

null|\PhpOffice\PhpSpreadsheet\Cell\Cell

key()

key() : integer

Return the current iterator key.

Returns

integer

next()

next()

Set the iterator to its next value.

prev()

prev()

Set the iterator to its previous value.

valid()

valid() : boolean

Indicate if more rows exist in the worksheet range of rows that we're iterating.

Returns

boolean

adjustForExistingOnlyRange()

adjustForExistingOnlyRange()

Validate start/end values for "IterateOnlyExistingCells" mode, and adjust if necessary.

Throws

\PhpOffice\PhpSpreadsheet\Exception