Backend Development
PHP Tutorial
How to set column width and column position when exporting Excel using native PHP?
How to set column width and column position when exporting Excel using native PHP?
Apr 01, 2025 pm 01:06 PM
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 'PHPExcel.php'; // 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:
- Introduce the PHPExcel library: Make sure
PHPExcellibrary file is imported correctly and add its path to the code. - Set column width: Use
getColumnDimension()method to get column objects, and then usesetWidth()method to set column width (unit is character width). - Set cell value: Use
setCellValue()method to write title and data to the corresponding cell. - Output Excel file: Use
PHPExcel_IOFactory::createWriter()to create an Excel5 writer, set appropriateheaderinformation, 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!
Hot AI Tools
Undress AI Tool
Undress images for free
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
The latest version of virtual currency exchange v6.129.0 official latest Android APP
Jul 07, 2025 pm 09:57 PM
The Virtual Currency Exchange APP is a professional digital asset trading application, providing users with safe and convenient digital currency trading services. The new v6.129.0 version has upgraded the performance and operation experience, aiming to bring a smoother trading experience.
The latest official version of virtual currency trading platform v6.129.0 Android app 2025 new version
Jul 07, 2025 pm 10:15 PM
The latest official version of the virtual currency trading platform v6.129.0 is a professional and secure digital asset trading application created for Android users. It provides rich market conditions, convenient trading functions and multiple security protection, and is committed to providing users with a first-class trading experience.
Google Chrome Speed ??Browser Official Edition Portal
Jul 08, 2025 pm 02:30 PM
Google Chrome is a free and fast multi-platform web browser developed by Google. It is known for its speed, stability and reliability. Chrome is based on the open source Chromium project and is widely used on devices such as desktops, laptops, tablets and smartphones. The browser has a clean interface and a wide range of customizable options, allowing users to personalize it according to their preferences. In addition, Chrome has a huge library of extensions that provide additional features such as ad blocking, password management and language translation, further enhancing the browsing experience.
The latest version of the virtual digital currency exchange APP v6.128.0 Android genuine
Jul 07, 2025 pm 10:03 PM
The Virtual Digital Coin Exchange APP is a powerful digital asset trading tool, committed to providing safe, professional and convenient trading services to global users. The platform supports a variety of mainstream and emerging digital asset transactions, with a bank-level security protection system and a smooth operating experience.
How much cash is 1USDT equal? USDT Value Conversion Tutorial (Mainland)
Jul 10, 2025 pm 08:42 PM
?As a stable digital asset pegged to the US dollar, USDT's value conversion and monetization are issues that many users are concerned about. This article will introduce the value composition of USDT in detail and provide practical tutorials on value conversion and monetization in mainland China. 1 USDT's cash value is approximately equal to the real-time dollar exchange rate, but the final delivery price through C2C trading will fluctuate slightly. The core of conversion is to select a merchant with good reputation and appropriate price to trade through the C2C function of a reliable platform.
The latest download address and installation tutorial of Ouyi official app Ouyi
Jul 07, 2025 pm 09:51 PM
OKX is a world-leading digital asset service platform that provides users with trading, investment and management services for a variety of digital asset. It has comprehensive functions and convenient operation, and is trusted by the majority of users.
Dogecoin Trading Platform App Download What Dogecoin Trading Platforms are there
Jul 08, 2025 pm 05:36 PM
This article will explain the selection of Dogecoin trading platform and the official application download. We will explain in detail how to find and download the application of the trading platform through safe and reliable channels. This process will be presented in the form of step-by-step teaching. Next, we will introduce several mainstream Dogecoin trading platforms in the current market, and combine the general feedback from online users to comprehensively explain their characteristics for reference.
Solana official APP platform. Popular address.co
Jul 10, 2025 pm 07:06 PM
The acquisition and management of digital assets can be achieved through the official Solana platform and secure storage solutions. 1. Solana's official application platform (solana.com/ecosystem) provides project browsing, official application downloads and developer resources; 2. Its trading platform address is a designated link to facilitate user transactions; 3. Hardware storage devices such as Ledger can ensure private key security offline; 4. Desktop or mobile applications such as Phantom support convenient management; 5. Multi-signature technology improves authorization security; in addition, you can also participate in the digital asset ecosystem by participating in community governance, using decentralized applications, content creation, etc.
