Rename Worksheet - how?

[josipWebbite]

Hi, I need to rename default "Worksheet" name to something else. How?

Regards

[josipWebbite]

Anyone?

[oleibman]

When a new sheet is created, it will have the title Worksheet (or Worksheet 1 etc.). You can explicitly change the title after it has been created:

$sheet->setTitle('anything');

[josipWebbite]

I tried, but how to implement, I have something like this:

$spreadsheet = new Spreadsheet();
$reader = new \PhpOffice\PhpSpreadsheet\Reader\Csv();


// $reader->setInputEncoding('CP1252');
$reader->setDelimiter(';');
$reader->setEnclosure('"');
$reader->setSheetIndex(0);

// Load a CSV file and save as a XLS 
$spreadsheet = $reader->load($_SERVER['DOCUMENT_ROOT'].'/path/Locations_datum.csv');
$writer = new Xlsx($spreadsheet);
$writer->save($_SERVER['DOCUMENT_ROOT'].'/path/'.$fileName.'.xlsx');

$spreadsheet->disconnectWorksheets();
unset($spreadsheet);

[oleibman]

After loading the spreadsheet:

$sheet = $spreadsheet->getActiveSheet();
$sheet->setTitle('anything');

[josipWebbite]

Great! Thank you!

[alexcaussades]

Great! Thank you!