Questions tagged as 'phpexcel'

Tagged questions
0
answers

How to clear Apache cache?

I have a project mounted on an external server working correctly for some time, from this download an excel file using PHPExcel everything works fine. I saw the need to make some updates to the excel it throws, working on my local server to make...
asked by 06.12.2018 / 19:01
0
answers

Pass the value of a variable in php to an excel column with phpExcel

Generate reports with use of the phpExcel library, when generating the reports I do it by means of queries and I only send them to call with a variable within a while , the conflict is when you want to save values of a variable that...
asked by 23.11.2018 / 17:17
0
answers

Save excel in Database with PhpSpreadSheet

PHP code, which verifies if the folder exists and then reads the Excel data. The problem that I have is these are students and at the time of printing they print 1 to 1 for example: the name is printed, then the last name, etc. Nose how to put t...
asked by 20.11.2018 / 21:25
1
answer

problem with excel

I'm trying to read an excel in php and this is my code: require_once 'Excel/Classes/PHPExcel/IOFactory.php'; $file = "currier.xls"; $objPHPExcel = PHPExcel_IOFactory::load($file, 'Excel2007'); $objPHPExcel->getSecurity()->...
asked by 06.11.2018 / 16:01
0
answers

Problem with PHPExcel format

I'm doing a query in Sql Server to bring some numbers and put them in an Excel file (.xls) with the library PHPExcel . $consulta = "selec celular FROM clientes where celular <> '' AND LEN(celular) = '10' AND ind_estado = '1...
asked by 02.11.2018 / 17:01
0
answers

Problems generating an excel with phpexcel

I am exporting a MYSQL database to an Excel file using the phpexcel library in PHP. require_once('phpexcel/Classes/PHPExcel.php'); require '../database.php'; $pdo = Database::Conectar(); error_reporting(E_ALL); ini_set('di...
asked by 30.10.2018 / 21:09
0
answers

Export to Excel 3.1, apply style and a report title

Someone knows some more complete documentation of Export Excel 3.1 I want to join cells for the name of my report and give them a style until now I just manage to put the header. public function headings(): array { return [...
asked by 25.10.2018 / 18:19
0
answers

Error in excelphp, does not upload the .CSV

I have a problem in excelphp that I can not identify, and that is when I try to upload a massive load (with a small one works well) of. CSV I get this error: Warning: DOMDocument::loadHTML(): htmlParseEntityRef: no name in Entity, line:...
asked by 17.10.2018 / 21:18
0
answers

Problem with Worksheet.php PHPEXCEL

I have been using this tool to generate excel files, and it has worked excellently, but when creating a new excel it marks me an error and I can not find a solution, I leave here my code and the code of the Worksheet. ------------ Code that I...
asked by 15.10.2018 / 19:23
0
answers

Disadvantage with download to excel

The download to excel does not work for me using the phpExcel library the syntax of the project is as follows <? require_once(/librerias_generales/Classes/PHPExcel.php); $objPHPExcel = new PHPExcel(); function descargar_mov() { $sql="...
asked by 17.10.2018 / 18:12