How to convert csv to xls in php
How to convert csv to xls in php: 1. Use the "fgetcsv()" function to read the contents of the CSV file; 2. Traverse the results and store the data into a two-dimensional array; 3. Introduce the PHPExcel class library Used to create Excel files and instantiate the PHPExcel and PHPExcel_IOFactory classes accordingly; 4. Create a new workbook and set the title bar and other styles; 5. Loop through the two-dimensional array and write data to the worksheet row by row; 6. Output Excel That’s it.

Operating system for this tutorial: Windows 10 system, php8.1.3 version, Dell G3 computer.
To convert csv to xls in php, you can use the following steps:
Use the fgetcsv() function to read the contents of the CSV file
-
Traverse the results and store the data into a two-dimensional array
Introduce the PHPExcel class library to create Excel files, and instantiate the corresponding PHPExcel and PHPExcel_IOFactory classes
Create a new workbook and set the title bar and other styles
Loop through the two-dimensional array and write data to the worksheet row by row
Output to Excel.
The reference code is as follows:
<?php
// 加载 PHPExcel 类库和其他依赖类库。
require_once dirname(__FILE__) . '/PHPExcel.php';
require_once dirname(__FILE__) . '/PHPExcel/IOFactory.php';
/**
* CSV 转 XLS
*
* @param string $inputFilePath 输入文件路径
* @param string $outputFilePath 输出文件路径
*
* @return bool true 转换成功,否则转换失败
*/
function csvToXls($inputFilePath, $outputFilePath) {
// 读取 CSV 文件的内容,将每一行数据存储到一个二维数组中
$csv = array_map('str_getcsv', file($inputFilePath));
// 实例化一个空的 PHPExcel 对象
$objPHPExcel = new PHPExcel();
// 设置当前工作表的信息
$objPHPExcel->getProperties()
->setCreator('')
->setLastModifiedBy('')
->setTitle('CSV to XLS')
->setSubject('')
->setDescription('')
->setKeywords('')
->setCategory('');
// 选择当前工作表的第一个工作页
$objPHPExcel->setActiveSheetIndex(0);
// 设置列名,将第一行数据设置为标题栏
$colNames = array_shift($csv);
foreach ($colNames as $key => $value) {
$colLetter = PHPExcel_Cell::stringFromColumnIndex($key); // 根据列的 index 获取其对应的字母编号
$objPHPExcel->getActiveSheet()
->setCellValueExplicit($colLetter . '1', $valueThe above is the detailed content of How to convert csv to xls in 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
1793
16
1736
56
1587
29
267
587
Commenting Out Code in PHP
Jul 18, 2025 am 04:57 AM
There are three common methods for PHP comment code: 1. Use // or # to block one line of code, and it is recommended to use //; 2. Use /.../ to wrap code blocks with multiple lines, which cannot be nested but can be crossed; 3. Combination skills comments such as using /if(){}/ to control logic blocks, or to improve efficiency with editor shortcut keys, you should pay attention to closing symbols and avoid nesting when using them.
Tips for Writing PHP Comments
Jul 18, 2025 am 04:51 AM
The key to writing PHP comments is to clarify the purpose and specifications. Comments should explain "why" rather than "what was done", avoiding redundancy or too simplicity. 1. Use a unified format, such as docblock (/*/) for class and method descriptions to improve readability and tool compatibility; 2. Emphasize the reasons behind the logic, such as why JS jumps need to be output manually; 3. Add an overview description before complex code, describe the process in steps, and help understand the overall idea; 4. Use TODO and FIXME rationally to mark to-do items and problems to facilitate subsequent tracking and collaboration. Good annotations can reduce communication costs and improve code maintenance efficiency.
Quick PHP Installation Tutorial
Jul 18, 2025 am 04:52 AM
ToinstallPHPquickly,useXAMPPonWindowsorHomebrewonmacOS.1.OnWindows,downloadandinstallXAMPP,selectcomponents,startApache,andplacefilesinhtdocs.2.Alternatively,manuallyinstallPHPfromphp.netandsetupaserverlikeApache.3.OnmacOS,installHomebrew,thenrun'bre
Learning PHP: A Beginner's Guide
Jul 18, 2025 am 04:54 AM
TolearnPHPeffectively,startbysettingupalocalserverenvironmentusingtoolslikeXAMPPandacodeeditorlikeVSCode.1)InstallXAMPPforApache,MySQL,andPHP.2)Useacodeeditorforsyntaxsupport.3)TestyoursetupwithasimplePHPfile.Next,learnPHPbasicsincludingvariables,ech
Improving Readability with Comments
Jul 18, 2025 am 04:46 AM
The key to writing good comments is to explain "why" rather than just "what was done" to improve the readability of the code. 1. Comments should explain logical reasons, such as considerations behind value selection or processing; 2. Use paragraph annotations for complex logic to summarize the overall idea of functions or algorithms; 3. Regularly maintain comments to ensure consistency with the code, avoid misleading, and delete outdated content if necessary; 4. Synchronously check comments when reviewing the code, and record public logic through documents to reduce the burden of code comments.
Writing Effective PHP Comments
Jul 18, 2025 am 04:44 AM
Comments cannot be careless because they want to explain the reasons for the existence of the code rather than the functions, such as compatibility with old interfaces or third-party restrictions, otherwise people who read the code can only rely on guessing. The areas that must be commented include complex conditional judgments, special error handling logic, and temporary bypass restrictions. A more practical way to write comments is to select single-line comments or block comments based on the scene. Use document block comments to explain parameters and return values at the beginning of functions, classes, and files, and keep comments updated. For complex logic, you can add a line to the previous one to summarize the overall intention. At the same time, do not use comments to seal code, but use version control tools.
Mastering PHP Block Comments
Jul 18, 2025 am 04:35 AM
PHPblockcommentsareusefulforwritingmulti-lineexplanations,temporarilydisablingcode,andgeneratingdocumentation.Theyshouldnotbenestedorleftunclosed.BlockcommentshelpindocumentingfunctionswithPHPDoc,whichtoolslikePhpStormuseforauto-completionanderrorche
PHP Development Environment Setup
Jul 18, 2025 am 04:55 AM
The first step is to select the integrated environment package XAMPP or MAMP to build a local server; the second step is to select the appropriate PHP version according to the project needs and configure multiple version switching; the third step is to select VSCode or PhpStorm as the editor and debug with Xdebug; in addition, you need to install Composer, PHP_CodeSniffer, PHPUnit and other tools to assist in development.


