XLSXWriter

package

Default

Methods

__construct

__construct()

__destruct

__destruct()

add_to_list_get_index

add_to_list_get_index( &$haystack, $needle)
static

Arguments

$haystack

$needle

addCellStyle

addCellStyle( $number_format, $cell_style_string)

Arguments

$number_format

$cell_style_string

array_first_key

array_first_key(array $arr)
static

Arguments

$arr

array

buildAppXML

buildAppXML()

buildContentTypesXML

buildContentTypesXML()

buildCoreXML

buildCoreXML()

buildRelationshipsXML

buildRelationshipsXML()

buildWorkbookRelsXML

buildWorkbookRelsXML()

buildWorkbookXML

buildWorkbookXML()

convert_date_time

convert_date_time( $date_input)
static

Arguments

$date_input

countSheetRows

countSheetRows( $sheet_name = '')

Arguments

$sheet_name

determineNumberFormatType

determineNumberFormatType( $num_format)
static

Arguments

$num_format

finalizeSheet

finalizeSheet( $sheet_name)

Arguments

$sheet_name

initializeColumnTypes

initializeColumnTypes( $header_types)

Arguments

$header_types

initializeSheet

initializeSheet( $sheet_name, $col_widths = array(), $auto_filter = false, $freeze_rows = false, $freeze_columns = false)

Arguments

$sheet_name

$col_widths

$auto_filter

$freeze_rows

$freeze_columns

log

log( $string)
static

Arguments

$string

markMergedCell

markMergedCell( $sheet_name, $start_cell_row, $start_cell_column, $end_cell_row, $end_cell_column)

Arguments

$sheet_name

$start_cell_row

$start_cell_column

$end_cell_row

$end_cell_column

numberFormatStandardized

numberFormatStandardized( $num_format)
static

Arguments

$num_format

sanitize_filename

sanitize_filename( $filename)
static

Arguments

$filename

sanitize_sheetname

sanitize_sheetname( $sheetname)
static

Arguments

$sheetname

setAuthor

setAuthor( $author = '')

Arguments

$author

setCompany

setCompany( $company = '')

Arguments

$company

setDescription

setDescription( $description = '')

Arguments

$description

setKeywords

setKeywords( $keywords = '')

Arguments

$keywords

setRightToLeft

setRightToLeft( $isRightToLeft = false)

Arguments

$isRightToLeft

setSubject

setSubject( $subject = '')

Arguments

$subject

setTempDir

setTempDir( $tempdir = '')

Arguments

$tempdir

setTitle

setTitle( $title = '')

Arguments

$title

styleFontIndexes

styleFontIndexes()

tempFilename

tempFilename()

writeCell

writeCell(\XLSXWriter_BuffererWriter &$file, $row_number, $column_number, $value, $num_format_type, $cell_style_idx)

Arguments

$row_number

$column_number

$value

$num_format_type

$cell_style_idx

writeSheet

writeSheet(array $data, $sheet_name = '',array $header_types = array())

Arguments

$data

array

$sheet_name

$header_types

array

writeSheetHeader

writeSheetHeader( $sheet_name,array $header_types, $col_options = null)

Arguments

$sheet_name

$header_types

array

$col_options

writeSheetRow

writeSheetRow( $sheet_name,array $row, $row_options = null)

Arguments

$sheet_name

$row

array

$row_options

writeStylesXML

writeStylesXML()

writeToFile

writeToFile( $filename)

Arguments

$filename

writeToStdOut

writeToStdOut()

writeToString

writeToString()

xlsCell

xlsCell( $row_number, $column_number, $absolute = false)
static

Arguments

$row_number

$column_number

$absolute

xmlspecialchars

xmlspecialchars( $val)
static

Arguments

$val

Constants

EXCEL_2007_MAX_ROW

EXCEL_2007_MAX_ROW

EXCEL_2007_MAX_COL

EXCEL_2007_MAX_COL

Properties

title

title :

Type(s)

subject

subject :

Type(s)

author

author :

Type(s)

isRightToLeft

isRightToLeft :

Type(s)

company

company :

Type(s)

description

description :

Type(s)

keywords

keywords :

Type(s)

current_sheet

current_sheet :

Type(s)

sheets

sheets :

Type(s)

temp_files

temp_files :

Type(s)

cell_styles

cell_styles :

Type(s)

number_formats

number_formats :

Type(s)