/** * Initialize a new {@link PHPExcel} object based on the provided * {@link DataObjectInterface} interface. * @param DataObjectInterface $do * @return PHPExcel */ protected function setupExcel(DataObjectInterface $do) { // Try to get the current user $member = Member::currentUser(); $creator = $member ? $member->getName() : ''; // Get information about the current Model Class $singular = $do ? $do->i18n_singular_name() : ''; $plural = $do ? $do->i18n_plural_name() : ''; // Create the Spread sheet $excel = new PHPExcel(); $excel->getProperties()->setCreator($creator)->setTitle(_t('firebrandhq.EXCELEXPORT', '{singular} export', 'Title for the spread sheet export', array('singular' => $singular)))->setDescription(_t('firebrandhq.EXCELEXPORT', 'List of {plural} exported out of a SilverStripe website', 'Description for the spread sheet export', array('pluralr' => $plural))); // Give a name to the sheet if ($plural) { $excel->getActiveSheet()->setTitle($plural); } return $excel; }