dolibarr  9.0.0
Public Member Functions | Public Attributes | List of all members
ExportExcel Class Reference

Class to build export files with Excel format. More...

+ Inheritance diagram for ExportExcel:
+ Collaboration diagram for ExportExcel:

Public Member Functions

 __construct ($db)
 Constructor. More...
 
 getDriverId ()
 getDriverId More...
 
 getDriverLabel ()
 getDriverLabel More...
 
 getDriverDesc ()
 getDriverDesc More...
 
 getDriverExtension ()
 getDriverExtension More...
 
 getDriverVersion ()
 getDriverVersion More...
 
 getLibLabel ()
 getLibLabel More...
 
 getLibVersion ()
 getLibVersion More...
 
 open_file ($file, $outputlangs)
 Open output file. More...
 
 write_header ($outputlangs)
 Write header. More...
 
 write_title ($array_export_fields_label, $array_selected_sorted, $outputlangs, $array_types)
 Output title line into file. More...
 
 write_record ($array_selected_sorted, $objp, $outputlangs, $array_types)
 Output record line into file. More...
 
 write_footer ($outputlangs)
 Write footer. More...
 
 close_file ()
 Close Excel file. More...
 
 excel_clean ($newvalue)
 Clean a cell to respect rules of Excel file cells. More...
 
 column2Letter ($c)
 Convert a column to letter (1->A, 0->B, 27->AA, ...) More...
 
- Public Member Functions inherited from ModeleExports
 liste_modeles ($db, $maxfilenamelength=0)
 Load into memory list of available export format. More...
 
 getPictoForKey ($key)
 Return picto of export driver. More...
 
 getDriverLabelForKey ($key)
 Renvoi libelle d'un driver export. More...
 
 getDriverDescForKey ($key)
 Renvoi le descriptif d'un driver export. More...
 
 getDriverVersionForKey ($key)
 Renvoi version d'un driver export. More...
 
 getLibLabelForKey ($key)
 Renvoi libelle de librairie externe du driver. More...
 
 getLibVersionForKey ($key)
 Renvoi version de librairie externe du driver. More...
 
- Public Member Functions inherited from CommonDocGenerator
 __construct ($db)
 Constructor. More...
 
 get_substitutionarray_user ($user, $outputlangs)
 Define array with couple subtitution key => subtitution value. More...
 
 get_substitutionarray_mysoc ($mysoc, $outputlangs)
 Define array with couple subtitution key => subtitution value. More...
 
 get_substitutionarray_thirdparty ($object, $outputlangs)
 Define array with couple subtitution key => subtitution value. More...
 
 get_substitutionarray_contact ($object, $outputlangs, $array_key='object')
 Define array with couple subtitution key => subtitution value. More...
 
 get_substitutionarray_other ($outputlangs)
 Define array with couple subtitution key => subtitution value. More...
 
 get_substitutionarray_object ($object, $outputlangs, $array_key='object')
 Define array with couple substitution key => substitution value. More...
 
 get_substitutionarray_lines ($line, $outputlangs)
 Define array with couple substitution key => substitution value. More...
 
 get_substitutionarray_shipment ($object, $outputlangs, $array_key='object')
 Define array with couple substitution key => substitution value. More...
 
 get_substitutionarray_shipment_lines ($line, $outputlangs)
 Define array with couple substitution key => substitution value. More...
 
 get_substitutionarray_each_var_object (&$object, $outputlangs, $recursive=true)
 Define array with couple subtitution key => subtitution value. More...
 
 fill_substitutionarray_with_extrafields ($object, $array_to_fill, $extrafields, $array_key, $outputlangs)
 Fill array with couple extrafield key => extrafield value. More...
 
 printRect ($pdf, $x, $y, $l, $h, $hidetop=0, $hidebottom=0)
 Rect pdf. More...
 
 columnSort ($a, $b)
 uasort callback function to Sort colums fields More...
 
 prepareArrayColumnField ($object, $outputlangs, $hidedetails=0, $hidedesc=0, $hideref=0)
 Prepare Array Column Field. More...
 
 getColumnContentWidth ($colKey)
 get column content width from column key More...
 
 getColumnContentXStart ($colKey)
 get column content X (abscissa) left position from column key More...
 
 getColumnRank ($colKey)
 get column position rank from column key More...
 
 insertNewColumnDef ($newColKey, $defArray, $targetCol=false, $insertAfterTarget=false)
 get column position rank from column key More...
 
 printStdColumnContent ($pdf, &$curY, $colKey, $columnText='')
 print standard column content More...
 
 getColumnStatus ($colKey)
 get column status from column key More...
 

