Inheritance diagram for PHPExcel_Writer_Excel5_Worksheet:
Collaboration diagram for PHPExcel_Writer_Excel5_Worksheet:
Public Member Functions | |
| __construct (&$str_total, &$str_unique, &$str_table, &$colors, $parser, $preCalculateFormulas, $phpSheet) | |
| Constructor. More... | |
| close () | |
| Add data to the beginning of the workbook (note the reverse order) and to the end of the workbook. More... | |
| getData () | |
| Retrieves data from memory in one chunk, or from disk in $buffer sized chunks. More... | |
| printRowColHeaders ($print=1) | |
| Set the option to print the row and column headers on the printed page. More... | |
| setOutline ($visible=true, $symbols_below=true, $symbols_right=true, $auto_style=false) | |
| This method sets the properties for outlining and grouping. More... | |
| _writeBlank ($row, $col, $xfIndex) | |
| Write a blank cell to the specified row and column (zero indexed). More... | |
| _writeUrlRange ($row1, $col1, $row2, $col2, $url) | |
| This is the more general form of _writeUrl(). More... | |
| _writeUrlWeb ($row1, $col1, $row2, $col2, $url) | |
| Used to write http, ftp and mailto hyperlinks. More... | |
| _writeUrlInternal ($row1, $col1, $row2, $col2, $url) | |
| Used to write internal reference hyperlinks such as "Sheet1!A1". More... | |
| _writeUrlExternal ($row1, $col1, $row2, $col2, $url) | |
| Write links to external directory names such as 'c:.xls', c:.xls::Sheet1!A1', '../../foo.xls'. More... | |
| insertBitmap ($row, $col, $bitmap, $x=0, $y=0, $scale_x=1, $scale_y=1) | |
| Insert a 24bit bitmap image in a worksheet. More... | |
| _positionImage ($col_start, $row_start, $x1, $y1, $width, $height) | |
| Calculate the vertices that define the position of the image as required by the OBJ record. More... | |
| _processBitmapGd ($image) | |
| Convert a GD-image into the internal format. More... | |
| _processBitmap ($bitmap) | |
| Convert a 24 bit bitmap into the modified internal format used by Windows. More... | |
| getEscher () | |
| Get Escher object. More... | |
| setEscher (PHPExcel_Shared_Escher $pValue=null) | |
| Set Escher object. More... | |
| Public Member Functions inherited from PHPExcel_Writer_Excel5_BIFFwriter | |
| __construct () | |
| Constructor. More... | |
| _append ($data) | |
| General storage function. More... | |
| writeData ($data) | |
| General storage function like _append, but returns string instead of modifying $this->_data. More... | |
| _storeBof ($type) | |
| Writes Excel BOF record to indicate the beginning of a stream or sub-stream in the BIFF file. More... | |
| _storeEof () | |
| Writes Excel EOF record to indicate the end of a BIFF stream. More... | |
| writeEof () | |
| Writes Excel EOF record to indicate the end of a BIFF stream. More... | |
| _addContinue ($data) | |
| Excel limits the size of BIFF records. More... | |
Data Fields | |
| $_xls_strmax | |
| $_colinfo | |
| $_selection | |
| $_active_pane | |
| $_outline_on | |
| $_outline_style | |
| $_outline_below | |
| $_outline_right | |
| $_str_total | |
| $_str_unique | |
| $_str_table | |
| $_phpSheet | |
| $_fntHashIndex | |
| $record = 0x01B8 | |
| $length = 0x00000 | |
| $url = preg_replace('/^external:/', '', $url) | |
| $absolute = 0x00 | |
| if(preg_match('/^ | $link_type [A-Z]:/', $url)) = 0x01 | $absolute |
| $dir_long = $url | |
| if(preg_match("/\", $url)) | $link_type = pack("V", $link_type) |
| $up_count = preg_match_all("/\.\.\\\/", $dir_long, $useless) | |
| $dir_short = preg_replace("/\.\.\\\/", '', $dir_long) . "\0" | |
| $dir_short_len = pack("V", strlen($dir_short) ) | |
| $dir_long_len = pack("V", strlen($dir_long) ) | |
| $stream_len = pack("V", 0) | |
| $unknown1 = pack("H*",'D0C9EA79F9BACE118C8200AA004BA90B02000000' ) | |
| $unknown2 = pack("H*",'0303000000000000C000000000000046' ) | |
| $unknown3 = pack("H*",'FFFFADDE000000000000000000000000000000000000000') | |
| $unknown4 = pack("v", 0x03 ) | |
| $data | |
| $header = pack("vv", $record, $length) | |
| return | |
| Data Fields inherited from PHPExcel_Writer_Excel5_BIFFwriter | |
| $_data | |
| $_datasize | |
| $_limit = 8224 | |
Private Member Functions | |
| _writeBIFF8CellRangeAddressFixed ($range='A1') | |
| Write a cell range address in BIFF8 always fixed range See section 2.5.14 in OpenOffice.org's Documentation of the Microsoft Excel File Format. More... | |
| _writeNumber ($row, $col, $num, $xfIndex) | |
| Write a double to the specified row and column (zero indexed). More... | |
| _writeString ($row, $col, $str, $xfIndex) | |
| Write a LABELSST record or a LABEL record. More... | |
| _writeRichTextString ($row, $col, $str, $xfIndex, $arrcRun) | |
| Write a LABELSST record or a LABEL record. More... | |
| _writeLabel ($row, $col, $str, $xfIndex) | |
| Write a string to the specified row and column (zero indexed). More... | |
| _writeLabelSst ($row, $col, $str, $xfIndex) | |
| Write a string to the specified row and column (zero indexed). More... | |
| _writeNote ($row, $col, $note) | |
| Writes a note associated with the cell given by the row and column. More... | |
| _writeBoolErr ($row, $col, $value, $isError, $xfIndex) | |
| Write a boolean or an error type to the specified row and column (zero indexed) More... | |
| _writeFormula ($row, $col, $formula, $xfIndex, $calculatedValue) | |
| Write a formula to the specified row and column (zero indexed). More... | |
| _writeStringRecord ($stringValue) | |
| Write a STRING record. More... | |
| _writeUrl ($row, $col, $url) | |
| Write a hyperlink. More... | |
| _writeRow ($row, $height, $xfIndex, $hidden=false, $level=0) | |
| This method is used to set the height and format for a row. More... | |
| _writeDimensions () | |
| Writes Excel DIMENSIONS to define the area in which there is data. More... | |
| _writeWindow2 () | |
| Write BIFF record Window2. More... | |
| _writeDefaultRowHeight () | |
| Write BIFF record DEFAULTROWHEIGHT. More... | |
| _writeDefcol () | |
| Write BIFF record DEFCOLWIDTH if COLINFO records are in use. More... | |
| _writeColinfo ($col_array) | |
| Write BIFF record COLINFO to define column widths. More... | |
| _writeSelection () | |
| Write BIFF record SELECTION. More... | |
| _writeMergedCells () | |
| Store the MERGEDCELLS records for all ranges of merged cells. More... | |
| _writeSheetLayout () | |
| Write SHEETLAYOUT record. More... | |
| _writeSheetProtection () | |
| Write SHEETPROTECTION. More... | |
| _writeRangeProtection () | |
| Write BIFF record RANGEPROTECTION. More... | |
| _writeExterncount ($count) | |
| Write BIFF record EXTERNCOUNT to indicate the number of external sheet references in a worksheet. More... | |
| _writeExternsheet ($sheetname) | |
| Writes the Excel BIFF EXTERNSHEET record. More... | |
| _writePanes () | |
| Writes the Excel BIFF PANE record. More... | |
| _writeSetup () | |
| Store the page setup SETUP BIFF record. More... | |
| _writeHeader () | |
| Store the header caption BIFF record. More... | |
| _writeFooter () | |
| Store the footer caption BIFF record. More... | |
| _writeHcenter () | |
| Store the horizontal centering HCENTER BIFF record. More... | |
| _writeVcenter () | |
| Store the vertical centering VCENTER BIFF record. More... | |
| _writeMarginLeft () | |
| Store the LEFTMARGIN BIFF record. More... | |
| _writeMarginRight () | |
| Store the RIGHTMARGIN BIFF record. More... | |
| _writeMarginTop () | |
| Store the TOPMARGIN BIFF record. More... | |
| _writeMarginBottom () | |
| Store the BOTTOMMARGIN BIFF record. More... | |
| _writePrintHeaders () | |
| Write the PRINTHEADERS BIFF record. More... | |
| _writePrintGridlines () | |
| Write the PRINTGRIDLINES BIFF record. More... | |
| _writeGridset () | |
| Write the GRIDSET BIFF record. More... | |
| _writeAutoFilterInfo () | |
| Write the AUTOFILTERINFO BIFF record. More... | |
| _writeGuts () | |
| Write the GUTS BIFF record. More... | |
| _writeWsbool () | |
| Write the WSBOOL BIFF record, mainly for fit-to-page. More... | |
| _writeBreaks () | |
| Write the HORIZONTALPAGEBREAKS and VERTICALPAGEBREAKS BIFF records. More... | |
| _writeProtect () | |
| Set the Biff PROTECT record to indicate that the worksheet is protected. More... | |
| _writeScenProtect () | |
| Write SCENPROTECT. More... | |
| _writeObjectProtect () | |
| Write OBJECTPROTECT. More... | |
| _writePassword () | |
| Write the worksheet PASSWORD record. More... | |
| _writeObjPicture ($colL, $dxL, $rwT, $dyT, $colR, $dxR, $rwB, $dyB) | |
| Store the OBJ record that precedes an IMDATA record. More... | |
| _writeZoom () | |
| Store the window zoom factor. More... | |
| _writeMsoDrawing () | |
| Write MSODRAWING record. More... | |
| _writeDataValidity () | |
| Store the DATAVALIDATIONS and DATAVALIDATION records. More... | |
| _writePageLayoutView () | |
| Write PLV Record. More... | |
| _writeCFRule (PHPExcel_Style_Conditional $conditional) | |
| Write CFRule Record. More... | |
| _writeCFHeader () | |
| Write CFHeader record. More... | |
Static Private Member Functions | |
| static | _mapErrorCode ($errorCode) |
| Map Error code. More... | |
Private Attributes | |
| $_parser | |
| $_colors | |
| Color cache. More... | |
| $_firstRowIndex | |
| $_lastRowIndex | |
| $_firstColumnIndex | |
| $_lastColumnIndex | |
| $_countCellStyleXfs | |
| $_escher | |
Additional Inherited Members | |
| Static Public Member Functions inherited from PHPExcel_Writer_Excel5_BIFFwriter | |
| static | getByteOrder () |
| Determine the byte order and store it as class data to avoid recalculating it for each call to new(). More... | |
Detailed Description
Definition at line 71 of file Worksheet.php.
Constructor & Destructor Documentation
◆ __construct()
| PHPExcel_Writer_Excel5_Worksheet::__construct | ( | & | $str_total, |
| & | $str_unique, | ||
| & | $str_table, | ||
| & | $colors, | ||
| $parser, | |||
| $preCalculateFormulas, | |||
| $phpSheet | |||
| ) |
Constructor.
- Parameters
-
int &$str_total Total number of strings int &$str_unique Total number of unique strings array &$str_table String Table array &$colors Colour Table mixed $parser The formula parser created for the Workbook boolean $preCalculateFormulas Flag indicating whether formulas should be calculated or just written string $phpSheet The worksheet to write PHPExcel_Worksheet $phpSheet
Definition at line 214 of file Worksheet.php.
References $parser, array, and PHPExcel_Cell\columnIndexFromString().
Here is the call graph for this function:
Member Function Documentation
◆ _mapErrorCode()
|
staticprivate |
Map Error code.
- Parameters
-
string $errorCode
- Returns
- int
Definition at line 2976 of file Worksheet.php.
References $errorCode.
◆ _positionImage()
| PHPExcel_Writer_Excel5_Worksheet::_positionImage | ( | $col_start, | |
| $row_start, | |||
| $x1, | |||
| $y1, | |||
| $width, | |||
| $height | |||
| ) |
Calculate the vertices that define the position of the image as required by the OBJ record.
+---------—+---------—+ | A | B | +--—+---------—+---------—+ | |(x1,y1) | | | 1 |(A1)._______|______ | | | | | | | | | | | +--—+-—| BITMAP |--—+ | | | | | | 2 | |______________. | | | | (B2)| | | | (x2,y2)| +-— +---------—+---------—+
Example of a bitmap that covers some of the area from cell A1 to cell B2.
Based on the width and height of the bitmap we need to calculate 8 vars: $col_start, $row_start, $col_end, $row_end, $x1, $y1, $x2, $y2. The width and height of the cells are also variable and have to be taken into account. The values of $col_start and $row_start are passed in from the calling function. The values of $col_end and $row_end are calculated by subtracting the width and height of the bitmap from the width and height of the underlying cells. The vertices are expressed as a percentage of the underlying cell width as follows (rhs values are in pixels):
x1 = X / W *1024
y1 = Y / H *256
x2 = (X-1) / W *1024
y2 = (Y-1) / H *256
Where: X is distance from the left side of the underlying cell
Y is distance from the top of the underlying cell
W is the width of the cell
H is the height of the cell
The SDK incorrectly states that the height should be expressed as a percentage of 1024.
private
- Parameters
-
integer $col_start Col containing upper left corner of object integer $row_start Row containing top left corner of object integer $x1 Distance to left side of object integer $y1 Distance to top of object integer $width Width of image frame integer $height Height of image frame
Definition at line 2440 of file Worksheet.php.
References _writeObjPicture(), PHPExcel_Shared_Excel5\sizeCol(), PHPExcel_Shared_Excel5\sizeRow(), and PHPExcel_Cell\stringFromColumnIndex().
Referenced by insertBitmap().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ _processBitmap()
| PHPExcel_Writer_Excel5_Worksheet::_processBitmap | ( | $bitmap | ) |
Convert a 24 bit bitmap into the modified internal format used by Windows.
This is described in BITMAPCOREHEADER and BITMAPCOREINFO structures in the MSDN library.
private
- Parameters
-
string $bitmap The bitmap to process
- Returns
- array Array with data and properties of the bitmap
Definition at line 2613 of file Worksheet.php.
References $data, $header, $size, and array.
Referenced by insertBitmap().
Here is the caller graph for this function:
◆ _processBitmapGd()
| PHPExcel_Writer_Excel5_Worksheet::_processBitmapGd | ( | $image | ) |
Convert a GD-image into the internal format.
private
- Parameters
-
resource $image The image to process
- Returns
- array Array with data and properties of the bitmap
Definition at line 2583 of file Worksheet.php.
References $data, $i, $key, and array.
Referenced by insertBitmap().
Here is the caller graph for this function:
◆ _writeAutoFilterInfo()
|
private |
Write the AUTOFILTERINFO BIFF record.
This is used to configure the number of autofilter select used in the sheet.
Definition at line 2084 of file Worksheet.php.
References $data, $header, $length, $record, PHPExcel_Writer_Excel5_BIFFwriter\_append(), and PHPExcel_Cell\rangeBoundaries().
Referenced by close().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ _writeBIFF8CellRangeAddressFixed()
|
private |
Write a cell range address in BIFF8 always fixed range See section 2.5.14 in OpenOffice.org's Documentation of the Microsoft Excel File Format.
- Parameters
-
string $range E.g. 'A1' or 'A1:B6'
- Returns
- string Binary data
Definition at line 558 of file Worksheet.php.
References PHPExcel_Cell\columnIndexFromString(), and PHPExcel_Cell\coordinateFromString().
Referenced by _writeDataValidity(), and _writeRangeProtection().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ _writeBlank()
| PHPExcel_Writer_Excel5_Worksheet::_writeBlank | ( | $row, | |
| $col, | |||
| $xfIndex | |||
| ) |
Write a blank cell to the specified row and column (zero indexed).
A blank cell is used to specify formatting without adding a string or a number.
A blank cell without a format serves no purpose. Therefore, we don't write a BLANK record unless a format is specified.
Returns 0 : normal termination (including no format) -1 : insufficient number of arguments -2 : row or column out of range
- Parameters
-
integer $row Zero indexed row integer $col Zero indexed column mixed $xfIndex The XF format index
Definition at line 819 of file Worksheet.php.
References $data, $header, $length, $record, $row, and PHPExcel_Writer_Excel5_BIFFwriter\_append().
Referenced by close().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ _writeBoolErr()
|
private |
Write a boolean or an error type to the specified row and column (zero indexed)
- Parameters
-
int $row Row index (0-based) int $col Column index (0-based) int $value boolean $isError Error or Boolean? int $xfIndex
Definition at line 839 of file Worksheet.php.
References $data, $header, $length, $record, $row, and PHPExcel_Writer_Excel5_BIFFwriter\_append().
Referenced by close().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ _writeBreaks()
|
private |
Write the HORIZONTALPAGEBREAKS and VERTICALPAGEBREAKS BIFF records.
Definition at line 2182 of file Worksheet.php.
References $data, $header, $length, $record, PHPExcel_Writer_Excel5_BIFFwriter\_append(), array, PHPExcel_Worksheet\BREAK_COLUMN, PHPExcel_Worksheet\BREAK_NONE, PHPExcel_Worksheet\BREAK_ROW, PHPExcel_Cell\columnIndexFromString(), and PHPExcel_Cell\coordinateFromString().
Referenced by close().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ _writeCFHeader()
|
private |
Write CFHeader record.
Definition at line 3635 of file Worksheet.php.
References $conditionalStyles, $data, $header, $length, $record, PHPExcel_Writer_Excel5_BIFFwriter\_append(), array, PHPExcel_Cell\columnIndexFromString(), PHPExcel_Style_Conditional\CONDITION_CELLIS, PHPExcel_Style_Conditional\CONDITION_EXPRESSION, and PHPExcel_Cell\coordinateFromString().
Referenced by close().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ _writeCFRule()
|
private |
Write CFRule Record.
- Parameters
-
PHPExcel_Style_Conditional $conditional
Definition at line 3024 of file Worksheet.php.
References $data, $header, $record, $type, PHPExcel_Writer_Excel5_BIFFwriter\_append(), PHPExcel_Style_Border\BORDER_DASHDOT, PHPExcel_Style_Border\BORDER_DASHDOTDOT, PHPExcel_Style_Border\BORDER_DASHED, PHPExcel_Style_Border\BORDER_DOTTED, PHPExcel_Style_Border\BORDER_DOUBLE, PHPExcel_Style_Border\BORDER_HAIR, PHPExcel_Style_Border\BORDER_MEDIUM, PHPExcel_Style_Border\BORDER_MEDIUMDASHDOT, PHPExcel_Style_Border\BORDER_MEDIUMDASHDOTDOT, PHPExcel_Style_Border\BORDER_MEDIUMDASHED, PHPExcel_Style_Border\BORDER_NONE, PHPExcel_Style_Border\BORDER_SLANTDASHDOT, PHPExcel_Style_Border\BORDER_THICK, PHPExcel_Style_Border\BORDER_THIN, PHPExcel_Style_Color\COLOR_BLACK, PHPExcel_Style_Conditional\CONDITION_CELLIS, PHPExcel_Style_Conditional\CONDITION_EXPRESSION, PHPExcel_Style_Fill\FILL_GRADIENT_LINEAR, PHPExcel_Style_Fill\FILL_GRADIENT_PATH, PHPExcel_Style_Fill\FILL_NONE, PHPExcel_Style_Fill\FILL_PATTERN_DARKDOWN, PHPExcel_Style_Fill\FILL_PATTERN_DARKGRAY, PHPExcel_Style_Fill\FILL_PATTERN_DARKGRID, PHPExcel_Style_Fill\FILL_PATTERN_DARKHORIZONTAL, PHPExcel_Style_Fill\FILL_PATTERN_DARKTRELLIS, PHPExcel_Style_Fill\FILL_PATTERN_DARKUP, PHPExcel_Style_Fill\FILL_PATTERN_DARKVERTICAL, PHPExcel_Style_Fill\FILL_PATTERN_GRAY0625, PHPExcel_Style_Fill\FILL_PATTERN_GRAY125, PHPExcel_Style_Fill\FILL_PATTERN_LIGHTDOWN, PHPExcel_Style_Fill\FILL_PATTERN_LIGHTGRAY, PHPExcel_Style_Fill\FILL_PATTERN_LIGHTGRID, PHPExcel_Style_Fill\FILL_PATTERN_LIGHTHORIZONTAL, PHPExcel_Style_Fill\FILL_PATTERN_LIGHTTRELLIS, PHPExcel_Style_Fill\FILL_PATTERN_LIGHTUP, PHPExcel_Style_Fill\FILL_PATTERN_LIGHTVERTICAL, PHPExcel_Style_Fill\FILL_PATTERN_MEDIUMGRAY, PHPExcel_Style_Fill\FILL_SOLID, PHPExcel_Style_Conditional\getConditions(), PHPExcel_Style_Conditional\getConditionType(), PHPExcel_Style_Conditional\getOperatorType(), PHPExcel_Style_Conditional\getStyle(), PHPExcel_Style_Alignment\HORIZONTAL_CENTER, PHPExcel_Style_Alignment\HORIZONTAL_CENTER_CONTINUOUS, PHPExcel_Style_Alignment\HORIZONTAL_GENERAL, PHPExcel_Style_Alignment\HORIZONTAL_JUSTIFY, PHPExcel_Style_Alignment\HORIZONTAL_LEFT, PHPExcel_Style_Alignment\HORIZONTAL_RIGHT, PHPExcel_Style_Conditional\OPERATOR_BETWEEN, PHPExcel_Style_Conditional\OPERATOR_EQUAL, PHPExcel_Style_Conditional\OPERATOR_GREATERTHAN, PHPExcel_Style_Conditional\OPERATOR_GREATERTHANOREQUAL, PHPExcel_Style_Conditional\OPERATOR_LESSTHAN, PHPExcel_Style_Conditional\OPERATOR_LESSTHANOREQUAL, PHPExcel_Style_Conditional\OPERATOR_NONE, PHPExcel_Style_Conditional\OPERATOR_NOTEQUAL, PHPExcel_Style_Protection\PROTECTION_PROTECTED, PHPExcel_Style_Font\UNDERLINE_DOUBLE, PHPExcel_Style_Font\UNDERLINE_DOUBLEACCOUNTING, PHPExcel_Style_Font\UNDERLINE_NONE, PHPExcel_Style_Font\UNDERLINE_SINGLE, PHPExcel_Style_Font\UNDERLINE_SINGLEACCOUNTING, PHPExcel_Shared_String\UTF8toBIFF8UnicodeLong(), PHPExcel_Style_Alignment\VERTICAL_BOTTOM, PHPExcel_Style_Alignment\VERTICAL_CENTER, PHPExcel_Style_Alignment\VERTICAL_JUSTIFY, and PHPExcel_Style_Alignment\VERTICAL_TOP.
Referenced by close().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ _writeColinfo()
|
private |
Write BIFF record COLINFO to define column widths.
Note: The SDK says the record length is 0x0B but Excel writes a 0x0C length record.
- Parameters
-
array $col_array This is the only parameter received and is composed of the following: 0 => First formatted column, 1 => Last formatted column, 2 => Col width (8.43 is Excel default), 3 => The optional XF format of the column, 4 => Option flags. 5 => Optional outline level
Definition at line 1391 of file Worksheet.php.
References $data, $header, $length, $record, and PHPExcel_Writer_Excel5_BIFFwriter\_append().
Referenced by close().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ _writeDataValidity()
|
private |
Store the DATAVALIDATIONS and DATAVALIDATION records.
Definition at line 2816 of file Worksheet.php.
References $data, $error, $header, $length, $options, $record, $type, PHPExcel_Writer_Excel5_BIFFwriter\_append(), _writeBIFF8CellRangeAddressFixed(), PHPExcel_Cell_DataValidation\OPERATOR_BETWEEN, PHPExcel_Cell_DataValidation\OPERATOR_EQUAL, PHPExcel_Cell_DataValidation\OPERATOR_GREATERTHAN, PHPExcel_Cell_DataValidation\OPERATOR_GREATERTHANOREQUAL, PHPExcel_Cell_DataValidation\OPERATOR_LESSTHAN, PHPExcel_Cell_DataValidation\OPERATOR_LESSTHANOREQUAL, PHPExcel_Cell_DataValidation\OPERATOR_NOTBETWEEN, PHPExcel_Cell_DataValidation\OPERATOR_NOTEQUAL, PHPExcel_Cell_DataValidation\STYLE_INFORMATION, PHPExcel_Cell_DataValidation\STYLE_STOP, PHPExcel_Cell_DataValidation\STYLE_WARNING, PHPExcel_Cell_DataValidation\TYPE_CUSTOM, PHPExcel_Cell_DataValidation\TYPE_DATE, PHPExcel_Cell_DataValidation\TYPE_DECIMAL, PHPExcel_Cell_DataValidation\TYPE_LIST, PHPExcel_Cell_DataValidation\TYPE_NONE, PHPExcel_Cell_DataValidation\TYPE_TEXTLENGTH, PHPExcel_Cell_DataValidation\TYPE_TIME, PHPExcel_Cell_DataValidation\TYPE_WHOLE, and PHPExcel_Shared_String\UTF8toBIFF8UnicodeLong().
Referenced by close().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ _writeDefaultRowHeight()
|
private |
Write BIFF record DEFAULTROWHEIGHT.
Definition at line 1343 of file Worksheet.php.
References $data, $header, $length, $record, and PHPExcel_Writer_Excel5_BIFFwriter\_append().
Referenced by close().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ _writeDefcol()
|
private |
Write BIFF record DEFCOLWIDTH if COLINFO records are in use.
Definition at line 1365 of file Worksheet.php.
References $data, $header, $length, $record, and PHPExcel_Writer_Excel5_BIFFwriter\_append().
Referenced by close().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ _writeDimensions()
|
private |
Writes Excel DIMENSIONS to define the area in which there is data.
Definition at line 1269 of file Worksheet.php.
References $data, $header, $length, $record, and PHPExcel_Writer_Excel5_BIFFwriter\_append().
Referenced by close().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ _writeExterncount()
|
private |
Write BIFF record EXTERNCOUNT to indicate the number of external sheet references in a worksheet.
Excel only stores references to external sheets that are used in formulas. For simplicity we store references to all the sheets in the workbook regardless of whether they are used or not. This reduces the overall complexity and eliminates the need for a two way dialogue between the formula parser the worksheet objects.
- Parameters
-
integer $count The number of external sheet references in this worksheet
Definition at line 1685 of file Worksheet.php.
References $data, $header, $length, $record, and PHPExcel_Writer_Excel5_BIFFwriter\_append().
Here is the call graph for this function:
◆ _writeExternsheet()
|
private |
Writes the Excel BIFF EXTERNSHEET record.
These references are used by formulas. A formula references a sheet name via an index. Since we store a reference to all of the external worksheets the EXTERNSHEET index is the same as the worksheet index.
- Parameters
-
string $sheetname The name of a external worksheet
Definition at line 1703 of file Worksheet.php.
References $data, $header, $length, $record, and PHPExcel_Writer_Excel5_BIFFwriter\_append().
Here is the call graph for this function:
◆ _writeFooter()
|
private |
Store the footer caption BIFF record.
Definition at line 1904 of file Worksheet.php.
References $header, $length, $record, PHPExcel_Writer_Excel5_BIFFwriter\_append(), and PHPExcel_Shared_String\UTF8toBIFF8UnicodeLong().
Referenced by close().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ _writeFormula()
|
private |
Write a formula to the specified row and column (zero indexed).
The textual representation of the formula is passed to the parser in Parser.php which returns a packed binary string.
Returns 0 : normal termination -1 : formula errors (bad formula) -2 : row or column out of range
- Parameters
-
integer $row Zero indexed row integer $col Zero indexed column string $formula The formula text string mixed $xfIndex The XF format index mixed $calculatedValue Calculated value
- Returns
- integer
Definition at line 866 of file Worksheet.php.
References $data, $error, $header, $length, $record, $row, PHPExcel_Writer_Excel5_BIFFwriter\_append(), _writeString(), _writeStringRecord(), and PHPExcel_Cell_DataType\getErrorCodes().
Referenced by close().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ _writeGridset()
|
private |
Write the GRIDSET BIFF record.
Must be used in conjunction with the PRINTGRIDLINES record.
Definition at line 2069 of file Worksheet.php.
References $data, $header, $length, $record, and PHPExcel_Writer_Excel5_BIFFwriter\_append().
Referenced by close().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ _writeGuts()
|
private |
Write the GUTS BIFF record.
This is used to configure the gutter margins where Excel outline symbols are displayed. The visibility of the gutters is controlled by a flag in WSBOOL.
- See also
- _writeWsbool()
Definition at line 2103 of file Worksheet.php.
References $data, $header, $i, $length, $record, and PHPExcel_Writer_Excel5_BIFFwriter\_append().
Referenced by close().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ _writeHcenter()
|
private |
Store the horizontal centering HCENTER BIFF record.
private
Definition at line 1930 of file Worksheet.php.
References $data, $header, $length, $record, and PHPExcel_Writer_Excel5_BIFFwriter\_append().
Referenced by close().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ _writeHeader()
|
private |
Store the header caption BIFF record.
Definition at line 1880 of file Worksheet.php.
References $header, $length, $record, PHPExcel_Writer_Excel5_BIFFwriter\_append(), and PHPExcel_Shared_String\UTF8toBIFF8UnicodeLong().
Referenced by close().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ _writeLabel()
|
private |
Write a string to the specified row and column (zero indexed).
NOTE: there is an Excel 5 defined limit of 255 characters. $format is optional. Returns 0 : normal termination -2 : row or column out of range -3 : long string truncated to 255 chars
public
- Parameters
-
integer $row Zero indexed row integer $col Zero indexed column string $str The string to write mixed $xfIndex The XF format index for the cell
- Returns
- integer
Definition at line 719 of file Worksheet.php.
References $_xls_strmax, $data, $header, $length, $record, $row, and PHPExcel_Writer_Excel5_BIFFwriter\_append().
Here is the call graph for this function:
◆ _writeLabelSst()
|
private |
Write a string to the specified row and column (zero indexed).
This is the BIFF8 version (no 255 chars limit). $format is optional. Returns 0 : normal termination -2 : row or column out of range -3 : long string truncated to 255 chars
public
- Parameters
-
integer $row Zero indexed row integer $col Zero indexed column string $str The string to write mixed $xfIndex The XF format index for the cell
- Returns
- integer
Definition at line 755 of file Worksheet.php.
References $data, $header, $length, $record, $row, PHPExcel_Writer_Excel5_BIFFwriter\_append(), and PHPExcel_Shared_String\UTF8toBIFF8UnicodeLong().
Referenced by _writeString().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ _writeMarginBottom()
|
private |
Store the BOTTOMMARGIN BIFF record.
Definition at line 2018 of file Worksheet.php.
References $data, $header, $length, $record, and PHPExcel_Writer_Excel5_BIFFwriter\_append().
Referenced by close().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ _writeMarginLeft()
|
private |
Store the LEFTMARGIN BIFF record.
Definition at line 1961 of file Worksheet.php.
References $data, $header, $length, $record, and PHPExcel_Writer_Excel5_BIFFwriter\_append().
Referenced by close().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ _writeMarginRight()
|
private |
Store the RIGHTMARGIN BIFF record.
Definition at line 1980 of file Worksheet.php.
References $data, $header, $length, $record, and PHPExcel_Writer_Excel5_BIFFwriter\_append().
Referenced by close().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ _writeMarginTop()
|
private |
Store the TOPMARGIN BIFF record.
Definition at line 1999 of file Worksheet.php.
References $data, $header, $length, $record, and PHPExcel_Writer_Excel5_BIFFwriter\_append().
Referenced by close().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ _writeMergedCells()
|
private |
Store the MERGEDCELLS records for all ranges of merged cells.
Definition at line 1503 of file Worksheet.php.
References $header, $i, $length, $record, PHPExcel_Writer_Excel5_BIFFwriter\_append(), PHPExcel_Cell\columnIndexFromString(), PHPExcel_Cell\coordinateFromString(), and PHPExcel_Cell\splitRange().
Referenced by close().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ _writeMsoDrawing()
|
private |
Write MSODRAWING record.
Definition at line 2733 of file Worksheet.php.
References $data, $header, $i, $length, $record, and PHPExcel_Writer_Excel5_BIFFwriter\_append().
Referenced by close().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ _writeNote()
|
private |
Writes a note associated with the cell given by the row and column.
NOTE records don't have a length limit.
- Parameters
-
integer $row Zero indexed row integer $col Zero indexed column string $note The note to write
Definition at line 781 of file Worksheet.php.
References $data, $header, $i, $length, $record, $row, and PHPExcel_Writer_Excel5_BIFFwriter\_append().
Here is the call graph for this function:
◆ _writeNumber()
|
private |
Write a double to the specified row and column (zero indexed).
An integer can be written as a double. Excel will display an integer. $format is optional.
Returns 0 : normal termination -2 : row or column out of range
- Parameters
-
integer $row Zero indexed row integer $col Zero indexed column float $num The number to write mixed $xfIndex The optional XF format
- Returns
- integer
Definition at line 650 of file Worksheet.php.
References $data, $header, $length, $record, $row, and PHPExcel_Writer_Excel5_BIFFwriter\_append().
Referenced by close().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ _writeObjectProtect()
|
private |
Write OBJECTPROTECT.
Definition at line 2312 of file Worksheet.php.
References $data, $header, $length, $record, and PHPExcel_Writer_Excel5_BIFFwriter\_append().
Referenced by close().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ _writeObjPicture()
|
private |
Store the OBJ record that precedes an IMDATA record.
This could be generalise to support other Excel objects.
- Parameters
-
integer $colL Column containing upper left corner of object integer $dxL Distance from left side of cell integer $rwT Row containing top left corner of object integer $dyT Distance from top of cell integer $colR Column containing lower right corner of object integer $dxR Distance from right of cell integer $rwB Row containing bottom right corner of object integer $dyB Distance from bottom of cell
Definition at line 2510 of file Worksheet.php.
References $data, $header, $id, $length, $record, and PHPExcel_Writer_Excel5_BIFFwriter\_append().
Referenced by _positionImage().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ _writePageLayoutView()
|
private |
Write PLV Record.
Definition at line 2993 of file Worksheet.php.
References $data, $header, $length, $record, PHPExcel_Writer_Excel5_BIFFwriter\_append(), and PHPExcel_Worksheet_SheetView\SHEETVIEW_PAGE_LAYOUT.
Referenced by close().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ _writePanes()
|
private |
Writes the Excel BIFF PANE record.
The panes can either be frozen or thawed (unfrozen). Frozen panes are specified in terms of an integer number of rows and columns. Thawed panes are specified in terms of Excel's units for rows and columns.
Definition at line 1732 of file Worksheet.php.
References $column, $data, $header, $length, $record, $row, $x, $y, PHPExcel_Writer_Excel5_BIFFwriter\_append(), array, PHPExcel_Cell\columnIndexFromString(), and PHPExcel_Cell\coordinateFromString().
Referenced by close().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ _writePassword()
|
private |
Write the worksheet PASSWORD record.
Definition at line 2336 of file Worksheet.php.
References $data, $header, $length, $record, and PHPExcel_Writer_Excel5_BIFFwriter\_append().
Referenced by close().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ _writePrintGridlines()
|
private |
Write the PRINTGRIDLINES BIFF record.
Must be used in conjunction with the GRIDSET record.
Definition at line 2053 of file Worksheet.php.
References $data, $header, $length, $record, and PHPExcel_Writer_Excel5_BIFFwriter\_append().
Referenced by close().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ _writePrintHeaders()
|
private |
Write the PRINTHEADERS BIFF record.
Definition at line 2037 of file Worksheet.php.
References $data, $header, $length, $record, and PHPExcel_Writer_Excel5_BIFFwriter\_append().
Referenced by close().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ _writeProtect()
|
private |
Set the Biff PROTECT record to indicate that the worksheet is protected.
Definition at line 2267 of file Worksheet.php.
References $data, $header, $length, $record, and PHPExcel_Writer_Excel5_BIFFwriter\_append().
Referenced by close().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ _writeRangeProtection()
|
private |
Write BIFF record RANGEPROTECTION.
Openoffice.org's Documentaion of the Microsoft Excel File Format uses term RANGEPROTECTION for these records Microsoft Office Excel 97-2007 Binary File Format Specification uses term FEAT for these records
Definition at line 1631 of file Worksheet.php.
References $header, $length, $password, $record, PHPExcel_Writer_Excel5_BIFFwriter\_append(), _writeBIFF8CellRangeAddressFixed(), and PHPExcel_Shared_String\UTF8toBIFF8UnicodeLong().
Referenced by close().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ _writeRichTextString()
|
private |
Write a LABELSST record or a LABEL record.
Which one depends on BIFF version It differs from _writeString by the writing of rich text strings.
- Parameters
-
int $row Row index (0-based) int $col Column index (0-based) string $str The string mixed $xfIndex The XF format index for the cell array $arrcRun Index to Font record and characters beginning
Definition at line 688 of file Worksheet.php.
References $data, $header, $length, $record, $row, PHPExcel_Writer_Excel5_BIFFwriter\_append(), and PHPExcel_Shared_String\UTF8toBIFF8UnicodeShort().
Referenced by close().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ _writeRow()
|
private |
This method is used to set the height and format for a row.
- Parameters
-
integer $row The row to set integer $height Height we are giving to the row. Use null to set XF without setting height integer $xfIndex The optional cell style Xf index to apply to the columns bool $hidden The optional hidden attribute integer $level The optional outline level for row, in range [0,7]
Definition at line 1219 of file Worksheet.php.
References $data, $header, $length, $record, $row, and PHPExcel_Writer_Excel5_BIFFwriter\_append().
Referenced by close().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ _writeScenProtect()
|
private |
Write SCENPROTECT.
Definition at line 2288 of file Worksheet.php.
References $data, $header, $length, $record, and PHPExcel_Writer_Excel5_BIFFwriter\_append().
Referenced by close().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ _writeSelection()
|
private |
Write BIFF record SELECTION.
Definition at line 1439 of file Worksheet.php.
References $_active_pane, $data, $header, $length, $record, PHPExcel_Writer_Excel5_BIFFwriter\_append(), array, PHPExcel_Cell\columnIndexFromString(), PHPExcel_Cell\coordinateFromString(), and PHPExcel_Cell\splitRange().
Referenced by close().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ _writeSetup()
|
private |
Store the page setup SETUP BIFF record.
Definition at line 1812 of file Worksheet.php.
References $header, $length, $record, PHPExcel_Writer_Excel5_BIFFwriter\_append(), and PHPExcel_Worksheet_PageSetup\ORIENTATION_LANDSCAPE.
Referenced by close().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ _writeSheetLayout()
|
private |
Write SHEETLAYOUT record.
Definition at line 1557 of file Worksheet.php.
References $header, $length, $record, and PHPExcel_Writer_Excel5_BIFFwriter\_append().
Referenced by close().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ _writeSheetProtection()
|
private |
Write SHEETPROTECTION.
Definition at line 1584 of file Worksheet.php.
References $header, $length, $options, $record, and PHPExcel_Writer_Excel5_BIFFwriter\_append().
Referenced by close().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ _writeString()
|
private |
Write a LABELSST record or a LABEL record.
Which one depends on BIFF version
- Parameters
-
int $row Row index (0-based) int $col Column index (0-based) string $str The string int $xfIndex Index to XF record
Definition at line 674 of file Worksheet.php.
References $row, and _writeLabelSst().
Referenced by _writeFormula(), and close().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ _writeStringRecord()
|
private |
Write a STRING record.
This
- Parameters
-
string $stringValue
Definition at line 948 of file Worksheet.php.
References $data, $header, $length, $record, PHPExcel_Writer_Excel5_BIFFwriter\_append(), and PHPExcel_Shared_String\UTF8toBIFF8UnicodeLong().
Referenced by _writeFormula().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ _writeUrl()
|
private |
Write a hyperlink.
This is comprised of two elements: the visible label and the invisible link. The visible label is the same as the link unless an alternative string is specified. The label is written using the _writeString() method. Therefore the 255 characters string limit applies. $string and $format are optional.
The hyperlink can be to a http, ftp, mail, internal sheet (not yet), or external directory url.
Returns 0 : normal termination -2 : row or column out of range -3 : long string truncated to 255 chars
- Parameters
-
integer $row Row integer $col Column string $url URL string
- Returns
- integer
Definition at line 979 of file Worksheet.php.
References $row, $url, and _writeUrlRange().
Referenced by close().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ _writeUrlExternal()
| PHPExcel_Writer_Excel5_Worksheet::_writeUrlExternal | ( | $row1, | |
| $col1, | |||
| $row2, | |||
| $col2, | |||
| $url | |||
| ) |
Write links to external directory names such as 'c:.xls', c:.xls::Sheet1!A1', '../../foo.xls'.
and '../../foo.xls::Sheet1!A1'.
Note: Excel writes some relative links with the $dir_long string. We ignore these cases for the sake of simpler code.
private
- See also
- _writeUrl()
- Parameters
-
integer $row1 Start row integer $col1 Start column integer $row2 End row integer $col2 End column string $url URL string
- Returns
- integer
Definition at line 1124 of file Worksheet.php.
Referenced by _writeUrlRange().
Here is the caller graph for this function:
◆ _writeUrlInternal()
| PHPExcel_Writer_Excel5_Worksheet::_writeUrlInternal | ( | $row1, | |
| $col1, | |||
| $row2, | |||
| $col2, | |||
| $url | |||
| ) |
Used to write internal reference hyperlinks such as "Sheet1!A1".
private
- See also
- _writeUrl()
- Parameters
-
integer $row1 Start row integer $col1 Start column integer $row2 End row integer $col2 End column string $url URL string
- Returns
- integer
Definition at line 1071 of file Worksheet.php.
References $data, $header, $length, $options, $record, $unknown1, $url, PHPExcel_Writer_Excel5_BIFFwriter\_append(), PHPExcel_Shared_String\ConvertEncoding(), and PHPExcel_Shared_String\CountCharacters().
Referenced by _writeUrlRange().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ _writeUrlRange()
| PHPExcel_Writer_Excel5_Worksheet::_writeUrlRange | ( | $row1, | |
| $col1, | |||
| $row2, | |||
| $col2, | |||
| $url | |||
| ) |
This is the more general form of _writeUrl().
It allows a hyperlink to be written to a range of cells. This function also decides the type of hyperlink to be written. These are either, Web (http, ftp, mailto), Internal (Sheet1!A1) or external ('c:.xls::Sheet1!A1').
private
- See also
- _writeUrl()
- Parameters
-
integer $row1 Start row integer $col1 Start column integer $row2 End row integer $col2 End column string $url URL string
- Returns
- integer
Definition at line 1000 of file Worksheet.php.
References $url, _writeUrlExternal(), _writeUrlInternal(), and _writeUrlWeb().
Referenced by _writeUrl().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ _writeUrlWeb()
| PHPExcel_Writer_Excel5_Worksheet::_writeUrlWeb | ( | $row1, | |
| $col1, | |||
| $row2, | |||
| $col2, | |||
| $url | |||
| ) |
Used to write http, ftp and mailto hyperlinks.
The link type ($options) is 0x03 is the same as absolute dir ref without sheet. However it is differentiated by the $unknown2 data stream.
private
- See also
- _writeUrl()
- Parameters
-
integer $row1 Start row integer $col1 Start column integer $row2 End row integer $col2 End column string $url URL string
- Returns
- integer
Definition at line 1026 of file Worksheet.php.
References $data, $header, $length, $options, $record, $unknown1, $unknown2, $url, and PHPExcel_Writer_Excel5_BIFFwriter\_append().
Referenced by _writeUrlRange().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ _writeVcenter()
|
private |
Store the vertical centering VCENTER BIFF record.
Definition at line 1946 of file Worksheet.php.
References $data, $header, $length, $record, and PHPExcel_Writer_Excel5_BIFFwriter\_append().
Referenced by close().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ _writeWindow2()
|
private |
Write BIFF record Window2.
Definition at line 1289 of file Worksheet.php.
References $_outline_on, $data, $header, $length, $record, PHPExcel_Writer_Excel5_BIFFwriter\_append(), and PHPExcel_Worksheet_SheetView\SHEETVIEW_PAGE_BREAK_PREVIEW.
Referenced by close().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ _writeWsbool()
|
private |
Write the WSBOOL BIFF record, mainly for fit-to-page.
Used in conjunction with the SETUP record.
Definition at line 2147 of file Worksheet.php.
References $data, $header, $length, $record, and PHPExcel_Writer_Excel5_BIFFwriter\_append().
Referenced by close().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ _writeZoom()
|
private |
Store the window zoom factor.
This should be a reduced fraction but for simplicity we will store all fractions with a numerator of 100.
Definition at line 2695 of file Worksheet.php.
References $data, $header, $length, $record, and PHPExcel_Writer_Excel5_BIFFwriter\_append().
Referenced by close().
Here is the call graph for this function:
Here is the caller graph for this function:
◆ close()
| PHPExcel_Writer_Excel5_Worksheet::close | ( | ) |
Add data to the beginning of the workbook (note the reverse order) and to the end of the workbook.
public
- See also
- PHPExcel_Writer_Excel5_Workbook::storeWorkbook()
Definition at line 276 of file Worksheet.php.
References $_phpSheet, $column, $conditionalStyles, $i, $row, $url, PHPExcel_Writer_Excel5_BIFFwriter\_storeBof(), PHPExcel_Writer_Excel5_BIFFwriter\_storeEof(), _writeAutoFilterInfo(), _writeBlank(), _writeBoolErr(), _writeBreaks(), _writeCFHeader(), _writeCFRule(), _writeColinfo(), _writeDataValidity(), _writeDefaultRowHeight(), _writeDefcol(), _writeDimensions(), _writeFooter(), _writeFormula(), _writeGridset(), _writeGuts(), _writeHcenter(), _writeHeader(), _writeMarginBottom(), _writeMarginLeft(), _writeMarginRight(), _writeMarginTop(), _writeMergedCells(), _writeMsoDrawing(), _writeNumber(), _writeObjectProtect(), _writePageLayoutView(), _writePanes(), _writePassword(), _writePrintGridlines(), _writePrintHeaders(), _writeProtect(), _writeRangeProtection(), _writeRichTextString(), _writeRow(), _writeScenProtect(), _writeSelection(), _writeSetup(), _writeSheetLayout(), _writeSheetProtection(), _writeString(), _writeUrl(), _writeVcenter(), _writeWindow2(), _writeWsbool(), _writeZoom(), array, PHPExcel_Cell\columnIndexFromString(), PHPExcel_Style_Conditional\CONDITION_CELLIS, PHPExcel_Style_Conditional\CONDITION_EXPRESSION, PHPExcel_Cell\coordinateFromString(), PHPExcel_Shared_String\CountCharacters(), PHPExcel_Shared_Font\getDefaultColumnWidthByFont(), PHPExcel_Cell\stringFromColumnIndex(), PHPExcel_Cell_DataType\TYPE_BOOL, PHPExcel_Cell_DataType\TYPE_ERROR, PHPExcel_Cell_DataType\TYPE_FORMULA, PHPExcel_Cell_DataType\TYPE_NULL, PHPExcel_Cell_DataType\TYPE_NUMERIC, and PHPExcel_Cell_DataType\TYPE_STRING.
Here is the call graph for this function:
◆ getData()
| PHPExcel_Writer_Excel5_Worksheet::getData | ( | ) |
Retrieves data from memory in one chunk, or from disk in $buffer sized chunks.
- Returns
- string The data
Definition at line 589 of file Worksheet.php.
References PHPExcel_Writer_Excel5_BIFFwriter\$_data.
◆ getEscher()
| PHPExcel_Writer_Excel5_Worksheet::getEscher | ( | ) |
Get Escher object.
- Returns
- PHPExcel_Shared_Escher
Definition at line 2715 of file Worksheet.php.
References $_escher.
◆ insertBitmap()
| PHPExcel_Writer_Excel5_Worksheet::insertBitmap | ( | $row, | |
| $col, | |||
| $bitmap, | |||
$x = 0, |
|||
$y = 0, |
|||
$scale_x = 1, |
|||
$scale_y = 1 |
|||
| ) |
Insert a 24bit bitmap image in a worksheet.
public
- Parameters
-
integer $row The row we are going to insert the bitmap into integer $col The column we are going to insert the bitmap into mixed $bitmap The bitmap filename or GD-image resource integer $x The horizontal position (offset) of the image inside the cell. integer $y The vertical position (offset) of the image inside the cell. float $scale_x The horizontal scale float $scale_y The vertical scale
Definition at line 2366 of file Worksheet.php.
References $data, $env, $header, $length, $record, $row, $size, $x, $y, PHPExcel_Writer_Excel5_BIFFwriter\_append(), _positionImage(), _processBitmap(), and _processBitmapGd().
Here is the call graph for this function:
◆ printRowColHeaders()
| PHPExcel_Writer_Excel5_Worksheet::printRowColHeaders | ( | $print = 1 | ) |
Set the option to print the row and column headers on the printed page.
public
- Parameters
-
integer $print Whether to print the headers or not. Defaults to 1 (print).
Definition at line 609 of file Worksheet.php.
◆ setEscher()
| PHPExcel_Writer_Excel5_Worksheet::setEscher | ( | PHPExcel_Shared_Escher | $pValue = null | ) |
Set Escher object.
- Parameters
-
PHPExcel_Shared_Escher $pValue
Definition at line 2725 of file Worksheet.php.
◆ setOutline()
| PHPExcel_Writer_Excel5_Worksheet::setOutline | ( | $visible = true, |
|
$symbols_below = true, |
|||
$symbols_right = true, |
|||
$auto_style = false |
|||
| ) |
This method sets the properties for outlining and grouping.
The defaults correspond to Excel's defaults.
- Parameters
-
bool $visible bool $symbols_below bool $symbols_right bool $auto_style
Definition at line 623 of file Worksheet.php.
Field Documentation
◆ $_active_pane
| PHPExcel_Writer_Excel5_Worksheet::$_active_pane |
Definition at line 102 of file Worksheet.php.
Referenced by _writeSelection().
◆ $_colinfo
| PHPExcel_Writer_Excel5_Worksheet::$_colinfo |
Definition at line 90 of file Worksheet.php.
◆ $_colors
|
private |
Color cache.
Definition at line 149 of file Worksheet.php.
◆ $_countCellStyleXfs
|
private |
Definition at line 186 of file Worksheet.php.
◆ $_escher
|
private |
Definition at line 193 of file Worksheet.php.
Referenced by getEscher().
◆ $_firstColumnIndex
|
private |
Definition at line 167 of file Worksheet.php.
◆ $_firstRowIndex
|
private |
Definition at line 155 of file Worksheet.php.
◆ $_fntHashIndex
| PHPExcel_Writer_Excel5_Worksheet::$_fntHashIndex |
Definition at line 200 of file Worksheet.php.
◆ $_lastColumnIndex
|
private |
Definition at line 173 of file Worksheet.php.
◆ $_lastRowIndex
|
private |
Definition at line 161 of file Worksheet.php.
◆ $_outline_below
| PHPExcel_Writer_Excel5_Worksheet::$_outline_below |
Definition at line 120 of file Worksheet.php.
◆ $_outline_on
| PHPExcel_Writer_Excel5_Worksheet::$_outline_on |
Definition at line 108 of file Worksheet.php.
Referenced by _writeWindow2().
◆ $_outline_right
| PHPExcel_Writer_Excel5_Worksheet::$_outline_right |
Definition at line 126 of file Worksheet.php.
◆ $_outline_style
| PHPExcel_Writer_Excel5_Worksheet::$_outline_style |
Definition at line 114 of file Worksheet.php.
◆ $_parser
|
private |
Definition at line 78 of file Worksheet.php.
◆ $_phpSheet
| PHPExcel_Writer_Excel5_Worksheet::$_phpSheet |
Definition at line 179 of file Worksheet.php.
Referenced by close().
◆ $_selection
| PHPExcel_Writer_Excel5_Worksheet::$_selection |
Definition at line 96 of file Worksheet.php.
◆ $_str_table
| PHPExcel_Writer_Excel5_Worksheet::$_str_table |
Definition at line 144 of file Worksheet.php.
◆ $_str_total
| PHPExcel_Writer_Excel5_Worksheet::$_str_total |
Definition at line 132 of file Worksheet.php.
◆ $_str_unique
| PHPExcel_Writer_Excel5_Worksheet::$_str_unique |
Definition at line 138 of file Worksheet.php.
◆ $_xls_strmax
| PHPExcel_Writer_Excel5_Worksheet::$_xls_strmax |
Definition at line 84 of file Worksheet.php.
Referenced by _writeLabel().
◆ $absolute
| PHPExcel_Writer_Excel5_Worksheet::$absolute = 0x00 |
Definition at line 1145 of file Worksheet.php.
◆ $data
| PHPExcel_Writer_Excel5_Worksheet::$data |
Definition at line 1185 of file Worksheet.php.
Referenced by _processBitmap(), _processBitmapGd(), _writeAutoFilterInfo(), _writeBlank(), _writeBoolErr(), _writeBreaks(), _writeCFHeader(), _writeCFRule(), _writeColinfo(), _writeDataValidity(), _writeDefaultRowHeight(), _writeDefcol(), _writeDimensions(), _writeExterncount(), _writeExternsheet(), _writeFormula(), _writeGridset(), _writeGuts(), _writeHcenter(), _writeLabel(), _writeLabelSst(), _writeMarginBottom(), _writeMarginLeft(), _writeMarginRight(), _writeMarginTop(), _writeMsoDrawing(), _writeNote(), _writeNumber(), _writeObjectProtect(), _writeObjPicture(), _writePageLayoutView(), _writePanes(), _writePassword(), _writePrintGridlines(), _writePrintHeaders(), _writeProtect(), _writeRichTextString(), _writeRow(), _writeScenProtect(), _writeSelection(), _writeStringRecord(), _writeUrlInternal(), _writeUrlWeb(), _writeVcenter(), _writeWindow2(), _writeWsbool(), _writeZoom(), and insertBitmap().
◆ $dir_long
| PHPExcel_Writer_Excel5_Worksheet::$dir_long = $url |
Definition at line 1154 of file Worksheet.php.
◆ $dir_long_len
| PHPExcel_Writer_Excel5_Worksheet::$dir_long_len = pack("V", strlen($dir_long) ) |
Definition at line 1175 of file Worksheet.php.
◆ $dir_short
| PHPExcel_Writer_Excel5_Worksheet::$dir_short = preg_replace("/\.\.\\\/", '', $dir_long) . "\0" |
Definition at line 1168 of file Worksheet.php.
◆ $dir_short_len
| PHPExcel_Writer_Excel5_Worksheet::$dir_short_len = pack("V", strlen($dir_short) ) |
Definition at line 1174 of file Worksheet.php.
◆ $header
| PHPExcel_Writer_Excel5_Worksheet::$header = pack("vv", $record, $length) |
Definition at line 1202 of file Worksheet.php.
Referenced by _processBitmap(), _writeAutoFilterInfo(), _writeBlank(), _writeBoolErr(), _writeBreaks(), _writeCFHeader(), _writeCFRule(), _writeColinfo(), _writeDataValidity(), _writeDefaultRowHeight(), _writeDefcol(), _writeDimensions(), _writeExterncount(), _writeExternsheet(), _writeFooter(), _writeFormula(), _writeGridset(), _writeGuts(), _writeHcenter(), _writeHeader(), _writeLabel(), _writeLabelSst(), _writeMarginBottom(), _writeMarginLeft(), _writeMarginRight(), _writeMarginTop(), _writeMergedCells(), _writeMsoDrawing(), _writeNote(), _writeNumber(), _writeObjectProtect(), _writeObjPicture(), _writePageLayoutView(), _writePanes(), _writePassword(), _writePrintGridlines(), _writePrintHeaders(), _writeProtect(), _writeRangeProtection(), _writeRichTextString(), _writeRow(), _writeScenProtect(), _writeSelection(), _writeSetup(), _writeSheetLayout(), _writeSheetProtection(), _writeStringRecord(), _writeUrlInternal(), _writeUrlWeb(), _writeVcenter(), _writeWindow2(), _writeWsbool(), _writeZoom(), and insertBitmap().
◆ $length
| PHPExcel_Writer_Excel5_Worksheet::$length = 0x00000 |
Definition at line 1133 of file Worksheet.php.
Referenced by _writeAutoFilterInfo(), _writeBlank(), _writeBoolErr(), _writeBreaks(), _writeCFHeader(), _writeColinfo(), _writeDataValidity(), _writeDefaultRowHeight(), _writeDefcol(), _writeDimensions(), _writeExterncount(), _writeExternsheet(), _writeFooter(), _writeFormula(), _writeGridset(), _writeGuts(), _writeHcenter(), _writeHeader(), _writeLabel(), _writeLabelSst(), _writeMarginBottom(), _writeMarginLeft(), _writeMarginRight(), _writeMarginTop(), _writeMergedCells(), _writeMsoDrawing(), _writeNote(), _writeNumber(), _writeObjectProtect(), _writeObjPicture(), _writePageLayoutView(), _writePanes(), _writePassword(), _writePrintGridlines(), _writePrintHeaders(), _writeProtect(), _writeRangeProtection(), _writeRichTextString(), _writeRow(), _writeScenProtect(), _writeSelection(), _writeSetup(), _writeSheetLayout(), _writeSheetProtection(), _writeStringRecord(), _writeUrlInternal(), _writeUrlWeb(), _writeVcenter(), _writeWindow2(), _writeWsbool(), _writeZoom(), and insertBitmap().
◆ $link_type [1/2]
| if (preg_match('/^ PHPExcel_Writer_Excel5_Worksheet::$link_type[A-Z]:/', $url)) = 0x01 | $absolute |
Definition at line 1149 of file Worksheet.php.
◆ $link_type [2/2]
| if (preg_match("/\/", $url)) PHPExcel_Writer_Excel5_Worksheet::$link_type = pack("V", $link_type) |
Definition at line 1161 of file Worksheet.php.
◆ $record
| PHPExcel_Writer_Excel5_Worksheet::$record = 0x01B8 |
Definition at line 1132 of file Worksheet.php.
Referenced by _writeAutoFilterInfo(), _writeBlank(), _writeBoolErr(), _writeBreaks(), _writeCFHeader(), _writeCFRule(), _writeColinfo(), _writeDataValidity(), _writeDefaultRowHeight(), _writeDefcol(), _writeDimensions(), _writeExterncount(), _writeExternsheet(), _writeFooter(), _writeFormula(), _writeGridset(), _writeGuts(), _writeHcenter(), _writeHeader(), _writeLabel(), _writeLabelSst(), _writeMarginBottom(), _writeMarginLeft(), _writeMarginRight(), _writeMarginTop(), _writeMergedCells(), _writeMsoDrawing(), _writeNote(), _writeNumber(), _writeObjectProtect(), _writeObjPicture(), _writePageLayoutView(), _writePanes(), _writePassword(), _writePrintGridlines(), _writePrintHeaders(), _writeProtect(), _writeRangeProtection(), _writeRichTextString(), _writeRow(), _writeScenProtect(), _writeSelection(), _writeSetup(), _writeSheetLayout(), _writeSheetProtection(), _writeStringRecord(), _writeUrlInternal(), _writeUrlWeb(), _writeVcenter(), _writeWindow2(), _writeWsbool(), _writeZoom(), and insertBitmap().
◆ $stream_len
| PHPExcel_Writer_Excel5_Worksheet::$stream_len = pack("V", 0) |
Definition at line 1176 of file Worksheet.php.
◆ $unknown1
| PHPExcel_Writer_Excel5_Worksheet::$unknown1 = pack("H*",'D0C9EA79F9BACE118C8200AA004BA90B02000000' ) |
Definition at line 1179 of file Worksheet.php.
Referenced by _writeUrlInternal(), and _writeUrlWeb().
◆ $unknown2
| PHPExcel_Writer_Excel5_Worksheet::$unknown2 = pack("H*",'0303000000000000C000000000000046' ) |
Definition at line 1180 of file Worksheet.php.
Referenced by _writeUrlWeb().
◆ $unknown3
| PHPExcel_Writer_Excel5_Worksheet::$unknown3 = pack("H*",'FFFFADDE000000000000000000000000000000000000000') |
Definition at line 1181 of file Worksheet.php.
◆ $unknown4
| PHPExcel_Writer_Excel5_Worksheet::$unknown4 = pack("v", 0x03 ) |
Definition at line 1182 of file Worksheet.php.
◆ $up_count
| PHPExcel_Writer_Excel5_Worksheet::$up_count = preg_match_all("/\.\.\\\/", $dir_long, $useless) |
Definition at line 1164 of file Worksheet.php.
◆ $url
| PHPExcel_Writer_Excel5_Worksheet::$url = preg_replace('/^external:/', '', $url) |
Definition at line 1137 of file Worksheet.php.
Referenced by _writeUrl(), _writeUrlInternal(), _writeUrlRange(), _writeUrlWeb(), and close().
◆ return
| PHPExcel_Writer_Excel5_Worksheet::return |
Definition at line 1206 of file Worksheet.php.
The documentation for this class was generated from the following file:
- libs/composer/vendor/phpoffice/phpexcel/Classes/PHPExcel/Writer/Excel5/Worksheet.php
