Adding support for autofilters to PHP Excel library

Анульовано Опубліковано %project.relative_time Оплачується при отриманні
Анульовано Оплачується при отриманні

An autofilter in Microsoft Excel adds drop-down lists to column headers, allowing for easy filtering by the user.

The task is to add support for writing autofilters to an existing open source library called PHPExcel. The library currently does not support autofilters in the Excel5 (.xls) format, but does support it in the Excel 2007 (.xlsx) format.

**Tasks **

1. Obtain the latest stable version of PHPExcel library from http://phpexcel.codeplex.com.

2. Add support for creating autofilters in PHPExcel_Writer_Excel5 package. It is not required to add support for actually setting a filter value. Having a working drop-down list is sufficient.

3. Make the new code work via PHPExcel's setAutoFilter() function, the same way it works for Excel2007 format.

4. Demonstrate that it works by changing the PHPExcel file "Tests/[url removed, login to view]" to use the Excel5 writer instead of Excel2007. Verify that you actually see autofilters by opening the file in Excel 2003, 2007 or 2010. If you don't have Excel, you can use the Excel viewer 2003 (free download) or OpenOffice/LibreOffice. Excel should not throw any errors.

5. Deliver the full library in a zip/[url removed, login to view] archive.

**Hints **

* Look at the Spreadsheet::WriteExcel library on CPAN for a working implementation of the autofilters in Perl for the Excel5 format.

* You have to write an AutofilterinfoRecord which contains the number of filters, and create an MSODRAWING and an OBJ for each column containing a filter. The PHPExcel code may already contain code for writing these objects.

*

* Microsoft has documentation on the Excel binary format here: [url removed, login to view]

Техніка PHP Управління проектом Установка скріпту Shell Script Архітектура ПЗ Тестування ПЗ

ID Проекту: #2717983

Про проект

Дистанційний проект Остання активність Mar 17, 2012