PHPExcel

Hello guys,I currently am experiencing 2 problems in regards with excel output. I don't know if it's a bug or not, if it's excel's fault or the phpexcel itself.__General info (Applied to both problems):__* This is how I generate my excel file. First ... [More] , I have a excel template that I created using Microsoft Excel 2007. Complete with formatting and print area settings, so I don't have to do some formatting in the process. So, I open the excel template file using the read template method in phpexcel, then set my data to the respective cells and the download the file to the client's PC.* All column widths in the templates are set in "1.5". __Problem #1__When the user with Microsoft Office 2010 and below opened the generated excel file, there are no problems whatsoever, everything is fine. The problem arises when the user has Office 365, then the first column's (Column A only) width automatically resizes to "8.5".One thing to note also is that, it only resizes column A when the user has Office 365 Enterprise edition, other version (Home, Business, etc) are all fine. (Base on my testing)__Problem #2__In the template, I set the print area to "A1:AS59, A60:AS118, A119:AS177, A178:AS236, A237:AS295, A296:AS354" (6 pages in total).When viewed in Office 365 (All versions), it's completely fine, but in Office 2010 and below, print area is set to "A1:AS59, A60:AS119, A120:AS179, A180:AS239, A240:AS299, A300:AS354"Additional details:Row widths are set to "15".Fonts are set to MS PGothic (Texts are in Japanese)Any help is much appreciated.Thanks in advance. [Less]

I'm creating an excel file using PHPEXCEL library in codeigniter.Actually i'm taking the data from one excel file and copying the data from loaded file to new file. Finally a new excel is creating with an extra row without data.But When I open that ... [More] file and saving without doing any modification (Simply opening the file and Ctrl+S), all the extra row commas are eliminating. This I have found the major error from the file comparision. I need to eliminate the commas at last programtically. http://codebeautify.org/file-diffPlease check the attached image.image description hereFirst Pane in the image is created file and second pane is after saving the file (Manually opened from location) $this->load->library('Excel'); $objPHPExcel_final = new PHPExcel(); $objPHPExcel_final->setActiveSheetIndex(0); // Loading new data file $objPHPExcel = PHPExcel_IOFactory::load($uploaded_file_path); $allDataInSheet = $objPHPExcel->getActiveSheet()->toArray(null, true, true, true); // Loading excel template for header $objPHPExcel_exist = PHPExcel_IOFactory::load($existing_file_path); $allDataInSheet_exist = $objPHPExcel_exist->getActiveSheet()->toArray(null, true, true, true); // Taking headers from exising and Putting Some Data into new Excel file $objPHPExcel_final->getActiveSheet()->SetCellValue("G" . $i, date("d/m/Y")); // Application Date $objPHPExcel_final->getActiveSheet()->SetCellValue("I" . $i, "Individual"); // Cover Type $objPHPExcel_final->getActiveSheet()->SetCellValue("J" . $i, "1"); // No.of Lives $objPHPExcel_final->getActiveSheet()->SetCellValue("K" . $i, "1"); // Tenure $objWriter_final->save('myfile.xls'); [Less]

MarkBaker has declined patch #18667. Comment:DANGEROUS SPAM

vico89 has uploaded a patch. Description:PROJECT

