PHPOffice / PHPExcel

ARCHIVED
Other
11.46k stars 4.2k forks source link

editing (.xlsm) macro enable files and save .xlsm #1255

Open urfusion opened 7 years ago

urfusion commented 7 years ago
error_reporting(E_ALL);
ini_set('display_errors', TRUE);
ini_set('display_startup_errors', TRUE);

if (PHP_SAPI == 'cli')
    die('This example should only be run from a Web Browser');

/** Include PHPExcel */
require_once 'Classes/PHPExcel.php';
require_once 'Classes/PHPExcel/IOFactory.php';

$objReader = PHPExcel_IOFactory::createReader('Excel2007');
$objPHPExcelR = $objReader->load("20170407Simpledevelopmentv0.2.xlsm");

$objPHPExcelR->setActiveSheetIndex(11);
$worksheet = $objPHPExcelR->getActiveSheet();

$worksheet->setCellValue('E28',22000);
//echo "kapil". $worksheet->getCellByColumnAndRow('4','28')->getValue(); die;
$objPHPExcel = new PHPExcel();

$objPHPExcel = $objPHPExcelR;

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
//$objWriter->setPreCalculateFormulas(true);
$objWriter->save('result.xlsx');

exit;

Getting error

` Fatal error: Uncaught exception 'PHPExcel_Exception' with message 'Invalid cell coordinate 'I|Gen'' in D:\xampp\htdocs\work\PHPExcel-1.8\Classes\PHPExcel\Cell.php:594 Stack trace: #0 D:\xampp\htdocs\work\PHPExcel-1.8\Classes\PHPExcel\Cell.php(651): PHPExcel_Cell::coordinateFromString(''I|Gen'') #1 D:\xampp\htdocs\work\PHPExcel-1.8\Classes\PHPExcel\Cell.php(624): PHPExcel_Cell::absoluteCoordinate(''I|Gen'') #2 D:\xampp\htdocs\work\PHPExcel-1.8\Classes\PHPExcel\Writer\Excel2007\Workbook.php(323): PHPExcel_Cell::absoluteReference(''I|Gen'') #3 D:\xampp\htdocs\work\PHPExcel-1.8\Classes\PHPExcel\Writer\Excel2007\Workbook.php(300): PHPExcel_Writer_Excel2007_Workbook->writeDefinedNameForNamedRange(Object(PHPExcel_Shared_XMLWriter), Object(PHPExcel_NamedRange)) #4 D:\xampp\htdocs\work\PHPExcel-1.8\Classes\PHPExcel\Writer\Excel2007\Workbook.php(269): PHPExcel_Writer_Excel2007_Workbook->writeNamedRanges(Object(PHPExcel_Shared_XMLWriter), Object(PHPExcel)) #5 D:\xampp\htdocs\work\PHPExcel-1.8\Classes\PHPExcel\Writer\Excel2007\Workbo in D:\xampp\htdocs\work\PHPExcel-1.8\Classes\PHPExcel\Cell.php on line 594`