How to set column width and column position when exporting Excel using native PHP?

Native PHP export Excel: Precisely control column width and column position

When exporting Excel directly using PHP native functions, it is difficult to accurately control the column width and column position. This article will demonstrate how to solve this problem, ensure that the "Alipay account", "name" and "payment amount" are located in columns A, B, and C respectively, and adjust the column width.

The following is the improved code, using the PHPExcel library to achieve precise control:

Problems with the original code: The original code uses the fputcsv function, which separates data with tab characters ( \t ), making it difficult to accurately control the column width and position.

Improved code:

 <?php require_once &#39;PHPExcel.php&#39;; // Make sure that the PHPExcel library has correctly introduced $objPHPExcel = new PHPExcel();
$sheet = $objPHPExcel->getActiveSheet();

// Set column width $sheet->getColumnDimension('A')->setWidth(20); // Alipay account $sheet->getColumnDimension('B')->setWidth(15); // Name $sheet->getColumnDimension('C')->setWidth(12); // Payment amount// Set title $sheet->setCellValue('A1', 'Alipay account');
$sheet->setCellValue('B1', 'name');
$sheet->setCellValue('C1', 'Paid Amount');

// Fill in data $row = 2;
foreach ($list as $val) {
    $sheet->setCellValue('A' . $row, $val['alipay_acount']);
    $sheet->setCellValue('B' . $row, $val['alipay_real_name']);
    $sheet->setCellValue('C' . $row, $val['total_check_che']);
    $row ;
}

// Output Excel file $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="Article Information Statistics'.date('ymdHis').'.xls"');
$objWriter->save('php://output');
?>

Code description:

1. Introduce the PHPExcel library: Make sure PHPExcel library file is imported correctly and add its path to the code.
2. Set column width: Use getColumnDimension() method to get column objects, and then use setWidth() method to set column width (unit is character width).
3. Set cell value: Use setCellValue() method to write title and data to the corresponding cell.
4. Output Excel file: Use PHPExcel_IOFactory::createWriter() to create an Excel5 writer, set appropriate header information, and output the Excel file to the browser.

Batch setting column width: If you need to batch set column width, you can use a loop:

 $cols = range('A', 'C'); // Set the width of column A to C foreach ($cols as $col) {
    $sheet->getColumnDimension($col)->setWidth(15); // All column widths are set to 15
}

By using the PHPExcel library, you can easily control the column width and column position of Excel files, and generate more standardized and easier to read Excel reports. Please make sure your server has the PHPExcel library installed and configured.

The above is the detailed content of How to set column width and column position when exporting Excel using native PHP?. For more information, please follow other related articles on the PHP Chinese website!