Posted by petersprc on 06/20/07 12:06

On Jun 20, 7:13 am, Dawid Pustulka <DPustu...@gmail.com> wrote:
> How to export data to xls file using PHP? Is it possible to edit a
> look of document (like cell size, borders etc.) ? Please help.

Hi,

There are a few options you might like:

o You can export the data as an HTML table:

http://www.php-mysql-tutorial.com/php-mysql-select.php

o Use the Excel.Application COM object on windows:

http://web.informbank.com/articles/technology/php-office-documents.htm

o You can export in CSV format the values only:

http://webdeveloper.terapad.com/index.cfm?fa=contentNews.newsDetails&newsID=10879

o Or use the PEAR Spreadsheet_Excel_Writer class to create an excel
doc:

http://pear.php.net/manual/en/package.fileformats.spreadsheet-excel-writer.php

• Next in forum: Re: Exporting data to MS Excel
• Prev in forum: Re: Exporting data to MS Excel
• Thread view: Re: Exporting data to MS Excel

[Reply to this message]