Exporting data to MS Excel

[Dawid Pustulka]

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.

[Captain Paralytic]

On 20 Jun, 12:13, Dawid Pustulka <[e-mail]:

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.

http://www.koders.com/php/fid2163EF6...A5.aspx?s=mary
has a simple class to create a workbook in Excel97 format.

phpclasses.org has some others.

Alternatively a tab delimited file with a .XLS sufix will load fine
into Excel.

To do cell size and borders you will need to create something in
Excel's xml format:

http://msdn2.microsoft.com/en-us/lib...ffice.10).aspx

[Moot]

On Jun 20, 7:50 am, Captain Paralytic <[e-mail]:

On 20 Jun, 12:13, Dawid Pustulka <[e-mail]:

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.

To do cell size and borders you will need to create something in
Excel's xml format:

http://msdn2.microsoft.com/en-us/lib...ffice.10).aspx

I find the XML method to be the easiest. But you don't have to bother
trying to learn the proper nodes and structure. Just make an excel
worksheet and fill it with fake data to make it look the way you want,
then Save As as XML and open the resulting document in a text editor.
You should be able to figure it out from there and replace the fake
data with the real.

[Captain Paralytic]

On 20 Jun, 12:57, Moot <[e-mail]:

On Jun 20, 7:50 am, Captain Paralytic <[e-mail]:

On 20 Jun, 12:13, Dawid Pustulka <[e-mail]:

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.

To do cell size and borders you will need to create something in
Excel's xml format:

http://msdn2.microsoft.com/en-us/lib...ffice.10).aspx

I find the XML method to be the easiest. But you don't have to bother
trying to learn the proper nodes and structure. Just make an excel
worksheet and fill it with fake data to make it look the way you want,
then Save As as XML and open the resulting document in a text editor.
You should be able to figure it out from there and replace the fake
data with the real.

Sometime I'll write a class to do it. Sometime.....

[petersprc]

On Jun 20, 7:13 am, Dawid Pustulka <[e-mail]:

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/t...-documents.htm

o You can export in CSV format the values only:

http://webdeveloper.terapad.com/inde...s&newsID=10879

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

http://pear.php.net/manual/en/packag...cel-writer.php

[Captain Paralytic]

On 20 Jun, 13:06, petersprc <[e-mail]:

On Jun 20, 7:13 am, Dawid Pustulka <[e-mail]:

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/t...-documents.htm

o You can export in CSV format the values only:

http://webdeveloper.terapad.com/inde...s.newsDetails&...

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

http://pear.php.net/manual/en/packag...dsheet-excel-w...

The csv link above is in fact a tab delimited format as I suggested
earlier.