Class CreateExcelSheet

Description

Create excel sheet

Located in /CreateExcelSheet.inc (line 29)

CreateElement
   |
   --CreateExcelSheet
Method Summary
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 generateSHEETFORMATPR ([string $baseColWidth = '10'], [string $defaultRowHeight = '15'])
void generateSHEETVIEW ([string $tabSelected = '1'], [string $workbookViewId = '0'])
void generateTABLEPART ([string $id = '1'])
void generateTABLEPARTS ([string $count = '1'])
void generateV (string $num)
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

Documentation generated on Tue, 23 Aug 2011 13:14:28 +0200 by phpDocumentor 1.4.3