ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   PHP Excel generation libraries (https://www.excelbanter.com/excel-programming/381615-php-excel-generation-libraries.html)

sikander iqbal

PHP Excel generation libraries
 
Hello,

I've tried using the PEAR Worksheet package to create .XLS files but
the spreadsheet format corresponds to Excel 5 format.

http://pear.php.net/manual/en/packag...iter.intro.php

I would like to be able to create an Excel file that adheres to the
Microsoft Office Excel Workbook format. Is there any PHP library, or
any other language's library, that would allow me to do so ?

Thanks.


Tom Ogilvy

PHP Excel generation libraries
 
Unless you are want some special capabilities found in later versions of
excel in the workbooks, the Excel 5 format is a valid Microsoft Office Excel
Workbook format.

--
Regards,
Tom Ogilvy

"sikander iqbal" wrote in message
ups.com...
Hello,

I've tried using the PEAR Worksheet package to create .XLS files but
the spreadsheet format corresponds to Excel 5 format.

http://pear.php.net/manual/en/packag...iter.intro.php

I would like to be able to create an Excel file that adheres to the
Microsoft Office Excel Workbook format. Is there any PHP library, or
any other language's library, that would allow me to do so ?

Thanks.




NickHK

PHP Excel generation libraries
 
If you need a newer format, try this VB code :
http://www.freevbcode.com/ShowCode.Asp?ID=6856

If you feel inclined, you can read the BIFF8 file format definition and add
any missing functionality...although I would make my output adhere to the
capabilities of this or your current PEAR component.

NickHK

"sikander iqbal" wrote in message
ups.com...
Hello,

I've tried using the PEAR Worksheet package to create .XLS files but
the spreadsheet format corresponds to Excel 5 format.


http://pear.php.net/manual/en/packag...iter.intro.php

I would like to be able to create an Excel file that adheres to the
Microsoft Office Excel Workbook format. Is there any PHP library, or
any other language's library, that would allow me to do so ?

Thanks.




Tom Ogilvy

PHP Excel generation libraries
 
Just to add:
based on the description at that link, the only obvious additional feature
beyond what BIFF5/Excel 5 supports that I saw was Merged cells.

The BIFF8 format also supported 32K characters in a cell, but my guess would
be that these classes doesn't support that, but I didn't examine the code to
see.

--
Regards,
Tom Ogilvy

"NickHK" wrote in message
...
If you need a newer format, try this VB code :
http://www.freevbcode.com/ShowCode.Asp?ID=6856

If you feel inclined, you can read the BIFF8 file format definition and
add
any missing functionality...although I would make my output adhere to the
capabilities of this or your current PEAR component.

NickHK

"sikander iqbal" wrote in message
ups.com...
Hello,

I've tried using the PEAR Worksheet package to create .XLS files but
the spreadsheet format corresponds to Excel 5 format.


http://pear.php.net/manual/en/packag...iter.intro.php

I would like to be able to create an Excel file that adheres to the
Microsoft Office Excel Workbook format. Is there any PHP library, or
any other language's library, that would allow me to do so ?

Thanks.







All times are GMT +1. The time now is 01:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com