excel to php maintaining format

Topics: User Forum
May 12, 2015 at 5:48 PM
Hi!
I am trying to implement PHPexcel to my project but I have minimum knowledge of PHP so this is a little bit hard for me.
I am trying to get excel content from two sheets (one named sheet 1 and the other sheet 2), convert it and include it in my php file by maintaining the format from excel.

My code for now looks like:
<?
require_once 'PHPExcel/IOFactory.php';

$excelFile = "mySheet.xlsx";

$objReader = PHPExcel_IOFactory::createReader('Excel2007');
$objPHPExcel = $objReader->load($excelFile);


var_dump($arrayData);
?>

How do I call the two sheets by ID by maintaining the format of the two sheets?
Any help would be greatly appreciated.
Thank you in advance.
Radu.