Asudahlah.com

Programming, tutorials, mechatronics, operating systems, and other tech stuff

PHPExcel Generate Excel Spreadsheet Files in PHP with Different Formats

, , 58 comments
PHPExcel is a powerful PHP library (class) which allows us to generate and read Excel spreadsheet file in PHP server-side. Developed by PHPOffice team.

Depending on the circumstances, generating an excel spreadsheet file as a reporting medium is a great way to present reporting data in offline, independent manner. Especially when dealing about printing and lots of numeric data such as financial report.

Reading an excel file using PHP is also a good way to automate data entry. Especially when dealing with batch data entries. And on the end-user side, this method will also ease the user as the interface for entering the data is an excel spreadsheet file which most people are familiar with. And absolutely more agile when compared to web-interfaced forms.

To use this library, simply download the library files here.

Extract it anywhere in your web root directories. Call the PHPExcel.php file in your script and you're good to go.

Here's a Hello World PHP script example to generate an excel file.
I think the comments in pretty self-explanatory. 
<?php
require_once 'Classes/PHPExcel.php';

//create PHPExcel object
$excel = new PHPExcel();

//insert some data to PHPExcel object
$excel->setActiveSheetIndex(0)
 ->setCellValue('A1','Hello')
 ->setCellValue('B1','World');

//redirect to browser (download) instead of saving the result as a file

//this is for MS Office Excel 2007 xlsx format
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment; filename="test.xlsx"');

//this is for MS Office Excel 2003 xls format
//header('Content-Type: application/vnd.ms-excel');
//header('Content-Disposition: attachment; filename="test.xlsx"');


header('Cache-Control: max-age=0');

//write the result to a file
//for excel 2007 format
$file = PHPExcel_IOFactory::createWriter($excel,'Excel2007');

//for excel 2003 format
//$file = PHPExcel_IOFactory::createWriter($excel,'Excel5');

//output to php output instead of filename
$file->save('php://output');

?>

You can choose in what format the excel file will be generated by uncomment/comment the headers and IOFactory line.

Basically, what needs to be change to save it in different formats is:
for Excel 2007 or above
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment; filename="test.xlsx"');
$file = PHPExcel_IOFactory::createWriter($excel,'Excel2007');

and for Excel 2003
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment; filename="test.xls"');
$file = PHPExcel_IOFactory::createWriter($excel,'Excel5');

And here's the video if you need a step-by-step explanation.

Part #1 How to install and test php excel (basic usage).

Part #2 Download PHP Generated Excel File.

