how to also copy the format of the original and sheet name? I tired writing this but didn't change the name of the sheet inside the foreach $worksheet $worksheet1 = $workbook->addworksheet($worksheet);