Backend Development
PHP Tutorial
How to export Excel files and set column width using PHPExcel library?
How to export Excel files and set column width using PHPExcel library?
Apr 01, 2025 am 10:54 AM
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!
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
How to trade stablecoins_A full flow diagram for beginners buying and selling
Jul 18, 2025 am 06:00 AM
The stablecoin trading process includes the steps of registering an exchange, completing certification, buying or selling. First, choose a trusted exchange such as Binance, OKX, etc., and then complete KYC identity authentication, and then buy stablecoins through fiat currency recharge or OTC transactions. You can also transfer the stablecoins to the fund account and sell them through P2P transactions and withdraw them to the bank card or Alipay. When operating, you need to pay attention to choosing a regulated platform, confirm transaction security and handling fees.
How to download the official Bitcoin app? Bitcoin App Use Guide
Jul 22, 2025 pm 11:54 PM
Bitcoin does not have an official app, and users mainly trade and manage them through third-party exchanges or account apps. 1. Binance has comprehensive functions and is suitable for all kinds of traders; 2. OKX provides integrated trading and Web3 accounts; 3. Huobi (HTX) is stable and reliable in the Asian market; 4. Gate.io is known for its rich currency; 5. KuCoin has diverse currencies and active communities; 6. Bybit is known for its derivatives trading. When downloading, you should visit the official website, scan the QR code, complete the installation according to the system, and set up security measures such as two-factor verification to ensure the security of the account.
Answers to Ant New Village on July 17, 2025
Jul 17, 2025 am 06:10 AM
Maybe there are many children's shoes who want to know the answers to Ant New Village on July 17, 2025. Let's bring you answers in this regard. Come and have a look.
Ant New Village Small Classroom Today's Answer July 17th Is the cotton paper used in the ancient books of intangible cultural heritage made of cotton?
Jul 17, 2025 am 06:10 AM
Maybe there are many children's shoes that don't know the answers of Ant New Village Classroom today July 17th. Is the cotton paper used in the ancient books of intangible cultural heritage made of cotton? Let the editor answer this question below. Let's take a look with me!
How to build a content payment platform through PHP How to implement PHP paid reading system
Jul 25, 2025 pm 06:30 PM
To build a PHP content payment platform, it is necessary to build a user management, content management, payment and permission control system. First, establish a user authentication system and use JWT to achieve lightweight authentication; second, design the backend management interface and database fields to manage paid content; third, integrate Alipay or WeChat payment and ensure process security; fourth, control user access rights through session or cookies. Choosing the Laravel framework can improve development efficiency, use watermarks and user management to prevent content theft, optimize performance requires coordinated improvement of code, database, cache and server configuration, and clear policies must be formulated and malicious behaviors must be prevented.
Where is the most convenient transaction for USDT? Full guide to buying and selling USDT (with handling fees and transaction skills instructions)
Jul 22, 2025 pm 07:45 PM
Selecting a platform requires consideration of security, fees, liquidity, experience and support. Priority is given to platforms with good reputation, low fees and strong liquidity, such as Binance, OKEx, etc.; 2. When purchasing USDT, you can go through three ways: C2C (no handling fee but with price difference), credit card (fast but expensive), and currency trading (low cost suitable for currency holders); 3. Selling USDT can take three ways: C2C (direct exchange for fiat currency, pay attention to checking buyer information), fiat currency withdrawal (KYC required), and exchange for other currencies; 4. Transaction fees include order/eating fee (cheap order), withdrawal fee (TRC-20 chain is the most cost-effective), and C2C premiums need to be paid attention to; 5. Trading skills are to first test small amounts, choose the right chain (such as TRC-20), set 2FA to ensure safety, complete KYC increase limit,
How to use PHP to build a payment system to monetize PHP payment interface docking process
Jul 25, 2025 pm 06:24 PM
Choose a payment platform based on user portrait. WeChat Pay is suitable for users in the WeChat ecosystem, and Alipay is suitable for mature consumer groups and PC-side large-scale payments; 2. Registering a merchant account to obtain AppID, MCHID, API keys and other qualifications is the prerequisite; 3. Using the official PHPSDK integrated interface can simplify development and improve security; 4. The PHP backend generates orders and initiates prepayment requests, and the front end calls for payment based on the returned data; 5. Asynchronous callbacks are the final basis for successful payment, and signatures, IP whitelists, SSL encryption transmission must be verified and idempotence must be realized to prevent repeated processing; 6. Timeout orders are closed through timed tasks, refunds must be called to the API and handled multiple states, reconciliation needs to be regularly compared with the platform flow and system orders to ensure the consistency of funds, and the entire flow
Ant New Village today's answer 7.17
Jul 17, 2025 am 06:10 AM
I believe some children's shoes want to know about Ant New Village's answer today. The editor below will bring you the answer. Let's take a look with me!
