Spreadsheet_Excel_Writer_Workbook
Class for generating Excel Spreadsheets
Located in /web/plugin/feature/sms_excel/lib/external/Spreadsheet/Excel/Writer/Workbook.php (line 50)
PEAR | --Spreadsheet_Excel_Writer_BIFFwriter | --Spreadsheet_Excel_Writer_Workbook
| Class | Description |
|---|---|
Spreadsheet_Excel_Writer
|
Class for writing Excel Spreadsheets. This class should change COMPLETELY. |
integer
$_1904
(line 68)
Flag for 1904 date system (0 => base date is 1900, 1 => base date is 1904)
integer
$_activesheet
(line 74)
The active worksheet of the workbook (0 indexed)
integer
$_biffsize
(line 106)
The BIFF file size for the workbook.
integer
$_codepage
(line 154)
The codepage indicates the text encoding used for strings
integer
$_country_code
(line 160)
The country code used for localization
integer
$_fileclosed
(line 99)
Flag for preventing close from being called twice.
string
$_filename
(line 56)
Filename for the Workbook
integer
$_firstsheet
(line 80)
1st displayed worksheet in the workbook (0 indexed)
array
$_formats
(line 136)
Array containing references to all of this workbook's formats
array
$_palette
(line 142)
Array containing the colour palette
object Parser
$_parser
(line 62)
Formula parser
integer
$_selected
(line 86)
Number of workbook tabs selected
string
$_sheetname
(line 112)
The default sheetname for all sheets created.
array
$_sheetnames
(line 130)
Array of sheetnames for creating the EXTERNSHEET records
integer
$_string_sizeinfo_size
(line 166)
number of bytes for sizeinfo of strings
object Format
$_tmp_format
(line 118)
The default XF format.
object Format
$_url_format
(line 148)
The default format for URLs.
array
$_worksheets
(line 124)
Array containing references to all of this workbook's worksheets
integer
$_xf_index
(line 92)
Index for creating adding new formats to the workbook
Inherited Variables
Inherited from Spreadsheet_Excel_Writer_BIFFwriter
Class constructor
- string $filename: filename for storing the workbook. "-" for writing to stdout.
Add a new format to the Excel workbook.
Also, pass any properties to the Format constructor.
- array $properties: array with properties for initializing the format.
Add a new worksheet to the Excel workbook.
If no name is given the name of the worksheet will be Sheeti$i, with $i in [1..].
- string $name: the optional name of the worksheet
Calls finalization methods.
This method should always be the last one to be called on every workbook
Set the country identifier for the workbook
- integer $code: Is the international calling country code for the chosen country.
Change the RGB components of the elements in the colour palette.
- integer $index: colour index
- integer $red: red RGB value [0-255]
- integer $green: green RGB value [0-255]
- integer $blue: blue RGB value [0-255]
Sets the BIFF version.
This method exists just to access experimental functionality from BIFF8. It will be deprecated ! Only possible value is 8 (Excel 97/2000). For any other value it fails silently.
- integer $version: The BIFF version
An accessor for the _worksheets[] array Returns an array of the worksheet objects in a workbook It actually calls to worksheets()
An accessor for the _worksheets[] array.
Returns an array of the worksheet objects in a workbook
Inherited Methods
Inherited From Spreadsheet_Excel_Writer_BIFFwriter
Spreadsheet_Excel_Writer_BIFFwriter::Spreadsheet_Excel_Writer_BIFFwriter()
Spreadsheet_Excel_Writer_BIFFwriter::setTempDir()
Inherited From PEAR
Documentation generated on Wed, 09 Feb 2011 09:05:19 +0700 by phpDocumentor 1.4.2