How to convert Excel XLS to CSV using PHP

by

This will surely work,

require_once 'Classes/PHPExcel/IOFactory.php';

$inputFileType="Excel5";
$inputFileName="YOUR_EXCEL_FILE_PATH";

$objReader = PHPExcel_IOFactory::createReader($inputFileType);
$objPHPExcelReader = $objReader->load($inputFileName);

$loadedSheetNames = $objPHPExcelReader->getSheetNames();

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcelReader, 'CSV');

foreach($loadedSheetNames as $sheetIndex => $loadedSheetName) {
    $objWriter->setSheetIndex($sheetIndex);
    $objWriter->save($loadedSheetName.'.csv');
}

Hope this helps…

More Related Contents:

  1. PHPExcel — Color part of XLSX table
  2. Split a comma-delimited string into an array?
  3. Export to CSV via PHP
  4. How to extract data from csv file in PHP
  5. How can I output a UTF-8 CSV in PHP that Excel will read properly?
  6. Create a CSV File for a user in PHP
  7. PHP code to convert a MySQL query to CSV [closed]
  8. How to parse a CSV file using PHP [duplicate]
  9. How to create an array from a CSV file using PHP and the fgetcsv function
  10. Importing CSV data using PHP/MySQL
  11. Convert array into csv
  12. Import CSV file directly into MySQL
  13. php implode (101) with quotes
  14. PHP Array to CSV
  15. CSV to Associative Array
  16. Why am I getting mime-type of .csv file as “application/octet-stream”?
  17. Download CSV file using “AJAX”
  18. Creating csv file with php
  19. Create a comma-separated string from a single column of an array of objects
  20. Remove trailing delimiting character from a delimited string
  21. How to use the CSV MIME-type?
  22. Group subarrays by one column, make comma-separated values from other column within groups
  23. Process CSV Into Array With Column Headings For Key
  24. how do i parse a csv file to grab the column names first then the rows that relate to it?
  25. Isolate comma-separated values, remove duplicates and empty values, then sort
  26. Reports in Codeigniter
  27. Write CSV To File Without Enclosures In PHP
  28. Process very big csv file without timeout and memory error
  29. Converting HTML Table to a CSV automatically using PHP?
  30. Force Download CSV File

Leave a Comment