blocks|key|190100|text|如果将列设置为AutoSize，PHPExcel将尝试根据该列的计算值(任何公式的结果也是如此)以及由格式掩码添加的任何附加字符(如千位分隔符)来计算列宽。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|190101|默认情况下，这是一个estimated宽度:基于使用GD，可以使用一种更精确的计算方法，它也可以处理粗体和斜体等字体样式功能；但这是一个更大的开销，因此默认情况下它是关闭的。您可以使用以下命令启用更精确的计算|offset|length|style|CODE|190102|PHPExcel_Shared_Font::setAutoSizeMethod(PHPExcel_Shared_Font::AUTOSIZE_METHOD_EXACT);|code-block|syntax|javascript|190103|但是，自动调整大小并不适用于所有Writer格式...例如CSV。你没有提到你使用的是哪个作者。|190104|但您还需要确定用于设置维度的列：|190105|foreach(range('B','G')+as+$columnID)+{
++++$objPHPExcel->getActiveSheet()->getColumnDimension($columnID)
++++++++->setAutoSize(true);
}|190106|$objPHPExcel->getActiveSheet()->getColumnDimension()需要列ID。|190107|$objPHPExcel->getActiveSheet()->getColumnDimensions()将返回一个包含所有已定义列维记录的数组；但是，除非显式地创建了列维记录(可能是通过加载模板或手动调用getColumnDimension())，否则它将不会存在(节省内存)。|190108|entityMap^0|0|A|9|0|0|0|0|0|0|1G|0|0|1H|2V|K|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Z|8|@$D|10|E|11|F|G]]|9|@]|A|$]]|$1|H|3|I|5|J|7|12|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|13|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|14|8|@]|9|@]|A|$]]|$1|Q|3|R|5|J|7|15|8|@]|9|@]|A|$K|L]]|$1|S|3|T|5|6|7|16|8|@$D|17|E|18|F|G]]|9|@]|A|$]]|$1|U|3|V|5|6|7|19|8|@$D|1A|E|1B|F|G]|$D|1C|E|1D|F|G]]|9|@]|A|$]]|$1|W|3|-4|5|6|7|1E|8|@]|9|@]|A|$]]]|X|$]]

If a column is set to AutoSize, PHPExcel attempts to calculate the column width based on the calculated value of the column (so on the result of any formulae), and any additional characters added by format masks such as thousand separators. 

By default, this is an <code>estimated</code> width: a more accurate calculation method is available, based on using GD, which can also handle font style features such as bold and italic; but this is a much bigger overhead, so it is turned off by default. You can enable the more accurate calculation using

<pre><code>PHPExcel_Shared_Font::setAutoSizeMethod(PHPExcel_Shared_Font::AUTOSIZE_METHOD_EXACT);
</code></pre>

However, autosize doesn't apply to all Writer formats... for example CSV. You don't mention what writer you're using.

But you also need to identify the columns to set dimensions:

<pre><code>foreach(range('B','G') as $columnID) {
 $objPHPExcel-&gt;getActiveSheet()-&gt;getColumnDimension($columnID)
 -&gt;setAutoSize(true);
}
</code></pre>

<code>$objPHPExcel-&gt;getActiveSheet()-&gt;getColumnDimension()</code> expects a column ID.

<code>$objPHPExcel-&gt;getActiveSheet()-&gt;getColumnDimensions()</code> will return an array of all the defined column dimension records; but unless a column dimension record has been explicitly created (perhaps by loading a template, or by manually calling <code>getColumnDimension()</code>) then it won't exist (memory saving).

blocks|key|3018571|text|这里是一个基于@Mark+Baker帖子的更灵活的变体：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3018572|foreach+(range('A',+$phpExcelObject->getActiveSheet()->getHighestDataColumn())+as+$col)+{
++++++++$phpExcelObject->getActiveSheet()
++++++++++++++++->getColumnDimension($col)
++++++++++++++++->setAutoSize(true);
++++}+|code-block|syntax|javascript|3018573|希望这能有所帮助;)|3018574|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Here a more flexible variant based on @Mark Baker post:

<pre><code>foreach (range('A', $phpExcelObject-&gt;getActiveSheet()-&gt;getHighestDataColumn()) as $col) {
 $phpExcelObject-&gt;getActiveSheet()
 -&gt;getColumnDimension($col)
 -&gt;setAutoSize(true);
 } 
</code></pre>

Hope this helps ;)

