<div>
Richard<br />
<br />
If it's only the values have you tried using rangeToArray to retrieve the data and then fromArray to 'paste' the data into the new sheet?<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-43101024-1"><span>$data = $spreadsheet-&gt;getSheetByName('Sheet1')-&gt;rangeToArray('A1:D20');</span>
<span>$spreadsheet-&gt;getSheetByName('Sheet2)-&gt;fromArray($data, null, 'A1');</span>
</code></pre>
</div>


<div>
It would be nice to have cell formatting too, but I can do that separately. That covers the basic need.<br>I am using this structure to build sheets:<br><br>$rps = $spreadsheet-&gt;getActiveSheet();<br>$rps-&gt;setCellValue($cell, $str);<br><br>or<br>$range = "A" . $row . ":I" . $row;<br>$spreadsheet-&gt;getActiveSheet()-&gt;getStyle($range)-&gt;getFont()-&gt;setBold(true);<br><br>How do I get the "name" of a sheet?<br><br>Thank you.
</div>


Business Owner / Chief Developer

Richard Korts

<div>
That's perfect, Chris.<br><br>I can handle the styling easily.<br><br>I think phpSpreadsheet is an AWESOME tool, I am using it to create sales reports for new clients, just looking for little shortcuts. In this case, there is a MASTER sales report for management with about 20 (number varies) of Reps. All the Rep detail is in one set of contiguous rows, I'd just like to make the individual sheets for the reps by just copying the sections that comprise there part into individual sheets, emailed to each rep. My customers LOVE this, Excel is so commonly used, almost everyone is business can deal with it.<br><br>Just that when I want to do something different, hard to find in docs.
</div>


<div>
Richard<br />
<br />
Are you putting all the data into one sheet and then want to copy data from that sheet to separate sheets for each individual rep?
</div>


<div>
Yes, but I need the same formatting (alignment, fill color, bold, font size, etc.)
</div>


<div>
<div class="content wysiwyg-content">
I'm using phpOffice/phpSpreadsheet. Great tool, documentation very difficult.<br />
<br />
If there were a way............<br />
<br />
I build &quot;master&quot; spreadsheets of sales reports; included is all the detail by Rep, then lower categories.<br />
<br />
It would be convenient to be able to copy rows and &quot;paste&quot; them into another sheet, just like you can do in Excel itself.<br />
<br />
I looked up copy rows; takes me to recipes in the docs, nothing there about that.<br />
<br />
Can this be done? In other words, start a new sheet &amp;&nbsp;build it's content by copying rows from an existing sheet .<br />
<br />
Thanks
</div>
</div>


I'm using phpOffice/phpSpreadsheet. Great tool, documentation very difficult.

If there were a way............

I build "master" spreadsheets of sales reports; included is all the detail by Rep, then lower categories.

It would be convenient to be able to copy rows and "paste" them into another sheet, just like you can do in Excel itself.

I looked up copy rows; takes me to recipes in the docs, nothing there about that.

Can this be done? In other words, start a new sheet & build it's content by copying rows from an existing sheet .

Thanks

Copy rows using phpSpreadsheet

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.

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.