Spreadsheet_OpenDocument_Worksheet __construct(
string
$name, [
$workbook = null]
)
|
|
Parameters:
|
string |
$name: |
Name of the current worksheet |
|
|
$workbook: |
|
API Tags:
Information Tags:
| Since: | 0.6.0 - 23. Jul. 2007 |
Retrieve the worksheet name.
This is usefull when creating worksheets without a name.
API Tags:
| Return: | worksheet's name |
| Access: | public |
Information Tags:
| Since: | 0.6.0 - 23. Jul. 2007 |
void protect(
string
$password
)
|
|
Set the worksheet protection flag to prevent accidental modification and to hide formulas if the locked and hidden format properties have been set.
Parameters:
|
string |
$password: |
The password to use for protecting the sheet. |
API Tags:
Information Tags:
| Since: | 0.6.0 - 23. Jul. 2007 |
void setColumn(
integer
$firstcol, integer
$lastcol, float
$width, [mixed
$format = null], [integer
$hidden = null]
)
|
|
Set the width of a single column or a range of columns.
Parameters:
|
integer |
$firstcol: |
- first column on the range |
|
integer |
$lastcol: |
- last column on the range |
|
float |
$width: |
- width to set |
|
mixed |
$format: |
- The optional XF format to apply to the columns |
|
integer |
$hidden: |
- The optional hidden atribute |
void write(
integer
$row, integer
$col, mixed
$token, [mixed
$format = null]
)
|
|
Map to the appropriate write method acording to the token recieved.
Parameters:
|
integer |
$row: |
The row of the cell we are writing to |
|
integer |
$col: |
The column of the cell we are writing to |
|
mixed |
$token: |
What we are writing |
|
mixed |
$format: |
The optional format to apply to the cell |
API Tags:
Information Tags:
| Since: | 0.6.0 - 23. Jul. 2007 |
integer writeUrl(
integer
$row, integer
$col, string
$url, [string
$string = ''], [mixed
$format = null]
)
|
|
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.
Parameters:
|
integer |
$row: |
Row |
|
integer |
$col: |
Column |
|
string |
$url: |
URL string |
|
string |
$string: |
Alternative label |
|
mixed |
$format: |
The cell format |
API Tags:
| Return: | 0 : normal termination -2 : row or column out of range -3 : long string truncated to 255 chars |
| Access: | public |
