Welcome Guest, Not a member yet? Register   Sign In
PHPExcel_Cell_DefaultValueBinder not working in server
#1

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.
Reply




Theme © iAndrew 2016 - Forum software by © MyBB