<div>
I didn't use PhpSpreadsheet library before, but I found a simple example at; 
 
PhpSpreadsheet – A Beginner’s Tutorial 
<a href="https://code-boxx.com/phpspreadsheet-beginner-tutorial/" rel="ugc">https://code-boxx.com/phpspreadsheet-beginner-tutorial/</a> 
 
I have a quick view for: 
<a href="https://phpspreadsheet.readthedocs.io/en/latest/" rel="ugc">https://phpspreadsheet.readthedocs.io/en/latest/</a> 
 
think the examples are there but it's merely &quot;too simple&quot; in the case to provide a solution.
</div>

Business Owner / Chief Developer

Richard Korts

<div>
Those are perfect. Thank you. 
 
The part that was confusing to me was having to do the writer AFTER putting the content in. 
 
Thanks
</div>

<div>
No worries Richard, 
 
You can create the writer before you've put the content in, if that makes more sense to you. You just need to pass in the spreadsheet, and make sure you call save() on the writer when you're done: 
 

<pre><code class="code-10 nolinks" id="code-20-43072361-1">require __DIR__ . '/vendor/autoload.php';

use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;

$spreadsheet = new Spreadsheet();
$writer = new Xlsx($spreadsheet);

$sheet = $spreadsheet-&gt;getActiveSheet();
$sheet-&gt;setCellValue('A1', 'Chris Stanyon');

$writer-&gt;save('mysheet.xlsx');
</code></pre>
</div>

<div>
Hey Chris, 
 
I have this code: 
 
$sh_name = &quot;reports/Sales Detail Master &quot;&nbsp;. $rdate . &quot;.xlsx&quot;; 
// Create a new Writer (needed to save the WorkBook) 
$writer = new Xlsx($spreadsheet); 
echo &quot;final row number: &quot;&nbsp;. $row . &quot;&lt;br&gt;&quot;; 
// Save the Workbook 
$writer-&gt;save($sh_name); 
 
It fails with this error 
 
Warning: ZipArchive::close(): Failure to create temporary file: No such file or directory in /home/rkassoc/public_html/dewitt/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Writer/Xlsx.php on line 409 
 
I assume this means I have to give it the full path even though the folder &quot;reports&quot; exists under public_html/dewitt, where the php is being executed.
</div>

<div>
Hi Richard, 
 
You shouldn't have to give the full path as it's a relative path (relative to where the script is being ran). The only way I could replicate your error was by not having the reports folder already created. Once I created that, the code ran fine. 
 
You need to make sure you have the reports folder in the same folder as the PHP script.
</div>

<div>
<div class="content wysiwyg-content">
Want to use php Office / php Spreadsheet to create a NEW sheet (xlsx file), populate rows &amp;&nbsp;columns, I'll build the loops, etc. 
 
Very frustrated, cannot find a single example of all the steps needed to do this; create a new instance, populate cells, write to an xlsx file. 
 
It's real big on how to read, ZERO examples I can find on how to write. 
 
Please someone show me. a FULL example, one if I run it, it will literally produce an xlsx file. 
 
Using this, tried every way of asking I can think of, ZERO results. 
 
<a href="https://phpspreadsheet.readthedocs.io/en/latest/" rel="ugc">https://phpspreadsheet.readthedocs.io/en/latest/</a>
</div>
</div>

Want to use php Office / php Spreadsheet to create a NEW sheet (xlsx file), populate rows & columns, I'll build the loops, etc.

Very frustrated, cannot find a single example of all the steps needed to do this; create a new instance, populate cells, write to an xlsx file.

It's real big on how to read, ZERO examples I can find on how to write.

Please someone show me. a FULL example, one if I run it, it will literally produce an xlsx file.

Using this, tried every way of asking I can think of, ZERO results.

https://phpspreadsheet.readthedocs.io/en/latest/

Please show example of CREATE &amp; POPULATE new spreadsheet

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

Please show example of CREATE &amp; POPULATE new spreadsheet

Please show example of CREATE & POPULATE new spreadsheet