Set Widths of Columns

$objPHPExcel-&gt;getActiveSheet()-&gt;getColumnDimension(&#39;B&#39;)-&gt;setAutoSize(true);

$objPHPExcel-&gt;getActiveSheet()-&gt;getColumnDimension(&#39;D&#39;)-&gt;setWidth(12);

$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setAutoSize(true);

$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(12);

Example:

//Can&#39;t use column index
$column_codes = array(&#39;A&#39;, &#39;B&#39;, &#39;C&#39;, &#39;D&#39;, &#39;E&#39;, &#39;F&#39;, &#39;G&#39;, &#39;H&#39;);
foreach($column_codes as $value){
	$worksheet-&gt;getColumnDimension($value)-&gt;setAutoSize(true);
}

//Can't use column index

$column_codes = array('A', 'B', 'C', 'D', 'E', 'F', 'G', 'H');

foreach($column_codes as $value){

$worksheet->getColumnDimension($value)->setAutoSize(true);

}

One thought on “Set Widths of Columns”

Printable coupons 03/22/2013 at 4:06 am

I all the time emailed this blog post page to all my contacts, for the reason that if like to read
it afterward my friends will too.

Comments are closed.

M	T	W	T	F	S	S
	1	2	3	4	5	6
7	8	9	10	11	12	13
14	15	16	17	18	19	20
21	22	23	24	25	26	27
28	29	30	31

Rex's Personal Site

This site is built on WordPress and contains personal notes, photos and videos

Set Widths of Columns

One thought on “Set Widths of Columns”