MoodleODSWorksheet Class Reference

ODS Worksheet abstraction. More...

Public Member Functions
	__construct ($name, array $worksheets)
	Constructs one Moodle Worksheet.
	hide_gridlines ()
	Set the option to hide gridlines on the printed page.
	hide_screen_gridlines ()
	Set the option to hide gridlines on the worksheet (as seen on the screen).
	insert_bitmap ($row, $col, $bitmap, $x=0, $y=0, $scale_x=1, $scale_y=1)
	Insert a 24bit bitmap image in a worksheet.
	merge_cells ($first_row, $first_col, $last_row, $last_col)
	Merges the area given by its arguments.
	set_column ($firstcol, $lastcol, $width, $format=null, $hidden=false, $level=0)
	Sets the width (and other settings) of one column.
	set_row ($row, $height, $format=null, $hidden=false, $level=0)
	Sets the height (and other settings) of one row.
	write ($row, $col, $token, $format=null)
	Write anything somewhere in the worksheet, type will be automatically detected.
	write_blank ($row, $col, $format=null)
	Write one blank somewhere in the worksheet.
	write_date ($row, $col, $date, $format=null)
	Write one date somewhere in the worksheet.
	write_formula ($row, $col, $formula, $format=null)
	Write one formula somewhere in the worksheet.
	write_number ($row, $col, $num, $format=null)
	Write one number somewhere in the worksheet.
	write_string ($row, $col, $str, $format=null)
	Write one string somewhere in the worksheet.
	write_url ($row, $col, $url, $format=null)
	Write one url somewhere in the worksheet.

Public Attributes
	$columns = array()
	$data = array()
int	$maxc = 0
	Max number of cols in the sheet.
int	$maxr = 0
	Max number of rows in the sheet.
	$name
	$rows = array()
	$showgrid = true

Detailed Description

ODS Worksheet abstraction.

Copyright

2006 Petr Skoda

License

http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later

Constructor & Destructor Documentation

__construct()

MoodleODSWorksheet::__construct	(		$name,
		array	$worksheets )

Constructs one Moodle Worksheet.

Parameters

string	$name	The name of the file
array	$worksheets	existing worksheets

Member Function Documentation

insert_bitmap()

MoodleODSWorksheet::insert_bitmap	(		$row,
			$col,
			$bitmap,
			$x = 0,
			$y = 0,
			$scale_x = 1,
			$scale_y = 1 )

Insert a 24bit bitmap image in a worksheet.

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
string	$bitmap	The bitmap filename
integer	$x	The horizontal position (offset) of the image inside the cell.
integer	$y	The vertical position (offset) of the image inside the cell.
integer	$scale_x	The horizontal scale
integer	$scale_y	The vertical scale

merge_cells()

MoodleODSWorksheet::merge_cells	(		$first_row,
			$first_col,
			$last_row,
			$last_col )

Merges the area given by its arguments.

Parameters

integer	$first_row	First row of the area to merge
integer	$first_col	First column of the area to merge
integer	$last_row	Last row of the area to merge
integer	$last_col	Last column of the area to merge

set_column()

MoodleODSWorksheet::set_column	(		$firstcol,
			$lastcol,
			$width,
			$format = null,
			$hidden = false,
			$level = 0 )

Sets the width (and other settings) of one column.

Parameters

integer	$firstcol	first column on the range
integer	$lastcol	last column on the range
integer	$width	width to set (null to set just format without setting the width)
mixed	$format	The optional format to apply to the columns
bool	$hidden	The optional hidden attribute
integer	$level	The optional outline level (0-7)

set_row()

MoodleODSWorksheet::set_row	(		$row,
			$height,
			$format = null,
			$hidden = false,
			$level = 0 )

Sets the height (and other settings) of one row.

Parameters

integer	$row	The row to set
integer	$height	Height we are giving to the row (null to set just format without setting the height)
mixed	$format	The optional format we are giving to the row
bool	$hidden	The optional hidden attribute
integer	$level	The optional outline level (0-7)

write()

MoodleODSWorksheet::write	(		$row,
			$col,
			$token,
			$format = null )

Write anything somewhere in the worksheet, type will be automatically detected.

Parameters

integer	$row	Zero indexed row
integer	$col	Zero indexed column
mixed	$token	What we are writing
mixed	$format	The XF format for the cell

write_blank()

MoodleODSWorksheet::write_blank	(		$row,
			$col,
			$format = null )

Write one blank somewhere in the worksheet.

Parameters

integer	$row	Zero indexed row
integer	$col	Zero indexed column
mixed	$format	The XF format for the cell

write_date()

MoodleODSWorksheet::write_date	(		$row,
			$col,
			$date,
			$format = null )

Write one date somewhere in the worksheet.

Parameters

integer	$row	Zero indexed row
integer	$col	Zero indexed column
string	$date	The url to write
mixed	$format	The XF format for the cell

write_formula()

MoodleODSWorksheet::write_formula	(		$row,
			$col,
			$formula,
			$format = null )

Write one formula somewhere in the worksheet.

Parameters

integer	$row	Zero indexed row
integer	$col	Zero indexed column
string	$formula	The formula to write
mixed	$format	The XF format for the cell

write_number()

MoodleODSWorksheet::write_number	(		$row,
			$col,
			$num,
			$format = null )

Write one number somewhere in the worksheet.

Parameters

integer	$row	Zero indexed row
integer	$col	Zero indexed column
float	$num	The number to write
mixed	$format	The XF format for the cell

write_string()

MoodleODSWorksheet::write_string	(		$row,
			$col,
			$str,
			$format = null )

Write one string somewhere in the worksheet.

Parameters

integer	$row	Zero indexed row
integer	$col	Zero indexed column
string	$str	The string to write
mixed	$format	The XF format for the cell

write_url()

MoodleODSWorksheet::write_url	(		$row,
			$col,
			$url,
			$format = null )

Write one url somewhere in the worksheet.

Parameters

integer	$row	Zero indexed row
integer	$col	Zero indexed column
string	$url	The url to write
mixed	$format	The XF format for the cell

---

The documentation for this class was generated from the following file:

• lib/odslib.class.php