php-excel - Project Hosting on Google Code

Last 30 days Dec 09, 2009 issue 14 (Nothing happens when launching the code inside test.php in a...) reported by mslevinge - What steps will reproduce the problem? 1. Copy test.php's code into the page I created below 2. Launch the page 3. Nothing appears What is the expected output? What do you see instead? The arrays contain data but nothing happens. I am able to print_r($excelSheet) and confirm it contains data. I have also used the test.php code to confirm it is not my array that is the issue. It is really puzzling - even if I copy paste the test.php code, and made sure that the class file is in the same folder, nothing appears. The rest of my page functions as expected. What version of the product are you using? On what operating system? Latest version (the 2009 build) Please provide any additional information below. Please see attached file What steps will reproduce the problem? 1. Copy test.php's code into the page I created below 2. Launch the page 3. Nothing appears What is the expected output? What do you see instead? The arrays contain data but nothing happens. I am able to print_r($excelSheet) and confirm it contains data. I have also used the test.php code to confirm it is not my array that is the issue. It is really puzzling - even if I copy paste the test.php code, and made sure that the class file is in the same folder, nothing appears. The rest of my page functions as expected. What version of the product are you using? On what operating system? Latest version (the 2009 build) Please provide any additional information below. Please see attached file Dec 03, 2009 issue 13 (Error in output excel file from format conflict) commented on by mattmaye...@ucla.edu - This change didn't do anything for me. When I open the file I still get this message: "The file you are trying to open, 'my-test-3.xls', is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?" It then lets me open the file, but I'd really like to get rid of that warning. Any help would be greatly appreciated. Thanks! This change didn't do anything for me. When I open the file I still get this message: "The file you are trying to open, 'my-test-3.xls', is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?" It then lets me open the file, but I'd really like to get rid of that warning. Any help would be greatly appreciated. Thanks! Earlier this year Oct 08, 2009 issue 13 (Error in output excel file from format conflict) commented on by dongkun.113 - may be XML not entire be encoded. may be XML not entire be encoded. Oct 08, 2009 issue 13 (Error in output excel file from format conflict) reported by dongkun.113 - if we want to store data "</Data>", this will conflict width excel format so i add <![CDATA[ ]]> to avoid this, the changes was in the file attached. if we want to store data "</Data>", this will conflict width excel format so i add <![CDATA[ ]]> to avoid this, the changes was in the file attached. Sep 29, 2009 issue 12 (htmlentities function doesn't work) changed by oliver.schwarz - Version 1.1 already supports the remote setting of the encoding. UTF-8 is not required anymore for exporting data. When you create the data dump just use the correct/necessary encoding when calling the constructor. Status: Fixed Owner: oliver.schwarz Labels: Milestone-Release1.1 Version 1.1 already supports the remote setting of the encoding. UTF-8 is not required anymore for exporting data. When you create the data dump just use the correct/necessary encoding when calling the constructor. Status: Fixed Owner: oliver.schwarz Labels: Milestone-Release1.1 Sep 29, 2009 issue 11 (Improvements: Using a debugger to measure performance) Labels changed by oliver.schwarz - Labels: Milestone-Release1.2 Labels: Milestone-Release1.2 Sep 29, 2009 issue 11 (Improvements: Using a debugger to measure performance) Status changed by oliver.schwarz - Introducing Xdebug: I've made the first tests using Xdebug as memory monitoring. Creation of files mainly poses threads to the object which will be created before sent into the file. I am currently working on version 1.2 and will post key findings and performance analysis before the release. Status: Started Introducing Xdebug: I've made the first tests using Xdebug as memory monitoring. Creation of files mainly poses threads to the object which will be created before sent into the file. I am currently working on version 1.2 and will post key findings and performance analysis before the release. Status: Started Sep 29, 2009 issue 5 (Open Office) Status changed by oliver.schwarz - Version 1.2 will add the remote setting of the mimetype extension. Thus you can decide whether you'd like to export to OO or MS Excel. You may still open XML files with Excel using the "Open with..." dialog. Status: Started Version 1.2 will add the remote setting of the mimetype extension. Thus you can decide whether you'd like to export to OO or MS Excel. You may still open XML files with Excel using the "Open with..." dialog. Status: Started Sep 29, 2009 issue 2 (Formulas?) Status changed by oliver.schwarz - I've checked various possibilities to insert formulas into the excel/XML document. Quite easy, when parsing the equal sign "=" at the beginning of the string. However, I decided, not to support formulas in version 1 releases of the library. Introducing formulas insertion needs more than the creation of an array for dumping into excel. So a preparation wrapper would be the best way to enter single cells, add up to rows and finally to columns. This exceeds the idea of a simple dump library. Status: WontFix I've checked various possibilities to insert formulas into the excel/XML document. Quite easy, when parsing the equal sign "=" at the beginning of the string. However, I decided, not to support formulas in version 1 releases of the library. Introducing formulas insertion needs more than the creation of an array for dumping into excel. So a preparation wrapper would be the best way to enter single cells, add up to rows and finally to columns. This exceeds the idea of a simple dump library. Status: WontFix Sep 28, 2009 issue 12 (htmlentities function doesn't work) commented on by perrefe - mmmmm... I think this issue is resolved using ISO-8859-1 instead UTF-8. mmmmm... I think this issue is resolved using ISO-8859-1 instead UTF-8. Sep 28, 2009 issue 12 (htmlentities function doesn't work) reported by perrefe - What steps will reproduce the problem? 1. Send a value with character "ñ" to AddRow method What is the expected output? What do you see instead? I expect the correct word "compañia" I see a blank value What version of the product are you using? On what operating system? excel-class 1.1 php 5.2.x osx leopard 10.5.8 Thanks! What steps will reproduce the problem? 1. Send a value with character "ñ" to AddRow method What is the expected output? What do you see instead? I expect the correct word "compañia" I see a blank value What version of the product are you using? On what operating system? excel-class 1.1 php 5.2.x osx leopard 10.5.8 Thanks! Sep 27, 2009 issue 2 (Formulas?) commented on by perrefe - Hello! For a personal project I made this little modification to AddRow method to put a simple formula at worksheet if (preg_match('/^=/', $v)) { $type = 'Number'; //<Cell ss:StyleID="s21" ss:Formula="=100-(RC[-2]100/RC[-3])"><Data ss:Type="Number"></Data></Cell> $cells .= "<Cell ss:Formula=\"$v\"><Data ss:Type=\"$type\"></Data></Cell>\n"; } OBS: RC it's cells offset from current position I know this resolv my own issue and it's far from being a global solution , but may could help. Bye! Hello! For a personal project I made this little modification to AddRow method to put a simple formula at worksheet if (preg_match('/^=/', $v)) { $type = 'Number'; //<Cell ss:StyleID="s21" ss:Formula="=100-(RC[-2]100/RC[-3])"><Data ss:Type="Number"></Data></Cell> $cells .= "<Cell ss:Formula=\"$v\"><Data ss:Type=\"$type\"></Data></Cell>\n"; } OBS: RC it's cells offset from current position I know this resolv my own issue and it's far from being a global solution , but may could help. Bye! Sep 24, 2009 MemoryUsageAndExecutionTimes (Testing boundaries before publishing version 1.2) Wiki page added by oliver.schwarz - Revision r50 Writing about first performance analysis in version 1.2. Revision r50 Writing about first performance analysis in version 1.2. Sep 11, 2009 Upcoming (Basic info and Roadmap for the PHP Excel converter.) Wiki page edited by oliver.schwarz - Revision r49 Edited wiki page through web user interface. Revision r49 Edited wiki page through web user interface. Sep 11, 2009 Upcoming (Basic info and Roadmap for the PHP Excel converter.) Wiki page edited by oliver.schwarz - Revision r48 Edited wiki page through web user interface. Revision r48 Edited wiki page through web user interface. Sep 11, 2009 Upcoming (Basic info and Roadmap for the PHP Excel converter.) Wiki page edited by oliver.schwarz - Revision r47 Edited wiki page through web user interface. Revision r47 Edited wiki page through web user interface. Sep 11, 2009 Upcoming (Basic info and Roadmap for the PHP Excel converter.) Wiki page edited by oliver.schwarz - Revision r46 Edited wiki page through web user interface. Revision r46 Edited wiki page through web user interface. Sep 11, 2009 Upcoming (Basic info and Roadmap for the PHP Excel converter.) Wiki page edited by oliver.schwarz - Revision r45 Edited wiki page through web user interface. Revision r45 Edited wiki page through web user interface. Sep 11, 2009 Upcoming (Basic info and Roadmap for the PHP Excel converter.) Wiki page edited by oliver.schwarz - Revision r44 Edited wiki page through web user interface. Revision r44 Edited wiki page through web user interface. Sep 11, 2009 DesignGuidelines Wiki page deleted by oliver.schwarz - Revision r43 Deleting wiki page DesignGuidelines. Revision r43 Deleting wiki page DesignGuidelines. Sep 11, 2009 DesignGuidelines Wiki page added by oliver.schwarz - Revision r41 Created wiki page through web user interface. Revision r41 Created wiki page through web user interface. Sep 11, 2009 Upcoming (Plans about what I am going to do with my project.) Wiki page edited by oliver.schwarz - Revision r40 Edited wiki page through web user interface. Revision r40 Edited wiki page through web user interface. Sep 11, 2009 Upcoming (Plans about what I am going to do with my project.) Wiki page edited by oliver.schwarz - Revision r39 Edited wiki page through web user interface. Revision r39 Edited wiki page through web user interface. Sep 11, 2009 Upcoming (Plans about what I am going to do with my project.) Wiki page edited by oliver.schwarz - Revision r38 Edited wiki page through web user interface. Revision r38 Edited wiki page through web user interface. Sep 11, 2009 Upcoming (Plans about what I am going to do with my project.) Wiki page edited by oliver.schwarz - Revision r37 Some features were already implemented in version 1.1 Revision r37 Some features were already implemented in version 1.1 Sep 10, 2009 issue 11 (Improvements: Using a debugger to measure performance) reported by oliver.schwarz - I need to use a debugger (or something) to measure the performance of the class methods. I am too unsure to decide whether I use array_slice or a for loop to resize an array which is possibly too large to handle. I need to use a debugger (or something) to measure the performance of the class methods. I am too unsure to decide whether I use array_slice or a for loop to resize an array which is possibly too large to handle. Sep 10, 2009 r36 (Security fix: The library now stops to throw out lines to th...) committed by oliver.schwarz - Security fix: The library now stops to throw out lines to the output when the default excel maximum lines is reached (65536 lines). Added a test for this, trying to generate more than 100000 lines. Security fix: The library now stops to throw out lines to the output when the default excel maximum lines is reached (65536 lines). Added a test for this, trying to generate more than 100000 lines. Sep 10, 2009 r35 (Tagging version 1.1.) committed by oliver.schwarz - Tagging version 1.1. Tagging version 1.1. Sep 10, 2009 issue 4 (Internet Explorer 7 compatibility issue) changed by oliver.schwarz - Thanks for this input/fix. I will try to improve the sent header in one of the next version. It's quite difficult to test this in all MS/Office/IE combinations. Status: Accepted Owner: oliver.schwarz Thanks for this input/fix. I will try to improve the sent header in one of the next version. It's quite difficult to test this in all MS/Office/IE combinations. Status: Accepted Owner: oliver.schwarz Sep 10, 2009 issue 6 (PHP excel xml report creating using loops ) changed by oliver.schwarz - I am really sorry, but generally by using the library you should not need to echo the rows yourself. How do you create this problem or better: In which contexts is the problem created. In the library I wanted to avoid using set fields like NamedCell or attributes like ss:StyleID (this should be done afterwards manually). How can I help you in this? Status: Invalid Owner: oliver.schwarz I am really sorry, but generally by using the library you should not need to echo the rows yourself. How do you create this problem or better: In which contexts is the problem created. In the library I wanted to avoid using set fields like NamedCell or attributes like ss:StyleID (this should be done afterwards manually). How can I help you in this? Status: Invalid Owner: oliver.schwarz Sep 10, 2009 issue 1 (There's no readme and no explanation yet) changed by oliver.schwarz - A readme file has been included in Version 1.1. It explains the different ways of using the constructor options. Status: Fixed Labels: Milestone-Release1.1 A readme file has been included in Version 1.1. It explains the different ways of using the constructor options. Status: Fixed Labels: Milestone-Release1.1 Sep 10, 2009 issue 9 (XML entities are not encoded) Labels changed by oliver.schwarz - Labels: Milestone-Release1.2 Labels: Milestone-Release1.2 Sep 10, 2009 issue 5 (Open Office) Labels changed by oliver.schwarz - Labels: Milestone-Release1.2 Labels: Milestone-Release1.2 Sep 10, 2009 issue 5 (Open Office) changed by oliver.schwarz - I believe there is a simple solution to this: Just replace the mimetype xls by xml (Filename: test.xml) and it should work in OpenOffice Calc. However, I'll still need to test this and I will provide a solution in the next version. Status: Accepted Owner: oliver.schwarz I believe there is a simple solution to this: Just replace the mimetype xls by xml (Filename: test.xml) and it should work in OpenOffice Calc. However, I'll still need to test this and I will provide a solution in the next version. Status: Accepted Owner: oliver.schwarz Sep 10, 2009 issue 2 (Formulas?) changed by oliver.schwarz - I just took a look into the formula thing and I am quite impressed how excel deals with this. However, I am not sure how to implement such a feature. Adding formular usage to the class will definitely make it lose it's "lightweight". Status: Accepted Owner: oliver.schwarz I just took a look into the formula thing and I am quite impressed how excel deals with this. However, I am not sure how to implement such a feature. Adding formular usage to the class will definitely make it lose it's "lightweight". Status: Accepted Owner: oliver.schwarz Sep 10, 2009 ChangeLog (This is the changelog of the simple php-excel library) Wiki page edited by oliver.schwarz - Revision r34 Added some lines about compatibility and structuring the file by version. Revision r34 Added some lines about compatibility and structuring the file by version. Sep 10, 2009 ChangeLog (This is the changelog of the simple php-excel library) Wiki page added by oliver.schwarz - Revision r33 Starting the changelog. Revision r33 Starting the changelog. Sep 10, 2009 QuickUsageGuide (Quick and dirty guide to using php-excel.) Wiki page commented on by oliver.schwarz - @gmeader (Oct 2008): Converting chars while writing into the cells is a question of performance. This is a great piece of code you put there! I will see if I can adapt this. I have to do some tests for this. @gmeader (Oct 2008): Converting chars while writing into the cells is a question of performance. This is a great piece of code you put there! I will see if I can adapt this. I have to do some tests for this. Sep 10, 2009 QuickUsageGuide (Quick and dirty guide to using php-excel.) Wiki page commented on by oliver.schwarz - Thanks a lot for all these comments. I haven't exactly reviewed all of them, but a few issues have been fixed with the new version 1.1. Please check the download section of the project. Here are a few answers to some comments: @xmarkvh (from 2007): I will see if I can improve the issue with the automatic type conversion (strings <> numbers). Sometimes, you do not want to convert values to numbers (article numbers starting with zero). I will see, if I can improve this in later version. @z1nkum (Jan 2009): Version 1.1 now provides the remote setting of the charset in the constructor: {{{ $xls = new Excel_XML('WINDOWS-1251'); }}} should do the trick ;) @z1nkum (May 2009): I haven't tested this yet in IE8. I may improve the header-directive settings in the next version. Thanks for the input! @jimnau9 (Dec 2008): Thanks for the input. I will implement an MS Excel/OpenOffice switch in the next versions. Thanks a lot for all these comments. I haven't exactly reviewed all of them, but a few issues have been fixed with the new version 1.1. Please check the download section of the project. Here are a few answers to some comments: @xmarkvh (from 2007): I will see if I can improve the issue with the automatic type conversion (strings <> numbers). Sometimes, you do not want to convert values to numbers (article numbers starting with zero). I will see, if I can improve this in later version. @z1nkum (Jan 2009): Version 1.1 now provides the remote setting of the charset in the constructor: {{{ $xls = new Excel_XML('WINDOWS-1251'); }}} should do the trick ;) @z1nkum (May 2009): I haven't tested this yet in IE8. I may improve the header-directive settings in the next version. Thanks for the input! @jimnau9 (Dec 2008): Thanks for the input. I will implement an MS Excel/OpenOffice switch in the next versions. Sep 10, 2009 r32 (Adding the new version 1.1 (and new testcases, single-file l...) committed by oliver.schwarz - Adding the new version 1.1 (and new testcases, single-file license and readme) to the trunk. Old version is tagged 01 and is still available. Adding the new version 1.1 (and new testcases, single-file license and readme) to the trunk. Old version is tagged 01 and is still available. Sep 10, 2009 r31 (Tagging old version 01.) committed by oliver.schwarz - Tagging old version 01. Tagging old version 01. Sep 10, 2009 issue 9 (XML entities are not encoded) changed by oliver.schwarz - I've tried to fix this with version 1.1. However, I still need to test this thoroughly. Check the download section at: http://code.google.com/p/php-excel/downloads/list Status: Started Owner: oliver.schwarz I've tried to fix this with version 1.1. However, I still need to test this thoroughly. Check the download section at: http://code.google.com/p/php-excel/downloads/list Status: Started Owner: oliver.schwarz Sep 10, 2009 issue 10 (Filename is not escaped and therefore is a potential problem) Status changed by oliver.schwarz - The filename is now 1) optional and 2) escaped by a whitelist filter. Status: Fixed The filename is now 1) optional and 2) escaped by a whitelist filter. Status: Fixed Sep 10, 2009 issue 7 (utf8_encode of cyrillic characters) changed by oliver.schwarz - I have removed the utf8_encode from version 1.1 which is available now in the [http://code.google.com/p/php-excel/downloads/list download section] of the project. Additionally you may set the desired encoding in the constructor of the file. See the attached readme.txt for details. I still need to validate this with other charsets. Status: Fixed Owner: oliver.schwarz I have removed the utf8_encode from version 1.1 which is available now in the [http://code.google.com/p/php-excel/downloads/list download section] of the project. Additionally you may set the desired encoding in the constructor of the file. See the attached readme.txt for details. I still need to validate this with other charsets. Status: Fixed Owner: oliver.schwarz Sep 10, 2009 issue 8 (fix Number Stored as Text error) changed by oliver.schwarz - Thanks again for posting your fix. I've addressed this issue in the new version 1.1, which is available in the [http://code.google.com/p/php-excel/downloads/list download section] of the project. However, activating the auto-type identification remains optional since there are cases where you do not want the library to autoconvert values (for example: german postcodes starting with 0). Status: Fixed Owner: oliver.schwarz Thanks again for posting your fix. I've addressed this issue in the new version 1.1, which is available in the [http://code.google.com/p/php-excel/downloads/list download section] of the project. However, activating the auto-type identification remains optional since there are cases where you do not want the library to autoconvert values (for example: german postcodes starting with 0). Status: Fixed Owner: oliver.schwarz Sep 10, 2009 issue 3 (Implode() doesn't work well with large arrays) changed by oliver.schwarz - This issue is resolved with version 1.1. Version 1.1 is now available and should be fully compatible with code based on version 1.0. Please refer to the [http://code.google.com/p/php-excel/downloads/list download section] to retrieve the new version. Status: Fixed Owner: oliver.schwarz This issue is resolved with version 1.1. Version 1.1 is now available and should be fully compatible with code based on version 1.0. Please refer to the [http://code.google.com/p/php-excel/downloads/list download section] to retrieve the new version. Status: Fixed Owner: oliver.schwarz Sep 10, 2009 php-excel-v1.1-20090910.zip (PHP-Excel Version 1.1) file uploaded by oliver.schwarz - Labels: Type-Source Featured Labels: Type-Source Featured Sep 10, 2009 r30 (Adding a default filename to generateXML-method to prevent a...) committed by oliver.schwarz - Adding a default filename to generateXML-method to prevent an error when delivering out the file. Adding a default filename to generateXML-method to prevent an error when delivering out the file. Sep 10, 2009 r29 (Removing license info from the class, putting a link to the ...) committed by oliver.schwarz - Removing license info from the class, putting a link to the MIT license instead. Removing license info from the class, putting a link to the MIT license instead. Sep 10, 2009 r28 (Adding a line of documentation.) committed by oliver.schwarz - Adding a line of documentation. Adding a line of documentation.

QuickUsageGuide (Quick and dirty guide to using php-excel.) Wiki page commented on by oliver.schwarz - Thanks a lot for all these comments. I haven't exactly reviewed all of them, but a few issues have been fixed with the new version 1.1. Please check the download section of the project. Here are a few answers to some comments: @xmarkvh (from 2007): I will see if I can improve the issue with the automatic type conversion (strings <> numbers). Sometimes, you do not want to convert values to numbers (article numbers starting with zero). I will see, if I can improve this in later version. @z1nkum (Jan 2009): Version 1.1 now provides the remote setting of the charset in the constructor: {{{ $xls = new Excel_XML('WINDOWS-1251'); }}} should do the trick ;) @z1nkum (May 2009): I haven't tested this yet in IE8. I may improve the header-directive settings in the next version. Thanks for the input! @jimnau9 (Dec 2008): Thanks for the input. I will implement an MS Excel/OpenOffice switch in the next versions.

Thanks a lot for all these comments. I haven't exactly reviewed all of them, but a few issues have been fixed with the new version 1.1. Please check the download section of the project. Here are a few answers to some comments: @xmarkvh (from 2007): I will see if I can improve the issue with the automatic type conversion (strings <> numbers). Sometimes, you do not want to convert values to numbers (article numbers starting with zero). I will see, if I can improve this in later version. @z1nkum (Jan 2009): Version 1.1 now provides the remote setting of the charset in the constructor: {{{ $xls = new Excel_XML('WINDOWS-1251'); }}} should do the trick ;) @z1nkum (May 2009): I haven't tested this yet in IE8. I may improve the header-directive settings in the next version. Thanks for the input! @jimnau9 (Dec 2008): Thanks for the input. I will implement an MS Excel/OpenOffice switch in the next versions.

Last 30 days

Earlier this year