With CakePHP you can easily insert data to database or how create views from database models. At times, however, you need to output your database model as a spreadsheet file or need to Importing the records from an excel file. In this article I’ll share with you some useful tutorials and resoureces how to deal with .xls files on CakePHP.

Generate Excel spreadsheets from your database

In this article Jan Boonen will show how you can use PEAR’s Spreadsheet_Excel_Writer class to generate an Excel spreadsheet with CakePHP.

CakePHP – php-excel-reader

In this tutorial we will learn how to importing the records from an excel file would probably the most common and straight forward way.

CakePHP – Read data from an excel file into an array

This tutorial teach us how to read the excel content for processing instead of just displaying it in the view.

CakePHP – Export data to a .xls file

In this tutorial, ykyuen teach us how to create a .xls in CakePHP

Excel xls helper

Useful Helper to creation of simple xls files.

CakePHP Excel Helper

This is a helper for building multi-sheets Excel documents in CakePHP. The hepler was inspired from Yuen Ying’s blog post, but it’s extended to support multiple sheets.

Incoming search terms for the article:

• cakephp xls
• cakephp excel export
• cakephp excel helper
• cakephp excel
• cakephp export xls
• cakephp read xls
• cakephp export to excel
• cakephp export excel
• cakephp generate xls
• cakephp excel reader