我有大型轴心,有公式和图表。 我想在此增加一些价值观,如:
<?php
require_once dirname(__FILE__) . /Classes/PHPExcel.php ;
set_time_limit(60 * 5);
ini_set("memory_limit","1000M");
$pathWeek = "Z:homephpexcel.ruwwwweekstat.xls";
$phpReader = new PHPExcel_Reader_Excel5();
$weekReader = $phpReader->load($pathWeek);
$weekReader->getSheetByName("2G")->setCellValue("C4", 1);
$weekReader->getSheetByName("2G")->setCellValue("Z4", 1);
$objWriter = PHPExcel_IOFactory::createWriter($weekReader, Excel5 );
$objWriter->save($pathWeek);
?>
还有一个错误:
Fatal error: Uncaught exception Exception with message данные для обобщенных пок!C4 -> 2G KKmrc%;AAmrc%!C4 -> 2G KKmrc%;AAmrc%!C4 -> Cyclic Reference in Formula in Z:homephpexcel.ruwwwClassesPHPExcelCell.php on line 288
工作 姓名——“2G KKmrc%;Amrc%”在单元4中,我有以下公式:
=IF($2G.$B4="";"";$2G.C4/$2G.$Z4*100)
In°РЅРЅС‹Р微克 » μ微克 ...... РїРѕРє!
INDEX($ 2G KKmrc%;AAmrc% .C1:C27;MATCH("";$ 2G KKmrc%;AAmrc% .C1:C250;0)-1;1)
任何想法? Maybe i dont