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
1 answer

Problems encoding japanese characters in Excel5 output PHPExcel

I'm using PHPExcel on a restricted server running PHP 5.6. I have some Japanese characters that I'm trying to include in a CSV and Excel output. Seeing as there's potential to have the same output also in HTML or PDF I'm using PHPExcel to build all…
CyberneticianDave
  • 162
  • 1
  • 9
0
votes
1 answer

unable to write data using phpexcel

$filepath = longdata.xlsx; @mkdir($filepath, 0777, true); $objReader = PHPExcel_IOFactory::createReader('Excel2007'); $objPHPExcel = $objReader->load($filepath); $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel,…
Tanmay Vaishya
  • 53
  • 7
0
votes
1 answer

Path to mpdf/jpgraph library in PHPExcel example on Windows

I'm trying to run the 36chartreadwritePDF.php example of PHPExcel. I have the lastest of the jpgraph and mpdf library placed within the Example folder of the PHPExcel folder (as folders mpdf and jpgraph respectively). Now To link the code to the…
Ojchris
  • 188
  • 1
  • 3
  • 11
0
votes
1 answer

Maintain chart phpexcel

I'm using phpexcel 1.8 to editing an xls. In particular, the original file has 3 sheets First with a graph and values Second with an image Third with some values Here's the code $excel2 = PHPExcel_IOFactory::createReader('Excel2007'); $excel2…
Andrea Mason
  • 239
  • 1
  • 2
  • 14
0
votes
1 answer

How to assign read only authority to cells in excel through PHP?

I am using Github library (https://github.com/PHPOffice/PHPExcel/) for excel file reading and writing through PHP. Now, the problem is that I want Cells with drop down shall be protected to limited any other input that means when you double-click on…
Apoorva Agarwal
  • 183
  • 1
  • 1
  • 9
0
votes
1 answer

How to keep the cell references from another sheet updated when adding new rows with PHPExcel

After using insertNewRowBefore method from the PHPExcel 1.8.0 library, the cell references defined in the active sheet (i.e. sheet1) are correctly updated. However the cell references from the other sheets (e.g. sheet1!A10) remain unchanged. Is…
Quentin Walter
  • 29
  • 1
  • 12
0
votes
1 answer

Updating Cell References in copied rows in PHPExcel (PHPSpreadsheet)

I am using the following code to copy rows in PHPSpreadsheet. However I would like to change the formula references in the copied rows to reflect the new row number. (e.g. (A1-B1), (A2-B2), A3-B3 etc.) Any suggestions? function…
jayzcos
  • 35
  • 1
  • 3
0
votes
1 answer

PHPExcel library get date

Using PHPExcel, I a trying to fetch data from Excel file and save it in MySql database using the following code: $sheet = $objPHPExcel->getSheet(0); $highestRow = $sheet->getHighestRow(); $highestColumn = $sheet->getHighestColumn(); $i=0; $arr…
ITSagar
  • 673
  • 2
  • 10
  • 29
0
votes
1 answer

How to choose PHPExcel graph type in detail?

Following the official example on generating line graph, I am able to create a line graph. However, when I use my own set of data, changing only the data source with all other parts exactly the same as the official example, somehow PHPExcel decide…
cytsunny
  • 4,838
  • 15
  • 62
  • 129
0
votes
1 answer

special character in php array and then insert into excel using phpexcel

I need to put in the small "TM" in php array and then insert into excel file using phpexcel. However, the excel generated shows the cell as "FALSE" and not "ABC™ 1". May I know how can I put in the small "TM" in php array and pass it into excel file…
Ken
  • 11
0
votes
0 answers

Page blank, die extracting formattvalue with phpexcel?

First time, i change a static document values with this code $path = 'xtelcom.xlsx'; $objReader = PHPExcel_IOFactory::createReader('Excel2007'); $objReader->setReadDataOnly(true); $excel_import =…
Malasuerte94
  • 1,454
  • 3
  • 14
  • 18
0
votes
0 answers

Concatenation cutting formula off

I am having a problem with phpExcel. I have been tasked with generating a report that contains a rather complex formula. The formula includes some concatenated strings, but phpExcel does not seem to like that. The resulting file shows part of the…
Tanoro
  • 871
  • 2
  • 10
  • 30
0
votes
0 answers

PHPExcel: auto wrap long text (without spaces) in PDF

How can I auto wrap long word (without spaces) while creating PDF? Example word = Hellooooooooooooooooooooooooooo . I tried this // This is for each column $this->sheet->getColumnDimension($columnID)->setWidth(10); // This is for full data…
Vikram
  • 622
  • 1
  • 6
  • 18
0
votes
2 answers

PHPExcel inserting 38 of 48 rows into MySQL from xlsx file

I am trying to insert the text (UTF-8 Encoded) from an excel file that has 48 rows into a MySQL table. Only 38 of the rows get inserted. Some of the rows do have special characters like "/", "?", ":", ",", ".", "()", "'", """, "!". foreach ($ret…
Jesse T
  • 1
-1
votes
1 answer

Execute a query in IF statement inside FOR loop using PHPExcel

I have a question on executing query inside IF statement. I will start with how i want the process to run. Initially i have an excel file that i want to upload into MYSql database. Using PHPExcel, i am able to get the data from the excel file. Now,…
Nik Shakirin
  • 1
  • 1
  • 5
1 2 3
4
5