ExportExcel2007 Class Reference

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

Inheritance diagram for ExportExcel2007:

Collaboration diagram for ExportExcel2007:

Public Member Functions
	__construct ($db)
	Constructor.
	getDriverId ()
	getDriverId
	getDriverLabel ()
	getDriverLabel
	getDriverLabelBis ()
	getDriverLabel
	getDriverDesc ()
	getDriverDesc
	getDriverExtension ()
	getDriverExtension
	getDriverVersion ()
	getDriverVersion
	getLibLabel ()
	getLibLabel
	getLibVersion ()
	getLibVersion
	open_file ($file, $outputlangs)
	Open output file.
	write_header ($outputlangs)
	Write header.
	write_title ($array_export_fields_label, $array_selected_sorted, $outputlangs, $array_types)
	Output title line into file.
	write_record ($array_selected_sorted, $objp, $outputlangs, $array_types)
	Output record line into file.
	write_footer ($outputlangs)
	Write footer.
	close_file ()
	Close Excel file.
	excel_clean ($newvalue)
	Clean a cell to respect rules of Excel file cells.
	column2Letter ($c)
	Convert a column to letter (1->A, 0->B, 27->AA, ...)
	setCellValue ($val, $startCell, $endCell='')
	Set cell value and automatically merge if we give an endcell.
	setBorderStyle ($thickness, $color)
	Set border style.
	setFontStyle ($bold, $color)
	Set font style.
	setAlignmentStyle ($horizontal)
	Set alignment style (horizontal, left, right, ...)
	resetStyle ()
	Reset Style.
	setBlock ($startCell, $TDatas=array(), $boldTitle=false)
	Make a NxN Block in sheet.
	setBlock2Columns ($startCell, $TDatas=array(), $boldTitle=false)
	Make a 2xN Tab in Sheet.
	enableAutosize ($firstColumn, $lastColumn)
	Enable auto sizing for column range.
	setMergeCellValueByLength ($val, $startCell, $length, $offset=0)
	Set a value cell and merging it by giving a starting cell and a length.
Public Member Functions inherited from ModeleExports
	listOfAvailableExportFormat ($db, $maxfilenamelength=0)
	Load into memory list of available export format.
	getPictoForKey ($key)
	Return picto of export driver.
	getDriverLabelForKey ($key)
	Return label of driver export.
	getDriverDescForKey ($key)
	Renvoi le descriptif d'un driver export.
	getDriverVersionForKey ($key)
	Renvoi version d'un driver export.
	getLibLabelForKey ($key)
	Renvoi label of driver lib.
	getLibVersionForKey ($key)
	Return version of driver lib.
Public Member Functions inherited from CommonDocGenerator
	get_substitutionarray_user ($user, $outputlangs)
	Define array with couple substitution key => substitution value.
	getSubstitutionarrayMember ($member, $outputlangs)
	Define array with couple substitution key => substitution value.
	get_substitutionarray_mysoc ($mysoc, $outputlangs)
	Define array with couple substitution key => substitution value.
	get_substitutionarray_thirdparty ($object, $outputlangs, $array_key='company')
	Define array with couple substitution key => substitution value For example {company_name}, {company_name_alias}.
	get_substitutionarray_contact ($object, $outputlangs, $array_key='object')
	Define array with couple substitution key => substitution value.
	get_substitutionarray_other ($outputlangs)
	Define array with couple substitution key => substitution value.
	get_substitutionarray_lines ($line, $outputlangs, $linenumber=0)
	Define array with couple substitution key => substitution value Note that vars into substitutions array are formatted.
	get_substitutionarray_shipment ($object, $outputlangs, $array_key='object')
	Define array with couple substitution key => substitution value Note that vars into substitutions array are formatted.
	get_substitutionarray_each_var_object (&$object, $outputlangs, $recursive=1)
	Define array with couple substitution key => substitution value.
	fill_substitutionarray_with_extrafields ($object, $array_to_fill, $extrafields, $array_key, $outputlangs)
	Fill array with couple extrafield key => extrafield value Note that vars into substitutions array are formatted.
	printRect ($pdf, $x, $y, $l, $h, $hidetop=0, $hidebottom=0)
	Rect pdf.
	columnSort ($a, $b)
	uasort callback function to Sort columns fields
	prepareArrayColumnField ($object, $outputlangs, $hidedetails=0, $hidedesc=0, $hideref=0)
	Prepare Array Column Field.
	getColumnContentWidth ($colKey)
	get column content width from column key
	getColumnContentXStart ($colKey)
	get column content X (abscissa) left position from column key
	getColumnRank ($colKey)
	get column position rank from column key
	insertNewColumnDef ($newColKey, $defArray, $targetCol='', $insertAfterTarget=false)
	get column position rank from column key
	printStdColumnContent ($pdf, &$curY, $colKey, $columnText='')
	print standard column content
	printColDescContent ($pdf, &$curY, $colKey, $object, $i, $outputlangs, $hideref=0, $hidedesc=0, $issupplierline=0)
	print description column content
	getExtrafieldContent ($object, $extrafieldKey, $outputlangs=null)
	get extrafield content for pdf writeHtmlCell compatibility usage for PDF line columns and object note block
	getColumnStatus ($colKey)
	get column status from column key
	pdfTabTitles (&$pdf, $tab_top, $tab_height, $outputlangs, $hidetop=0)
	Print standard column content.
	defineColumnExtrafield ($object, $outputlangs, $hidedetails=0)
	Define Array Column Field for extrafields.
	defineColumnField ($object, $outputlangs, $hidedetails=0, $hidedesc=0, $hideref=0)
	Define Array Column Field into $this->cols This method must be implemented by the module that generate the document with its own columns.