Home Features Requirements Examples FAQ Contribute Documents Credits Contact We moved to https://github.com/PHPOffice/PHPExcel nearly 5 years ago The site here on codeplex is no longer current! Please stop using it!!! PHPExcel - ... [More] OpenXML - Read, Write and Create Excel documents in PHP - Spreadsheet engine PHPExcel (OLD DEAD REPOSITORY) - visit PHPOffice/PHPExcel on github insteadCheckout the Features this class set provides, such as setting spreadsheet meta data (author, title, description, ...), multiple worksheets, different fonts and font styles, cell borders, fills, gradients, adding images to your spreadsheet, calculating formulas, converting between file types and much, much more!Want to bookmark this page? Please use http://www.phpexcel.net as the URL. Want to contribute? Please remember that we have been using github as our source repository for over two years now.... source code has not been maintained here on Codeplex in all that time. If you want to contribute, you can fork the develop branch from github. We do accept Pull Requests.Please refer the Contribute page. Downloads All code is now maintained on githubLast release here on codeplex: Cannot resolve release macro, invalid id. is not the latest official release News 2015-08-10 Friendly Reminder! We moved to https://github.com/PHPOffice/PHPExcel over 3 years agoThe site here on codeplex is no longer current 2014-03-02 Release 1.8.0 out now! Despite earlier news to the contrary, the 1.x branch of PHPExcel is still not end of line, and the branch will continue to be maintained alongside the development of the version 2.x branch for the time being.Current release Cannot resolve release macro, invalid id.. check the changelog for details! 2013-06-02 Looking forward to PHPExcel 2.0.0! Please note that PHPExcel 1.7.9 will be the last release of PHPExcel in the 1.x branch.The next release will be 2.0.0 and it will require a minimum PHP version of 5.3. This will allow us to take advantage of language features that are only available in 5.3, including namespaces, closures, late static binding and guaranteed access to SPL. These features will in turn allow us to make significant improvements in performance and memory usage, as well as making the code cleaner and easier to maintain.In addition to this core rewrite, planned changes to the PHPExcel functionality will include switching the XML-based readers to use XMLReader rather than SimpleXML; and a complete rewrite of the Calculation Engine to improve performance and provide support for array functions, for row and column references, for R1C1 references, better locale handling (particularly for date functions), and to make it more easily extensible.Where possible, we will try to make the API consistent with the current API, but these changes mean that scripts using PHPExcel 2.x will not always be fully backward compatible with scripts using PHPExcel 1.x, but we hope that the improvements will be worth it. 2013-06-02 Release 1.7.9 out now! Current release Cannot resolve release macro, invalid id.. check the changelog for details! 2013-05-22 Documentation now online! In honour of World Goth Day, most of the PHPExcel documentation is now online at https://github.com/PHPOffice/PHPExcel/wiki/User%20Documentation Looking for volunteers to help proofread and sanity test all the code snippets and recipes to be certain that they all work and are easily understandable. 2013-05-22 We are on Github! Please remember that we have been using github as our source repository for nearly a year now.... source code has not been maintained here on Codeplex in all that time. If you want to contribute, you can fork it. We do accept Pull Requests. 2012-12-18 Free German language e-book now available! For those who read German, Ralf Hohoff has published a free e-book on "Automated document generation with PHPExcel, PHPWord and PHPPowerPoint", available from http://ebookstr.e-bookshelf.de/php-for-office-403106.html. 2012-10-12 Release 1.7.8 out now! Current release Cannot resolve release macro, invalid id.. check the changelog for details! 2012-06-19 PHPExcel Moves to github! The source repository for PHPExcel, together with its sister projects PHPWord and PHPPowerPoint under the auspices of PHPOffice. The repository can be found at https://github.com/PHPOffice/PHPExcel, and the latest working development code is in the develop branch.This is the first part of series of changes in our development process which we believe will make it easier for us to do more frequent releases of better quality code. The next step will be CI integration for running automated unit testing against PHP 5.2, 5.3 and 5.4 using TravisCI.We shall be maintaining the CodePlex SVN Source repository in parallel for a time, but the github repository should be considered the definitive source. 2012-05-19 Release 1.7.7 out now! Current release Cannot resolve release macro, invalid id.. check the changelog for details! 2012-05-06 Ruby/PHP Bridge: accessing PHPExcel from Ruby! Kasper Johansen has written a Ruby PHP Bridge, allowing the use of PHPExcel from within Ruby.More details available from the code repository is at https://github.com/kaspernj/php_process for any Ruby coders wanting to try it. You can find a working example using PHPExcel to generate an Excel file at https://github.com/kaspernj/php_process/blob/master/examples/example_phpexcel.rb. 2012-01-02 PHPExcel Roadmap for 2012 2011-02-28 Release 1.7.6 out now! Current release Cannot resolve release macro, invalid id.. check the changelog for details! 2010-12-10 Release 1.7.5 out now! Current release Cannot resolve release macro, invalid id.. check the changelog for details! 2010-10-22 PHPExcel ported to Python! Eric Gazoni has just released the first version of a port of PHPExcel to Python... openpyxl/More details available from his blog at http://ericgazoni.wordpress.com/2010/04/10/openpyxl-python-xlsx/. and the code repository is at http://bitbucket.org/ericgazoni/openpyxl/ for any Python coders wanting to try it 2010-08-26 Release 1.7.4 out now! Current release Cannot resolve release macro, invalid id.. check the changelog for details!We now also have a full PEAR channel! Here's how to use it:New installation:pear channel-discover pear.pearplex.netpear install pearplex/PHPExcelOr if you've already installed PHPExcel before:pear upgrade pearplex/PHPExcelThe official page can be found at http://pearplex.net. 2010-05-31 Release 1.7.3c out now! Current release Cannot resolve release macro, invalid id., check the changelog for details! 2010-05-31 Release 1.7.3b out now! Current release Cannot resolve release macro, invalid id., check the changelog for details! 2010-05-17 Release 1.7.3 out now! Current release Cannot resolve release macro, invalid id., check the changelog for details! 2010-01-11 Release 1.7.2 out now! Current release Cannot resolve release macro, invalid id., check the changelog for details! 2009-11-02 Release 1.7.1 out now! Current release Cannot resolve release macro, invalid id., check the changelog for details! 2009-08-10 Release 1.7.0 out now! Current release Cannot resolve release macro, invalid id., check the changelog for details! 2009-05-07 New PHPExcel tutorial available There is a new PHPExcel tutorial available over at OpenXmlDeveloper.org. If you are just starting working with PHPExcel, this is a good read! 2009-04-27 Create PowerPoint 2007 files from PHP PHPExcel has a new sister project: PHPPowerPoint. Just like with PHPExcel, PHPPowerPoint can be used to generate PPTX files from a PHP application. This can be done by creating an in-memory presentation that consists of slides and different shapes, which can then be written to disk using a writer (of which there’s currently only one for PowerPoint 2007). News archive Team members Check the Credits for a complete list of team members. [Less]

