![]() |
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. |
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. |
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. |
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