Direction de feuille excel droite à gauche
Bonsoir
j'ai créer un fichier excel avec la classe PHPExcel, mais la direction de page feuille excel est gauche à droite.
Voila mon code:
Code:
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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
|
<?php
require_once 'include/PHPExcel/PHPExcel.php';
require_once 'include/PHPExcel/PHPExcel/IOFactory.php';
$workbook = new PHPExcel;
$sheet = $workbook->getActiveSheet();
$sheet->setTitle("Factures");
//on fusionne les cellules de A1 à D1
$sheet->mergeCells('A1:j1');
$sheet->setCellValue("A1", "Gestion Des Factures");
$sheet->getStyle("A1:j1")->getFont()->setBold(true);
$sheet->getStyle("A1:j1")->getFont()->setSize(25);
$sheet->getColumnDimension("A")->setWidth(15);
$sheet->getColumnDimension("B")->setWidth(20);
$sheet->getColumnDimension("C")->setWidth(20);
$sheet->getColumnDimension("D")->setWidth(14);
$sheet->getColumnDimension("E")->setWidth(14);
$sheet->getColumnDimension("F")->setWidth(14);
$sheet->getColumnDimension("G")->setWidth(14);
$sheet->getColumnDimension("H")->setWidth(17);
$sheet->getColumnDimension("I")->setWidth(17);
$sheet->getColumnDimension("J")->setWidth(17);
$sheet->setCellValue("A3", "Numero Facture");
$sheet->setCellValue("B3", "Numero Client");
$sheet->setCellValue("C3", "Client");
$sheet->setCellValue("D3", "Date");
$sheet->setCellValue("E3", "Date Envoie");
$sheet->setCellValue("F3", "Date Relance");
$sheet->setCellValue("G3", "Date Paiement");
$sheet->setCellValue("H3", "Total HT");
$sheet->setCellValue("I3", "Total TTC");
$sheet->setCellValue("J3", "Montant Payé TTC");
$sheet->getStyle("A3:J3")->getFont()->setBold(true);
$sheet->getStyle("A3:J3")->getBorders()->applyFromArray(array('allborders' => array('style' => PHPExcel_Style_Border::BORDER_DOUBLE, 'color' => array('rgb' => '000000'))));
$writer = new PHPExcel_Writer_Excel2007($workbook);
$writer->save("include/PHPExcel/test.xlsx");
?> |
Comment faire la direction de feuille excel droite à gauche?
Merci
