dataformat_excel\writer Class Reference

Excel data format writer. More...

Inheritance diagram for dataformat_excel\writer:

Public Member Functions
	close_output ()
	Write the end of the file. More...
	close_output_to_file ()
	Write data to disk. More...
	close_sheet ($columns)
	Write the end of the sheet containing the data. More...
	get_extension ()
	Get the file extension. More...
	send_http_headers ()
	Output file headers to initialise the download of the file. More...
	set_filename ($filename)
	Set download filename base. More...
	set_filepath (string $filepath)
	Set file path when writing to file. More...
	set_sheettitle ($title)
	Set the title of the worksheet inside a spreadsheet. More...
	start_output ()
	Write the start of the file. More...
	start_output_to_file ()
	Set the dataformat to be output to current file. More...
	start_sheet ($columns)
	Write the start of the sheet we will be adding data to. More...
	supports_html ()
	Method to define whether the dataformat supports export of HTML. More...
	write_record ($record, $rownum)
	Write a single record. More...

Protected Member Functions
	export_html_image_source (\stored_file $file)
	Given a stored_file, return a suitable source attribute for an img element in the export (or null to use the original) More...
	format_record ($record)
	Apply formatting to the cells of a given record. More...
	replace_pluginfile_images (?string $content)
	We need to locate all img tags within a given cell that match pluginfile URL's. More...

Protected Attributes
$extension	$extension = ".xlsx"
$filename	$filename = ''
string	$filepath = ''
	The location to store the output content.
$mimetype	$mimetype = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
$renamecurrentsheet	$renamecurrentsheet = false
$sheettitle	$sheettitle
$spouttype	$spouttype = Box\Spout\Common\Type::XLSX
$writer	$writer

Detailed Description

Excel data format writer.

Copyright

2016 Brendan Heywood (brend.nosp@m.an@c.nosp@m.ataly.nosp@m.st-a.nosp@m.u.net)

License

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

Member Function Documentation

close_output()

core\dataformat\spout_base::close_output ( )

inherited

Write the end of the file.

Reimplemented from core\dataformat\base.

close_output_to_file()

core\dataformat\spout_base::close_output_to_file ( )

inherited

Write data to disk.

Return values

bool

Reimplemented from core\dataformat\base.

close_sheet()

core\dataformat\base::close_sheet (   $columns )

inherited

Write the end of the sheet containing the data.

Parameters

array

$columns

Reimplemented in dataformat_html\writer, and dataformat_json\writer.

export_html_image_source()

core\dataformat\base::export_html_image_source ( \stored_file  $file )

protectedinherited

Given a stored_file, return a suitable source attribute for an img element in the export (or null to use the original)

Parameters

stored_file

$file

Return values

string|null

Reimplemented in dataformat_pdf\writer.

format_record()

core\dataformat\base::format_record (   $record )

protectedinherited

Apply formatting to the cells of a given record.

Parameters

array | stdClass

$record

Return values

array

get_extension()

core\dataformat\base::get_extension ( )

inherited

Get the file extension.

Return values

string

file extension

replace_pluginfile_images()

core\dataformat\base::replace_pluginfile_images ( ?string  $content )

protectedinherited

We need to locate all img tags within a given cell that match pluginfile URL's.

Partly so the exported file will show the image without requiring the user is logged in; and also to prevent some of the dataformats requesting the file themselves, which is likely to fail due to them not having an active session

Parameters

string | null

$content

Return values

string

send_http_headers()

core\dataformat\spout_base::send_http_headers ( )

inherited

Output file headers to initialise the download of the file.

Reimplemented from core\dataformat\base.

set_filename()

core\dataformat\base::set_filename (   $filename )

inherited

Set download filename base.

Parameters

string

$filename

set_filepath()

core\dataformat\base::set_filepath ( string  $filepath )

inherited

Set file path when writing to file.

Parameters

string

$filepath

Exceptions

coding_exception

set_sheettitle()

dataformat_excel\writer::set_sheettitle

(

$title

)

Set the title of the worksheet inside a spreadsheet.

For some formats this will be ignored.

Parameters

string

$title

Reimplemented from core\dataformat\spout_base.

start_output()

core\dataformat\base::start_output ( )

inherited

Write the start of the file.

Reimplemented in dataformat_html\writer, dataformat_json\writer, and dataformat_pdf\writer.

start_output_to_file()

core\dataformat\spout_base::start_output_to_file ( )

inherited

Set the dataformat to be output to current file.

Reimplemented from core\dataformat\base.

start_sheet()

core\dataformat\spout_base::start_sheet (   $columns )

inherited

Write the start of the sheet we will be adding data to.

Parameters

array

$columns

Reimplemented from core\dataformat\base.

supports_html()

core\dataformat\base::supports_html ( )

inherited

Method to define whether the dataformat supports export of HTML.

Return values

bool

Reimplemented in dataformat_html\writer, and dataformat_pdf\writer.

write_record()

core\dataformat\spout_base::write_record (   $record,   $rownum  )

inherited

Write a single record.

Parameters

array	$record
int	$rownum

Reimplemented from core\dataformat\base.

---

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

• dataformat/excel/classes/writer.php