Home Features Requirements Examples FAQ Contribute Documents Credits Contact We moved to https://github.com/PHPOffice/PHPExcel nearly 5 years ago The site here on codeplex is no longer current. Please stop using it! PHPExcel - ... [More] OpenXML - Read, Write and Create Excel documents in PHP - Spreadsheet engine PHPExcel (OLD DEAD REPOSITORY) - visit PHPOffice/PHPExcel on github insteadCheckout the Features this class set provides, such as setting spreadsheet meta data (author, title, description, ...), multiple worksheets, different fonts and font styles, cell borders, fills, gradients, adding images to your spreadsheet, calculating formulas, converting between file types and much, much more!Want to bookmark this page? Please use http://www.phpexcel.net as the URL. Want to contribute? Please remember that we have been using github as our source repository for over two years now.... source code has not been maintained here on Codeplex in all that time. If you want to contribute, you can fork the develop branch from github. We do accept Pull Requests.Please refer the Contribute page. Downloads All code is now maintained on githubLast release here on codeplex: Cannot resolve release macro, invalid id. is not the latest official release News 2015-08-10 Friendly Reminder! We moved to https://github.com/PHPOffice/PHPExcel over 3 years agoThe site here on codeplex is no longer current 2014-03-02 Release 1.8.0 out now! Despite earlier news to the contrary, the 1.x branch of PHPExcel is still not end of line, and the branch will continue to be maintained alongside the development of the version 2.x branch for the time being.Current release Cannot resolve release macro, invalid id.. check the changelog for details! 2013-06-02 Looking forward to PHPExcel 2.0.0! Please note that PHPExcel 1.7.9 will be the last release of PHPExcel in the 1.x branch.The next release will be 2.0.0 and it will require a minimum PHP version of 5.3. This will allow us to take advantage of language features that are only available in 5.3, including namespaces, closures, late static binding and guaranteed access to SPL. These features will in turn allow us to make significant improvements in performance and memory usage, as well as making the code cleaner and easier to maintain.In addition to this core rewrite, planned changes to the PHPExcel functionality will include switching the XML-based readers to use XMLReader rather than SimpleXML; and a complete rewrite of the Calculation Engine to improve performance and provide support for array functions, for row and column references, for R1C1 references, better locale handling (particularly for date functions), and to make it more easily extensible.Where possible, we will try to make the API consistent with the current API, but these changes mean that scripts using PHPExcel 2.x will not always be fully backward compatible with scripts using PHPExcel 1.x, but we hope that the improvements will be worth it. 2013-06-02 Release 1.7.9 out now! Current release Cannot resolve release macro, invalid id.. check the changelog for details! 2013-05-22 Documentation now online! In honour of World Goth Day, most of the PHPExcel documentation is now online at https://github.com/PHPOffice/PHPExcel/wiki/User%20Documentation Looking for volunteers to help proofread and sanity test all the code snippets and recipes to be certain that they all work and are easily understandable. 2013-05-22 We are on Github! Please remember that we have been using github as our source repository for nearly a year now.... source code has not been maintained here on Codeplex in all that time. If you want to contribute, you can fork it. We do accept Pull Requests. 2012-12-18 Free German language e-book now available! For those who read German, Ralf Hohoff has published a free e-book on "Automated document generation with PHPExcel, PHPWord and PHPPowerPoint", available from http://ebookstr.e-bookshelf.de/php-for-office-403106.html. 2012-10-12 Release 1.7.8 out now! Current release Cannot resolve release macro, invalid id.. check the changelog for details! 2012-06-19 PHPExcel Moves to github! The source repository for PHPExcel, together with its sister projects PHPWord and PHPPowerPoint under the auspices of PHPOffice. The repository can be found at https://github.com/PHPOffice/PHPExcel, and the latest working development code is in the develop branch.This is the first part of series of changes in our development process which we believe will make it easier for us to do more frequent releases of better quality code. The next step will be CI integration for running automated unit testing against PHP 5.2, 5.3 and 5.4 using TravisCI.We shall be maintaining the CodePlex SVN Source repository in parallel for a time, but the github repository should be considered the definitive source. 2012-05-19 Release 1.7.7 out now! Current release Cannot resolve release macro, invalid id.. check the changelog for details! 2012-05-06 Ruby/PHP Bridge: accessing PHPExcel from Ruby! Kasper Johansen has written a Ruby PHP Bridge, allowing the use of PHPExcel from within Ruby.More details available from the code repository is at https://github.com/kaspernj/php_process for any Ruby coders wanting to try it. You can find a working example using PHPExcel to generate an Excel file at https://github.com/kaspernj/php_process/blob/master/examples/example_phpexcel.rb. 2012-01-02 PHPExcel Roadmap for 2012 2011-02-28 Release 1.7.6 out now! Current release Cannot resolve release macro, invalid id.. check the changelog for details! 2010-12-10 Release 1.7.5 out now! Current release Cannot resolve release macro, invalid id.. check the changelog for details! 2010-10-22 PHPExcel ported to Python! Eric Gazoni has just released the first version of a port of PHPExcel to Python... openpyxl/More details available from his blog at http://ericgazoni.wordpress.com/2010/04/10/openpyxl-python-xlsx/. and the code repository is at http://bitbucket.org/ericgazoni/openpyxl/ for any Python coders wanting to try it 2010-08-26 Release 1.7.4 out now! Current release Cannot resolve release macro, invalid id.. check the changelog for details!We now also have a full PEAR channel! Here's how to use it:New installation:pear channel-discover pear.pearplex.netpear install pearplex/PHPExcelOr if you've already installed PHPExcel before:pear upgrade pearplex/PHPExcelThe official page can be found at http://pearplex.net. 2010-05-31 Release 1.7.3c out now! Current release Cannot resolve release macro, invalid id., check the changelog for details! 2010-05-31 Release 1.7.3b out now! Current release Cannot resolve release macro, invalid id., check the changelog for details! 2010-05-17 Release 1.7.3 out now! Current release Cannot resolve release macro, invalid id., check the changelog for details! 2010-01-11 Release 1.7.2 out now! Current release Cannot resolve release macro, invalid id., check the changelog for details! 2009-11-02 Release 1.7.1 out now! Current release Cannot resolve release macro, invalid id., check the changelog for details! 2009-08-10 Release 1.7.0 out now! Current release Cannot resolve release macro, invalid id., check the changelog for details! 2009-05-07 New PHPExcel tutorial available There is a new PHPExcel tutorial available over at OpenXmlDeveloper.org. If you are just starting working with PHPExcel, this is a good read! 2009-04-27 Create PowerPoint 2007 files from PHP PHPExcel has a new sister project: PHPPowerPoint. Just like with PHPExcel, PHPPowerPoint can be used to generate PPTX files from a PHP application. This can be done by creating an in-memory presentation that consists of slides and different shapes, which can then be written to disk using a writer (of which there’s currently only one for PowerPoint 2007). News archive Team members Check the Credits for a complete list of team members. [Less]