blocks|key|190110|text|以下是如何使用工作表中的所有列的示例：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|190111|$sheet+=+$PHPExcel->getActiveSheet();
$cellIterator+=+$sheet->getRowIterator()->current()->getCellIterator();
$cellIterator->setIterateOnlyExistingCells(+true+);
/**+@var+PHPExcel_Cell+$cell+*/
foreach(+$cellIterator+as+$cell+)+{
++++++++$sheet->getColumnDimension(+$cell->getColumn()+)->setAutoSize(+true+);
}|code-block|syntax|javascript|190112|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 is example how to use all columns from worksheet:

<pre><code>$sheet = $PHPExcel-&gt;getActiveSheet();
$cellIterator = $sheet-&gt;getRowIterator()-&gt;current()-&gt;getCellIterator();
$cellIterator-&gt;setIterateOnlyExistingCells( true );
/** @var PHPExcel_Cell $cell */
foreach( $cellIterator as $cell ) {
 $sheet-&gt;getColumnDimension( $cell-&gt;getColumn() )-&gt;setAutoSize( true );
}
</code></pre>

blocks|key|190114|text|如果您需要在多个工作表上执行此操作，并且每个工作表中有多个列，下面是您可以遍历所有这些表的方法：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|190115|//+Auto+size+columns+for+each+worksheet
foreach+($objPHPExcel->getWorksheetIterator()+as+$worksheet)+{

++++$objPHPExcel->setActiveSheetIndex($objPHPExcel->getIndex($worksheet));

++++$sheet+=+$objPHPExcel->getActiveSheet();
++++$cellIterator+=+$sheet->getRowIterator()->current()->getCellIterator();
++++$cellIterator->setIterateOnlyExistingCells(true);
++++/**+@var+PHPExcel_Cell+$cell+*/
++++foreach+($cellIterator+as+$cell)+{
++++++++$sheet->getColumnDimension($cell->getColumn())->setAutoSize(true);
++++}
}|code-block|syntax|javascript|190116|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|$]]

If you need to do that on multiple sheets, and multiple columns in each sheet, here is how you can iterate through all of them:

<pre><code>// Auto size columns for each worksheet
foreach ($objPHPExcel-&gt;getWorksheetIterator() as $worksheet) {

 $objPHPExcel-&gt;setActiveSheetIndex($objPHPExcel-&gt;getIndex($worksheet));

 $sheet = $objPHPExcel-&gt;getActiveSheet();
 $cellIterator = $sheet-&gt;getRowIterator()-&gt;current()-&gt;getCellIterator();
 $cellIterator-&gt;setIterateOnlyExistingCells(true);
 /** @var PHPExcel_Cell $cell */
 foreach ($cellIterator as $cell) {
 $sheet-&gt;getColumnDimension($cell-&gt;getColumn())-&gt;setAutoSize(true);
 }
}
</code></pre>

blocks|key|187880|text|foreach(range('B','G')+as+$columnID)
{
++++$objPHPExcel->getActiveSheet()->getColumnDimension($columnID)->setAutoSize(true);
}|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|187881|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>foreach(range('B','G') as $columnID)
{
 $objPHPExcel-&gt;getActiveSheet()-&gt;getColumnDimension($columnID)-&gt;setAutoSize(true);
}
</code></pre>

blocks|key|2806314|text|来晚了，但在到处寻找之后，我创建了一个似乎就是“唯一”的解决方案。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2806315|知道在最新的API版本中有一个列迭代器，但不知道如何调整列对象本身，基本上我已经创建了一个循环来从真正的第一次使用的列转到真正的最后使用的列。|2806316|它是这样的：|2806317|//Just+before+saving+de+Excel+document,+you+do+this:

PHPExcel_Shared_Font::setAutoSizeMethod(PHPExcel_Shared_Font::AUTOSIZE_METHOD_EXACT);

//We+get+the+util+used+space+on+worksheet.+Change+getActiveSheet+to+setActiveSheetIndex(0)+to+choose+the+sheet+you+want+to+autosize.+Iterate+thorugh'em+if+needed.
//We+remove+all+digits+from+this+string,+which+cames+in+a+form+of+"A1:G24".
//Exploding+via+":"+to+get+a+2+position+array+being+0+fisrt+used+column+and+1,+the+last+used+column.
$cols+=+explode(":",+trim(preg_replace('/\d%2B/u',+'',+$objPHPExcel->getActiveSheet()->calculateWorksheetDimension())));

