dolibarr  7.0.0-beta
Public Member Functions | 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...
 

Detailed Description

Class to build export files with Excel format.

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

Constructor & Destructor Documentation

ExportExcel::__construct (   $db)

Constructor.

Parameters
DoliDB$dbDatabase handler

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

Member Function Documentation

ExportExcel::close_file ( )

Close Excel file.

Returns
int <0 if KO, >0 if OK

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

ExportExcel::column2Letter (   $c)

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

Parameters
int$cColumn position
Returns
string Letter

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

Referenced by write_title().

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 462 of file export_excel.modules.php.

References dol_string_nohtmltag().

Referenced by write_record().

ExportExcel::getDriverDesc ( )

getDriverDesc

Returns
string

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

ExportExcel::getDriverExtension ( )

getDriverExtension

Returns
string

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

ExportExcel::getDriverId ( )

getDriverId

Returns
string

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

ExportExcel::getDriverLabel ( )

getDriverLabel

Returns
string Return driver label

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

ExportExcel::getDriverVersion ( )

getDriverVersion

Returns
string

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

ExportExcel::getLibLabel ( )

getLibLabel

Returns
string

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

ExportExcel::getLibVersion ( )

getLibVersion

Returns
string

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

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 170 of file export_excel.modules.php.

References dol_syslog().

ExportExcel::write_footer (   $outputlangs)

Write footer.

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

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

ExportExcel::write_header (   $outputlangs)

Write header.

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

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

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 310 of file export_excel.modules.php.

References dol_print_error(), dol_stringtotime(), and excel_clean().

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 255 of file export_excel.modules.php.

References column2Letter(), and dol_print_error().


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