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

Inheritance diagram for ExportExcel2007:

Collaboration diagram for ExportExcel2007:

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...

	setCellValue ($val, $startCell, $endCell='')
	Set cell value and automatically merge if we give an endcell. More...

	setBorderStyle ($thickness, $color)
	Set border style. More...

	setFontStyle ($bold, $color)
	Set font style. More...

	setAlignmentStyle ($horizontal)
	Set alignment style (horizontal, left, right, ...) More...

	resetStyle ()
	Reset Style. More...

	setBlock ($startCell, $TDatas=array(), $boldTitle=false)
	Make a NxN Block in sheet. More...

	setBlock2Columns ($startCell, $TDatas=array(), $boldTitle=false)
	Make a 2xN Tab in Sheet. More...

	enableAutosize ($firstColumn, $lastColumn)
	Enable auto sizing for column range. More...

	setMergeCellValueByLength ($val, $startCell, $length, $offset=0)
	Set a value cell and merging it by giving a starting cell and a length. More...

Public Member Functions inherited from ModeleExports
	listOfAvailableExportFormat ($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
	get_substitutionarray_user ($user, $outputlangs)
	Define array with couple substitution key => substitution value. More...

	getSubstitutionarrayMember ($member, $outputlangs)
	Define array with couple substitution key => substitution value. More...

	get_substitutionarray_mysoc ($mysoc, $outputlangs)
	Define array with couple substitution key => substitution value. More...

	get_substitutionarray_thirdparty ($object, $outputlangs, $array_key='company')
	Define array with couple substitution key => substitution value For example {company_name}, {company_name_alias}. More...

	get_substitutionarray_contact ($object, $outputlangs, $array_key='object')
	Define array with couple substitution key => substitution value. More...

	get_substitutionarray_other ($outputlangs)
	Define array with couple substitution key => substitution value. More...

	get_substitutionarray_object ($object, $outputlangs, $array_key='object')
	Define array with couple substitution key => substitution value. More...

	get_substitutionarray_lines ($line, $outputlangs, $linenumber=0)
	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=1)
	Define array with couple substitution key => substitution 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 columns 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...

	printColDescContent ($pdf, &$curY, $colKey, $object, $i, $outputlangs, $hideref=0, $hidedesc=0, $issupplierline=0)
	print description column content More...

	getExtrafieldContent ($object, $extrafieldKey, $outputlangs=null)
	get extrafield content for pdf writeHtmlCell compatibility usage for PDF line columns and object note block More...

	getColumnStatus ($colKey)
	get column status from column key More...

	pdfTabTitles (&$pdf, $tab_top, $tab_height, $outputlangs, $hidetop=0)
	Print standard column content. More...

	defineColumnExtrafield ($object, $outputlangs, $hidedetails=0)
	Define Array Column Field for extrafields. More...

Detailed Description

Class to build export files with Excel format.

Definition at line 35 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 77 of file export_excel2007.modules.php.

Member Function Documentation

◆ close_file()

ExportExcel2007::close_file ( )

Close Excel file.

Returns: int <0 if KO, >0 if OK

Definition at line 422 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 459 of file export_excel2007.modules.php.

◆ 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 644 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 443 of file export_excel2007.modules.php.

References dol_string_nohtmltag().

◆ getDriverDesc()

ExportExcel2007::getDriverDesc ( )

getDriverDesc

Returns: string

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

◆ getDriverExtension()

ExportExcel2007::getDriverExtension ( )

getDriverExtension

Returns: string

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

◆ getDriverId()

ExportExcel2007::getDriverId ( )

getDriverId

Returns: string

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

◆ getDriverLabel()

ExportExcel2007::getDriverLabel ( )

getDriverLabel

Returns: string Return driver label

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

◆ getDriverVersion()

ExportExcel2007::getDriverVersion ( )

getDriverVersion

Returns: string

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

◆ getLibLabel()

ExportExcel2007::getLibLabel ( )

getLibLabel

Returns: string

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

◆ getLibVersion()

ExportExcel2007::getLibVersion ( )

getLibVersion

Returns: string

Definition at line 166 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 <0 if KO, >=0 if OK

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

◆ resetStyle()

ExportExcel2007::resetStyle ( )

Reset Style.

Returns: int 1

Definition at line 555 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 545 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 569 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 609 of file export_excel2007.modules.php.

◆ 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 512 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 484 of file export_excel2007.modules.php.

Referenced by setBlock().

◆ 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 530 of file export_excel2007.modules.php.

Referenced by setBlock().

◆ 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: string Coordinate or -1 if KO

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

◆ write_footer()

ExportExcel2007::write_footer ( $outputlangs )

Write footer.

Parameters

Translate $outputlangs Output language object

Returns: int <0 if KO, >0 if OK

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

◆ write_header()

ExportExcel2007::write_header ( $outputlangs )

Write header.

Parameters

Translate $outputlangs Object lang to translate values

Returns: int <0 if KO, >0 if OK

Definition at line 229 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 <0 if KO, >0 if OK

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

◆ 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 <0 if KO, >0 if OK

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

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

htdocs/core/modules/export/export_excel2007.modules.php

Public Member Functions

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ close_file()

◆ column2Letter()

◆ enableAutosize()

◆ excel_clean()

◆ getDriverDesc()

◆ getDriverExtension()

◆ getDriverId()

◆ getDriverLabel()

◆ getDriverVersion()

◆ getLibLabel()

◆ getLibVersion()

◆ open_file()

◆ resetStyle()

◆ setAlignmentStyle()

◆ setBlock()

◆ setBlock2Columns()

◆ setBorderStyle()

◆ setCellValue()

◆ setFontStyle()

◆ setMergeCellValueByLength()

◆ write_footer()

◆ write_header()

◆ write_record()

◆ write_title()