58 comments :

  1. Inigo josephNovember 22, 2017 at 1:39 AM

    Thanks a lot very much for the high your blog post quality and results-oriented help. I won’t think twice to endorse to anybody who wants and needs support about this area. https://www.besanttechnologies.com/training-courses/php-training/php-training-institute-in-chennai

    ReplyDelete
  2. abril josephMarch 26, 2018 at 4:12 AM

    Thanks a lot very much for the high quality and results-oriented help. I won’t think twice to endorse your blog post to anybody who wants and needs support about this area.
    hadoop-training-institute-in-chennai

    ReplyDelete
  3. Jack SparrowMarch 30, 2018 at 10:55 PM

    PLC Training in Chennai | PLC Training Institute in Chennai | PLC Training Center in Chennai | PLC SCADA Training in Chennai | PLC SCADA DCS Training in Chennai | Best PLC Training in Chennai | Best PLC Training Institute in Chennai | PLC Training Centre in Chennai | PLC SCADA Training in Chennai | Automation Training Institute in Chennai | PLC Training in Kerala

    ReplyDelete
  4. Jack SparrowMarch 30, 2018 at 11:00 PM

    Embedded Training in Chennai | Best Embedded Training in Chennai | Embedded System Training in Chennai | Embedded System Training Institute in Chennai | Best Embedded System Training Institute in Chennai | Embedded Course in Chennai | Embedded System Training Institutes in Chennai | Embedded System Training Center in Chennai | Best Embedded System Training in Chennai | Embedded Systems Training in Chennai

    ReplyDelete
  5. Jack SparrowMarch 30, 2018 at 11:00 PM

    VLSI Training in Chennai | Best VLSI Training in Chennai | VLSI Training Centres in Chennai | VLSI Courses in Chennai | VLSI Training Courses in Chennai | VLSI Training Institute in Chennai | VLSI Training Institutes in Chennai | Best VLSI Training Institute in Chennai

    ReplyDelete
  6. VishalMarch 31, 2018 at 12:28 AM

    Pretty article to updating..Thank you..Java Project Center in Chennai | Java Project Center in Velachery

    ReplyDelete
  7. srihariparuMarch 31, 2018 at 12:31 AM

    Really it was an awesome article...very interesting to read..You have provided an nice article....Thanks for sharing..
    Best Electrical Project Center in Chennai | IEEE Electrical Projects in Velachery

    ReplyDelete
  8. deeskhaMarch 31, 2018 at 3:55 AM

    Great information. I have got some important suggestions from it. Thank you for sharing..
    Best AWS Training Institute in Chennai | Best AWS Training Institute in Velachery

    ReplyDelete
  9. kumariMarch 31, 2018 at 4:48 AM

    Hi, am a big follower of your blog. I am really happy to found such a helpful and fascinating post that is written in well manner.
    Final Year Project Center in Chennai | Final Year Project Center in Velachery

    ReplyDelete
  10. VishalApril 2, 2018 at 4:30 AM

    Nice post.It Was simple and Effective..Thanks for sharing your valuable information and time. Please keep updating.
    Best cloud Computing Training Institute in Chennai | Best cloud Computing Training Institute in Velachery

    ReplyDelete
  11. mari AApril 11, 2018 at 12:23 AM

    Appreciation for really being thoughtful and also for deciding on certain marvelous guides most people really want to be aware of.

    AWS Training in Chennai

    ReplyDelete
  12. Apsara GApril 11, 2018 at 1:39 AM

    Good Post! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as updated one, keep blogging… Selenium Training in Chennai| Oracle Training in Chennai

    ReplyDelete
  13. Apsara GApril 11, 2018 at 2:51 AM

    Thanks for splitting your comprehension with us. It’s really useful to me & I hope it helps the people who in need of this vital information.. Big Data Training in Chennai Digital Marketing Training in Chennai

    ReplyDelete
  14. Apsara GApril 11, 2018 at 2:54 AM

    Thanks for splitting your comprehension with us. It’s really useful to me & I hope it helps the people who in need of this vital information. iOS Training in Chennai | iOS Training institutes in Chennai

    ReplyDelete
  15. Mary AdlenaApril 11, 2018 at 4:34 AM

    Good Post! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as updated one, keep blogging..
    B.Com Project Center in Chennai | B.Com Project Center in Velachery

    ReplyDelete
  16. Apsara GApril 11, 2018 at 11:37 PM

    Excellent Article ...thank u for sharing, such a valuable content Learners to get good knowledge after read this article.. Devops Training in Chennai | AWS Training in Chennai

    ReplyDelete
  17. Apsara GApril 11, 2018 at 11:41 PM

    Thanks for splitting your comprehension with us. It’s really useful to me & I hope it helps the people who in need of this vital information... iOS Training in Chennai | Big Data Training in Chennai

    ReplyDelete
  18. Apsara GApril 11, 2018 at 11:44 PM

    The strategy you have posted on this technology helped me to get into the next level and had lot of information in it... Oracle Training in Chennai | Selenium Training in Chennai

    ReplyDelete
  19. kumariMay 5, 2018 at 4:55 AM

    Nice and informative article. Thanks for sharing such nice article, keep on updating.
    Dot-net Summer Course training Institute in Chennai|Dot-net Summer Course training Institute in Ashok Nagar

    ReplyDelete
  20. ajay akMay 8, 2018 at 9:40 PM

    Thanks for the useful information about PHP course, give more updates on PHP course, First time I visit your blog nice, I bookmark your blog here after a daily visit. Learn PHP course in chennai

    ReplyDelete
  21. lotusMay 24, 2018 at 5:16 AM

    Nice and good article. It is very useful for me to learn and understand easily. Thanks for sharing your valuable information and time. Please keep updating...
    Dotnet Training Institute in Chennai |Dotnet Training Institute in Velachery

    ReplyDelete
  22. karthikMay 25, 2018 at 3:22 AM

    The information you have here is really useful to make my knowledge good. It is truly supportive for us and I have accumulated some essential data from this blog.
    C, C++ Training Institute in Chennai | C, C++ Training Institute in Ashok Nagar

    ReplyDelete
  23. rupiya daniMay 26, 2018 at 3:13 AM

    Post is very informative… It helped me with great information so I really believe you will do much better in the future.
    AWS Training Institute in Chennai|AWS Training Institute in Velachery

    ReplyDelete
  24. sriramMay 30, 2018 at 1:35 AM

    Thank you so much for sharing this worth able content with us. The concept taken here will be useful for my future programs and i will surely implement them in my study. Keep blogging article like this.
    MS office course in chennai

    ReplyDelete
  25. prabashJune 1, 2018 at 5:20 AM

    Awesome Post with unique content. I really get interest to read this post. I hope this article help many of them…
    Best MCSE/MCSA Certificate Training Institute in Chennai|Best MCSE/MCSA Certificate Training Institute in Velachery

    ReplyDelete
  26. revathi rekhaJune 3, 2018 at 5:35 AM

    The information you have here is really useful to make my knowledge good. It is truly supportive for us and I have accumulated some essential data from this blog.
    Redhat Linux Exam Centre in Chennai| Redhat Linux Exam Centre in Velachery

    ReplyDelete
  27. deeskhaJune 21, 2018 at 6:15 AM

    Nice and good article. It is very useful for me to learn and understand easily. Thanks for sharing your valuable information and time. Please keep updating...
    No.1 MCSE and MCSA Certificate Exam Centre in Chennai |No.1 MCSE and MCSA Certificate Exam Centre in Chennai.

    ReplyDelete
  28. ajay. chinnaJuly 27, 2018 at 4:35 AM

    Very useful information to everyone thanks for sharing, learn the latest updated Technology at Best Training institutions
    Salesforce Lightning is the latest updated technology
    Salesforce Training online in India
    Salesforce Training

    ReplyDelete
  29. raviraj tejeswiSeptember 14, 2018 at 10:49 PM

    hi there.
    i liked ur tutorial and i need some help.is there a way to automatically read the excel file column headers and automatically create a database with those headers instead of predefiing the column headers in database for eg

    data1.xlsx

    name emailid company
    tom t@gmail.com gmail ltd
    dick d@gold.com gold industries
    harry h@siver.com silver enterprises

    now without mention the column headers of this file in your php file can we upload it automatically to the server and a database will be created with the column headers as name emailid and company.

    ReplyDelete
  30. Priya RajeshOctober 15, 2018 at 3:58 AM

    Thanks for sharing this information admin, it helps me to learn new things. Continue sharing more like this.
    DevOps course in Chennai
    DevOps course
    Best DevOps Training in Chennai
    Robotics Process Automation Training in Chennai
    Angularjs Training in Chennai
    AWS course in Chennai
    ccna Training in Chennai

    ReplyDelete
  31. Sai ElakiyaaOctober 16, 2018 at 3:47 AM

    I have never read more interesting articles than yours before. You make me so easy to understand and I will continue to share this site. Thank you very much and more power!
    Selenium Training in Chennai
    software testing selenium training
    iOS Course in Chennai
    iOS Training Chennai
    Java training institute in chennai
    Best JAVA Training institute in Chennai

    ReplyDelete
  32. AnnieOctober 20, 2018 at 4:09 AM

    Outstanding blog thanks for sharing such wonderful blog with us ,after long time came across such knowlegeble blog. keep sharing such informative blog with us.
    Air Hostess Training in Chennai | Air Hostess Training Institute in Chennai | Air Hostess Academy in Chennai | Air Hostess Course in Chennai | Air Hostess Institute in Chennai

    ReplyDelete
  33. AnnieOctober 20, 2018 at 4:11 AM

    This comment has been removed by the author.

    ReplyDelete
  34. Vicky RamOctober 22, 2018 at 3:34 AM

    Thank you for sharing this valuable information. Good job.

    Guest posting sites
    Education

    ReplyDelete
  35. pavithra dassOctober 23, 2018 at 1:50 AM

    Its a wonderful post and very helpful, thanks for all this information. You are including better information regarding this topic in an effective way. T hank you so much.
    CCNA Training in Chennai
    DevOps Training in Chennai
    Best devOps Training in Chennai
    DevOps foundation certificate
    CCNA Training
    CCNA courses in Chennai

    ReplyDelete
  36. nanadhini chandranOctober 23, 2018 at 9:43 PM

    I am feeling great to read this.you gave a nice info for us.
    please update more.

    angularjs classes in bangalore
    AngularJS Training in Nolambur
    AngularJS Courses in T nagar

    ReplyDelete
  37. Sathish KOctober 25, 2018 at 5:28 AM

    It is an interesting post, helps me for my work. I like it, Thank you for sharing with us.

    C++ Training | C Language Training | C++ Programming Course | C Training in Adyar | C Training in Velachery | C Training in Tambaram

    ReplyDelete
  38. kim johnOctober 26, 2018 at 3:45 AM

    Thanks for sharing this tips admin. It gives lots of information to me, continue sharing more like this.
    UiPath Training in Chennai
    UiPath Course
    UiPath Training Institutes in Chennai
    UiPath Courses in Chennai
    UiPath Training in Tambaram
    Blue Prism course in Chennai
    RPA Training in Chennai

    ReplyDelete
  39. LindaJasmineOctober 30, 2018 at 2:46 AM

    Interesting Post. Looking for this information for a while. Thanks for Posting.
    Node JS Training Institute in chennai
    Node JS Training Institutes in chennai
    Node JS Course
    Node JS Training in Velachery
    Node JS Training in Tambaram
    Node JS Training in Adyar

    ReplyDelete
  40. Sai ElakiyaaNovember 2, 2018 at 11:11 PM

    Awesome Post!! Keep posting more content.

    Selenium Training in Chennai
    software testing selenium training
    ios developer course in chennai
    Digital Marketing Course in Chennai
    Selenium Interview Questions and Answers
    Future of testing professional
    Best Digital Marketing Training in Chennai
    Digital Marketing Courses in Chennai

    ReplyDelete
  41. Vicky RamNovember 3, 2018 at 9:46 PM

    Interesting blog, it gives lots of information to me. Thanks for sharing such a nice blog.

    superbfacts
    Article submission sites

    ReplyDelete
  42. mercyroyNovember 8, 2018 at 11:57 PM

    Thanks first of all for the useful info.
    the idea in this article is quite different and innovative please update more.
    AngularJS Training in Vadapalani
    AngularJS Training in Thirumangalam
    Angularjs Training institute in Bangalore
    angularjs classes in bangalore

    ReplyDelete
  43. LindaJasmineNovember 15, 2018 at 3:30 AM

    Awesome Post. Your writing is very unique. The choice of words stood as an exemplary piece of work. Thanks of sharing.
    Html5 Training in Chennai
    Html5 Courses in Chennai
    Html5 Training
    Html5 Course
    Html5 Training Course
    Html5 Training for Beginners
    Best Html5 Course
    Best Html5 Training

    ReplyDelete
  44. mercyroyNovember 16, 2018 at 9:25 PM

    Thanks for your interesting ideas.the information's in this blog is very much useful for me to improve my knowledge.
    vmware Training in Amjikarai
    vmware Training Institutes in Vadapalani
    vmware classes in bangalore
    vmware certification training in bangalore

    ReplyDelete
  45. Aruna RamNovember 18, 2018 at 10:14 PM

    Thanks for your sharing the knowledge to needed ones. Waiting for your updates. Keep it up.
    Digital Marketing Classes in Bangalore
    Best Digital Marketing Course in Bangalore
    Digital Marketing Course in Bangalore
    Digital Marketing Training in Tnagar
    Digital Marketing Training in Velachery
    Digital Marketing Training in Tambaram
    Digital Marketing Course in Omr

    ReplyDelete
  46. venu bharathNovember 19, 2018 at 4:16 AM

    Awesome Post. The choice of words makes this post very unique. Great content. Thanks for sharing.
    Node JS Training in Chennai
    Node JS Course in Chennai
    Node JS Advanced Training
    Node JS Training Institute in chennai
    Node JS Training Institutes in chennai
    Node JS Course

    ReplyDelete
  47. sathyarameshNovember 19, 2018 at 10:00 PM

    Thanks for splitting your comprehension with us. It’s really useful to me & I hope it helps the people who in need of this vital information.
    web designing course
    web designing courses
    web development courses
    PHP course
    PHP Training
    Best PHP training in chennai

    ReplyDelete
  48. nanadhini chandranDecember 3, 2018 at 9:27 PM

    nice thoughts you have attached in your post.surely i look into this insight and gather lot of new ideas.please update such Kind of information's more in future.
    software testing training near me
    software testing training in chennai
    Software Testing Training in Aminjikarai
    Software Testing Training Institutes in Vadapalani
    Software Testing Training in Kelambakkam
    Software Testing Training in Padur

    ReplyDelete
  49. sathyarameshDecember 4, 2018 at 10:45 PM

    This is a good post. This post give truly quality information. I’m definitely going to look into it. Really very useful tips are provided here. thank you so much. Keep up the good works.
    Android Development Course in Chennai
    Android app Development Course in Chennai
    Android Training Institute in Chennai
    AWS Certification Training in Chennai
    AWS Training near me
    AWS Training in Chennai

    ReplyDelete
  50. nanadhini chandranDecember 17, 2018 at 3:26 AM

    More informative,thanks for sharing with us.
    this blog makes the readers more enjoyable.keep add more info on your page.
    Java Institutes in bangalore
    Java Classes in Bangalore
    Java Training in Chennai Anna Nagar
    Java Institute in T nagar
    Java Training Institutes in OMR

    ReplyDelete
  51. Mueeid KhanJanuary 10, 2019 at 6:54 AM

    Often programmers find it daunting to understand and modify the code written by others. Hence, they need extra time to maintain and update the PHP applications efficiently.plakatų spausdinimas

    ReplyDelete
  52. Shadeep shreeJanuary 13, 2019 at 10:56 PM

    The blog which you have posted is stunning... Waiting for your upcoming data...
    Cloud Computing Courses in Coimbatore
    Java Training Institutes in Bangalore
    AWS Training in Bangalore
    data analytics courses in bangalore
    Android Training in Madurai
    Android Training in Coimbatore

    ReplyDelete
  53. UnknownJanuary 15, 2019 at 1:21 AM

    Exciting online games with us best casinos online come in and win right now.

    ReplyDelete
  54. Shiva ShakthiJanuary 16, 2019 at 10:44 PM

    Awesome post!!! Thanks a lot for sharing with us....
    Spring Training in Chennai
    Spring and Hibernate Training in Chennai
    Hibernate Training in Chennai
    Struts Training in Chennai
    Spring Training in Anna Nagar
    Spring Training in Adyar

    ReplyDelete
  55. punithaJanuary 16, 2019 at 11:36 PM

    Well written Blog, I really enjoy reading your blog. this info will be helpful for me. Thanks for sharing.
    SEO Training in Chennai
    SEO Course in Chennai
    RPA Classes in Chennai
    CCNA Training in Chennai
    DevOps Training in Chennai
    SEO Training in T Nagar
    SEO Training in Porur

    ReplyDelete
  56. Riya RajFebruary 6, 2019 at 11:34 PM

    The blog you have shared is more informative... Thanks for your valid blog.
    Selenium Training in Bangalore
    Selenium Training in Coimbatore
    Selenium Training Institutes in Bangalore
    Ethical Hacking Course in Bangalore
    German Classes in Bangalore
    German Classes in Madurai
    Hacking Course in Coimbatore
    German Classes in Coimbatore

    ReplyDelete
  57. Anbarasan14February 7, 2019 at 2:38 AM

    Happy to read your blog and gained a lot of new information in detail. Thanks for sharing.

    Spoken English in Velachery
    Spoken English Class in Chrompet
    Spoken English Classes in Navalur
    Spoken English Class in Avadi
    Spoken English Class in Chennai
    Spoken English Classes in Chennai

    ReplyDelete
  58. Durai RajFebruary 8, 2019 at 2:29 AM

    Great Blog!!! Thanks for sharing with us... it is more useful for us..
    hadoop training in bangalore
    big data courses in bangalore
    hadoop training institutes in bangalore
    Devops Training in Bangalore
    Digital Marketing Courses in Bangalore
    German Language Course in Madurai
    Cloud Computing Courses in Coimbatore
    Embedded course in Coimbatore

    ReplyDelete

Subscribe to: Post Comments ( Atom )