phpexcel to download

Question

hello i am new to phpexcel   and i was wondering if there is some way send the excel i have created to the clients download without saving it on my server or to delete it right after he downloads it  i am trying to create an  export button  on a page that will give the user a  pop-up  with the excel that he wants that i have just created   now after i create the table i do     objXLS- gt getActiveSheet  - gt getColumnDimension  A  - gt setAutoSize true    objXLS- gt getActiveSheet  - gt getColumnDimension  B  - gt setAutoSize true     objXLS- gt getActiveSheet  - gt setTitle  Test Stats      objXLS- gt setActiveSheetIndex 0     objWriter   PHPExcel IOFactory  createWriter  objXLS   Excel5     objWriter- gt save   DIR     test1 xls      but that saves it to my server  thank you

User · Answer

header  Content-type  application vnd ms-excel      header  Content-Disposition  attachment  filename  file xlsx       header  Cache-Control  max-age 0      header   Expires  Mon  26 Jul 1997 05 00 00 GMT      header   Last-Modified    gmdate  D  d M Y H i s     GMT      header   Cache-Control  cache  must-revalidate      header   Pragma  public       objWriter   PHPExcel IOFactory  createWriter  objPHPExcel   Excel5       objWriter- gt save  php   output

User · Answer

excel   new PHPExcel    header  Content-Type  application vnd ms-excel    header  Content-Disposition  attachment filename  your name xls     header  Cache-Control  max-age 0        Do your stuff here   writer   PHPExcel IOFactory  createWriter  excel   Excel5        This line will force the file to download  writer- gt save  php   output

User · Answer

posible you already solved your problem  any way i hope this help you   all files downloaded starts with empty line  in my case where four empty lines  and it make a problem  No matter if you work with readfile    or  save  php   output     This can be fixed with adding ob start    at the  beginning of the script and ob end clean    just before the readfile    or save  php   output

User · Answer

Use this call   objWriter- gt save  php   output      To output the XLS sheet to the page you are on  just make sure that the page you are on has no other echo s print s  outputs

User · Answer

Instead of saving it to a file  save it to php   output shy Docs    objWriter- gt save  php   output      This will send it AS-IS to the browser   You want to add some headers shy Docs first  like it s common with file downloads  so the browser knows which type that file is and how it should be named  the filename       We ll be outputting an excel file header  Content-type  application vnd ms-excel        It will be called file xls header  Content-Disposition  attachment  filename  file xls         Write file to the browser  objWriter- gt save  php   output      First do the headers  then the save  For the excel headers see as well the following question  Setting mime type for excel document

User · Answer

FOR XLSX USE  SET IN  xlsName name from XLSX with extension  Example   xlsName    teste xlsx     objPHPExcel   new PHPExcel      objWriter   PHPExcel IOFactory  createWriter  objPHPExcel   Excel2007    header  Content-Type  application vnd ms-excel    header  Content-Disposition  attachment filename     xlsName       header  Cache-Control  max-age 0     objWriter- gt save  php   output      FOR XLS USE  SET IN  xlsName name from XLS with extension  Example   xlsName    teste xls     objPHPExcel   new PHPExcel      objWriter   PHPExcel IOFactory  createWriter  objPHPExcel   Excel5    header  Content-Type  application vnd ms-excel    header  Content-Disposition  attachment filename     xlsName       header  Cache-Control  max-age 0     objWriter- gt save  php   output

[php] phpexcel to download

Examples related to php

Examples related to download

Examples related to export

Examples related to phpexcel

Examples related to export-to-excel