os/excel-bundle

OS Excel Bundle for Symfony2

Installs: 3 462

Dependents: 0

Stars: 6

Watchers: 2

Forks: 10

Open Issues: 1

Language: PHP

2.1 2013-04-03 22:25 UTC

README

Add this line to the require option in your composer.json file:

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

Execute this command line

 php composer.phar update os/excel-bundle

In your app/AppKernel.php

 new OS\ExcelBundle\OSExcelBundle

USING:

Call service

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

Open file

 $excel->loadFile([FILE_PATHNAME]);

Select sheet

 $excel->setActiveSheet([INDEX_OF_SHEET]);

Get count of sheet

 $excel->getSheetCount();

Get sheet names

 $excel->getSheetNames();

Get count of rows of selected sheet

 $excel->getRowCount();

Get Count of columns of selected sheet

 $excel->getColumnCount();

Get index of last column

 $excel->getHighestColumn();

Get row data

 $excel->getRowData([INDEX_OF_ROW]);

Get cell data

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

GET sheet data as php array

 $excel->getSheetData();

Enjoy!