Stack Overflow
Stack Overflow

Questions tagged [phpexcel-1.8.0]

PHPExcel is an excel file generating library developed using PHP. PHPExcel-1.8.0 is the latest stable release with many fixes from the earlier 1.7.x version. The major fix is in the password protection update to support in new versions of MS Excel

It providing a set of classes for the PHP programming language, which allow you to write to and read from different spreadsheet file formats, like Excel (BIFF) .xls, Excel 2007 (OfficeOpenXML) .xlsx, CSV, Libre/OpenOffice Calc .ods, Gnumeric, PDF, HTML, ... This project is built around Microsoft's OpenXML standard and PHP

66 questions
10
votes
1 answer

PHPExcel Cells over lapping each other >setRowHeight(-1) auto cell height not working

Update Tested using PHPSpreadsheet I have this code below that I have tried. It seems to work on MSOffice Excel if I use xls when I write the file. Note not working with Libre Office does not auto resize row need it to work with libre office as…
user4419336
5
votes
1 answer

How do I use PHPExcel to read data from an Excel file?

I want to read data from an Excel file in PHP so that I can process the data and insert it into a DB. Looking around SO, it looks like PHPExcel is the premier library for this task. I went to the PHPExcel GitHub page…
HartleySan
  • 7,404
  • 14
  • 66
  • 119
4
votes
1 answer

Populating a mysql database with an excel file using phpspreadsheet

I am trying to populate a mysql database with an excel file using phpspreadsheet library. I am doing it in the following way but I get just the first row. How can I do it for all the rows $spreadsheet =…
Unah Henry
  • 235
  • 1
  • 7
  • 16
3
votes
1 answer

How to set position of Data Labels in phpspreadsheet chart

I want to generate chart using phpspreadsheet library. Below is my requirement that I am not able to fulfill right now using phpspreadsheet. please check below images and suggest me options for below points. Want to set position of Data Values to…
Vishal Rambhiya
  • 741
  • 6
  • 10
3
votes
1 answer

PHPExcel Bar chart using PHPExcel

I have completed my work till gets the SQL table data in excel but I also want to convert data into a Bar chart using PHPEXCEL. Anyone have any idea? how to do that? My PHPEXCEL code is below, $sql = "SELECT sum(Ticket) AS count, Applications FROM…
Rock Linux
  • 63
  • 1
  • 8
2
votes
0 answers

Why some text aren't export in excel with phpexcel but showing in my database and array?

I am using phpexcel to export my data into excel but some words are not exporting into excel but these words are showing in Array when I print_r my data These are few lineswhich are not exporting but showing in array - Over 44 million Microsoft…
Utsav Upadhyay
  • 415
  • 6
  • 21
2
votes
1 answer

How read merged and cells with background color in PHPExcel

I have function: function funct($xls){ include_once '../system/PHPExcel/Classes/PHPExcel/IOFactory.php'; $objPHPExcel = PHPExcel_IOFactory::load($xls); $objPHPExcel->setActiveSheetIndex(9); $aSheet = $objPHPExcel->getActiveSheet(); …
Dmitriy Klochko
  • 51
  • 5
2
votes
1 answer

File extension or file is not valid at the time export excel using spout library in php

I am facing problem in export excel 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. Please guide me where is the…
Mohd Atiq
  • 151
  • 1
  • 13
2
votes
1 answer

Change text background color for hyper link in PHPExcel

In my PHPExcel library, I changed the color of hyper link using the below code $link_style_array = array( 'font' => array( 'color' => array('rgb' => '0000FF'), 'underline' => 'single' …
Arun
  • 3,640
  • 7
  • 44
  • 87
2
votes
1 answer

How to verify the password in PHPExcel generated ".xls" file?

I am generating excel files with extension .xls using PHPExcel library. The excel file is generating. I am using password protection for the document and made only some fields editable. I am doing an Export Import mechanism. It is perfectly working…
Arun
  • 3,640
  • 7
  • 44
  • 87
2
votes
3 answers

How to save the Printable Area on an xlsx file to a PDF with PHPExcel

How would i go about saving the printable area on an excel sheet as a PDF? If I need to use a different lib then I can work with that, but I need it to be as close to the same look as possible as when printing from excel, I know that is hard in…
Alan Doyle
  • 98
  • 16
1
vote
1 answer

How to prevent duplicate data when importing excel using PHPexcel in Codeigniter

public function import_excel(){ if (!$_FILES["file"]["name"]) { echo "Please upload excel file !"; } else { $path = $_FILES["file"]["tmp_name"]; $object = PHPExcel_IOFactory::load($path); …
Makuri David
  • 11
  • 3
1
vote
0 answers

Content cannot be enabled for .xlsm file generated with PhpExcel

I am trying to load and write contents on already existing .xlsm templates and save it as a new file in different directory.These files has macros ad the macros needs to be protected as it were in the original file. I have done the following things…
Tekraj Shrestha
  • 1,228
  • 3
  • 20
  • 48
1
vote
0 answers

Is it possible to insert an image as an excel commentary by means of PHPExcel/PhpSpreadsheet?

Is it possible to insert an image as an excel commentary by means of PHPExcel/PhpSpreadsheet? The way of adding simple text comment is this: $objPHPExcel->getActiveSheet()->getComment('A1')->getText()->createTextRun("comment example"); this in an…
Roman Prokofev
  • 11
  • 2
1
vote
0 answers

PHPExcel: excel sheet downloading but content not showing

Need a help to resolve the excel sheet issue with PHPExcel. I'm trying to generate the PHPExcel from database. The problem is that excel sheet get creating and memory also get occupied but the content is not showing so it's showing blank excel…
Nilesh Wani
  • 37
  • 10
1
2 3 4 5