English 中文(简体)
为什么在使用肥胖症-PHPEXCEL-save之后,由Excel制定的现行有条件格式规则就失去了意义?
原标题:why My Existing Conditional Formatting Rules set by Excel are Lost after using objWriter->PHPEXCEL-save?
  • 时间:2012-04-24 21:27:41
  •  标签:
  • php
  • phpexcel

我的问题是,一夫一妻中已经存在有条件格式规则的Excel案,一读,用下面的句子予以撤销:

$objReader = new PHPExcel_Reader_Excel2007();

$objReader->setReadDataOnly(false);
$objPHPExcel = $objReader->load( ../files/Reportes.xlsx );

//i set a value

$objPHPExcel->getActiveSheet()->SetCellValue( F6 , 10);

$objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);

$objWriter->save( ../files/Reportes.xlsx );

the output file is my Reportes.xlsx file without any Conditional Formating rules :S

i read in a post(a 2010 post) that this is a bug, im using the 1.7.6 of PHPEXCEL

plz帮助我, 成就

问题回答

可能的话题是<代码>PHPExcel_Writer。 如果你节省了一份文件,那么不会得到任何支持。





相关问题
Brute-force/DoS prevention in PHP [closed]

I am trying to write a script to prevent brute-force login attempts in a website I m building. The logic goes something like this: User sends login information. Check if username and password is ...

please can anyone check this while loop and if condition

<?php $con=mysql_connect("localhost","mts","mts"); if(!con) { die( unable to connect . mysql_error()); } mysql_select_db("mts",$con); /* date_default_timezone_set ("Asia/Calcutta"); $date = ...

定值美元

如何确认来自正确来源的数字。

Generating a drop down list of timezones with PHP

Most sites need some way to show the dates on the site in the users preferred timezone. Below are two lists that I found and then one method using the built in PHP DateTime class in PHP 5. I need ...

Text as watermarking in PHP

I want to create text as a watermark for an image. the water mark should have the following properties front: Impact color: white opacity: 31% Font style: regular, bold Bevel and Emboss size: 30 ...

How does php cast boolean variables?

How does php cast boolean variables? I was trying to save a boolean value to an array: $result["Users"]["is_login"] = true; but when I use debug the is_login value is blank. and when I do ...

热门标签