Set Guide in PHPExcel

Question

I am trying to export my database data to an excel file, so I am using PHPExcel classes.

My sheet should be from right to left. How to switch sheet direction to "RTL" in PHPExcel?

Answer 1

Quoting directly from the developer documentation, which can be found in the / Distribution documentation folder:

4.6.48. Sheet from right to left

Worksheets can be set individually, whether column "A" should start on the left or on the right. By default remains. Here's how to set columns from right to left.

// right-to-left worksheet $objPHPExcel->getActiveSheet() ->setRightToLeft(true);