XlsxResponseFormatter ​
- Type
- Class
- Namespace
- craft\web
- Inherits
- craft\web\XlsxResponseFormatter » craft\web\BaseSpreadsheetResponseFormatter » yii\base\Component » yii\base\BaseObject
- Implements
- yii\base\Configurable, yii\web\ResponseFormatterInterface
- Since
- 5.9.0
XlsxResponseFormatter formats the given data into XLSX response content.
It is used by \craft\web\YiiResponse to format response data.
Public Properties ​
| Property | Description |
|---|---|
| behaviors | yii\base\Behavior – List of behaviors attached to this component. |
| contentType | string – The Content-Type header for the response |
| headers | string[] – The header row values. |
| includeHeaderRow | boolean – Whether the response data should include a header row |
contentType ​
- Type
- string
- Default value
'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'
The Content-Type header for the response
Public Methods ​
| Method | Description |
|---|---|
| __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. |
Protected Methods ​
| Method | Description |
|---|---|
| createWriter() | Returns the writer object that should save out the spreadsheet file. |
createWriter() ​
Returns the writer object that should save out the spreadsheet file.
Arguments ​
$spreadsheet(\PhpOffice\PhpSpreadsheet\Spreadsheet)
Returns ​
\PhpOffice\PhpSpreadsheet\Writer\BaseWriter