How to export Excel files and set column width using PHPExcel library?

PHPExcel library exports Excel and customizes column width

This article introduces how to use the PHPEXcel library to export Excel files and accurately control the column width of each column to solve the problem of difficult adjustment of column width when exporting Excel by native PHP. Native PHP export methods (such as using fputcsv ) cannot accurately control column width, resulting in data displays that may be misaligned or incomplete.

Suppose you need to export a table containing Alipay account, name and payment amount. You hope that Alipay account, name and payment amount occupy columns A, B, and C respectively, and set the appropriate column width to clearly display the data. Here is a native PHP export code example that cannot meet the needs of column width customization:

 set_time_limit(0);
ob_end_clean();
header("content-type: application/vnd.ms-excel");
header('content-disposition: attachment; filename="Article information statistics'.date('ymdhis').'.xls"');
$fp = fopen('php://output', 'w');
fwrite($fp, chr(0xef).chr(0xbb).chr(0xbf));
$title = array('Alipay account','name','amount of payment');
fputcsv($fp, $title, "\t");
$body = array();
foreach($list as $key=>$val){
    $body['alipay_acount'] = $val['alipay_acount'];
    $body['alipay_real_name'] = $val['alipay_real_name'];
    $body['money'] = $val['total_check_che'];
    fputcsv($fp, $body, "\t");
}

This problem can be easily solved using the PHPExcel library. PHPExcel provides setWidth method to set the column width. For example, set the width of column A to 20:

 $objphpexcel->getActiveSheet()->getColumnDimension('A')->setWidth(20);

To set the column width in batches, you can use loops:

• Set the A to Z column width to 20:

 $cols = range('A', 'Z');
foreach ($cols as $col) {
    $objphpexcel->getActiveSheet()->getColumnDimension($col)->setWidth(20);
}

• Set different columns and different widths:

 $widths = array('A' => 20, 'B' => 15, 'C' => 25);
foreach ($widths as $col => $width) {
    $objPHPExcel->getActiveSheet()->getColumnDimension($col)->setWidth($width);
}

Through the above method, you can flexibly set the column width of the Excel file to ensure that the data is displayed clearly and completely in the table. Remember that before using the PHPExcel library, you need to install and introduce the library correctly.

The above is the detailed content of How to export Excel files and set column width using PHPExcel library?. For more information, please follow other related articles on the PHP Chinese website!