{"type":"rich","version":"1.0","provider_name":"phorkie","provider_url":"https:\/\/p.cweiske.de\/","title":"TYPO3 v12: Return a phpoffice spreadsheet in a response object","author_name":"Christian Weiske","cache_age":86400,"width":900,"height":900,"html":"<!-- embedding all files of https:\/\/p.cweiske.de\/886 -->\n<link rel=\"stylesheet\" href=\"https:\/\/p.cweiske.de\/css\/embed.css\"\/>\n<div class=\"phork\" id=\"886\">\n    <div class=\"phork-file\">\n <div class=\"phork-content\">\n  <style type=\"text\/css\">\/**\n * GeSHi (C) 2004 - 2007 Nigel McNie, 2007 - 2014 Benny Baumann\n * (http:\/\/qbnz.com\/highlighter\/ and http:\/\/geshi.org\/)\n *\/\n.php .de1, .php .de2 {font: normal normal 1em\/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;}\n.php  {font-family:monospace;}\n.php .imp {font-weight: bold; color: red;}\n.php li, .php .li1 {color: #DDD;}\n.php .ln {width:1px;text-align:right;margin:0;padding:0 2px;vertical-align:top;}\n.php .kw1 {color: #b1b100;}\n.php .kw2 {color: #000000; font-weight: bold;}\n.php .kw3 {color: #990000;}\n.php .kw4 {color: #009900; font-weight: bold;}\n.php .co1 {color: #666666; font-style: italic;}\n.php .co2 {color: #666666; font-style: italic;}\n.php .co3 {color: #0000cc; font-style: italic;}\n.php .co4 {color: #009933; font-style: italic;}\n.php .coMULTI {color: #666666; font-style: italic;}\n.php .es0 {color: #000099; font-weight: bold;}\n.php .es1 {color: #000099; font-weight: bold;}\n.php .es2 {color: #660099; font-weight: bold;}\n.php .es3 {color: #660099; font-weight: bold;}\n.php .es4 {color: #006699; font-weight: bold;}\n.php .es5 {color: #006699; font-weight: bold; font-style: italic;}\n.php .es6 {color: #009933; font-weight: bold;}\n.php .es_h {color: #000099; font-weight: bold;}\n.php .br0 {color: #009900;}\n.php .sy0 {color: #339933;}\n.php .sy1 {color: #000000; font-weight: bold;}\n.php .st0 {color: #0000ff;}\n.php .st_h {color: #0000ff;}\n.php .nu0 {color: #cc66cc;}\n.php .nu8 {color: #208080;}\n.php .nu12 {color: #208080;}\n.php .nu19 {color:#800080;}\n.php .me1 {color: #004000;}\n.php .me2 {color: #004000;}\n.php .re0 {color: #000088;}\n.php span.xtra { display:block; }\n<\/style><div class=\"code\"><table class=\"php\"><tbody><tr class=\"li1\"><td class=\"ln\"><pre class=\"de1\">1\n2\n3\n4\n5\n6\n7\n8\n9\n10\n11\n12\n13\n14\n15\n16\n17\n18\n19\n20\n21\n22\n23\n<\/pre><\/td><td class=\"de1\"><pre class=\"de1\"><span class=\"kw2\">&lt;?php<\/span>\n&#160;\n<span class=\"kw2\">use<\/span> PhpOffice\\PhpSpreadsheet\\Spreadsheet<span class=\"sy0\">;<\/span>\n<span class=\"kw2\">use<\/span> PhpOffice\\PhpSpreadsheet\\Writer\\Ods<span class=\"sy0\">;<\/span>\n&#160;\n<span class=\"kw2\">use<\/span> Psr\\Http\\Message\\ResponseInterface<span class=\"sy0\">;<\/span>\n&#160;\n<span class=\"kw2\">class<\/span> Controller\n<span class=\"br0\">&#123;<\/span>\n&#160; &#160; <span class=\"kw2\">public<\/span> <span class=\"kw2\">function<\/span> exportAction<span class=\"br0\">&#40;<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">:<\/span> ResponseInterface\n&#160; &#160; <span class=\"br0\">&#123;<\/span>\n&#160; &#160; &#160; &#160; <span class=\"re0\">$spreadsheet<\/span> <span class=\"sy0\">=<\/span> <span class=\"kw2\">new<\/span> Spreadsheet<span class=\"br0\">&#40;<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">;<\/span>\n&#160; &#160; &#160; &#160; <span class=\"re0\">$activeWorksheet<\/span> <span class=\"sy0\">=<\/span> <span class=\"re0\">$spreadsheet<\/span><span class=\"sy0\">-&gt;<\/span><span class=\"me1\">getActiveSheet<\/span><span class=\"br0\">&#40;<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">;<\/span>\n&#160; &#160; &#160; &#160; <span class=\"re0\">$activeWorksheet<\/span><span class=\"sy0\">-&gt;<\/span><span class=\"me1\">setCellValue<\/span><span class=\"br0\">&#40;<\/span><span class=\"st_h\">'A1'<\/span><span class=\"sy0\">,<\/span> <span class=\"st_h\">'Hello World !'<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">;<\/span>\n&#160;\n&#160; &#160; &#160; &#160; <span class=\"re0\">$writer<\/span> <span class=\"sy0\">=<\/span> <span class=\"kw2\">new<\/span> Ods<span class=\"br0\">&#40;<\/span><span class=\"re0\">$spreadsheet<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">;<\/span>\n&#160;\n&#160; &#160; &#160; &#160; <span class=\"kw1\">return<\/span> <span class=\"re0\">$this<\/span><span class=\"sy0\">-&gt;<\/span><span class=\"me1\">responseFactory<\/span><span class=\"sy0\">-&gt;<\/span><span class=\"me1\">createResponse<\/span><span class=\"br0\">&#40;<\/span><span class=\"br0\">&#41;<\/span>\n&#160; &#160; &#160; &#160; &#160; &#160; <span class=\"sy0\">-&gt;<\/span><span class=\"me1\">withHeader<\/span><span class=\"br0\">&#40;<\/span><span class=\"st_h\">'Content-Type'<\/span><span class=\"sy0\">,<\/span> <span class=\"st_h\">'application\/vnd.oasis.opendocument.spreadsheet'<\/span><span class=\"br0\">&#41;<\/span>\n&#160; &#160; &#160; &#160; &#160; &#160; <span class=\"sy0\">-&gt;<\/span><span class=\"me1\">withBody<\/span><span class=\"br0\">&#40;<\/span><span class=\"kw2\">new<\/span> SpreadsheetStream<span class=\"br0\">&#40;<\/span><span class=\"re0\">$writer<\/span><span class=\"br0\">&#41;<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">;<\/span>\n&#160; &#160; <span class=\"br0\">&#125;<\/span>\n&#160;\n<span class=\"br0\">&#125;<\/span><\/pre><\/td><\/tr><\/tbody><\/table><\/div>\n <\/div>\n <div class=\"phork-meta\">\n  <a href=\"https:\/\/p.cweiske.de\/886\/rev-raw\/7fb9406da031b3cfaab92d45a5635bf5299e838f\/Controller.php\" style=\"float: right\">view raw source<\/a>\n  <a href=\"https:\/\/p.cweiske.de\/886#Controller.php\">Controller.php<\/a>\n <\/div>\n<\/div>\n    <div class=\"phork-file\">\n <div class=\"phork-content\">\n  <style type=\"text\/css\">\/**\n * GeSHi (C) 2004 - 2007 Nigel McNie, 2007 - 2014 Benny Baumann\n * (http:\/\/qbnz.com\/highlighter\/ and http:\/\/geshi.org\/)\n *\/\n.php .de1, .php .de2 {font: normal normal 1em\/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;}\n.php  {font-family:monospace;}\n.php .imp {font-weight: bold; color: red;}\n.php li, .php .li1 {color: #DDD;}\n.php .ln {width:1px;text-align:right;margin:0;padding:0 2px;vertical-align:top;}\n.php .kw1 {color: #b1b100;}\n.php .kw2 {color: #000000; font-weight: bold;}\n.php .kw3 {color: #990000;}\n.php .kw4 {color: #009900; font-weight: bold;}\n.php .co1 {color: #666666; font-style: italic;}\n.php .co2 {color: #666666; font-style: italic;}\n.php .co3 {color: #0000cc; font-style: italic;}\n.php .co4 {color: #009933; font-style: italic;}\n.php .coMULTI {color: #666666; font-style: italic;}\n.php .es0 {color: #000099; font-weight: bold;}\n.php .es1 {color: #000099; font-weight: bold;}\n.php .es2 {color: #660099; font-weight: bold;}\n.php .es3 {color: #660099; font-weight: bold;}\n.php .es4 {color: #006699; font-weight: bold;}\n.php .es5 {color: #006699; font-weight: bold; font-style: italic;}\n.php .es6 {color: #009933; font-weight: bold;}\n.php .es_h {color: #000099; font-weight: bold;}\n.php .br0 {color: #009900;}\n.php .sy0 {color: #339933;}\n.php .sy1 {color: #000000; font-weight: bold;}\n.php .st0 {color: #0000ff;}\n.php .st_h {color: #0000ff;}\n.php .nu0 {color: #cc66cc;}\n.php .nu8 {color: #208080;}\n.php .nu12 {color: #208080;}\n.php .nu19 {color:#800080;}\n.php .me1 {color: #004000;}\n.php .me2 {color: #004000;}\n.php .re0 {color: #000088;}\n.php span.xtra { display:block; }\n<\/style><div class=\"code\"><table class=\"php\"><tbody><tr class=\"li1\"><td class=\"ln\"><pre class=\"de1\">1\n2\n3\n4\n5\n6\n7\n8\n9\n10\n11\n12\n13\n14\n15\n16\n17\n18\n19\n20\n21\n22\n23\n24\n25\n26\n27\n28\n29\n30\n31\n32\n33\n34\n35\n36\n37\n38\n39\n40\n41\n42\n43\n<\/pre><\/td><td class=\"de1\"><pre class=\"de1\"><span class=\"kw2\">&lt;?php<\/span>\n&#160;\n<span class=\"kw2\">declare<\/span><span class=\"br0\">&#40;<\/span>strict_types<span class=\"sy0\">=<\/span><span class=\"nu0\">1<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">;<\/span>\n&#160;\n<span class=\"kw2\">use<\/span> PhpOffice\\PhpSpreadsheet\\Writer\\BaseWriter<span class=\"sy0\">;<\/span>\n&#160;\n<span class=\"kw2\">use<\/span> GuzzleHttp\\Psr7\\StreamDecoratorTrait<span class=\"sy0\">;<\/span>\n<span class=\"kw2\">use<\/span> Psr\\Http\\Message\\StreamInterface<span class=\"sy0\">;<\/span>\n<span class=\"kw2\">use<\/span> TYPO3\\CMS\\Core\\Http\\SelfEmittableStreamInterface<span class=\"sy0\">;<\/span>\n&#160;\n<span class=\"co4\">\/**<\/span>\n<span class=\"co4\">&#160;* Generate a spreadsheet in the last moment for downloading<\/span>\n<span class=\"co4\">&#160;*\/<\/span>\n<span class=\"kw2\">class<\/span> SpreadsheetStream <span class=\"kw2\">implements<\/span> StreamInterface<span class=\"sy0\">,<\/span> SelfEmittableStreamInterface\n<span class=\"br0\">&#123;<\/span>\n&#160; &#160; <span class=\"kw2\">use<\/span> StreamDecoratorTrait<span class=\"sy0\">;<\/span>\n&#160;\n&#160; &#160; <span class=\"kw2\">public<\/span> <span class=\"kw2\">function<\/span> __construct<span class=\"br0\">&#40;<\/span>\n&#160; &#160; &#160; &#160; <span class=\"kw2\">protected<\/span> readonly BaseWriter <span class=\"re0\">$writer<\/span>\n&#160; &#160; <span class=\"br0\">&#41;<\/span> <span class=\"br0\">&#123;<\/span><span class=\"br0\">&#125;<\/span>\n&#160;\n&#160; &#160; <span class=\"co4\">\/**<\/span>\n<span class=\"co4\">&#160; &#160; &#160;* Emit the response to stdout, as specified in SelfEmittableStreamInterface.<\/span>\n<span class=\"co4\">&#160; &#160; &#160;*\/<\/span>\n&#160; &#160; <span class=\"kw2\">public<\/span> <span class=\"kw2\">function<\/span> emit<span class=\"br0\">&#40;<\/span><span class=\"br0\">&#41;<\/span>\n&#160; &#160; <span class=\"br0\">&#123;<\/span>\n&#160; &#160; &#160; &#160; <span class=\"re0\">$this<\/span><span class=\"sy0\">-&gt;<\/span><span class=\"me1\">writer<\/span><span class=\"sy0\">-&gt;<\/span><span class=\"me1\">save<\/span><span class=\"br0\">&#40;<\/span><span class=\"st_h\">'php:\/\/output'<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">;<\/span>\n&#160; &#160; <span class=\"br0\">&#125;<\/span>\n&#160;\n&#160; &#160; <span class=\"kw2\">public<\/span> <span class=\"kw2\">function<\/span> isWritable<span class=\"br0\">&#40;<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">:<\/span> bool\n&#160; &#160; <span class=\"br0\">&#123;<\/span>\n&#160; &#160; &#160; &#160; <span class=\"kw1\">return<\/span> <span class=\"kw4\">false<\/span><span class=\"sy0\">;<\/span>\n&#160; &#160; <span class=\"br0\">&#125;<\/span>\n&#160;\n&#160; &#160; <span class=\"co4\">\/**<\/span>\n<span class=\"co4\">&#160; &#160; &#160;* @throws \\RuntimeException<\/span>\n<span class=\"co4\">&#160; &#160; &#160;*\/<\/span>\n&#160; &#160; <span class=\"kw2\">public<\/span> <span class=\"kw2\">function<\/span> write<span class=\"br0\">&#40;<\/span>string <span class=\"re0\">$string<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">:<\/span> int\n&#160; &#160; <span class=\"br0\">&#123;<\/span>\n&#160; &#160; &#160; &#160; <span class=\"kw1\">throw<\/span> <span class=\"kw2\">new<\/span> \\RuntimeException<span class=\"br0\">&#40;<\/span><span class=\"st_h\">'Cannot write to a '<\/span> <span class=\"sy0\">.<\/span> <span class=\"kw2\">self<\/span><span class=\"sy0\">::<\/span><span class=\"kw2\">class<\/span><span class=\"sy0\">,<\/span> <span class=\"nu0\">1538331852<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">;<\/span>\n&#160; &#160; <span class=\"br0\">&#125;<\/span>\n<span class=\"br0\">&#125;<\/span>\n&#160;<\/pre><\/td><\/tr><\/tbody><\/table><\/div>\n <\/div>\n <div class=\"phork-meta\">\n  <a href=\"https:\/\/p.cweiske.de\/886\/rev-raw\/7fb9406da031b3cfaab92d45a5635bf5299e838f\/SpreadsheetStream.php\" style=\"float: right\">view raw source<\/a>\n  <a href=\"https:\/\/p.cweiske.de\/886#SpreadsheetStream.php\">SpreadsheetStream.php<\/a>\n <\/div>\n<\/div>\n<\/div>\n"}