What are the best practices for saving CSV data into an Excel file for download using PHP?

When saving CSV data into an Excel file for download using PHP, it is best to use the PHPExcel library which provides a convenient way to create Excel files. You can convert the CSV data into an Excel file by reading the CSV file, creating a new Excel file, and inserting the data into the Excel file. Finally, you can prompt the user to download the Excel file. 

// Include PHPExcel library
require_once 'PHPExcel.php';

// Load CSV data
$csvData = file_get_contents('data.csv');
$csvData = str_getcsv($csvData, "\n");

// Create new PHPExcel object
$objPHPExcel = new PHPExcel();

// Set active sheet
$objPHPExcel->setActiveSheetIndex(0);

// Insert CSV data into Excel file
foreach ($csvData as $key => $row) {
    $rowData = str_getcsv($row, ",");
    foreach ($rowData as $k => $value) {
        $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($k, $key + 1, $value);
    }
}

// Save Excel file
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter->save('data.xlsx');

// Prompt user to download the Excel file
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment;filename="data.xlsx"');
header('Cache-Control: max-age=0');
$objWriter->save('php://output');
exit;

Keywords

CSV Excel file download PHP functions libraries

Related Questions