Public Member Functions | |
__construct (&$xmlArr) | |
renderCSV ($objName) | |
renderTSV ($objName) | |
importCSV ($objName) | |
Protected Member Functions | |
render ($objName, $separator=",", $ext="csv") | |
strip_cell ($str) | |
getDataTable ($objName) | |
reportError ($error) |
Definition at line 28 of file excelService.php.
__construct | ( | &$ | xmlArr ) |
Initialize excelService with xml array metadata
array | $xmlArr |
Definition at line 37 of file excelService.php.
getDataTable | ( | $ | objName ) | [protected] |
Get raw data to display in the spreadsheet. header and data table
string | $objName |
Definition at line 222 of file excelService.php.
importCSV | ( | $ | objName ) |
Import from CSV file NOTE: This method must be called from a popup form where a file is uploaded. The parent form of the popup form is the target to import.
string | $objName |
Definition at line 76 of file excelService.php.
render | ( | $ | objName, |
$ | separator = "," , |
||
$ | ext = "csv" |
||
) | [protected] |
Render excel data
string | $objName | object form name |
string | $separator | sparator between column |
string | $ext | file extension |
Definition at line 178 of file excelService.php.
renderCSV | ( | $ | objName ) |
Render the excel output with CSV format
string | $objName | object name which is the bizform name |
Definition at line 47 of file excelService.php.
renderTSV | ( | $ | objName ) |
Render the excel output with TSV format
string | $objName | object name which is the bizform name |
Definition at line 61 of file excelService.php.
reportError | ( | $ | error ) | [protected] |
Show error message
int | $error | error number |
Definition at line 253 of file excelService.php.