Methods summary
public
|
#
__construct( string $filetype = NULL )
SimpleExcel constructor method
SimpleExcel constructor method
Parameters
- $filetype
string $filetype Set the filetype of the file
|
public
|
#
exportFile( string $target, string $fileType, string $options = NULL )
Export data as file
Parameters
- $target
string $target Where to write the file
- $fileType
string $filetype Type of the file to be written
- $options
string $options Options
Throws
|
public
SimpleExcel\Spreadsheet\Worksheet
|
#
getWorksheet( integer $index = 1 )
Get specified worksheet
Parameters
- $index
integer $index Worksheet index
Returns
Throws
Exception
If worksheet with specified index is not found
|
public
array
|
|
public
|
|
public
|
#
loadFile( string $filePath, string $fileType, string $options = NULL )
Load file to parser
Parameters
- $filePath
string $filepath Path to file
- $fileType
string $filetype Set the filetype of the file which will be parsed
- $options
string $options Options
Throws
|
public
|
#
loadString( string $string, string $fileType )
Load string to parser
Parameters
- $string
string $filepath Path to file
- $fileType
string $filetype Set the filetype of the file which will be parsed
Throws
|
public
|
#
removeWorksheet( integer $index )
Remove a worksheet
Parameters
- $index
integer $index Worksheet index to be removed
|
protected
|
#
setParserType( string $filetype )
Construct a SimpleExcel Parser
Construct a SimpleExcel Parser
Parameters
- $filetype
string $filetype Set the filetype of the file which will be parsed
(XML/CSV/TSV/HTML/JSON)
Throws
|
protected
|
#
setWriterType( string $filetype )
Construct a SimpleExcel Writer
Construct a SimpleExcel Writer
Parameters
- $filetype
string $filetype Set the filetype of the file which will be written
Throws
|
public
string
|
#
toString( string $filetype, string $options = NULL )
Get data as string
Parameters
- $filetype
string $filetype Document format for the string to be returned
- $options
string $options Options
Returns
string
Throws
|