PHPExcel and Text Wrapping

Question

I know that this line of code will make the cell text-wrap:

$objPHPExcel->getActiveSheet()->getStyle('D1')->getAlignment()->setWrapText(true);

'D1' being the chosen cell.

Instead of using this code for every cell I need wrapped, is there a way to make the entire Excel Worksheet automatically wrap everything?

Or is there a better practice technique to use for specified columns?

did you think about looping to every cell and apply the wrapper ? — HamZa, Jul 02 '12 at 20:02
Looping is highly inefficient, so I wouldn't recommend it, but setting style for a range of cells is a simple call — Mark Baker, Jul 02 '12 at 20:07

score 131 · Accepted Answer · answered Jul 02 '12 at 20:06

131

Apply to a range:

$objPHPExcel->getActiveSheet()->getStyle('D1:E999')
    ->getAlignment()->setWrapText(true);

Apply to a column

$objPHPExcel->getActiveSheet()->getStyle('D1:D'.$objPHPExcel->getActiveSheet()->getHighestRow())
    ->getAlignment()->setWrapText(true);

answered Jul 02 '12 at 20:06

Mark Baker

209,507
32
346
385

1

I am also facing same problem. It works perfect but it shows last word of the string? I want to show first few characters which can fit into the cell? – Gaurav Pant Oct 20 '13 at 12:46
1

@virus - then perhaps you need to set vertical alignment as well – Mark Baker Oct 20 '13 at 15:00
Just a heads up that setting the range to 999 will increase file size. – Butsuri Jan 05 '16 at 03:33
It'll only increase file size if you have fewer than 999 rows, adjust that value to suit the size of your spreadsheet – Mark Baker May 09 '17 at 07:10

score 34 · Answer 2 · edited Nov 12 '15 at 06:40

34

$objPHPExcel->getDefaultStyle()->getAlignment()->setWrapText(true);

edited Nov 12 '15 at 06:40

Sourabh Kumar Sharma

2,864
3
25
33

answered Nov 12 '15 at 06:23

james

341
3
2

1

Probably the best answer here. I don't know if this method was around when the question was posted, but it's definitely a nifty way to wrap text in all cells of the document. – Chris Sep 19 '21 at 07:24
yes, best answer to make automatically text-wrap all cell in doc regardless of any sheet, thanks – Birhan Karahasan Aug 27 '23 at 18:11

score 0 · Answer 3 · answered Jul 10 '14 at 07:36

0

Apply to column

$highestRow = $$objPHPExcel->getActiveSheet()->getHighestRow();
for ($row = 1; $row <= $highestRow; $row++){
    $sheet->getStyle("D$row")->getAlignment()->setWrapText(true);
}

answered Jul 10 '14 at 07:36

Naitik Shah

513
6
13

No need to wrap when you can use a range. getStyle('A1:AI100') – M H Dec 30 '19 at 20:09
@MH how do I wrap multiple columns, not range – Jaber Al Nahian Aug 31 '21 at 08:40

PHPExcel and Text Wrapping

3 Answers3

Linked