Skip to content

BaseSpreadsheetResponseFormatter ​

Type
Abstract Class
Namespace
craft\web
Inherits
craft\web\BaseSpreadsheetResponseFormatter » yii\base\Component » yii\base\BaseObject
Implements
yii\base\Configurable, yii\web\ResponseFormatterInterface
Extended by
craft\web\CsvResponseFormatter, craft\web\XlsxResponseFormatter
Since
5.9.0

BaseSpreadsheetResponseFormatter is the base class for response formatters for generating spreadsheet files.

View source

Public Properties ​

PropertyDescription
behaviorsyii\base\Behavior – List of behaviors attached to this component.
contentTypestring – The Content-Type header for the response
headersstring[] – The header row values.
includeHeaderRowboolean – Whether the response data should include a header row

contentType ​

Type
string
Default value
null

The Content-Type header for the response

View source

headers ​

Type
string[]
Default value
null

The header row values. The unique keys across all rows in yii\web\Response::$data will be used by default.

View source

includeHeaderRow ​

Type
boolean
Default value
true

Whether the response data should include a header row

View source

Public Methods ​

MethodDescription
__call()Calls the named method which is not a class method.
__clone()This method is called after the object is created by cloning an existing one.
__construct()Constructor.
__get()Returns the value of a component property.
__isset()Checks if a property is set, i.e. defined and not null.
__set()Sets the value of a component property.
__unset()Sets a component property to be null.
attachBehavior()Attaches a behavior to this component.
attachBehaviors()Attaches a list of behaviors to the component.
behaviors()Returns a list of behaviors that this component should behave as.
canGetProperty()Returns a value indicating whether a property can be read.
canSetProperty()Returns a value indicating whether a property can be set.
className()Returns the fully qualified name of this class.
detachBehavior()Detaches a behavior from the component.
detachBehaviors()Detaches all behaviors from the component.
ensureBehaviors()Makes sure that the behaviors declared in behaviors() are attached to this component.
format()Formats the specified response.
getBehavior()Returns the named behavior object.
getBehaviors()Returns all behaviors attached to this component.
hasEventHandlers()Returns a value indicating whether there is any handler attached to the named event.
hasMethod()Returns a value indicating whether a method is defined.
hasProperty()Returns a value indicating whether a property is defined for this component.
init()Initializes the object.
off()Detaches an existing event handler from this component.
on()Attaches an event handler to an event.
trigger()Triggers an event.

format() ​

Formats the specified response.

View source

Arguments ​

Protected Methods ​

MethodDescription
createWriter()Returns the writer object that should save out the spreadsheet file.

createWriter() ​

Returns the writer object that should save out the spreadsheet file.

View source

Arguments ​

  • $spreadsheet (\PhpOffice\PhpSpreadsheet\Spreadsheet)

Returns ​

\PhpOffice\PhpSpreadsheet\Writer\BaseWriter