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 solve the problem of 'Undefined array key 'sign'' error when calling Alipay EasySDK using PHP?
Mar 31, 2025 pm 11:51 PM
Problem Description When calling Alipay EasySDK using PHP, after filling in the parameters according to the official code, an error message was reported during operation: "Undefined...
Alipay PHP SDK transfer error: How to solve the problem of 'Cannot declare class SignData'?
Apr 01, 2025 am 07:21 AM
Alipay PHP...
The difference between H5 and mini-programs and APPs
Apr 06, 2025 am 10:42 AM
H5. The main difference between mini programs and APP is: technical architecture: H5 is based on web technology, and mini programs and APP are independent applications. Experience and functions: H5 is light and easy to use, with limited functions; mini programs are lightweight and have good interactiveness; APPs are powerful and have smooth experience. Compatibility: H5 is cross-platform compatible, applets and APPs are restricted by the platform. Development cost: H5 has low development cost, medium mini programs, and highest APP. Applicable scenarios: H5 is suitable for information display, applets are suitable for lightweight applications, and APPs are suitable for complex functions.
What are the development tools for H5 and mini program?
Apr 06, 2025 am 09:54 AM
H5 development tools recommendations: VSCode, WebStorm, Atom, Brackets, Sublime Text; Mini Program Development Tools: WeChat Developer Tools, Alipay Mini Program Developer Tools, Baidu Smart Mini Program IDE, Toutiao Mini Program Developer Tools, Taro.
How to choose H5 and applets
Apr 06, 2025 am 10:51 AM
The choice of H5 and applet depends on the requirements. For applications with cross-platform, rapid development and high scalability, choose H5; for applications with native experience, rich functions and platform dependencies, choose applets.
What are the different ways of promoting H5 and mini programs?
Apr 06, 2025 am 11:03 AM
There are differences in the promotion methods of H5 and mini programs: platform dependence: H5 depends on the browser, and mini programs rely on specific platforms (such as WeChat). User experience: The H5 experience is poor, and the mini program provides a smooth experience similar to native applications. Communication method: H5 is spread through links, and mini programs are shared or searched through the platform. H5 promotion methods: social sharing, email marketing, QR code, SEO, paid advertising. Mini program promotion methods: platform promotion, social sharing, offline promotion, ASO, cooperation with other platforms.
The latest news APP ranking recommendation in the currency circle (authoritative release in 2025)
Apr 21, 2025 pm 09:33 PM
The best cryptocurrency trading and analysis platforms include: 1. OKX: the world's number one in trading volume, supports multiple transactions, provides AI market analysis and on-chain data monitoring. 2. Binance: The world's largest exchange, providing in-depth market conditions and new currency first-time offerings. 3. Sesame Open Door: Known for spot trading and OTC channels, it provides automated trading strategies. 4. CoinMarketCap: an authoritative market data platform, covering 20,000 currencies. 5. CoinGecko: Known for community sentiment analysis, it provides DeFi and NFT trend monitoring. 6. Non-small account: a domestic market platform, providing analysis of linkage between A-shares and currency markets. 7. On-chain Finance: Focus on blockchain news and update in-depth reports every day. 8. Golden Finance: 24 small
What are the scam routines of cryptocurrency exchanges?
Apr 20, 2025 pm 05:06 PM
10 top scams on cryptocurrency exchanges Common scams: fake exchanges, Ponzi capital trading, contract manipulation, fake coin phishing, customer service fraud, etc. Identification points: Check regulatory licenses, check contract addresses, and be wary of high-yield commitments Must be protected: Use only mainstream exchanges (Binance/Coinbase) Enable hardware wallet Reject share private key/verification code Deal with fraud: take screenshots immediately, freeze assets, report on the platform, and report to the police Core principle: Any request for password/transfer is a fraud!