Home Features Requirements Examples FAQ Contribute Documents Credits Contact We moved to https://github.com/PHPOffice/PHPExcel nearly 5 years ago The site here on codeplex is no longer current. Please stop using it. PHPExcel - ... [More] OpenXML - Read, Write and Create Excel documents in PHP - Spreadsheet engine PHPExcel (OLD DEAD REPOSITORY) - visit PHPOffice/PHPExcel on github insteadCheckout the Features this class set provides, such as setting spreadsheet meta data (author, title, description, ...), multiple worksheets, different fonts and font styles, cell borders, fills, gradients, adding images to your spreadsheet, calculating formulas, converting between file types and much, much more!Want to bookmark this page? Please use http://www.phpexcel.net as the URL. Want to contribute? Please remember that we have been using github as our source repository for over two years now.... source code has not been maintained here on Codeplex in all that time. If you want to contribute, you can fork the develop branch from github. We do accept Pull Requests.Please refer the Contribute page. Downloads All code is now maintained on githubLast release here on codeplex: Cannot resolve release macro, invalid id. is not the latest official release News 2015-08-10 Friendly Reminder! We moved to https://github.com/PHPOffice/PHPExcel over 3 years agoThe site here on codeplex is no longer current 2014-03-02 Release 1.8.0 out now! Despite earlier news to the contrary, the 1.x branch of PHPExcel is still not end of line, and the branch will continue to be maintained alongside the development of the version 2.x branch for the time being.Current release Cannot resolve release macro, invalid id.. check the changelog for details! 2013-06-02 Looking forward to PHPExcel 2.0.0! Please note that PHPExcel 1.7.9 will be the last release of PHPExcel in the 1.x branch.The next release will be 2.0.0 and it will require a minimum PHP version of 5.3. This will allow us to take advantage of language features that are only available in 5.3, including namespaces, closures, late static binding and guaranteed access to SPL. These features will in turn allow us to make significant improvements in performance and memory usage, as well as making the code cleaner and easier to maintain.In addition to this core rewrite, planned changes to the PHPExcel functionality will include switching the XML-based readers to use XMLReader rather than SimpleXML; and a complete rewrite of the Calculation Engine to improve performance and provide support for array functions, for row and column references, for R1C1 references, better locale handling (particularly for date functions), and to make it more easily extensible.Where possible, we will try to make the API consistent with the current API, but these changes mean that scripts using PHPExcel 2.x will not always be fully backward compatible with scripts using PHPExcel 1.x, but we hope that the improvements will be worth it. 2013-06-02 Release 1.7.9 out now! Current release Cannot resolve release macro, invalid id.. check the changelog for details! 2013-05-22 Documentation now online! In honour of World Goth Day, most of the PHPExcel documentation is now online at https://github.com/PHPOffice/PHPExcel/wiki/User%20Documentation Looking for volunteers to help proofread and sanity test all the code snippets and recipes to be certain that they all work and are easily understandable. 2013-05-22 We are on Github! Please remember that we have been using github as our source repository for nearly a year now.... source code has not been maintained here on Codeplex in all that time. If you want to contribute, you can fork it. We do accept Pull Requests. 2012-12-18 Free German language e-book now available! For those who read German, Ralf Hohoff has published a free e-book on "Automated document generation with PHPExcel, PHPWord and PHPPowerPoint", available from http://ebookstr.e-bookshelf.de/php-for-office-403106.html. 2012-10-12 Release 1.7.8 out now! Current release Cannot resolve release macro, invalid id.. check the changelog for details! 2012-06-19 PHPExcel Moves to github! The source repository for PHPExcel, together with its sister projects PHPWord and PHPPowerPoint under the auspices of PHPOffice. The repository can be found at https://github.com/PHPOffice/PHPExcel, and the latest working development code is in the develop branch.This is the first part of series of changes in our development process which we believe will make it easier for us to do more frequent releases of better quality code. The next step will be CI integration for running automated unit testing against PHP 5.2, 5.3 and 5.4 using TravisCI.We shall be maintaining the CodePlex SVN Source repository in parallel for a time, but the github repository should be considered the definitive source. 2012-05-19 Release 1.7.7 out now! Current release Cannot resolve release macro, invalid id.. check the changelog for details! 2012-05-06 Ruby/PHP Bridge: accessing PHPExcel from Ruby! Kasper Johansen has written a Ruby PHP Bridge, allowing the use of PHPExcel from within Ruby.More details available from the code repository is at https://github.com/kaspernj/php_process for any Ruby coders wanting to try it. You can find a working example using PHPExcel to generate an Excel file at https://github.com/kaspernj/php_process/blob/master/examples/example_phpexcel.rb. 2012-01-02 PHPExcel Roadmap for 2012 2011-02-28 Release 1.7.6 out now! Current release Cannot resolve release macro, invalid id.. check the changelog for details! 2010-12-10 Release 1.7.5 out now! Current release Cannot resolve release macro, invalid id.. check the changelog for details! 2010-10-22 PHPExcel ported to Python! Eric Gazoni has just released the first version of a port of PHPExcel to Python... openpyxl/More details available from his blog at http://ericgazoni.wordpress.com/2010/04/10/openpyxl-python-xlsx/. and the code repository is at http://bitbucket.org/ericgazoni/openpyxl/ for any Python coders wanting to try it 2010-08-26 Release 1.7.4 out now! Current release Cannot resolve release macro, invalid id.. check the changelog for details!We now also have a full PEAR channel! Here's how to use it:New installation:pear channel-discover pear.pearplex.netpear install pearplex/PHPExcelOr if you've already installed PHPExcel before:pear upgrade pearplex/PHPExcelThe official page can be found at http://pearplex.net. 2010-05-31 Release 1.7.3c out now! Current release Cannot resolve release macro, invalid id., check the changelog for details! 2010-05-31 Release 1.7.3b out now! Current release Cannot resolve release macro, invalid id., check the changelog for details! 2010-05-17 Release 1.7.3 out now! Current release Cannot resolve release macro, invalid id., check the changelog for details! 2010-01-11 Release 1.7.2 out now! Current release Cannot resolve release macro, invalid id., check the changelog for details! 2009-11-02 Release 1.7.1 out now! Current release Cannot resolve release macro, invalid id., check the changelog for details! 2009-08-10 Release 1.7.0 out now! Current release Cannot resolve release macro, invalid id., check the changelog for details! 2009-05-07 New PHPExcel tutorial available There is a new PHPExcel tutorial available over at OpenXmlDeveloper.org. If you are just starting working with PHPExcel, this is a good read! 2009-04-27 Create PowerPoint 2007 files from PHP PHPExcel has a new sister project: PHPPowerPoint. Just like with PHPExcel, PHPPowerPoint can be used to generate PPTX files from a PHP application. This can be done by creating an in-memory presentation that consists of slides and different shapes, which can then be written to disk using a writer (of which there’s currently only one for PowerPoint 2007). News archive Team members Check the Credits for a complete list of team members. [Less]

