i want to export xlsx file using PHP excel class. but for a particular row should be text value thats why using PHPExcel_Cell_DefaultValueBinder . It is working in localhost but in server not working
Code:
require_once dirname(__FILE__) . '/Classes/PHPExcel.php';
$objPHPExcel = new PHPExcel();
class PHPExcel_Cell_MyColumnValueBinder extends PHPExcel_Cell_DefaultValueBinder implements PHPExcel_Cell_IValueBinder
{
protected $stringColumns = [];
public function __construct(array $stringColumnList = []) {
// Accept a list of columns that will always be set as strings
$this->stringColumns = $stringColumnList;
}
public function bindValue(PHPExcel_Cell $cell, $value = null)
{
// If the cell is one of our columns to set as a string...
if (in_array($cell->getColumn(), $this->stringColumns)) {
// ... then we cast it to a string and explicitly set it as a string
$cell->setValueExplicit((string) $value, PHPExcel_Cell_DataType::TYPE_STRING);
return true;
}
// Otherwise, use the default behaviour
return parent::bindValue($cell, $value);
}
}
PHPExcel_Cell::setValueBinder(new PHPExcel_Cell_MyColumnValueBinder(['G']));
what's wrong in my coding.