Convert php csv to excel format file format

With the generation and transmission of large amounts of data in various industries, files in CSV format have great advantages in data storage and processing. However, CSV file is not a user-friendly format as it is just a simple text file format and does not provide the functionality of complex operations such as running functions. Therefore, converting CSV files to Excel format files will be more convenient for data use.

In PHP, we can use the PHPExcel library to convert CSV files to Excel format files. PHPExcel is an open source library specifically used for PHP development. It supports many Excel functions, such as table merging, font styles, chart generation, etc. The following will introduce how to use the PHPExcel library to convert CSV files to Excel file format.

Install PHPExcel library

Before using the PHPExcel library, you need to install the library file first. You can use composer to install it, or download the source code from the official website.

Use composer to install:

composer require phpoffice/phpexcel

Install the source code:

1. Download the source code package from the PHPExcel official website.
2. Extract the downloaded file into the directory of the PHP server.
3. Introduce code files into the PHP program.

Convert CSV file to Excel format file

The following code example can convert CSV file to Excel format file. The Reader and Writer objects in PHPExcel are used here.

<?php
    require_once 'PHPExcel/Classes/PHPExcel.php';
     
    // 创建PHPExcel实例
    $objPHPExcel = new PHPExcel();
     
    // 读取CSV数据
    $csvReader = PHPExcel_IOFactory::createReader('CSV');
    $csvReader->setDelimiter(',');
    $csvReader->setEnclosure('"');
    $csvReader->setLineEnding("
");
    $csvReader->setSheetIndex(0);
    $csvFilePath = 'data.csv';
    $objPHPExcel = $csvReader->load($csvFilePath);
     
    // 保存为Excel格式
    $excelWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
    $excelWriter->save('data.xlsx');
?>

In the above sample code, first create a PHPExcel instance. Then, create a CSV reader object using the createReader method of PHPExcel_IOFactory. Before reading the data, you can set the delimiter using setDelimiter, set the quotes using setEnclosure, and set the line terminator using setLineEnding. Finally, use the load method to load the CSV file into the PHPExcel instance.

Finally, use the createWriter method of PHPExcel_IOFactory to create an Excel writer object, and use the save method to save the PHPExcel instance in Excel format. When saving an Excel file, you can specify the Excel file format.

Summary

This article introduces how to use the PHPExcel library to convert CSV files to Excel format files. Use the PHPExcel library to easily process Excel files, such as table merging, font styles, etc. Use the PHPExcel library to convert CSV files into Excel format files, and you can easily process the data in the CSV files to make them suitable for calculation and analysis.

The above is the detailed content of Convert php csv to excel format file format. For more information, please follow other related articles on the PHP Chinese website!