CODEWITHSUNDEEP
phpphpexcel
MajAfy
MajAfy

Reputation: 3097

Set direction sheet in PHPExcel

I trying to export my database data to excel file, so I use PHPExcel classes.

my sheet should be Right to left, How can I switch sheet direction to 'RTL' in PHPExcel ?

Upvotes: 7

Views: 4579

Answers (1)

Mark Baker
Mark Baker

Reputation: 212452

Quoting directly from the developer documentation, which can be found in the /Documentation folder of the distribution:

4.6.48. Right-to-left worksheet

Worksheets can be set individually whether column ‘A’ should start at left or right side. Default is left. Here is how to set columns from right-to-left.

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

Upvotes: 17

Related Questions