$col+=+$cols[0];+//first+util+column+with+data
$end+=+%2B%2B$cols[1];+//last+util+column+with+data+%2B1,+to+use+it+inside+the+WHILE+loop.+Else,+is+not+going+to+use+last+util+range+column.
while($col+!=+$end){
++++$objPHPExcel->getActiveSheet()->getColumnDimension($col)->setAutoSize(true);

++++$col%2B%2B;
}

//Saving.
$objWriter->save('php://output');|code-block|syntax|javascript|2806318|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|O|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|P|8|@]|9|@]|A|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Come late, but after searching everywhere, I've created a solution that seems to be "the one".

Being known that there is a column iterator on last API versions, but not knowing how to atuoadjust the column object it self, basically I've created a loop to go from real first used column to real last used one.

Here it goes:

<pre><code>//Just before saving de Excel document, you do this:

PHPExcel_Shared_Font::setAutoSizeMethod(PHPExcel_Shared_Font::AUTOSIZE_METHOD_EXACT);

//We get the util used space on worksheet. Change getActiveSheet to setActiveSheetIndex(0) to choose the sheet you want to autosize. Iterate thorugh'em if needed.
//We remove all digits from this string, which cames in a form of "A1:G24".
//Exploding via ":" to get a 2 position array being 0 fisrt used column and 1, the last used column.
$cols = explode(":", trim(preg_replace('/\d+/u', '', $objPHPExcel-&gt;getActiveSheet()-&gt;calculateWorksheetDimension())));

$col = $cols[0]; //first util column with data
$end = ++$cols[1]; //last util column with data +1, to use it inside the WHILE loop. Else, is not going to use last util range column.
while($col != $end){
 $objPHPExcel-&gt;getActiveSheet()-&gt;getColumnDimension($col)-&gt;setAutoSize(true);

 $col++;
}

//Saving.
$objWriter-&gt;save('php://output');
</code></pre>

blocks|key|187374|text|for+($i+=+'A';+$i+!=++$objPHPExcel->getActiveSheet()->getHighestColumn();+$i%2B%2B)+{
++++$objPHPExcel->getActiveSheet()->getColumnDimension($i)->setAutoSize(TRUE);
}|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|187375|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>for ($i = 'A'; $i != $objPHPExcel-&gt;getActiveSheet()-&gt;getHighestColumn(); $i++) {
 $objPHPExcel-&gt;getActiveSheet()-&gt;getColumnDimension($i)-&gt;setAutoSize(TRUE);
}
</code></pre>

blocks|key|185890|text|您还需要确定要设置尺寸的列：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|185891|foreach+(range('A',+$phpExcelObject->getActiveSheet()->getHighestDataColumn())+as+$col)+{
$phpExcelObject
++++++++->getActiveSheet()
++++++++->getColumnDimension($col)
++++++++->setAutoSize(true);
}|code-block|syntax|javascript|185892|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 also need to identify the columns to set dimensions:

<pre><code>foreach (range('A', $phpExcelObject-&gt;getActiveSheet()-&gt;getHighestDataColumn()) as $col) {
$phpExcelObject
 -&gt;getActiveSheet()
 -&gt;getColumnDimension($col)
 -&gt;setAutoSize(true);
}
</code></pre>

blocks|key|187897|text|$col+=+'A';
while(true){
++++$tempCol+=+$col%2B%2B;
++++$objPHPExcel->getActiveSheet()->getColumnDimension($tempCol)->setAutoSize(true);
++++if($tempCol+==+$objPHPExcel->getActiveSheet()->getHighestDataColumn()){
++++++++break;
++++}
}|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|187898|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>$col = 'A';
while(true){
 $tempCol = $col++;
 $objPHPExcel-&gt;getActiveSheet()-&gt;getColumnDimension($tempCol)-&gt;setAutoSize(true);
 if($tempCol == $objPHPExcel-&gt;getActiveSheet()-&gt;getHighestDataColumn()){
 break;
 }
}
</code></pre>

blocks|key|187900|text|此代码片段将自动调整所有工作表中包含数据的所有列的大小。不需要使用activeSheet的getter和setter。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|187901|//+In+my+case+this+line+didn't+make+much+of+a+difference
PHPExcel_Shared_Font::setAutoSizeMethod(PHPExcel_Shared_Font::AUTOSIZE_METHOD_EXACT);
//+Iterating+all+the+sheets
/**+@var+PHPExcel_Worksheet+$sheet+*/
foreach+($objPHPExcel->getAllSheets()+as+$sheet)+{
++++//+Iterating+through+all+the+columns
++++//+The+after+Z+column+problem+is+solved+by+using+numeric+columns;+thanks+to+the+columnIndexFromString+method
++++for+($col+=+0;+$col+<=+PHPExcel_Cell::columnIndexFromString($sheet->getHighestDataColumn());+$col%2B%2B)+{
++++++++$sheet->getColumnDimensionByColumn($col)->setAutoSize(true);
++++}
}|code-block|syntax|javascript|187902|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 code snippet will auto size all the columns that contain data in all the sheets. There is no need to use the activeSheet getter and setter.