Home Features Requirements Examples FAQ Contribute Documents Credits Contact We moved to https://github.com/PHPOffice/PHPExcel nearly 5 years ago The site here on codeplex is no longer current. Please stop using it. * PHPExcel ... [More] - OpenXML - Read, Write and Create Excel documents in PHP - Spreadsheet engine PHPExcel (OLD DEAD REPOSITORY) - visit PHPOffice/PHPExcel on github insteadCheckout the Features this class set provides, such as setting spreadsheet meta data (author, title, description, ...), multiple worksheets, different fonts and font styles, cell borders, fills, gradients, adding images to your spreadsheet, calculating formulas, converting between file types and much, much more!Want to bookmark this page? Please use http://www.phpexcel.net as the URL. Want to contribute? Please remember that we have been using github as our source repository for over two years now.... source code has not been maintained here on Codeplex in all that time. If you want to contribute, you can fork the develop branch from github. We do accept Pull Requests.Please refer the Contribute page. Downloads All code is now maintained on githubLast release here on codeplex: Cannot resolve release macro, invalid id. is not the latest official release News 2015-08-10 Friendly Reminder! We moved to https://github.com/PHPOffice/PHPExcel over 3 years agoThe site here on codeplex is no longer current 2014-03-02 Release 1.8.0 out now! Despite earlier news to the contrary, the 1.x branch of PHPExcel is still not end of line, and the branch will continue to be maintained alongside the development of the version 2.x branch for the time being.Current release Cannot resolve release macro, invalid id.. check the changelog for details! 2013-06-02 Looking forward to PHPExcel 2.0.0! Please note that PHPExcel 1.7.9 will be the last release of PHPExcel in the 1.x branch.The next release will be 2.0.0 and it will require a minimum PHP version of 5.3. This will allow us to take advantage of language features that are only available in 5.3, including namespaces, closures, late static binding and guaranteed access to SPL. These features will in turn allow us to make significant improvements in performance and memory usage, as well as making the code cleaner and easier to maintain.In addition to this core rewrite, planned changes to the PHPExcel functionality will include switching the XML-based readers to use XMLReader rather than SimpleXML; and a complete rewrite of the Calculation Engine to improve performance and provide support for array functions, for row and column references, for R1C1 references, better locale handling (particularly for date functions), and to make it more easily extensible.Where possible, we will try to make the API consistent with the current API, but these changes mean that scripts using PHPExcel 2.x will not always be fully backward compatible with scripts using PHPExcel 1.x, but we hope that the improvements will be worth it. 2013-06-02 Release 1.7.9 out now! Current release Cannot resolve release macro, invalid id.. check the changelog for details! 2013-05-22 Documentation now online! In honour of World Goth Day, most of the PHPExcel documentation is now online at https://github.com/PHPOffice/PHPExcel/wiki/User%20Documentation Looking for volunteers to help proofread and sanity test all the code snippets and recipes to be certain that they all work and are easily understandable. 2013-05-22 We are on Github! Please remember that we have been using github as our source repository for nearly a year now.... source code has not been maintained here on Codeplex in all that time. If you want to contribute, you can fork it. We do accept Pull Requests. 2012-12-18 Free German language e-book now available! For those who read German, Ralf Hohoff has published a free e-book on "Automated document generation with PHPExcel, PHPWord and PHPPowerPoint", available from http://ebookstr.e-bookshelf.de/php-for-office-403106.html. 2012-10-12 Release 1.7.8 out now! Current release Cannot resolve release macro, invalid id.. check the changelog for details! 2012-06-19 PHPExcel Moves to github! The source repository for PHPExcel, together with its sister projects PHPWord and PHPPowerPoint under the auspices of PHPOffice. The repository can be found at https://github.com/PHPOffice/PHPExcel, and the latest working development code is in the develop branch.This is the first part of series of changes in our development process which we believe will make it easier for us to do more frequent releases of better quality code. The next step will be CI integration for running automated unit testing against PHP 5.2, 5.3 and 5.4 using TravisCI.We shall be maintaining the CodePlex SVN Source repository in parallel for a time, but the github repository should be considered the definitive source. 2012-05-19 Release 1.7.7 out now! Current release Cannot resolve release macro, invalid id.. check the changelog for details! 2012-05-06 Ruby/PHP Bridge: accessing PHPExcel from Ruby! Kasper Johansen has written a Ruby PHP Bridge, allowing the use of PHPExcel from within Ruby.More details available from the code repository is at https://github.com/kaspernj/php_process for any Ruby coders wanting to try it. You can find a working example using PHPExcel to generate an Excel file at https://github.com/kaspernj/php_process/blob/master/examples/example_phpexcel.rb. 2012-01-02 PHPExcel Roadmap for 2012 2011-02-28 Release 1.7.6 out now! Current release Cannot resolve release macro, invalid id.. check the changelog for details! 2010-12-10 Release 1.7.5 out now! Current release Cannot resolve release macro, invalid id.. check the changelog for details! 2010-10-22 PHPExcel ported to Python! Eric Gazoni has just released the first version of a port of PHPExcel to Python... openpyxl/More details available from his blog at http://ericgazoni.wordpress.com/2010/04/10/openpyxl-python-xlsx/. and the code repository is at http://bitbucket.org/ericgazoni/openpyxl/ for any Python coders wanting to try it 2010-08-26 Release 1.7.4 out now! Current release Cannot resolve release macro, invalid id.. check the changelog for details!We now also have a full PEAR channel! Here's how to use it:New installation:pear channel-discover pear.pearplex.netpear install pearplex/PHPExcelOr if you've already installed PHPExcel before:pear upgrade pearplex/PHPExcelThe official page can be found at http://pearplex.net. 2010-05-31 Release 1.7.3c out now! Current release Cannot resolve release macro, invalid id., check the changelog for details! 2010-05-31 Release 1.7.3b out now! Current release Cannot resolve release macro, invalid id., check the changelog for details! 2010-05-17 Release 1.7.3 out now! Current release Cannot resolve release macro, invalid id., check the changelog for details! 2010-01-11 Release 1.7.2 out now! Current release Cannot resolve release macro, invalid id., check the changelog for details! 2009-11-02 Release 1.7.1 out now! Current release Cannot resolve release macro, invalid id., check the changelog for details! 2009-08-10 Release 1.7.0 out now! Current release Cannot resolve release macro, invalid id., check the changelog for details! 2009-05-07 New PHPExcel tutorial available There is a new PHPExcel tutorial available over at OpenXmlDeveloper.org. If you are just starting working with PHPExcel, this is a good read! 2009-04-27 Create PowerPoint 2007 files from PHP PHPExcel has a new sister project: PHPPowerPoint. Just like with PHPExcel, PHPPowerPoint can be used to generate PPTX files from a PHP application. This can be done by creating an in-memory presentation that consists of slides and different shapes, which can then be written to disk using a writer (of which there’s currently only one for PowerPoint 2007). News archive Team members Check the Credits for a complete list of team members. [Less]

