Questions tagged as 'phpexcel'

Tagged questions
1
answer

Report showing all the fields in BD, up to NULL fields

This is my code where an export is made of all my data stored in my DB (reports), but in my BD I have null fields and when downloading the excel report I download all the data that are stored in the BD and I just need you to show in that report...
asked by 21.05.2018 / 14:27
0
answers

The PHPExcel_Writer_Excel2010 class can not be found

I am using PHPExcel to generate Excel reports with PHP from data obtained from a MySQL database. This is the code I have: <?php $conexion = new mysqli('localhost','root','admin123','database',3306); if (mysqli_connect_errno()) {...
asked by 03.05.2018 / 14:30
0
answers

Save data in .xls file with ajax, javascript and PHPExcel

I am practicing with ajax and javascript, and the following problem has come up. I need to send by POST the values of 2 text input and 1 drop list (select), and save that data in an excel file that I created on the server. The .php file uses the...
asked by 20.04.2018 / 01:59
1
answer

Problems updating data by a bulk upload with an excel.CSV file

I make a module in which is a data update but it is massive by means of an excel.CSV, I have the following fields in my "worker" table, some are foreign keys of other table: id_ControlPrimaria nombre ap_paterno ap_materno NSS CURP...
asked by 09.04.2018 / 16:15
0
answers

Problem when updating a field in bulk with excel.CSV

I make a module in which is a data update but it is massive by means of an excel.CSV, I have the following fields in my "worker" table, some are foreign keys of other table: id_ControlPrimaria nombre ap_paterno ap_materno NSS CURP...
asked by 04.04.2018 / 08:48
0
answers

convert an excel file to txt php

I request kind and valuable knowledge of how to convert an excel file to txt. In what I have researched I realized that you must use the PHPEXCEL library to read the excel file after storing the information in an array and then convert it to TXT...
asked by 19.02.2018 / 01:50
1
answer

Increase Box Spout speed

I have an Amount or load with Box Spout but I do not see the difference in speed increase with PhpExcel, Can someone tell me if I'm doing something wrong? <?php error_reporting(E_ALL ^ E_NOTICE); ini_set('display_errors', TRUE);...
asked by 26.01.2018 / 21:29
0
answers

Uncaught Error: Call to undefined function createTitles ()

Good morning I am trying to create a function with php that fills in the title fields automatically, but when I try to pass the arrangement where I have my titles, I get the following error: "Uncaught Error: Call to undefined function createTitl...
asked by 04.12.2017 / 15:52
0
answers

Fatal error: Uncaught PHPExcel_Exception: Cell coordinate can not be zero-length

When I try to create a function that fills my data automatically with PHPExcel and a series of fixes, I get the following error:    " Fatal error: Uncaught PHPExcel_Exception: Cell coordinate can not be zero-length string in C: \ inetpub \ w...
asked by 04.12.2017 / 18:37
1
answer

How to perform SI.ND (VLOOKUP () ...) in PHPExcel

Good I would like to know if it is possible to make this formula in PHPExcel =SI.ND(BUSCARV(A46;Dat_STATUS_EXP;2;FALSO);0)+Q46 I have noticed that the function SI.ND could not use it, since it does not exist for excel 2007. I have...
asked by 29.09.2017 / 15:25