Breaking News: Grepper is joining You.com. Read the official announcement!

phpexcel clone excel worksheet into another excel worksheet

Half Unicorn, Half Potato answered on February 27, 2023 Popularity 1/10 Helpfulness 1/10

answer phpexcel clone excel worksheet into another excel worksheet

phpexcel clone excel worksheet into another excel worksheet

Comment

//load current worksheet
$file1 = "path to file";
$PhpSpreadsheet = $reader->load($file1);

//load worksheet from template 
$template = "path to file";
$PhpSpreadsheet1 = $reader->load($template);

//clone into current worksheet
$cloneWorksheet = clone $PhpSpreadsheet1->getActiveSheet()->copy();
$PhpSpreadsheet->addExternalSheet($cloneWorksheet);
$PhpSpreadsheet->setActiveSheetIndex($PhpSpreadsheet->getIndex($cloneWorksheet));
$PhpSpreadsheet->getActiveSheet()->setTitle("Title 1"));

unset($PhpSpreadsheet);
unset($PhpSpreadsheet1);

note that you have to add addExternalSheet() before setTitle() otherwise you will get error: Sheet does not exist

Popularity 1/10 Helpfulness 1/10 Language php

Source: Grepper

Tags: clone excel php phpexcel worksheet

Link to this answer
Share Copy Link

Contributed on Feb 27 2023

Half Unicorn, Half Potato

0 Answers Avg Quality 2/10

phpexcel clone excel worksheet into another excel worksheet

Contents

More Related Answers

phpexcel clone excel worksheet into another excel worksheet

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.