How to convert data to Excel file with PHP

PHP is a widely used programming language used to develop websites and applications. Microsoft Excel is a popular spreadsheet application used by many businesses to store and manage large amounts of data. Therefore, PHP conversion to xls is a common need to help businesses import Excel data into their websites and applications.

Generally speaking, PHP can access Excel files on the server side, while using some libraries and tools to convert xls files to other formats, such as CSV or XML. These formats can be easily imported into web applications or databases, providing businesses with a more convenient and reliable way to manage data.

In PHP, Excel files can be easily converted using the PHPExcel library. This library provides a set of classes and methods for reading, writing and converting Excel files. Below is a PHP code example that demonstrates how to use the PHPExcel library to convert xls to CSV format:

<?php require_once(&#39;PHPExcel/PHPExcel.php&#39;);

$input_file = &#39;sample.xls&#39;;
$output_file = &#39;sample.csv&#39;;

// Load Excel file
$objReader = PHPExcel_IOFactory::createReader(&#39;Excel5&#39;);
$objPHPExcel = $objReader->load($input_file);

// Load worksheet
$objWorksheet = $objPHPExcel->getActiveSheet();

// Open output file
$file = fopen($output_file, 'w');

// Write CSV file
foreach ($objWorksheet->getRowIterator() as $row) {
    $csv_data = array();
    foreach ($row->getCellIterator() as $cell) {
        $csv_data[] = $cell->getValue();
    }
    fputcsv($file, $csv_data);
}

// Close output file
fclose($file);
?>

The above code first loads the PHPExcel library, then uses the createReader() method to load the Excel file, and uses getActiveSheet() Method to get the worksheet object. Next, the code stores the Excel data in CSV format by looping through each row and cell, and writes it to the output file.

The above code only summarizes how to use the PHPExcel library to convert xls with PHP, but in fact PHPExcel also provides many other functions, such as encryption, filtering, charts and styles, etc. Additionally, other PHP libraries and tools, such as PhpSpreadsheet and Excel-Reader, can be used to achieve the same result.

In short, converting xls with PHP is a very useful technology for those businesses that need to use Excel data in web applications. Using PHPExcel and other PHP libraries and tools, you can easily convert xls files to other formats and import data into web applications and databases. This can lead to a more efficient, reliable and secure way for businesses to manage their data.

The above is the detailed content of How to convert data to Excel file with PHP. For more information, please follow other related articles on the PHP Chinese website!