| Property | Type | Description | |
|---|---|---|---|
| $author | ------------------------------------------------------------------ | ||
| $cell_formats | |||
| $cell_types | contains excel format like YYYY-MM-DD HH:MM:SS | ||
| $current_sheet | contains friendly format like datetime | ||
| $shared_string_count | unique set | ||
| $shared_strings | |||
| $sheets | |||
| $temp_dir | |||
| $temp_files | count of non-unique references to the unique set |
| Method | Description | |
|---|---|---|
| __construct ( ) | ||
| __destruct ( ) | ||
| array_first_key ( array $arr ) | ------------------------------------------------------------------ | |
| convert_date_time ( $date_input ) | ------------------------------------------------------------------ | |
| log ( $string ) | ------------------------------------------------------------------ | |
| markMergedCell ( $sheet_name, $start_cell_row, $start_cell_column, $end_cell_row, $end_cell_column ) | ||
| sanitize_filename ( $filename ) | ------------------------------------------------------------------ | |
| setAuthor ( $author = '' ) | ||
| setTempDir ( $dir ) | ||
| writeSheet ( array $data, $sheet_name = '', array $header_types = [] ) | ||
| writeSheetHeader ( $sheet_name, array $header_types, $suppress_row = false ) | ||
| writeSheetRow ( $sheet_name, array $row ) | ||
| writeToFile ( $filename ) | ||
| writeToStdOut ( ) | ||
| writeToString ( ) | ||
| xlsCell ( $row_number, $column_number ) | * | |
| xmlspecialchars ( $val ) | ------------------------------------------------------------------ |
| Method | Description | |
|---|---|---|
| buildAppXML ( ) | ||
| buildContentTypesXML ( ) | ||
| buildCoreXML ( ) | ||
| buildRelationshipsXML ( ) | ||
| buildWorkbookRelsXML ( ) | ||
| buildWorkbookXML ( ) | ||
| finalizeSheet ( $sheet_name ) | ||
| initializeSheet ( $sheet_name ) | ||
| setSharedString ( $v ) | ||
| tempFilename ( ) | ||
| writeCell ( XLSXWriter_BuffererWriter &$file, $row_number, $column_number, $value, $cell_format_index ) | ||
| writeSharedStringsXML ( ) | ||
| writeStylesXML ( ) |
| Method | Description | |
|---|---|---|
| addCellFormat ( $cell_format ) | ||
| determineCellType ( $cell_format ) | ||
| escapeCellFormat ( $cell_format ) |
| public static array_first_key ( array $arr ) | ||
| $arr | array | |
| public static convert_date_time ( $date_input ) |
| public static log ( $string ) |
| public markMergedCell ( $sheet_name, $start_cell_row, $start_cell_column, $end_cell_row, $end_cell_column ) |
| public static sanitize_filename ( $filename ) |
| protected writeCell ( XLSXWriter_BuffererWriter &$file, $row_number, $column_number, $value, $cell_format_index ) | ||
| $file | XLSXWriter_BuffererWriter | |
| public writeSheet ( array $data, $sheet_name = '', array $header_types = [] ) | ||
| $data | array | |
| $header_types | array | |
| public writeSheetHeader ( $sheet_name, array $header_types, $suppress_row = false ) | ||
| $header_types | array | |
| public static xlsCell ( $row_number, $column_number ) | ||
| $row_number | int, zero based | |
| $column_number | int, zero based | |
| public static xmlspecialchars ( $val ) |
| protected $author |