make OpenOffice & Office documents using templates
This package can merge OpenOffice and Microsoft Office templates with values, SQL and other data.
It is a plug-in for the TinyButStrong template engine. It can then open compressed documents in the format of OpenOffice or Microsoft Office and replace placeholders in the template by data which can be PHP variables, SQL queries, or other.
The resulting documents are saved to file, served for download or returned as a string.
It can merge any OpenDocuments files, any OpenXML files, and any XML files compressed in a zip archive.
This class you can also insert pictures in the documents, add and deleted any files in the archive.
It can also merge row and columns in Microsoft Excel (xlsx) and OpenOffice Calc (ods) spreadsheets. And also merge data in chart embedded in Microsoft Word documents (docx).
Create Microsoft Word document without COM objects
This class can be used to generate documents in Microsoft Word .doc format without using COM objects so it can work under Linux or other non-Windows based servers.
It may be useful to generate and serve documents that may be edited by the end users using Microsoft Word or OpenOffice.
The class generates XHTML documents with special tags and attributes that Microsoft Word understands like any variant of the .doc format.
In Portuguese:
MsDocGenerator é uma classe para gerar arquivos DOC, sem utilizar objetos COM, o que permite sua utilização em servidores que não estão rodando o Windows.
A classe gera um documento HTML em um formato específico, que o MSWord interpreta como se este fosse um arquivo DOC.
Pode ser útil na geração de relatórios, os quais o usuário final queira fazer alterações usando o Word ou o OpenOffice.
This class can be used to generate OpenOffice by using templates and a template engine to replace the template placeholders by parameter values.
The class extends the template engine class TinyButStrong.
The class allows the creation of OpenOffice documents dynamically, providing the separation between the document formatting logic and content.
In practice, you create a template using OpenOffice with the TinyButStrong tags. Then you create a PHP script that calls the class to merges the document template with dynamically defined data to generate the output OpenOffice document.
Features:
- It works on Linux, Windows and other platforms.
- It works with OpenOffice 1.x documents and the new format used in OpenOffice 2 (OpenDocument 1.0, OASIS standard).
- It does not need an installation of OpenOffice on the server.
- It uses the TinyButStrong native syntax and methods. It can merge 'var' and 'blocks' using the TinyButStrong syntax like (var, block, if, then, frm, ...). The merge results respects the layout, justification and styles used in the template.
This package can be used to browse and edit data stored in a MySQL database.
It generates an AJAX Web based interface to edit, insert, search rows of MySQL database tables.
It can be used to update and delete multiple records at once. It may also prevent editing or deleting records by simultaneous users.
Each database table record to be edited can be bound to given form inputs. The main class can generate Javascript for browser side validation and also perform server side validation.
The class can handle submission of data in the form of files. Uploaded files are copied to specific folders, if the uploaded files not exist already.
The class and also list and search for records to be edited or deleted. Search fields support AJAX based auto-complete suggestions. Search results can be saved to CSV files or XML files for Excel/OpenOffice.
Search results are displayed with pagination links in tables with different colors or CSS styles for different rows. Search result columns can be linked to other pages.
Read and write spreadsheet files in the ODS format
This class can be use to read and write spreadsheet files in the Open Document Spreadsheet (ODS) Format used by OpenOffice.
It can create spreadsheets by adding or changing the values of the cells, rows or formulas.
The class can create the spreadsheet files by generating the document XML files in its directory structure and then using the zip command to generate a single packed archive in the ODS compressed format.
It can also do the opposite by extracting a ODS zip archive and parsing the spreadsheet XML files to extract the cell data values into class variables.
This package can be used to generate spreadsheet documents in the OpenOffice format.
It uses template XML files to generate the different parts of an OpenOffice spreadsheet document: table cell contents, styles, settings, metadata and manifest.
The templates are processed and the output XML part is generated according to the contents of the spreadsheet defined by the application.
To see some examples and how-to-use informations, please visit the website (in french only) :
http://membres.lycos.fr/tafelmak/