Moodle APIs 3.9
Moodle 3.9.13+ (Build: 20220325)
Public Member Functions | Protected Member Functions | Protected Attributes | List of all members
dataformat_excel\writer Class Reference

Excel data format writer. More...

Inheritance diagram for dataformat_excel\writer:
core\dataformat\spout_base core\dataformat\base

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.

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
stringfile 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: