These are chat archives for PHPOffice/PhpSpreadsheet

7th
Feb 2018
Adrien Crivelli
@PowerKiKi
Feb 07 03:17
@Karu666_twitter AFAIK there is nothing out of the box that convert a column into a row, but that docs should give you the tools to do it yourself: http://phpspreadsheet.readthedocs.io/en/develop/topics/accessing-cells/
Carlo van Eeckhoven
@Karu666_twitter
Feb 07 08:39
Hi, I've tried that but can't seem to be able to copy the data from one to another sheet. How do I copy and paste from one sheet to another? I've used $spreadsheet2 = $reader->load to load a sheet but don't know how to actually get data from the first sheet into the specific cells in the other one.
Carlo van Eeckhoven
@Karu666_twitter
Feb 07 11:37
Right now I'm stuck at trying to write an array to an .xlsm file (data I got from an .csv file) Is this even possible? All I'm getting are 'compatibility issues' and an empty .xlsm file.