blocks|key|189510|text|假设您的单元是A1+..|type|unstyled|depth|inlineStyleRanges|entityRanges|data|189511|$objPHPExcel->getActiveSheet()->getStyle('A1')
++++->getNumberFormat()->applyFromArray(+
++++++++array(+
++++++++++++'code'+=>+PHPExcel_Style_NumberFormat::FORMAT_PERCENTAGE_00
++++++++)
++++);|code-block|syntax|javascript|189512|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

assuming your cell is A1 ..

<pre><code>$objPHPExcel-&gt;getActiveSheet()-&gt;getStyle('A1')
 -&gt;getNumberFormat()-&gt;applyFromArray( 
 array( 
 'code' =&gt; PHPExcel_Style_NumberFormat::FORMAT_PERCENTAGE_00
 )
 );
</code></pre>

blocks|key|3021965|text|PHPExcel库只预定义了几个基本的格式化常量。实际上，您可以为几乎任何目的(着色、格式化小数和千等)构建自己的应用程序。Excel中的格式化功能非常强大。下面将使用3位小数格式化百分比，并将负值着色为红色：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3021966|$workSheet
++++->getStyleByColumnAndRow($column,+$row)
++++->getNumberFormat()
++++->setFormatCode('0.000%25;[Red]-0.000%25');|code-block|syntax|javascript|3021967|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

PHPExcel library has predefined only few basic formatting constants. You can actually build your own for virtually any purpose (coloring, formatting decimals &amp; thousands etc). Formatting capabilities in Excel are huge. Following will format percent with 3 decimal places and coloring negative values to red:

<pre><code>$workSheet
 -&gt;getStyleByColumnAndRow($column, $row)
 -&gt;getNumberFormat()
 -&gt;setFormatCode('0.000%;[Red]-0.000%');
</code></pre>

blocks|key|189042|text|你可以试试这段代码：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|189043|$colLetter+=+"A";
$rowNumber+=+"1";

$objPHPExcel->getActiveSheet()
++++->getStyle("$colLetter:$rowNumber")
++++->getNumberFormat()
++++->applyFromArray([
++++++++"code"+=>+PHPExcel_Style_NumberFormat::FORMAT_PERCENTAGE
++++]);|code-block|syntax|javascript|189044|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

You can try this code:

<pre><code>$colLetter = "A";
$rowNumber = "1";

$objPHPExcel-&gt;getActiveSheet()
 -&gt;getStyle("$colLetter:$rowNumber")
 -&gt;getNumberFormat()
 -&gt;applyFromArray([
 "code" =&gt; PHPExcel_Style_NumberFormat::FORMAT_PERCENTAGE
 ]);
</code></pre>

blocks|key|3021988|text|以防在PHPExcel转向PHPSpreadsheet之后，其他人看到了这个。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3021989|PHPSpreadsheet具有应用格式代码的专用功能。因此，要将数字设置为百分比，现在我们需要将applyFromArray()替换为setFormatCode()，如下所示：|offset|length|style|CODE|3021990|$spreadsheet
+++->getActiveSheet()
+++->getStyle("A1")
+++->getNumberFormat()
+++->setFormatCode(\PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_PERCENTAGE_00);|code-block|syntax|javascript|3021991|注意：：setFormatCode()似乎不支持应用于整个列/行。因此，如果是您的情况，您将需要在列/行上创建一个循环，以分别应用于每个单元格。|BOLD|3021992|entityMap^0|0|1D|G|1W|F|0|0|0|3|4|F|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@$D|T|E|U|F|G]|$D|V|E|W|F|G]]|9|@]|A|$]]|$1|H|3|I|5|J|7|X|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|Y|8|@$D|Z|E|10|F|O]|$D|11|E|12|F|G]]|9|@]|A|$]]|$1|P|3|-4|5|6|7|13|8|@]|9|@]|A|$]]]|Q|$]]

Just in case someone else is seeing this after PHPExcel turns to PHPSpreadsheet.
PHPSpreadsheet have a dedicated function to apply format codes. So, to set a number as percentage now we need to replace <code>applyFromArray()</code> to <code>setFormatCode()</code> as follow:
<pre class="lang-php prettyprint-override"><code>$spreadsheet
 -&gt;getActiveSheet()
 -&gt;getStyle(&quot;A1&quot;)
 -&gt;getNumberFormat()
 -&gt;setFormatCode(\PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_PERCENTAGE_00);
</code></pre>
Note: <code>setFormatCode()</code> seems to not support to apply to a entire column/row. So, if it is your case, you will need to create a loop over column/row to apply for each cell individually.

I am automating an excel spreadsheet using PHP.

I have been looking for a way to pragmatically format a cell to a percentage in PHPExcel.

I want to change a value like 

<blockquote>
 0.077922078
</blockquote>

to 

<blockquote>
 8%
</blockquote>

Is there a solution for this?

Thanks in advance.

Formatting a cell to a percentage in PHPExcel

我是自动化的excel电子表格使用PHP。我一直在寻找一种实用的方法将单元格格式化为PHPExcel中的百分比。我想要更改一个值，比如 0.077922078至 8%对此有解决方案吗？提前谢谢。

问将单元格格式设置为PHPExcel中的百分比
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问将单元格格式设置为PHPExcel中的百分比EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问将单元格格式设置为PHPExcel中的百分比
EN