Questions tagged as 'phpexcel'

Tagged questions
3
answers

Difference of exact hours between sumHoras and hrsDia, Excel PHP

I want to make the exact Difference between Time A and Time B. Ejemplo A HoraEntrada HoraSalida sumaHoras hrsDia Diferencia 06:51:27 19:51:00 12:59 08:00:00 4.98 The following query ret...
asked by 28.09.2018 / 23:32
3
answers

Validate JPG or PNG PHP image

Well the point is that I do not know how to validate the following, in the database I capture the url of an image and then I show it with a echo in php, what I try to do is validate the image either jpg or png to then export it in an exce...
asked by 07.05.2018 / 07:09
2
answers

How to get the excel date with PHPExcel?

Cordial Greeting I have created a class to perform massive loads with the help of PHPExcel, the information to load has columns in date format but it is impossible for me to capture them with the PHPExcel, in doing so it brings me numbers as if...
asked by 10.07.2017 / 19:34
1
answer

Special characters Codeigniter PHPExcel

I have a function that extracts data from a DB and exports them to an excel file, the problem is that it does not show any characters or special characters (No.) This is my code: $this->excel->getActiveSheet()->setCellValue('I16',...
asked by 22.10.2018 / 20:59
1
answer

PHP How to get the name of a variable file?

I am trying to import an excel book in PHP but the name of this file is changed every day. $nombreArchivo="/Carpeta/archivovariable.xlsx" Is there any code to add in the path such as "%%" or "*" so that the file is imported without importin...
asked by 30.01.2018 / 23:40
1
answer

Error generating an excel report in php and msql with PHPExcel

I am using PHPExcel to generate Excel reports with PHP from data obtained from a MySQL database. This is the code I have and file shows this error:    Fatal error : 'break' not in the 'loop' or 'switch' context in    C: \ xampp \ htdocs...
asked by 03.05.2018 / 16:53
1
answer

Accelerate amount of PhpExcel

Good day, When I do the amount of files of up to a thousand records it does not delay, but when I increase the number of records it takes a long time. My question is if anyone knows how to accelerate the amount of phpexcel. Thanks in advance.  ...
asked by 22.01.2018 / 01:06
1
answer

Error exporting database to Excel with PHPExcel library

I am trying to export a table from my database to an excel file, using the library PHPExcel The structure of my table is:    reg, folio, key, date, place, address, telephone, name, subject, depto1, depto2, state, observations, scan,...
asked by 21.07.2017 / 21:28
1
answer

Unable to open file generated with PHPExcel

Why does downloading my file as Excel from a PHP page give me an error that it can not be opened or the extension is not valid? Will this part of the code where I give it name and extension have to do? <?php function activeErrorReporting()...
asked by 21.07.2017 / 01:26
2
answers

Read Excel file with PHP

Good, I need to create a form where users can upload an xlsx file, and the web app validate the file then read it, and finally I need to put the information after evaluating it in a database, I'm using a PHPExcel library , the problem is that it...
asked by 30.03.2017 / 21:43