Home Features Requirements Examples FAQ Contribute Documents Credits Contact We moved to https://github.com/PHPOffice/PHPExcel nearly 5 years agoThe site here on codeplex is no longer current. Please stop using it. PHPExcel - ... [More] OpenXML - Read, Write and Create Excel documents in PHP - Spreadsheet engine PHPExcel (OLD DEAD REPOSITORY) - visit PHPOffice/PHPExcel on github insteadCheckout the Features this class set provides, such as setting spreadsheet meta data (author, title, description, ...), multiple worksheets, different fonts and font styles, cell borders, fills, gradients, adding images to your spreadsheet, calculating formulas, converting between file types and much, much more!Want to bookmark this page? Please use http://www.phpexcel.net as the URL. Want to contribute? Please remember that we have been using github as our source repository for over two years now.... source code has not been maintained here on Codeplex in all that time. If you want to contribute, you can fork the develop branch from github. We do accept Pull Requests.Please refer the Contribute page. Downloads All code is now maintained on githubLast release here on codeplex: Cannot resolve release macro, invalid id. is not the latest official release News 2015-08-10 Friendly Reminder! We moved to https://github.com/PHPOffice/PHPExcel over 3 years agoThe site here on codeplex is no longer current 2014-03-02 Release 1.8.0 out now! Despite earlier news to the contrary, the 1.x branch of PHPExcel is still not end of line, and the branch will continue to be maintained alongside the development of the version 2.x branch for the time being.Current release Cannot resolve release macro, invalid id.. check the changelog for details! 2013-06-02 Looking forward to PHPExcel 2.0.0! Please note that PHPExcel 1.7.9 will be the last release of PHPExcel in the 1.x branch.The next release will be 2.0.0 and it will require a minimum PHP version of 5.3. This will allow us to take advantage of language features that are only available in 5.3, including namespaces, closures, late static binding and guaranteed access to SPL. These features will in turn allow us to make significant improvements in performance and memory usage, as well as making the code cleaner and easier to maintain.In addition to this core rewrite, planned changes to the PHPExcel functionality will include switching the XML-based readers to use XMLReader rather than SimpleXML; and a complete rewrite of the Calculation Engine to improve performance and provide support for array functions, for row and column references, for R1C1 references, better locale handling (particularly for date functions), and to make it more easily extensible.Where possible, we will try to make the API consistent with the current API, but these changes mean that scripts using PHPExcel 2.x will not always be fully backward compatible with scripts using PHPExcel 1.x, but we hope that the improvements will be worth it. 2013-06-02 Release 1.7.9 out now! Current release Cannot resolve release macro, invalid id.. check the changelog for details! 2013-05-22 Documentation now online! In honour of World Goth Day, most of the PHPExcel documentation is now online at https://github.com/PHPOffice/PHPExcel/wiki/User%20Documentation Looking for volunteers to help proofread and sanity test all the code snippets and recipes to be certain that they all work and are easily understandable. 2013-05-22 We are on Github! Please remember that we have been using github as our source repository for nearly a year now.... source code has not been maintained here on Codeplex in all that time. If you want to contribute, you can fork it. We do accept Pull Requests. 2012-12-18 Free German language e-book now available! For those who read German, Ralf Hohoff has published a free e-book on "Automated document generation with PHPExcel, PHPWord and PHPPowerPoint", available from http://ebookstr.e-bookshelf.de/php-for-office-403106.html. 2012-10-12 Release 1.7.8 out now! Current release Cannot resolve release macro, invalid id.. check the changelog for details! 2012-06-19 PHPExcel Moves to github! The source repository for PHPExcel, together with its sister projects PHPWord and PHPPowerPoint under the auspices of PHPOffice. The repository can be found at https://github.com/PHPOffice/PHPExcel, and the latest working development code is in the develop branch.This is the first part of series of changes in our development process which we believe will make it easier for us to do more frequent releases of better quality code. The next step will be CI integration for running automated unit testing against PHP 5.2, 5.3 and 5.4 using TravisCI.We shall be maintaining the CodePlex SVN Source repository in parallel for a time, but the github repository should be considered the definitive source. 2012-05-19 Release 1.7.7 out now! Current release Cannot resolve release macro, invalid id.. check the changelog for details! 2012-05-06 Ruby/PHP Bridge: accessing PHPExcel from Ruby! Kasper Johansen has written a Ruby PHP Bridge, allowing the use of PHPExcel from within Ruby.More details available from the code repository is at https://github.com/kaspernj/php_process for any Ruby coders wanting to try it. You can find a working example using PHPExcel to generate an Excel file at https://github.com/kaspernj/php_process/blob/master/examples/example_phpexcel.rb. 2012-01-02 PHPExcel Roadmap for 2012 2011-02-28 Release 1.7.6 out now! Current release Cannot resolve release macro, invalid id.. check the changelog for details! 2010-12-10 Release 1.7.5 out now! Current release Cannot resolve release macro, invalid id.. check the changelog for details! 2010-10-22 PHPExcel ported to Python! Eric Gazoni has just released the first version of a port of PHPExcel to Python... openpyxl/More details available from his blog at http://ericgazoni.wordpress.com/2010/04/10/openpyxl-python-xlsx/. and the code repository is at http://bitbucket.org/ericgazoni/openpyxl/ for any Python coders wanting to try it 2010-08-26 Release 1.7.4 out now! Current release Cannot resolve release macro, invalid id.. check the changelog for details!We now also have a full PEAR channel! Here's how to use it:New installation:pear channel-discover pear.pearplex.netpear install pearplex/PHPExcelOr if you've already installed PHPExcel before:pear upgrade pearplex/PHPExcelThe official page can be found at http://pearplex.net. 2010-05-31 Release 1.7.3c out now! Current release Cannot resolve release macro, invalid id., check the changelog for details! 2010-05-31 Release 1.7.3b out now! Current release Cannot resolve release macro, invalid id., check the changelog for details! 2010-05-17 Release 1.7.3 out now! Current release Cannot resolve release macro, invalid id., check the changelog for details! 2010-01-11 Release 1.7.2 out now! Current release Cannot resolve release macro, invalid id., check the changelog for details! 2009-11-02 Release 1.7.1 out now! Current release Cannot resolve release macro, invalid id., check the changelog for details! 2009-08-10 Release 1.7.0 out now! Current release Cannot resolve release macro, invalid id., check the changelog for details! 2009-05-07 New PHPExcel tutorial available There is a new PHPExcel tutorial available over at OpenXmlDeveloper.org. If you are just starting working with PHPExcel, this is a good read! 2009-04-27 Create PowerPoint 2007 files from PHP PHPExcel has a new sister project: PHPPowerPoint. Just like with PHPExcel, PHPPowerPoint can be used to generate PPTX files from a PHP application. This can be done by creating an in-memory presentation that consists of slides and different shapes, which can then be written to disk using a writer (of which there’s currently only one for PowerPoint 2007). News archive Team members Check the Credits for a complete list of team members. [Less]

I need PHPExcel to import data from a spreadsheet - no problem so far - but I need to ask the user to identify each column before uploading fully. Is the best way to do this by creating my own buffer in my database and then sorting the data from ... [More] there or is there a way of passing the raw data from page to page before adding to my database? Also, would this be very memory intensive? Any help would be great. [Less]