symfony-bundle excel-bundle

os/excel-bundle

OS Excel Bundle for Symfony2

Integrate OSExcelBundle in your project

Add this line to the require option in your composer.json file:, _(*1)

 "os/excel-bundle": "dev-master"

Execute this command line, _(*2)

 php composer.phar update os/excel-bundle

In your app/AppKernel.php, _(*3)

 new OS\ExcelBundle\OSExcelBundle

USING:

Call service, _(*4)

 $excel = $this->get('os.excel');

Open file, _(*5)

 $excel->loadFile([FILE_PATHNAME]);

Select sheet, _(*6)

 $excel->setActiveSheet([INDEX_OF_SHEET]);

Get count of sheet, _(*7)

 $excel->getSheetCount();

Get sheet names, _(*8)

 $excel->getSheetNames();

Get count of rows of selected sheet, _(*9)

 $excel->getRowCount();

Get Count of columns of selected sheet, _(*10)

 $excel->getColumnCount();

Get index of last column, _(*11)

 $excel->getHighestColumn();

Get row data, _(*12)

 $excel->getRowData([INDEX_OF_ROW]);

Get cell data, _(*13)

 $excel->getCellData([INDEX_OF_ROW], [INDEX_OF_COLUMN]);

GET sheet data as php array, _(*14)

 $excel->getSheetData();

Enjoy!, _(*15)