I am retrieving data from a database and creating an html table as well as an excel spreadsheet with the data.
The problem is that the excel spreadsheet inserts FALSE into the Description column ...
Id #21814 | Release:
| Updated: Mon at 9:34 PM by abas12 | Created: Mon at 9:34 PM by abas12
Here is a piece of code giving strange result
Id #21809 | Release:
| Updated: Thu at 2:16 PM by CaptainFantastic | Created: Thu at 2:16 PM by CaptainFantastic
I have a template (xlsx) including 2 charts (file have 4 datasheets, both column charts are on datasheet 1) and I just want to export this file again. Everything seems to work fine and the charts a...
Id #21807 | Release:
| Updated: Apr 15 at 11:29 AM by hanni | Created: Apr 15 at 11:29 AM by hanni
// show the field value in bold
$objRichText = new PHPExcel_RichText();
$objRichText->createText("Test Label : ");
$objPayable = $objRichText->createTextRun("Test Value");
Id #21806 | Release:
| Updated: Apr 15 at 8:49 AM by kimanthonygroves | Created: Apr 15 at 8:49 AM by kimanthonygroves
In PHP earlier than 5.2.11, using Excel2007 reader to load a .xlsx file will just die and showing no error.
It cause by @libxml_disable_entity_loader() in PHPExcel_Settings::setLibXmlLoaderOptions...
Id #21803 | Release:
| Updated: Apr 14 at 4:24 AM by tonywong240411 | Created: Apr 14 at 4:24 AM by tonywong240411
When I try PhpExcel insertNewRowBefore for the first time it runs flawlessly but whenever I need to call it more than once it gives me exception
Invalid cell coordinate i$1
even I have used the sa...
Id #21802 | Release:
| Updated: Apr 14 at 5:47 AM by ahsansalal | Created: Apr 14 at 4:18 AM by ahsansalal
I have tried to save Raw Data into database but No luck
Please let me know how to save raw data into mysql database.
raw data means if i put style (bold, italic) in font...then i need to ...
Id #21796 | Release:
| Updated: Apr 6 at 5:34 AM by chetnath | Created: Apr 2 at 11:58 AM by chetnath
Hello, I am trying to write a formula into excel that it isnt excel formula but it is external formula. The output is empty.
The formula is like this "=ASD("SN@CBBT corp";"AVG";" INTERVAL=1m";)"
Id #21779 | Release:
| Updated: Mar 16 at 10:03 PM by midall | Created: Mar 16 at 8:49 PM by midall
I have used the following code many times in many projects.
$objPHPExcel->getActiveSheet()->getStyle('A6:I6')->getFill() ->setFillType(PHPExcel_Style_Fill::FILL_SOLID) ->getStartColor()->setRG...
Id #21760 | Release:
| Updated: Mar 9 at 10:41 AM by MarkBaker | Created: Mar 9 at 10:01 AM by xand49
When i try to upload xlsx or xls file into server it's show Blank page.......and stop uploading
i assume that file is unable to load
here is my code
$jinput = JFactory::getApplication()->input;
Id #21759 | Release:
| Updated: Mar 10 at 1:40 PM by MarkBaker | Created: Mar 9 at 9:30 AM by chetnath