Vertical Text in PHPExcel Cell

Question

How can I print text vertically in a cell using PHPExcel class ?

enter image description here

need to print like the above figure.

score 28 · Accepted Answer · answered Feb 21 '14 at 05:26

28

I think you can do by rotating text:

Try this code:

$objPHPExcel->getActiveSheet()->getStyle('B7')->getAlignment()->setTextRotation(90);

Reference:

answered Feb 21 '14 at 05:26

Kumar V

score 0 · Answer 2 · answered Feb 21 '14 at 05:21

0

Try this code:

$objPHPExcel->setActiveSheetIndex(0);
$objPHPExcel->getActiveSheet()->setRightToLeft(true);

Refer: http://phpexcel.codeplex.com/discussions/75118

answered Feb 21 '14 at 05:21

Mani

score 0 · Answer 3 · answered Feb 21 '14 at 05:47

0

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

3 Answers3