Public Attributes

 $version = 'dolibarr'
 Dolibarr version of the loaded document string.
 

Detailed Description

Class to build export files with Excel format.

Definition at line 33 of file export_excel.modules.php.

Constructor & Destructor Documentation

◆ __construct()

ExportExcel::__construct (   $db)

Constructor.

Parameters
DoliDB$dbDatabase handler

Definition at line 73 of file export_excel.modules.php.

Member Function Documentation

◆ close_file()

ExportExcel::close_file ( )

Close Excel file.

Returns
int <0 if KO, >0 if OK

Definition at line 465 of file export_excel.modules.php.

◆ column2Letter()

ExportExcel::column2Letter (   $c)

Convert a column to letter (1->A, 0->B, 27->AA, ...)

Parameters
int$cColumn position
Returns
string Letter

Definition at line 509 of file export_excel.modules.php.

◆ excel_clean()

ExportExcel::excel_clean (   $newvalue)

Clean a cell to respect rules of Excel file cells.

Parameters
string$newvalueString to clean
Returns
string Value cleaned

Definition at line 493 of file export_excel.modules.php.

References dol_string_nohtmltag().

◆ getDriverDesc()

ExportExcel::getDriverDesc ( )

getDriverDesc

Returns
string

Definition at line 135 of file export_excel.modules.php.

◆ getDriverExtension()

ExportExcel::getDriverExtension ( )

getDriverExtension

Returns
string

Definition at line 145 of file export_excel.modules.php.

◆ getDriverId()

ExportExcel::getDriverId ( )

getDriverId

Returns
string

Definition at line 115 of file export_excel.modules.php.

◆ getDriverLabel()

ExportExcel::getDriverLabel ( )

getDriverLabel

Returns
string Return driver label

Definition at line 125 of file export_excel.modules.php.

◆ getDriverVersion()

ExportExcel::getDriverVersion ( )

getDriverVersion

Returns
string

Definition at line 155 of file export_excel.modules.php.

References $version.

◆ getLibLabel()

ExportExcel::getLibLabel ( )

getLibLabel

Returns
string

Definition at line 165 of file export_excel.modules.php.

◆ getLibVersion()

ExportExcel::getLibVersion ( )

getLibVersion

Returns
string

Definition at line 175 of file export_excel.modules.php.

◆ open_file()

ExportExcel::open_file (   $file,
  $outputlangs 
)

Open output file.

Parameters
string$fileFile name to generate
Translate$outputlangsOutput language object
Returns
int <0 if KO, >=0 if OK

Definition at line 189 of file export_excel.modules.php.

◆ write_footer()

ExportExcel::write_footer (   $outputlangs)

Write footer.

Parameters
Translate$outputlangsOutput language object
Returns
int <0 if KO, >0 if OK

Definition at line 452 of file export_excel.modules.php.

◆ write_header()

ExportExcel::write_header (   $outputlangs)

Write header.

Parameters
Translate$outputlangsObject lang to translate values
Returns
int <0 if KO, >0 if OK

Definition at line 259 of file export_excel.modules.php.

◆ write_record()

ExportExcel::write_record (   $array_selected_sorted,
  $objp,
  $outputlangs,
  $array_types 
)

Output record line into file.

Parameters
array$array_selected_sortedArray with list of field to export
resource$objpA record from a fetch with all fields from select
Translate$outputlangsObject lang to translate values
array$array_typesArray with types of fields
Returns
int <0 if KO, >0 if OK

Definition at line 335 of file export_excel.modules.php.

◆ write_title()

ExportExcel::write_title (   $array_export_fields_label,
  $array_selected_sorted,
  $outputlangs,
  $array_types 
)

Output title line into file.

Parameters
array$array_export_fields_labelArray with list of label of fields
array$array_selected_sortedArray with list of field to export
Translate$outputlangsObject lang to translate values
array$array_typesArray with types of fields
Returns
int <0 if KO, >0 if OK

Definition at line 278 of file export_excel.modules.php.


The documentation for this class was generated from the following file: