PHP Classes

File: CSVToExcelConverter.php

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in Bookmark in
  Classes of Johnny  >  Convert CSV to Excel  >  CSVToExcelConverter.php  >  Download  
File: CSVToExcelConverter.php
Role: Class source
Content type: text/plain
Description: Main class file
Class: Convert CSV to Excel
Convert CSV files to Excel using PHPExcel library
Author: By
Last change: row index start from 1
Date: 2 years ago
Size: 1,486 bytes


Class file image Download
 * CSVToExcelConverter
class CSVToExcelConverter
     * Read given csv file and write all rows to given xls file
     * @param string $csv_file Resource path of the csv file
     * @param string $xls_file Resource path of the excel file
     * @param string $csv_enc Encoding of the csv file, use utf8 if null
     * @throws Exception
public static function convert($csv_file, $xls_file, $csv_enc=null) {
//set cache
$cacheMethod = PHPExcel_CachedObjectStorageFactory::cache_to_phpTemp;
//open csv file
$objReader = new PHPExcel_Reader_CSV();
        if (
$csv_enc != null)
$objPHPExcel = $objReader->load($csv_file);
$in_sheet = $objPHPExcel->getActiveSheet();

//open excel file
$objPHPExcel = new PHPExcel();
$out_sheet = $objPHPExcel->getActiveSheet();
//row index start from 1
$row_index = 0;
        foreach (
$in_sheet->getRowIterator() as $row) {
$cellIterator = $row->getCellIterator();
//column index start from 0
$column_index = -1;
            foreach (
$cellIterator as $cell) {
$out_sheet->setCellValueByColumnAndRow($column_index, $row_index, $cell->getValue());
//write excel file
$objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);