Export to xls in customised way.

Question

My application is fetching a data dynamically from MYSQL and displaying. The Problem is even i have to give the option to "Export to Xls" file. And these file should be in a A4 size, so i should customize the font size of contents in the Xls file to fit into the A4 size.And i need to insert if possible image into the file.

Please help me to solve this as i am new to php and need to complete it within a day.

Answer 1

You can use

• PHPexcel or
• PEAR_Spreadsheet_Writer
• php_excel extension by Ilia Alshanetsky ^{(this requires a commercial license for libXL)}

to create the Excel Sheets.