Version 23 by Martin Keckeis
on Feb 15, 2011 07:18.
<< Changes from 22 to 23
compared with
Current by Martin Keckeis
on Feb 15, 2011 11:30.
Key
This line was removed.
This word was removed. This word was added.
This line was added.

Changes (14)

View Page History
<ac:macro ac:name="unmigrated-inline-wiki-markup"><ac:plain-text-body><![CDATA[{zone-template-instance:ZFPROP:Proposal Zone Template}
{zone-data:component-name}
Zend\OfficeOpen
...

{zone-data:operation}
General for using this component, the ZipArchive and XML Manipulating from PHP is needed.

||UC-01 write||
1. User defines what shall be written to the output (texts, images, meta-data, formatting, ...)
2. Forwarding the provided data to the generation classes
3. Generate and write each single XML document
4. Putting it in the ZIP together
...

||UC-012 open/read||
1. Unzip the XMLs
2. open [Content_Types].xml and _rels/.rels (these two files are required minimal)
3. Looping through the needed files (from user)
4. Return output
...

||UC-03 read + write||
...

{zone-data}

...
{zone-data:use-cases}
||UC-01 write||
use Zend\Excel;
$excel = new Excel(...);
$excel->setMetadata(...);

$worksheet = $excel->getWorksheet(...);
$worksheet->setHead(...);
$worksheet->setFooter(...);
||UC-02 read||

$style1 = new Excel\Style();
$style1->setBorder(...);
$style1->setBackgroundColor(...);
$style1->setColor(...);

$cell = new Excel\Cell();
$cell->setText('cellText');
$cell->setStyle($style1);

$worksheet->setCell('A', '1', $cell);

$excel->render('test.xlxs');
{zone-data}

...
{zone-data}

{zone-template-instance}
{zone-template-instance}]]></ac:plain-text-body></ac:macro>