How to set the column width of excel in php (technical method)

In the Excel export function, it is often necessary to set the column width to ensure that the exported Excel table can clearly display the data. In PHP, setting the column width of Excel is also very simple. This article will introduce how to set the column width of Excel in PHP, and provide sample code to help everyone understand.

In PHP, we can use PHPExcel, a powerful class library, to perform Excel operations. First, we need to introduce the PHPExcel class library into our code:

require_once 'path/to/PHPExcel.php';

Then, we need to create a PHPExcel object to perform Excel operations:

$excel = new PHPExcel();

After creating the PHPExcel object, We can set various properties of the Excel table. Before setting the column width of Excel, we need to obtain the object of the column to be set. PHPExcel provides the getColumnDimension method to obtain the object of a certain column. For example, if we want to set the width of column A to 20, we can use the following code:

$columnA = $excel->getActiveSheet()->getColumnDimension('A');
$columnA->setWidth(20);

Here, we first use the getActiveSheet() method to obtain the current active worksheet object, and then use the getColumnDimension() method to obtain For the object in column A, finally use the setWidth() method to set the column width to 20.

In addition to setting the width of a certain column, we can also set the width of multiple columns in batches. Suppose we want to set the width of columns A, B, and C to 20, 30, and 40. You can use the following code:

$columnA = $excel->getActiveSheet()->getColumnDimension('A');
$columnA->setWidth(20);

$columnB = $excel->getActiveSheet()->getColumnDimension('B');
$columnB->setWidth(30);

$columnC = $excel->getActiveSheet()->getColumnDimension('C');
$columnC->setWidth(40);

The above is how to set the column width of Excel in PHP. The following is a complete sample code to help you better understand how to set the column width of Excel:

require_once 'path/to/PHPExcel.php';

$excel = new PHPExcel();

// 设置第A列的宽度为20
$columnA = $excel->getActiveSheet()->getColumnDimension('A');
$columnA->setWidth(20);

// 设置第B列的宽度为30
$columnB = $excel->getActiveSheet()->getColumnDimension('B');
$columnB->setWidth(30);

// 设置第C列的宽度为40
$columnC = $excel->getActiveSheet()->getColumnDimension('C');
$columnC->setWidth(40);

// 导出Excel表
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="demo.xlsx"');
header('Cache-Control: max-age=0');

$objWriter = PHPExcel_IOFactory::createWriter($excel, 'Excel2007');
$objWriter->save('php://output');
exit;

In this sample code, we first create a PHPExcel object, and then set the width of column A to 20, the width of column B is 30, and the width of column C is 40. Finally, use the createWriter() method of the PHPExcel_IOFactory class to export the Excel table.

In general, setting the column width of Excel in PHP is very simple. We can easily complete this operation through the PHPExcel class library. I hope this article can help everyone better master the skills of operating Excel tables with PHP.

The above is the detailed content of How to set the column width of excel in php (technical method). For more information, please follow other related articles on the PHP Chinese website!