Questions tagged as 'phpexcel'

Tagged questions
1
answer

How to show an Excel with PhpSpreadsheet when loading the information

Currently I'm using the PHPSpreadsheet library to take values from PHP to Excel, what it does now is to take the values to an excel and store them in the address that I specify. but what I'm looking for is that when I upload information, show me...
asked by 10.10.2018 / 21:58
0
answers

It does not show data when downloading the excel

<?php /*******EDIT LINES 3-8*******/ $DB_Server = "localhost"; //MySQL Server $DB_Username = "pcomp"; //MySQL Username $DB_Password = "KneTPuxJ77f4YLNX"; //MySQL Password $DB_DBName = "base"; //MySQL Database...
asked by 04.10.2018 / 16:13
0
answers

Uncaught exception 'PHPExcel_Calculation_Exception' Formula Error: An unexpected error occured '

I'm working with the PHPExcel library and I'm trying to extract the data from an excel file using the getCalculatedValue() function, but that error comes out:    (Uncaught exception 'PHPExcel_Calculation_Exception' Formula Error:   An...
asked by 26.09.2018 / 21:59
1
answer

Conditional on setCellValue phpExcel

as I can add a conditional within -> setCellValue, for example: ->setCellValue('L'. $i, if($suma==4){ $suma=5}); $objPHPExcel->setActiveSheetIndex(0) ->setCellValue('A'. $i, $row['idemp']) ->setCellValue('B'. $...
asked by 21.09.2018 / 00:47
0
answers

Problem with Error 403 Forbidden in certain cases

I am developing a sales system, with HTML, javascript, php, jquery and ajax (it may not be the best combination but it is my first system), and when I want to transfer the data of a sale to excel with PHPExcel (the typical summary that is delive...
asked by 21.09.2018 / 04:45
1
answer

How can I export a file in Excel that shows the leading zeros using the PHPexcel library?

Good morning, I have some data in MySql which I export to Excel using the PHPExcel library, but some of the codes contain "zero" on the left, example: 010, but at the time of generating the Excel the data remains as "10" and I need it to be as i...
asked by 11.09.2018 / 18:09
0
answers

How to load information in an open Excel from a PHP

I have this code and what it does is that it keeps information inside an excel, in this case "Hello World!" , but what happens is that the excel has to be closed so that such execution can be made and when I try to do it with the open excl it se...
asked by 13.08.2018 / 16:49
0
answers

Put an image using the PHPEXCEL library

I am trying to put a header image in my EXCEL document but I have not succeeded, I am using the PHPEXCEL library and the CODEIGNITER framework. I hope you can help me, I share my code when I generate the EXCEL. public function export_excel_...
asked by 13.08.2018 / 17:56
1
answer

How to upload information from a Mysql to an EXCEL already established

What I'm looking for is that my information that I present in a mysql, can be shown in an excel already created, and that only autocomplete. I'm using the PHPExcel library ? Now I have the code in this way     
asked by 09.08.2018 / 22:31
0
answers

How to fix the error Uncaught exception 'PHPExcel_Reader_Exception'

I am trying to send two values to two cells in an excel ALREADY CREATED, which has the name query.xlsx ... but it turns out that I get the following error: Uncaught exception 'PHPExcel_Reader_Exception' with message 'Could not open consulta....
asked by 10.08.2018 / 19:36