Detailed Description

Class to build export files with Excel format.

Definition at line 37 of file export_excel2007.modules.php.

Constructor & Destructor Documentation

__construct()

ExportExcel2007::__construct

(

$db

)

Constructor.

Parameters

DoliDB

$db

Database handler

Reimplemented from CommonDocGenerator.

Definition at line 80 of file export_excel2007.modules.php.

References disabled.

Member Function Documentation

close_file()

ExportExcel2007::close_file

(

)

Close Excel file.

Returns

int Return integer <0 if KO, >0 if OK

Definition at line 432 of file export_excel2007.modules.php.

column2Letter()

ExportExcel2007::column2Letter

(

$c

)

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

Parameters

int

$c

Column position

Returns

string Letter

Definition at line 468 of file export_excel2007.modules.php.

Referenced by write_title().

enableAutosize()

ExportExcel2007::enableAutosize	(		$firstColumn,
			$lastColumn )

Enable auto sizing for column range.

Parameters

string	$firstColumn	first column to autosize
string	$lastColumn	to last column to autosize

Returns

int 1

Definition at line 653 of file export_excel2007.modules.php.

excel_clean()

ExportExcel2007::excel_clean

(

$newvalue

)

Clean a cell to respect rules of Excel file cells.

Parameters

string

$newvalue

String to clean

Returns

string Value cleaned

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

References dol_string_nohtmltag().

Referenced by write_record().

getDriverDesc()

ExportExcel2007::getDriverDesc

(

)

getDriverDesc

Returns

string

Definition at line 141 of file export_excel2007.modules.php.

getDriverExtension()

ExportExcel2007::getDriverExtension

(

)

getDriverExtension

Returns

string

Definition at line 151 of file export_excel2007.modules.php.

getDriverId()

ExportExcel2007::getDriverId

(

)

getDriverId

Returns

string

Definition at line 109 of file export_excel2007.modules.php.

getDriverLabel()

ExportExcel2007::getDriverLabel

(

)

getDriverLabel

Returns

string Return driver label

Definition at line 119 of file export_excel2007.modules.php.

getDriverLabelBis()

ExportExcel2007::getDriverLabelBis

(

)

getDriverLabel

Returns

string Return driver label

Definition at line 129 of file export_excel2007.modules.php.

getDriverVersion()

ExportExcel2007::getDriverVersion

(

)

getDriverVersion

Returns

string

Definition at line 161 of file export_excel2007.modules.php.

getLibLabel()

ExportExcel2007::getLibLabel

(

)

getLibLabel

Returns

string

Definition at line 171 of file export_excel2007.modules.php.

getLibVersion()

ExportExcel2007::getLibVersion

(

)

getLibVersion

Returns

string

Definition at line 181 of file export_excel2007.modules.php.

open_file()

ExportExcel2007::open_file	(		$file,
			$outputlangs )

Open output file.

Parameters

string	$file	File name to generate
Translate	$outputlangs	Output language object

Returns

int Return integer <0 if KO, >=0 if OK

Definition at line 195 of file export_excel2007.modules.php.

