PHP Exporting Data to Files

Creating a .docx file to use as a template Creating a .odt file to use as a template Creating a spreadsheet in the OpenDocument format Adding the data and downloading as a .ods file Adding the data and outputting a .rtf file

Introducing PHPExcel Populating an Excel spreadsheet with data Formatting columns in PHPExcel Setting heading and paragraph styles Setting properties and defaults in PHPExcel Setting the spreadsheet’s print options

Generating XML from a database result Converting the main content file to XSLT_2 Converting the main content file to XSLT Merging XML documents with XSLT Outputting the database result to a text file Outputting the result as a CSV file Controlling CSV options with the Csv class

Preparing a directory to generate the output Saving the data to a local file Loading the test data into a database Querying the database with PDO Querying the database with MySQL Improved Inspecting the structure of an OpenDocument text file Extracting the main content file from a .odt document Extracting the main content file from a Word document Offering a choice of download formats Outputting the database result as a .docx file Outputting the database result as a .odt file Generating XML from a database result