Skip to end of metadata
Go to start of metadata
You are viewing an old version of this page. View the current version. Compare with Current  |   View Page History
New Proposal Template
This page has been created from a template that uses "zones." To proceed:
  1. Edit the page
  2. Replace sample content within each zone-data tag with your own content
  3. Remove this notice
  4. Save the page
  5. When you are ready for community review, move this page to the Ready for Review section on the edit page.
No placeholders allowed!
Please do not create placeholders. Wait until you have sufficient content to replace all sample data in the proposal template before creating your proposal document.

<ac:macro ac:name="unmigrated-inline-wiki-markup"><ac:plain-text-body><![CDATA[

Zend Framework: Zend\Excel Component Proposal

Proposed Component Name Zend\Excel
Developer Notes http://framework.zend.com/wiki/display/ZFDEV/Zend\Excel
Proposers Martin Keckeis
Zend Liaison TBD
Revision 1.0 - 1 February 2011: Initial Draft. (wiki revision: 11)

Table of Contents

1. Overview

Zend\Excel is a simple component that can read and write Ecma Office Open XML File Formats, which is common known under the *.xlsx file.

2. References

3. Component Requirements, Constraints, and Acceptance Criteria

  • This component will not read/write Excel 5 files
  • This component will read/write Ecma Office Open XML File Formats and upwards
  • This component will use Zend\Cache for caching readed files
  • This component will use Zend\Translate and/or Zend\Locale for translating formulas and other things

4. Dependencies on Other Framework Components

  • Zend\Exception
  • Zend\Cache
  • Zend\Translate
  • Zend\Locale
  • Zend\Config (maybe)

5. Theory of Operation

The component is instantiated with a mind-link that ...

6. Milestones / Tasks

  • Milestone 1: Reading/Understanding the whole XML parts which are possible in the ZIP of word, excel, powerpoint
  • Milestone 2: Checking what parts are identical in the word/powerpoint/excel 2007 XML. If there are enough identical that it's worth to abstract -> If not: Skip Milestone 3 and procced with Milestone 4
  • Milestone 3: Rename the component to Zend\Microsoft or Zend\Office. Now this component will be able to be used by word, excel and powerpoint (in future)
  • Milestone 4: Class structure
  • Milestone 5: Working prototype
  • Milestone 6: Feedback
  • Milestone 7: Writing Tests
  • Milestone 8: Final coding
  • Milestone 9: Documentation / Review

7. Class Index

  • Zend\Excel\Exception
  • Zend\Excel\Excel (factory class)
  • Zend\Excel\Worksheet
  • Zend\Excel\Cell
  • Zend\Excel\Style
  • ....

8. Use Cases

UC-01 write

use Zend\Excel;
$excel = new Excel(...);
$excel->setMetadata(...);

$worksheet = $excel->getWorksheet(...);
$worksheet->setHead(...);
$worksheet->setFooter(...);

$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');

9. Class Skeletons

]]></ac:plain-text-body></ac:macro>

Labels:
None
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.