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
0
votes
0 answers

Convert First Row of .xlsx to Header Row with PhpSpreadsheet

How can I configure the first row of my Excel document as a header row? I can only find ways to customize the style of the cells in the first row. For this I made myself a little helper method, but there must be a flag I can set, right? What I'm…
floriankapaun
  • 472
  • 1
  • 4
  • 19
0
votes
0 answers

PHPExcel function showing error on php version 8

I upgrading my website from php 5.6 to php 8 , i am working on changing the PHPexcel to run in php 8 but getting below issue any idea to fix it try { $inputFileType = PHPExcel_IOFactory::identify($inputFileName); $objReader =…
boy108zon
  • 15
  • 6
0
votes
0 answers

PHPEXCEL read special characters that didn't appear in excel sheet (â)

I have column name in excel that have name : Hibah Ather when I read it by PHPExcel I get name : Hibahâ ather I tried to create new sheet and rewrite name and remove space between first and last name I read it by…
Menna Nasser
  • 1
0
votes
1 answer

PHPExcel Piechart legends with fix length

I have issue in setting the width of the legend lables. I can show them but not able to show them as per expectation. Currently it is looking like this I want the Legend to be displayed like this My code //NOTE Layer for charts $layout=new…
nikunj
  • 33
  • 1
  • 9
0
votes
0 answers

Getting Error While printing dynamic Cell and rows data together in PHPExcel?

Hi while printed dynamic column's name everything is correct and not getting any error but while printing my dynamic data in a row i am getting error only at two place of code i also place a comment where i am getting a error please check once and…
Utsaww
  • 13
  • 3
0
votes
1 answer

How to write php excel code in phpexcel format and print dynamic label?

I have a dynamic cell coming from a database. How can I print it into Phpexcel format? $out_table = ''; $k=0; mysql_data_seek($query_result1,0); while($row1=mysql_fetch_array($query_result1,MYSQL_ASSOC)){ $out_table .= "
Utsaww
  • 13
  • 3
0
votes
1 answer

How to write Concatenate url nd text in phpexcel

I am printing some url which is coming dynamic in phpexcel $sheet->setCellValue('M'.($results+2),($result['headline']).$result['url']); but the output is like this Govt to start Air India roadshows in Singapore this…
Utsaww
  • 13
  • 3
0
votes
0 answers

phpexcel download shows virus content warning

I have the following code for download the contents in excel using phpexcel. When I download the file,its showing a virus warning alert.If I tried to click the accept the risk button ,it will download the contents. I have removed the data from excel…
Techy
  • 2,626
  • 7
  • 41
  • 88
0
votes
1 answer

why string getting cut in cell in phpexcel

I am working on phpexcel i have string around 100 characters, and i am placing it in the cell value, when i download that excel file it is getting value cut, and when i am click on cell at that time it shows full string, i want to show that full…
Nikul Panchal
  • 119
  • 1
  • 11
0
votes
3 answers

phpexcel to html only a portion

I'm working on phpexcel. The File I'm working on is from tally export file. I have to read this file and save the data to each user . For example from this file I need only A2:G10 as HTML/TABLE. So i can display to the particular member (Adv.…
Sudhakar Krishnan
  • 732
  • 1
  • 8
  • 27
0
votes
0 answers

Class 'PHPExcel' not found in Excel5.php error upon loading an excel file on PHP

What could be the cause of this error upon loading a program that would get the content of an excel file and display it on PHP. Fatal error: Class 'PHPExcel' not found in C:\xampp\htdocs\uploader\PHPExcel\Reader\Excel5.php on line 624 Below…
user3819290
  • 43
  • 5
0
votes
0 answers

PHP Excel performance is slow

I want to generate an excel sheet which contain some default fields and variable number of comment fields and data related to comment. I want to set specific width and wrap text for comment fields.Righ now I am using this code $excelObj = new…
Rosa Mystica
  • 243
  • 1
  • 3
  • 17
0
votes
1 answer

PHPExcel: Read .xlsx file, sum column 'x' values for similar value of column 'y'

I'm stuck on this problem, let me explain. I've a Excel sheet that has 3 columns like so: y x z 10 5 0 10 5 4.25 10 5 0 30 2 0 30 2 1.85 30 2 0 How can I add the values…
Rakesh
  • 706
  • 6
  • 10
0
votes
1 answer

read data from xlsx file using PHPExcel

This is My test.xlsx sheet, I want to take only B table data from this Xlsx Sheet Using PHPExcel. (Or any other way). Please Give Some Suggestion about My Problem. Thank You
prabha
  • 43
  • 9
0
votes
0 answers

PHPExcel $objWriter->save('php://output'); on php 7.0 ubuntu 16.04 not working

Earlier on php 5.6 file got saved. After updating to php 7 and os to ubuntu 16.04. It is not working $objPHPExcel->getActiveSheet()->setTitle('KYC Report'); $objPHPExcel->setActiveSheetIndex(0); …
Jeevan Srivastava
  • 314
  • 3
  • 11
1 2
3
4 5