<pre><code>// In my case this line didn't make much of a difference
PHPExcel_Shared_Font::setAutoSizeMethod(PHPExcel_Shared_Font::AUTOSIZE_METHOD_EXACT);
// Iterating all the sheets
/** @var PHPExcel_Worksheet $sheet */
foreach ($objPHPExcel-&gt;getAllSheets() as $sheet) {
 // Iterating through all the columns
 // The after Z column problem is solved by using numeric columns; thanks to the columnIndexFromString method
 for ($col = 0; $col &lt;= PHPExcel_Cell::columnIndexFromString($sheet-&gt;getHighestDataColumn()); $col++) {
 $sheet-&gt;getColumnDimensionByColumn($col)-&gt;setAutoSize(true);
 }
}
</code></pre>

blocks|key|190182|text|如果您尝试使用for+($col+=+2;+$col+<=+'AC';+%2B%2B+$col){...}或foreach(range('A','AC')+as+$col)+{...}进行迭代，它将适用于从A到Z的列，但它无法传递Z+(Ex.在“A”到“AC”之间迭代)。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|190183|为了迭代传递'Z'，您需要将列转换为整数，递增，比较，并再次将其作为字符串获取：|190184|$MAX_COL+=+$sheet->getHighestDataColumn();
$MAX_COL_INDEX+=+PHPExcel_Cell::columnIndexFromString($MAX_COL);
++++for($index=0+;+$index+<=+$MAX_COL_INDEX+;+$index%2B%2B){
++++$col+=+PHPExcel_Cell::stringFromColumnIndex($index);

++++//+do+something,+like+set+the+column+width...
++++$sheet->getColumnDimension($col)->setAutoSize(TRUE);
}|code-block|syntax|javascript|190185|这样，您就可以轻松地迭代传递“Z”列，并将自动调整大小设置为每一列。|190186|entityMap^0|7|16|1E|12|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@$9|R|A|S|B|C]|$9|T|A|U|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|V|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|W|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|X|8|@]|D|@]|E|$]]|$1|O|3|-4|5|6|7|Y|8|@]|D|@]|E|$]]]|P|$]]

If you try to iterate with <code>for ($col = 2; $col &lt;= 'AC'; ++ $col){...}</code>, or with <code>foreach(range('A','AC') as $col) {...}</code> it will work for columns from A to Z, but it fails pass the Z (Ex. iterate between 'A' to 'AC').

In order to iterate pass 'Z', you need to convert the column to integer, increment, compare, and get it as string again:

<pre><code>$MAX_COL = $sheet-&gt;getHighestDataColumn();
$MAX_COL_INDEX = PHPExcel_Cell::columnIndexFromString($MAX_COL);
 for($index=0 ; $index &lt;= $MAX_COL_INDEX ; $index++){
 $col = PHPExcel_Cell::stringFromColumnIndex($index);

 // do something, like set the column width...
 $sheet-&gt;getColumnDimension($col)-&gt;setAutoSize(TRUE);
}
</code></pre>

With this, you easy iterate pass the 'Z' column and set autosize to every column.

blocks|key|187409|text|对于Spreedsheet+%2BPHP7，您必须编写\PhpOffice\PhpSpreadsheet\Cell::columnIndexFromString而不是PHPExcel_Cell::columnIndexFromString。并且在循环中是一个错误，在那里你一定不能使用<=。否则，他会在循环中使用过多的列。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|187410|entityMap^0|P|1H|29|10|3W|2|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]|$9|M|A|N|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|O|8|@]|D|@]|E|$]]]|G|$]]

For Spreedsheet + PHP 7, you must write instead of <code>PHPExcel_Cell::columnIndexFromString</code>, <code>\PhpOffice\PhpSpreadsheet\Cell::columnIndexFromString</code>. And at the loop is a mistake, there you must <code>&lt;</code> not work with <code>&lt;=</code>. Otherwise, he takes a column too much into the loop.

