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:

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 to create Excel files, and instantiate the corresponding PHPExcel and PHPExcel_IOFactory classes

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 to Excel.

The reference code is as follows:

<?php
// 加载 PHPExcel 类库和其他依赖类库。
require_once dirname(__FILE__) . &#39;/PHPExcel.php&#39;;
require_once dirname(__FILE__) . &#39;/PHPExcel/IOFactory.php&#39;;
/**
 * CSV 转 XLS
 *
 * @param string $inputFilePath 输入文件路径
 * @param string $outputFilePath 输出文件路径
 *
 * @return bool true 转换成功，否则转换失败
 */
function csvToXls($inputFilePath, $outputFilePath) {
    // 读取 CSV 文件的内容，将每一行数据存储到一个二维数组中
    $csv = array_map(&#39;str_getcsv&#39;, file($inputFilePath));
    // 实例化一个空的 PHPExcel 对象
    $objPHPExcel = new PHPExcel();
    // 设置当前工作表的信息
    $objPHPExcel->getProperties()
        ->setCreator(&#39;&#39;)
        ->setLastModifiedBy(&#39;&#39;)
        ->setTitle(&#39;CSV to XLS&#39;)
        ->setSubject(&#39;&#39;)
        ->setDescription(&#39;&#39;)
        ->setKeywords(&#39;&#39;)
        ->setCategory(&#39;&#39;);
    // 选择当前工作表的第一个工作页
    $objPHPExcel->setActiveSheetIndex(0);
    // 设置列名，将第一行数据设置为标题栏
    $colNames = array_shift($csv);
    foreach ($colNames as $key => $value) {
        $colLetter = PHPExcel_Cell::stringFromColumnIndex($key); // 根据列的 index 获取其对应的字母编号
        $objPHPExcel->getActiveSheet()
            ->setCellValueExplicit($colLetter . &#39;1&#39;, $value

The 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!