WebEnq4 PHP Documentation » \Webenq_Import_Adapter

Import adapter for XLSX documents

package	Webenq_Data_Import
author	Bart Huttinga

Methods

Decodes the given string

UTF8Decode(\encoded $value) : \decoded

Inherited

inherited_from	\Webenq_Import_Adapter_Abstract::UTF8Decode()
inherited_from	\Webenq_Import_Adapter_Xls::UTF8Decode()

Parameters

$value

\encoded

string

Returns

\decodedstring

Opens the file for reading

__construct(string $filename) : \Webenq_Import_Adapter_Xlsx

Inherited

inherited_from	\Webenq_Import_Adapter_Xls::__construct()
fluent	This method is part of a fluent interface and will return the same instance

Parameters

$filename

string

Returns

\Webenq_Import_Adapter_Xlsx

Factory for an import-adapter

factory(string $filename)

InheritedStatic

inherited_from	\Webenq_Import_Adapter_Abstract::factory()
inherited_from	\Webenq_Import_Adapter_Xls::factory()

Parameters

$filename

string

Name of the file

Returns the value for the given cell

getCell() : string

Inherited

The first parameter can be in the form of 'A1'. In that case the second paramter can be an integer indicating the working-sheet to use (defaults to 0). Alternatively the first and second parameter together can represent the cell, in the form 0, 0 (equals to A1). In that case the working-sheet integer is the third parameter.

inherited_from	\Webenq_Import_Adapter_Abstract::getCell()
inherited_from	\Webenq_Import_Adapter_Xls::getCell()

Returns

stringThe value of the requested cell

Gets the data from the file

getData() : array

Inherited

inherited_from	\Webenq_Import_Adapter_Xls::getData()

Returns

arrayNested array of sheets containing questions and answers

Returns the filename of the uploaded file

getFilename() : string

Inherited

inherited_from	\Webenq_Import_Adapter_Abstract::getFilename()
inherited_from	\Webenq_Import_Adapter_Xls::getFilename()

Returns

stringFilename

Helper function for getCell()

_getCellFromArray(string $row, string $col, int $sheet) : string

Inherited

inherited_from	\Webenq_Import_Adapter_Abstract::_getCellFromArray()
inherited_from	\Webenq_Import_Adapter_Xls::_getCellFromArray()

Parameters

$row

string

$col

string

$sheet

int

Returns

stringThe value of the requested cell

Helper function for getCell()

_getCellFromMatrix(string $cell, int $sheet) : string

Inherited

inherited_from	\Webenq_Import_Adapter_Abstract::_getCellFromMatrix()
inherited_from	\Webenq_Import_Adapter_Xls::_getCellFromMatrix()

Parameters

$cell

string

$sheet

int

Returns

stringThe value of the requested cell

Translates some field labels to Dutch

_translate(string $value) : string

Inherited

inherited_from	\Webenq_Import_Adapter_Abstract::_translate()
inherited_from	\Webenq_Import_Adapter_Xls::_translate()

Parameters

$value

string

Non-Dutch field label

Returns

stringDutch field label

Properties

$supportedFormats : array

Inherited

For every entry in this array there must be an adapter class.

inherited_from	\Webenq_Import_Adapter_Abstract::$$supportedFormats
inherited_from	\Webenq_Import_Adapter_Xls::$$supportedFormats

$_data : array

Inherited

inherited_from	\Webenq_Import_Adapter_Xls::$$_data

$_filename

Inherited

inherited_from	\Webenq_Import_Adapter_Xls::$$_filename

$_reader : string

$_sheets

Inherited

inherited_from	\Webenq_Import_Adapter_Xls::$$_sheets