blocks|key|616198|text|这是一个细微的区别，但这对我来说很好：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|616199|$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(10);|code-block|syntax|javascript|616200|请注意，getColumnDimensionByColumn和getColumnDimension之间的区别|offset|length|style|CODE|616201|而且，我甚至没有设置AutoSize，它工作得很好。|616202|entityMap^0|0|0|4|Q|V|I|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|S|8|@$I|T|J|U|K|L]|$I|V|J|W|K|L]]|9|@]|A|$]]|$1|M|3|N|5|6|7|X|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|P|$]]

It's a subtle difference, but this works fine for me:

<pre><code>$objPHPExcel-&gt;getActiveSheet()-&gt;getColumnDimension('A')-&gt;setWidth(10);
</code></pre>

Notice, the difference between <code>getColumnDimensionByColumn</code> and <code>getColumnDimension</code>

Also, I'm not even setting AutoSize and it works fine.

blocks|key|831635|text|嗨，我也有同样的问题..将0.71添加到excel单元格宽度值，并将该值赋给|type|unstyled|depth|inlineStyleRanges|entityRanges|data|831636|$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(10);|code-block|syntax|javascript|831637|例如:a列宽=+3.71+(excel值)|831638|给定列宽=+4.42|831639|将使输出文件具有相同的单元格宽度。|831640|$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(4.42);|831641|希望这对你有所帮助|831642|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|V|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|W|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|Y|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

hi i got the same problem..
add 0.71 to excel cell width value and give that value to the 

<pre><code>$objPHPExcel-&gt;getActiveSheet()-&gt;getColumnDimension('A')-&gt;setWidth(10);
</code></pre>

eg: 
A Column width = 3.71 (excel value)

give column width = 4.42 

will give the output file with same cell width.

<pre><code>$objPHPExcel-&gt;getActiveSheet()-&gt;getColumnDimension('A')-&gt;setWidth(4.42);
</code></pre>

hope this help

blocks|key|616287|text|必须在setWidth之前使用setAutoSize方法：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|616288|$objPHPExcel->getActiveSheet()->getColumnDimensionByColumn('C')->setAutoSize(false);
$objPHPExcel->getActiveSheet()->getColumnDimensionByColumn('C')->setWidth('10');|code-block|syntax|javascript|616289|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|$]]

setAutoSize method must come before setWidth:

<pre><code>$objPHPExcel-&gt;getActiveSheet()-&gt;getColumnDimensionByColumn('C')-&gt;setAutoSize(false);
$objPHPExcel-&gt;getActiveSheet()-&gt;getColumnDimensionByColumn('C')-&gt;setWidth('10');
</code></pre>

blocks|key|831724|text|列宽度的autoSize设置为bellow。这对我很管用。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|831725|$spreadsheet->getActiveSheet()->getColumnDimension('A')->setAutoSize(true);|code-block|syntax|javascript|831726|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|$]]

autoSize for column width set as bellow. It works for me.

<pre><code>$spreadsheet-&gt;getActiveSheet()-&gt;getColumnDimension('A')-&gt;setAutoSize(true);
</code></pre>

blocks|key|831769|text|这种方式更容易自动调整列的大小。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|831770|foreach+(range('A',+'I')+as+$letra)+{++++++++++++
++++++++++++$spreadsheet->getActiveSheet()->getColumnDimension($letra)->setAutoSize(true);
}|code-block|syntax|javascript|831771|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|$]]

This way is much easier to adjust the size of the columns automatically.
<pre><code>foreach (range('A', 'I') as $letra) { 
 $spreadsheet-&gt;getActiveSheet()-&gt;getColumnDimension($letra)-&gt;setAutoSize(true);
}
</code></pre>

I'm trying to set the width of a cell in an Excel document generated with PHPExcel with:

<pre><code>$objPHPExcel-&gt;getActiveSheet()-&gt;getColumnDimensionByColumn('C')-&gt;setWidth('10');
$objPHPExcel-&gt;getActiveSheet()-&gt;getColumnDimensionByColumn('C')-&gt;setAutoSize(false);
</code></pre>

but that does not works.

What is the method that I need to call here?

Setting width of spreadsheet cell using PHPExcel

我尝试使用以下命令设置用PHPExcel生成的Excel文档中单元格的宽度：$objPHPExcel->getActiveSheet()->getColumnDimensionByColumn('C')->setWidth('10');$objPHPExcel->getActiveSheet()->getColumnD...

问使用PHPExcel设置电子表格单元的宽度
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问使用PHPExcel设置电子表格单元的宽度EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问使用PHPExcel设置电子表格单元的宽度
EN