References dol_syslog().

resetStyle()

ExportExcel2007::resetStyle

(

)

Reset Style.

Returns

int 1

Definition at line 564 of file export_excel2007.modules.php.

setAlignmentStyle()

ExportExcel2007::setAlignmentStyle

(

$horizontal

)

Set alignment style (horizontal, left, right, ...)

Parameters

string

$horizontal

PhpOffice\PhpSpreadsheet\Style\Alignment

Returns

int 1

Definition at line 554 of file export_excel2007.modules.php.

setBlock()

ExportExcel2007::setBlock	(		$startCell,
			$TDatas = array(),
			$boldTitle = false )

Make a NxN Block in sheet.

Parameters

string	$startCell	starting cell
array	$TDatas	array(ColumnName=>array(Row value 1, row value 2, etc ...))
bool	$boldTitle	true if bold headers

Returns

int 1 if OK, -1 if KO

Definition at line 578 of file export_excel2007.modules.php.

References setCellValue(), and setFontStyle().

setBlock2Columns()

ExportExcel2007::setBlock2Columns	(		$startCell,
			$TDatas = array(),
			$boldTitle = false )

Make a 2xN Tab in Sheet.

Parameters

string	$startCell	A1
array	$TDatas	array(Title=>val)
bool	$boldTitle	true if bold titles

Returns

int 1 if OK, -1 if KO

Definition at line 618 of file export_excel2007.modules.php.

References setCellValue(), and setFontStyle().

setBorderStyle()

ExportExcel2007::setBorderStyle	(		$thickness,
			$color )

Set border style.

Parameters

string	$thickness	style \PhpOffice\PhpSpreadsheet\Style\Border
string	$color	color \PhpOffice\PhpSpreadsheet\Style\Color

Returns

int 1 if ok

Definition at line 521 of file export_excel2007.modules.php.

setCellValue()

ExportExcel2007::setCellValue	(		$val,
			$startCell,
			$endCell = '' )

Set cell value and automatically merge if we give an endcell.

Parameters

string	$val	cell value
string	$startCell	starting cell
string	$endCell	ending cell

Returns

int 1 if success -1 if failed

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

Referenced by setBlock(), setBlock2Columns(), and setMergeCellValueByLength().

setFontStyle()

ExportExcel2007::setFontStyle	(		$bold,
			$color )

Set font style.

Parameters

bool	$bold	true if bold
string	$color	color \PhpOffice\PhpSpreadsheet\Style\Color

Returns

int 1

Definition at line 539 of file export_excel2007.modules.php.

Referenced by setBlock(), and setBlock2Columns().

setMergeCellValueByLength()

ExportExcel2007::setMergeCellValueByLength	(		$val,
			$startCell,
			$length,
			$offset = 0 )

Set a value cell and merging it by giving a starting cell and a length.

Parameters

string	$val	Cell value
string	$startCell	Starting cell
int	$length	Length
int	$offset	Starting offset

Returns

int|string Coordinate or if KO: -1

Definition at line 670 of file export_excel2007.modules.php.

References setCellValue().

write_footer()

ExportExcel2007::write_footer

(

$outputlangs

)

Write footer.

Parameters

Translate

$outputlangs

Output language object

Returns

int Return integer <0 if KO, >0 if OK

Definition at line 419 of file export_excel2007.modules.php.

write_header()

ExportExcel2007::write_header

(

$outputlangs

)

Write header.

Parameters

Translate

$outputlangs

Object lang to translate values

Returns

int Return integer <0 if KO, >0 if OK

Definition at line 240 of file export_excel2007.modules.php.

write_record()

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

Output record line into file.

Parameters

array	$array_selected_sorted	Array with list of field to export
Resource	$objp	A record from a fetch with all fields from select
Translate	$outputlangs	Object lang to translate values
array	$array_types	Array with types of fields

Returns

int Return integer <0 if KO, >0 if OK

Definition at line 312 of file export_excel2007.modules.php.

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

write_title()

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

Output title line into file.

Parameters

array	$array_export_fields_label	Array with list of label of fields
array	$array_selected_sorted	Array with list of field to export
Translate	$outputlangs	Object lang to translate values
array	$array_types	Array with types of fields

Returns

int Return integer <0 if KO, >0 if OK

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

References column2Letter(), and dol_print_error().

---

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

• dolibarr_20.0/htdocs/core/modules/export/export_excel2007.modules.php