How can i write data into an excel using PHP

php export-to-excel
zod picture zod · Oct 19, 2010 · Viewed 68.7k times · Source

Is it possible to append content to an .xls file using PHP fwrite()?

When i try this using fwrite(), the resulting file causes an error message in Excel 2007.

Is there a specific separator I can use to accomplish this?

Is it possible without a third party library?

Answer

Mark Baker picture Mark Baker · Oct 19, 2010

You can use the PhpSpreadsheet library, to read an existing Excel file, add new rows/columns to it, then write it back as a real Excel file.

Disclaimer: I am one of the authors of this library.

Related questions

phpexcel to download

hello i am new to phpexcel, and i was wondering if there is some way send the excel i have created to the clients download without saving it on my server or to delete it right after he downloads it …

Read More
PHPExcel how to set cell value dynamically

How to set cell/column value dynamically using PHPExcel library? I am fetching result set from MySQL database and I want to write data in excel format using PHPExcel library. Looking at example $objPHPExcel->getActiveSheet()->setCellValue('A1…

Read More
Exporting data from php to excel

I need to export data from php (data retrieved from mysql database) to excel. I'm using Zend Framework. I need to do some changes to my data before exporting to excel. Actually, what I really need is to generate a …

Read More