Docs For Class CreateExcelSheet

Description

Create excel sheet

version: 1.0
copyright: Copyright (c) 2009-2011 Narcea Producciones Multimedia S.L. (http://www.2mdc.com)
link: http://www.phpdocx.com
since: Class available since Release 1.0
license: http://www.phpdocx.com/wp-content/themes/lightword/pro_license.php

Located in /CreateExcelSheet.inc (line 29)

CreateElement
   |
   --CreateExcelSheet

Method Summary

static CreateExcelSheet getInstance ()

CreateExcelSheet __construct ()

void __destruct ()

void createExcelSheet (string $args[0], array $args[1])

void generateC (string $r, string $s, [string $t = ''])

void generateCOL ([string $min = '1'], [string $max = '1'], [string $width = '11.85546875'], [string $customWidth = '1'])

void generateCOLS ()

void generateDIMENSION (int $sizeX, int $sizeY)

void generatePAGEMARGINS ([string $left = '0.7'], [string $rigth = '0.7'], [string $bottom = '0.75'], [string $top = '0.75'], [string $header = '0.3'], [string $footer = '0.3'])

void generatePAGESETUP ([string $paperSize = '9'], [string $orientation = 'portrait'], [string $id = '1'])

void generateROW (string $r, string $spans)

void generateSELECTION (string $num)

void generateSHEETDATA ()

void generateSHEETFORMATPR ([string $baseColWidth = '10'], [string $defaultRowHeight = '15'])

void generateSHEETVIEW ([string $tabSelected = '1'], [string $workbookViewId = '0'])

void generateSHEETVIEWS ()

void generateTABLEPART ([string $id = '1'])

void generateTABLEPARTS ([string $count = '1'])

void generateV (string $num)

void generateWORKSHEET ()

string __toString ()

Variables

Inherited Variables

Inherited from CreateElement

CreateElement::$_xml

Methods

static method getInstance (line 75)

access: public

static CreateExcelSheet getInstance ()

Constructor __construct (line 44)

Construct

access: public

CreateExcelSheet __construct ()

Redefinition of:

CreateElement::__construct(): Construct

Destructor __destruct (line 54)

Destruct

access: public

void __destruct ()

Redefinition of:

CreateElement::__destruct(): Destruct

createExcelSheet (line 90)

Create excel sheet

access: public

void createExcelSheet (string $args[0], array $args[1])

string $args[0]
array $args[1]

generateC (line 324)

Generate c

access: protected

void generateC (string $r, string $s, [string $t = ''])

string $r
string $s
string $t

generateCOL (line 279)

Generate col

access: protected

void generateCOL ([string $min = '1'], [string $max = '1'], [string $width = '11.85546875'], [string $customWidth = '1'])

string $min
string $max
string $width
string $customWidth

generateCOLS (line 264)

Generate cols

access: protected

void generateCOLS ()

generateDIMENSION (line 187)

Generate dimension

access: protected

void generateDIMENSION (int $sizeX, int $sizeY)

int $sizeX
int $sizeY

generatePAGEMARGINS (line 361)

Generate pagemargins

access: protected

void generatePAGEMARGINS ([string $left = '0.7'], [string $rigth = '0.7'], [string $bottom = '0.75'], [string $top = '0.75'], [string $header = '0.3'], [string $footer = '0.3'])

string $left
string $rigth
string $bottom
string $top
string $header
string $footer

generatePAGESETUP (line 381)

Generate pagesetup

access: protected

void generatePAGESETUP ([string $paperSize = '9'], [string $orientation = 'portrait'], [string $id = '1'])

string $paperSize
string $orientation
string $id

generateROW (line 307)

Generate row

access: protected

void generateROW (string $r, string $spans)

string $r
string $spans

generateSELECTION (line 234)

Generate selection

access: protected

void generateSELECTION (string $num)

string $num

generateSHEETDATA (line 293)

Generate sheetdata

access: protected

void generateSHEETDATA ()

generateSHEETFORMATPR (line 249)

Generate sheetformatpr

access: protected

void generateSHEETFORMATPR ([string $baseColWidth = '10'], [string $defaultRowHeight = '15'])

string $baseColWidth
string $defaultRowHeight

generateSHEETVIEW (line 218)

Generate sheetview

access: protected

void generateSHEETVIEW ([string $tabSelected = '1'], [string $workbookViewId = '0'])

string $tabSelected
string $workbookViewId

generateSHEETVIEWS (line 204)

Generate sheetviews

access: protected

void generateSHEETVIEWS ()

generateTABLEPART (line 411)

Generate tablepart

access: protected

void generateTABLEPART ([string $id = '1'])

string $id

generateTABLEPARTS (line 397)

Generate tableparts

access: protected

void generateTABLEPARTS ([string $count = '1'])

string $count

generateV (line 343)

Generate v

access: protected

void generateV (string $num)

string $num

generateWORKSHEET (line 170)

Generate worksheet

access: protected

void generateWORKSHEET ()

__toString (line 64)

access: public

string __toString ()

Redefinition of:

CreateElement::__toString()

Inherited Methods

Inherited From CreateElement

CreateElement::__construct()
CreateElement::cleanTemplate()
CreateElement::cleanTemplateFirstRPR()
CreateElement::generateANCHOR()
CreateElement::generateAVLST()
CreateElement::generateB()
CreateElement::generateBCS()
CreateElement::generateBLIP()
CreateElement::generateBLIPFILL()
CreateElement::generateCNVGRAPHICFRAMEPR()
CreateElement::generateCNVPICPR()
CreateElement::generateCNVPR()
CreateElement::generateDOCPR()
CreateElement::generateDRAWING()
CreateElement::generateEFFECTEXTENT()
CreateElement::generateEXT()
CreateElement::generateEXTENT()
CreateElement::generateFILLRECT()
CreateElement::generateGRAPHIC()
CreateElement::generateGRAPHICDATA()
CreateElement::generateGRAPHICPRAMELOCKS()
CreateElement::generateINLINE()
CreateElement::generateJC()
CreateElement::generateLINETO()
CreateElement::generateLN()
CreateElement::generateNOPROOF()
CreateElement::generateNVPICPR()
CreateElement::generateOFF()
CreateElement::generateP()
CreateElement::generatePIC()
CreateElement::generatePOSITIONH()
CreateElement::generatePOSITIONV()
CreateElement::generatePOSOFFSET()
CreateElement::generatePPR()
CreateElement::generatePRSTDASH()
CreateElement::generatePRSTGEOM()
CreateElement::generatePSTYLE()
CreateElement::generateQUITAR()
CreateElement::generateR()
CreateElement::generateRFONTS()
CreateElement::generateRPR()
CreateElement::generateRSTYLE()
CreateElement::generateSCHEMECLR()
CreateElement::generateSIMPLEPOS()
CreateElement::generateSOLIDFILL()
CreateElement::generateSPPR()
CreateElement::generateSTART()
CreateElement::generateSTRETCH()
CreateElement::generateT()
CreateElement::generateWRAPNONE()
CreateElement::generateWRAPPOLYGON()
CreateElement::generateWRAPSQUARE()
CreateElement::generateWRAPTHROUGH()
CreateElement::generateWRAPTOPANDBOTTOM()
CreateElement::generateXFRM()
CreateElement::__destruct()
CreateElement::__toString()

Class Constants

Inherited Constants

Inherited from CreateElement

CreateElement::MATHNAMESPACEWORD
CreateElement::NAMESPACEWORD