From the course: PHP: Exporting Data to Files
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Introducing PHPExcel - PHP Tutorial
From the course: PHP: Exporting Data to Files
Introducing PHPExcel
This is cars.csv, that was created in the previous chapter. Csv files are useful for exporting data that's intended to be viewed in a spreadsheet. The main drawback with this sort of file, is that it doesn't have any formatting. For more professional finish, I recommend using PHPExcel, a powerful open-source library. That generates files in Microsoft Excel format. At the time of recording this video, the latest stable version of PHPExcel is 1.8.0 and that's the version included in the exercise files for this course. But if we scroll down to the News section of this site we can see that PHPExcel 2.0 is under development. This is likely to break some backwards compatibility so I recommend that you stick with the latest version of the run.x branch even if the 2.x branch has been released by the time you watch this video. And this news item here says that the 1.x branch will continue to be maintained alongside the development of the 2.x branch. The exercise files for this course contain…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
Introducing PHPExcel3m 31s
-
Setting properties and defaults in PHPExcel6m 58s
-
Setting the spreadsheet's print options5m 59s
-
Populating an Excel spreadsheet with data7m 46s
-
Formatting columns in PHPExcel5m 47s
-
Downloading the data as a .xlsx file5m 18s
-
Creating a spreadsheet in the OpenDocument format3m 4s
-
Creating columns and headers in Fusonic SpreadsheetExport6m 26s
-
Adding the data and downloading as a .ods file6m 52s
-
-
-
-
-
-