reportWriterExcel
A shared writer that coverts the report data into a PHPExcel object that can then be output by additional writers that inherit this class.
Methods
protected abstract _storeFile($inXls)
Write out the file to the file system
private createReportOutput($inXls, $inReport, $sheet)
Creates appropriate sheets for the report
private createFormat($inXls, $inStyle, $inSection)
Creates a format for the specified section
private createWorksheet($inXls, $inReport, $inSheetNum, $inTitleFormat, $inDescFormat, $inHeadingFormat, [$inSetSheetNum = 1])
Creates a new worksheet on the specified Workbook
Also appends the title, description and columns and styling.
private getWidths($inReport)
Calculates the widths of strings
private _getColumnLetter($inNumber)
Converts column number to letter format used by Excel
Inherited Methods
- reportWriterBase::_compile()
- reportWriterBase::__construct()
- reportWriterBase::reset()
- reportWriterBase::initialise()
- reportWriterBase::compile()
- reportWriterBase::buildFileStore()
- reportWriterBase::isModified()
- reportWriterBase::setModified()
- reportWriterBase::getReport()
- reportWriterBase::setReport()
- reportWriterBase::getFilename()
- reportWriterBase::getFileStore()
- reportWriterBase::getFullPathToOutputFile()
- reportWriterBase::setFileStore()
- reportWriterBase::getExtension()
- reportWriterBase::setExtension()
- reportWriterBase::getMimeType()
- reportWriterBase::setMimeType()
Posted by: Scorpio Documentor (Writer), in Report on 19 Nov 2009 @ 20:31
Tags: report, reportwriterbase, reportwriterexcel,
This
work is licenced under a
Creative Commons Licence.