From the course: PHP: Exporting Data to Files

Unlock the full course today

Join today to access over 22,700 courses taught by industry experts or purchase this course individually.

Creating a spreadsheet in the OpenDocument format

Creating a spreadsheet in the OpenDocument format - PHP Tutorial

From the course: PHP: Exporting Data to Files

Start my 1-month free trial

Creating a spreadsheet in the OpenDocument format

“

OpenDocument format is an international standard designed to eliminate the problems with vendor-specific formats for spreadsheets, presentations, and word process documents. It's used by open source suites, such as Apache Open Office and Libra Office. What might come as a surprise is that it's also supported by Microsoft Office Ever since Office 2007 for Windows and Office 2008 for Mac, document contents are stored in a portable XML format designed to be interoperable with other software. It's not identical to the format used by Open Source Office Suite, but it's broadly compatible. In the exercise files of this video, there is a copy of cars.xlsx, which was generated by PHPExcel. If I right click it, I can open it with OpenOfficeCalc, and it displays absolutely perfectly. I can also open in LibraOfficeCalc. It displays pretty well, but for some reason the text wrap works only in this first row of the description column. So with PHPExcel creating a nicely formatted spreadsheet that's…

Contents