blocks|key|3018636|text|以防有人在找这个。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3018637|下面的解决方案也适用于他们的新版本PHPExcel+-+PHPSpreadsheet。|offset|length|style|CODE|3018638|//+assuming+$spreadsheet+is+instance+of+PhpOffice\PhpSpreadsheet\Spreadsheet
//+assuming+$worksheet+=+$spreadsheet->getActiveSheet();
foreach(range('A',$worksheet->getHighestColumn())+as+$column)+{
++++$spreadsheet->getColumnDimension($column)->setAutoSize(true);
}|code-block|syntax|javascript|3018639|3018640|注意:可以用getHighestDataColumn()或最后一个实际列替换getHighestColumn()。|blockquote|3018641|3018642|3018643|这些方法的作用：|3018644|getHighestColumn($row+=+null)+-获取最高的工作表列。|3018645|getHighestDataColumn($row+=+null)+-获取包含数据的最高工作表列。|3018646|getHighestRow($column+=+null)+-获取最高的工作表行|3018647|getHighestDataRow($column+=+null)+-获取包含数据的最高工作表行。|3018648|entityMap^0|0|S|E|0|0|0|6|M|12|I|0|0|0|0|0|T|0|0|X|0|0|T|0|0|X|0^^$0|@$1|2|3|4|5|6|7|14|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|15|8|@$D|16|E|17|F|G]]|9|@]|A|$]]|$1|H|3|I|5|J|7|18|8|@]|9|@]|A|$K|L]]|$1|M|3|-4|5|6|7|19|8|@]|9|@]|A|$]]|$1|N|3|O|5|P|7|1A|8|@$D|1B|E|1C|F|G]|$D|1D|E|1E|F|G]]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|1F|8|@]|9|@]|A|$]]|$1|R|3|-4|5|6|7|1G|8|@]|9|@]|A|$]]|$1|S|3|T|5|6|7|1H|8|@]|9|@]|A|$]]|$1|U|3|V|5|6|7|1I|8|@$D|1J|E|1K|F|G]]|9|@]|A|$]]|$1|W|3|X|5|6|7|1L|8|@$D|1M|E|1N|F|G]]|9|@]|A|$]]|$1|Y|3|Z|5|6|7|1O|8|@$D|1P|E|1Q|F|G]]|9|@]|A|$]]|$1|10|3|11|5|6|7|1R|8|@$D|1S|E|1T|F|G]]|9|@]|A|$]]|$1|12|3|-4|5|6|7|1U|8|@]|9|@]|A|$]]]|13|$]]

In case somebody was looking for this.

The resolution below also works on <code>PHPSpreadsheet</code>, their new version of PHPExcel.

<pre><code>// assuming $spreadsheet is instance of PhpOffice\PhpSpreadsheet\Spreadsheet
// assuming $worksheet = $spreadsheet-&gt;getActiveSheet();
foreach(range('A',$worksheet-&gt;getHighestColumn()) as $column) {
 $spreadsheet-&gt;getColumnDimension($column)-&gt;setAutoSize(true);
}
</code></pre>

<blockquote>
 Note: <code>getHighestColumn()</code> can be replaced with <code>getHighestDataColumn()</code> or the last actual column. 
</blockquote>

What these methods do:

<code>getHighestColumn($row = null)</code> - Get highest worksheet column.

<code>getHighestDataColumn($row = null)</code> - Get highest worksheet column that contains data.

<code>getHighestRow($column = null)</code> - Get highest worksheet row

<code>getHighestDataRow($column = null)</code> - Get highest worksheet row that contains data.

blocks|key|190200|text|对于phpspreadsheet：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|190201|$sheet+=+$spreadsheet->getActiveSheet();+//+$spreadsheet+is+instance+of+PhpOffice\PhpSpreadsheet\Spreadsheet

foreach+(
++++range(
+++++++++1,+
+++++++++Coordinate::columnIndexFromString($sheet->getHighestColumn(1))
++++)+as+$column
)+{
++++$sheet
++++++++++->getColumnDimension(Coordinate::stringFromColumnIndex($column))
++++++++++->setAutoSize(true);
}|code-block|syntax|javascript|190202|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|$]]

for phpspreadsheet:

<pre><code>$sheet = $spreadsheet-&gt;getActiveSheet(); // $spreadsheet is instance of PhpOffice\PhpSpreadsheet\Spreadsheet

