- $this->rtl = ($_SESSION['language']->dir === 'rtl' ? 'rtl' : 'ltr');
- $this->code = $_SESSION['language']->encoding;
- $this->filename = $filename;
- $this->path = $comp_path.'/'.user_company(). '/pdf_files/';
- $this->ExcelWriterXML($this->filename);
- $this->setCharSet($this->code);
- $this->overwriteFile();
- $this->showErrorSheet(true);
-
- $this->sheet =& $this->addSheet($this->title);
- if ($this->rtl === 'rtl')
- $this->sheet->displayRightToLeft();
- $formatTitle =& $this->addStyle('formatTitle');
- $formatTitle->fontSize('16');
- $formatTitle->fontBold();
- $formatTitle->border('Top', '2', 'darkgray');
-
+ $rtl = ($_SESSION['language']->dir == 'rtl');
+ $this->code = strtolower($_SESSION['language']->encoding);
+ $this->filename = $filename.".xls";
+ $this->unique_name = uniqid('').".xls";
+ $this->path = $comp_path.'/'.user_company(). '/pdf_files';
+ $this->Spreadsheet_Excel_Writer_Workbook($this->path."/".$this->unique_name);
+ //$this->setCountry(48);
+ if ($this->code != "iso-8859-1")
+ $this->setVersion(8); // set biff version to 8 (0x0006 internal)
+ $this->sheet =& $this->addWorksheet($this->title);
+ if ($this->code != "iso-8859-1")
+ $this->sheet->setInputEncoding($this->code); // set sheet encoding
+ if ($rtl)
+ $this->sheet->setRTL();
+ $this->formatTitle =& $this->addFormat();
+ $this->formatTitle->setSize(16);
+ $this->formatTitle->setBold();
+ $this->formatTitle->setAlign($rtl ? 'right' : 'left');
+ $this->formatTitle->setTop(2);
+ $this->formatTitle->setTopColor('gray');
+