Documentation

Csv extends BaseReader

Table of Contents

DEFAULT_FALLBACK_ENCODING  = 'CP1252'

GUESS_ENCODING  = 'guess'

UTF16BE_BOM  = "��"

UTF16BE_BOM_LEN  = 2

UTF16BE_LF  = " "

UTF16LE_BOM  = "��"

UTF16LE_BOM_LEN  = 2

UTF16LE_LF  = " "

UTF32BE_BOM  = "��"

UTF32BE_BOM_LEN  = 4

UTF32BE_LF  = " "

UTF32LE_BOM  = "��"

UTF32LE_BOM_LEN  = 4

UTF32LE_LF  = " "

UTF8_BOM  = ""

UTF8_BOM_LEN  = 3

$castFormattedNumberToNumeric  : bool

$fileHandle  : resource

$includeCharts  : bool

Read charts that are defined in the workbook? Identifies whether the Reader should read the definitions for any charts that exist in the workbook;.

$loadSheetsOnly  : null|array<string|int, string>

Restrict which sheets should be loaded? This property holds an array of worksheet names to be loaded. If null, then all worksheets will be loaded.

$preserveNumericFormatting  : bool

$readDataOnly  : bool

Read data only? Identifies whether the Reader should only read data values for cells, and ignore any formatting information; or whether it should read both data and formatting.

$readEmptyCells  : bool

Read empty cells? Identifies whether the Reader should read data values for cells all cells, or should ignore cells containing null value or empty string.

$readFilter  : IReadFilter

IReadFilter instance.

$securityScanner  : XmlScanner|null

$constructorCallback  : callable|null

Callback for setting defaults in construction.

$contiguous  : bool

Load rows contiguously.

$delimiter  : string|null

Delimiter.

$enclosure  : string

Enclosure.

$escapeCharacter  : string

The character that can escape the enclosure.

$fallbackEncoding  : string

Fallback encoding if guess strikes out.

$inputEncoding  : string

Input encoding.

$preserveNullString  : bool

$sheetIndex  : int

Sheet index to read.

$testAutodetect  : bool

Attempt autodetect line endings (deprecated after PHP8.1)?

__construct()  : mixed

Create a new CSV Reader instance.

canRead()  : bool

Can the current IReader read the file?

castFormattedNumberToNumeric()  : void

getConstructorCallback()  : callable|null

getContiguous()  : bool

getDelimiter()  : string|null

getEnclosure()  : string

getEscapeCharacter()  : string

getFallbackEncoding()  : string

getIncludeCharts()  : bool

Read charts in workbook? If this is true, then the Reader will include any charts that exist in the workbook.

getInputEncoding()  : string

getLoadSheetsOnly()  : mixed

Get which sheets to load Returns either an array of worksheet names (the list of worksheets that should be loaded), or a null indicating that all worksheets in the workbook should be loaded.

getPreserveNullString()  : bool

getReadDataOnly()  : bool

Read data only? If this is true, then the Reader will only read data values for cells, it will not read any formatting or structural information (like merges).

getReadEmptyCells()  : bool

Read empty cells? If this is true (the default), then the Reader will read data values for all cells, irrespective of value.

getReadFilter()  : IReadFilter

Read filter.

getSecurityScanner()  : XmlScanner|null

getSecurityScannerOrThrow()  : XmlScanner

getSheetIndex()  : int

guessEncoding()  : string

listWorksheetInfo()  : array<string|int, mixed>

Return worksheet info (Name, Last Column Letter, Last Column Index, Total Rows, Total Columns).

load()  : Spreadsheet

Loads Spreadsheet from file.

loadIntoExisting()  : Spreadsheet

Loads PhpSpreadsheet from file into PhpSpreadsheet instance.

loadSpreadsheetFromString()  : Spreadsheet

Loads Spreadsheet from string.

setConstructorCallback()  : void

Set a callback to change the defaults.

setContiguous()  : self

setDelimiter()  : self

setEnclosure()  : self

setEscapeCharacter()  : self

setFallbackEncoding()  : self

setIncludeCharts()  : IReader

Set read charts in workbook Set to true, to advise the Reader to include any charts that exist in the workbook.

setInputEncoding()  : self

setLoadAllSheets()  : IReader

Set all sheets to load Tells the Reader to load all worksheets from the workbook.

setLoadSheetsOnly()  : IReader

Set which sheets to load.

setPreserveNullString()  : self

setReadDataOnly()  : IReader

Set read data only Set to true, to advise the Reader only to read data values for cells, and to ignore any formatting or structural information (like merges).

setReadEmptyCells()  : IReader

Set read empty cells Set to true (the default) to advise the Reader read data values for all cells, irrespective of value.

setReadFilter()  : IReader

Set read filter.

setSheetIndex()  : self

setTestAutoDetect()  : self

checkSeparator()  : void

Identify any separator that is explicitly set in the file.

inferSeparator()  : void

Infer the separator if it isn't explicitly set in the file or specified by the user.

loadSpreadsheetFromFile()  : Spreadsheet

Loads Spreadsheet from file.

openFile()  : void

Open file for reading.

processFlags()  : void

skipBOM()  : void

Move filepointer past any BOM marker.

convertBoolean()  : void

Convert string true/false to boolean, and null to null-string.

convertFormattedNumber()  : string

Convert numeric strings to int or float values.

guessEncodingBom()  : string

guessEncodingNoBom()  : string

guessEncodingTestBom()  : void

guessEncodingTestNoBom()  : void

loadStringOrFile()  : Spreadsheet

Loads PhpSpreadsheet from file into PhpSpreadsheet instance.

openDataUri()  : void

Open data uri for reading.

openFileOrMemory()  : void

setAutoDetect()  : string|null