Questions tagged [phpxlsxwriter]
8 questions
2
votes
0 answers
Excel 2007 cannot open php xlsxwriter generated file
I am using xlsxwriter in php 5 under centos 7.
Here is a simple script which generates an xlsx file:
writeSheetRow('test', array('test'),…
grandguiyom
- 21
- 3
1
vote
1 answer
php_xlsxwriter - Excel cannot open file output from browser
Using PHP_XLSXWriter, if I write an .xlsx file to the server, download and then open it in Excel all works well :-
include_once("xlsxwriter.class.php");
$filename = "example.xlsx";
$rows = array(
array('year','month','amount'),
…
Jules
- 275
- 1
- 4
- 11
0
votes
1 answer
PHP_XLSXWriter and Code Igniter Corrupted Output Excel File
I'm trying to integrate [PHP_XLSXWriter] (https://github.com/mk-j/PHP_XLSXWriter) with Code Igniter
Here's my controller source code
public function ToExcel(){
include_once APPPATH.'/third_party/xlsxwriter.class.php';
$filename =…
Adhi Kristianto
- 33
- 7
0
votes
1 answer
PHP_XLSXWriter Mixed Format Issues
I'm working with PHP_XLSXWriter for one of my projects and running into a problem I don't seem to be able to resolve; mixed formats.
I need to produce an Excel file from my database tables, together with a header row that's all text. The data after…
David Taylor
- 1
- 2
0
votes
1 answer
File Format or File Extension is not valid using Spout PHP In Linux CentOS
I am facing problem in export xlsx format using spout library. I don't know where is the issue in my code. I don't know much about spout library. I have tried many times but the same error occurs again and again when I tried opening the exported…
Bala Vasudevan
- 1
- 3
0
votes
1 answer
How to insert an image, Report title and Headers into an excel worksheet using PHP XLSX Writer?
I want to achieve a report header like this. If I add Report Title and subtitle using $writer->writeSheetRow() then $writer->writeSheetHeader() doesn't display header row. Also, I cannot insert an image into the sheet. If there is any sample code,…
Sandhiya C
- 49
- 2
- 10
0
votes
1 answer
phpxlsxwriter insert multiple font style on one cell
I need to write row consist of 7 columns to excel and apply two types of font styles, bold and underline on second column only. So, I inserted two styles in array,
array('font-style'=>'bold','font-style'=>'underline')
But, only font-style…
Premlatha
- 1,676
- 2
- 20
- 40
0
votes
1 answer
PHP_xlsxwriter not working on server (file_exists cannot detect)
I had been using PHPExcel but switched to PHP_xlsxwriter because of speed. I am really satisfied with the performance but it only works on local server somehow.
$filename = "Report.xls";
$writer->writeToFile($filename);
if (file_exists($filename))…
Min Lee
- 347
- 1
- 3
- 8