foreach (
 range(
 1, 
 Coordinate::columnIndexFromString($sheet-&gt;getHighestColumn(1))
 ) as $column
) {
 $sheet
 -&gt;getColumnDimension(Coordinate::stringFromColumnIndex($column))
 -&gt;setAutoSize(true);
}
</code></pre>

blocks|key|185920|text|//+Auto-size+columns+for+all+worksheets
foreach+($objPHPExcel->getWorksheetIterator()+as+$worksheet)+{
++++foreach+($worksheet->getColumnIterator()+as+$column)+{
++++++++$worksheet
++++++++++++->getColumnDimension($column->getColumnIndex())
++++++++++++->setAutoSize(true);
++++}+
}|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|185921|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre class="lang-php prettyprint-override"><code>// Auto-size columns for all worksheets
foreach ($objPHPExcel-&gt;getWorksheetIterator() as $worksheet) {
 foreach ($worksheet-&gt;getColumnIterator() as $column) {
 $worksheet
 -&gt;getColumnDimension($column-&gt;getColumnIndex())
 -&gt;setAutoSize(true);
 } 
}
</code></pre>

blocks|key|190204|text|不要使用range()，它不会在列Z之外工作。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|190205|只需使用：|190206|$sheet+=+$spreadsheet->getActiveSheet();
foreach+($sheet->getColumnIterator()+as+$column)+{
++++$sheet->getColumnDimension($column->getColumnIndex())->setAutoSize(true);
}|code-block|syntax|javascript|190207|在写入数据之后执行此操作，以便列迭代器知道要迭代多少列。|190208|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|O|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Do not use range() it wont work beyond column Z.
Simply use:
<pre><code>$sheet = $spreadsheet-&gt;getActiveSheet();
foreach ($sheet-&gt;getColumnIterator() as $column) {
 $sheet-&gt;getColumnDimension($column-&gt;getColumnIndex())-&gt;setAutoSize(true);
}
</code></pre>
Do this after you have written your data so that the column iterator knows how many columns to iterate over.

blocks|key|187425|text|试试这个，我就是这样解决的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|187426|$Sheet+=+$excel->getActiveSheet();
$lABC1+=+array('A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z');
$lABC2+=+array('A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z');

for($I+=+0;+$I+<+count($lABC1);+$I%2B%2B):
++$Sheet->getColumnDimension($lABC1[$I])->setAutoSize(true);
++for($J+=+0;+$J+<+6;+$J%2B%2B){
++++$Sheet->getColumnDimension($lABC2[$J].$lABC1[$I])->setAutoSize(true);
++}
endfor;|code-block|syntax|javascript|187427|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|$]]

Try this, i solved like this.
<pre><code>$Sheet = $excel-&gt;getActiveSheet();
$lABC1 = array('A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z');
$lABC2 = array('A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z');

for($I = 0; $I &lt; count($lABC1); $I++):
 $Sheet-&gt;getColumnDimension($lABC1[$I])-&gt;setAutoSize(true);
 for($J = 0; $J &lt; 6; $J++){
 $Sheet-&gt;getColumnDimension($lABC2[$J].$lABC1[$I])-&gt;setAutoSize(true);
 }
endfor;
</code></pre>

I'm trying to auto size the columns of my sheet. 
I'm writing the file and in the end I try to resize all of my columns.

<pre><code>// Add some data
$objPHPExcel-&gt;setActiveSheetIndex(0)
 -&gt;setCellValue('B1', 'test1111111111111111111111')
 -&gt;setCellValue('C1', 'test1111111111111')
 -&gt;setCellValue('D1', 'test1111111')
 -&gt;setCellValue('E1', 'test11111')
 -&gt;setCellValue('F1', 'test1')
 -&gt;setCellValue('G1', 'test1');

foreach($objPHPExcel-&gt;getActiveSheet()-&gt;getColumnDimension() as $col) {
 $col-&gt;setAutoSize(true);
}
$objPHPExcel-&gt;getActiveSheet()-&gt;calculateColumnWidths();
</code></pre>

The above code doesn't work. Doesn't change the column size to fit the text

UPDATE
The writer I'm using <code>$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');</code>

PHPExcel auto size column width

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋 

腾讯云代码助手

CODING DevOps

Cloud Studio

SDK中心

API中心

命令行工具

我正在尝试自动调整工作表中列的大小。我正在编写文件，最后尝试调整所有列的大小。// Add some data$objPHPExcel->setActiveSheetIndex(0)            ->setCellValue('B1', 'test1111111111111111111111')       ...

问PHPExcel自动调整列宽
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问PHPExcel自动调整列宽EN