getActiveSheet();
// Read CSV file using PHPSpreadsheet
$reader = new Csv();
$reader->setDelimiter(','); // Adjust delimiter if necessary
$reader->setEnclosure('"');
$reader->setSheetIndex(0);
// Load CSV into PHPSpreadsheet object
$spreadsheet = $reader->load($csvFilePath);
// *** Change or edit an existing cell value ***
// Change the value of cell 'A1'
$spreadsheet->getActiveSheet()->setCellValue('A1', 'Updated Value for A1');
// *** Add a new row ***
// Get the highest row number
$highestRow = $spreadsheet->getActiveSheet()->getHighestRow();
// Insert a new row after the highest row
$newRow = $highestRow + 1;
$sheet->setCellValue('A' . $newRow, 'New Row Value A' . $newRow);
$sheet->setCellValue('B' . $newRow, 'New Row Value B' . $newRow);
$sheet->setCellValue('C' . $newRow, 'New Row Value C' . $newRow);
// Write the Spreadsheet into an Excel file (.xlsx)
$writer = new Xlsx($spreadsheet);
// Define the output file path and name
$excelFilePath = 'converted_excel_file.xlsx';
// Save the Excel file
$writer->save($excelFilePath);
// Provide download link or success message
echo "CSV successfully converted to Excel, cell values updated, and new row added!
";
echo "Download Excel File";
} else {
echo "Please upload a valid CSV file.";
}
} else {
echo "No file uploaded.";
}