Questions tagged as 'phpexcel'

Tagged questions
2
answers

Error generating excel with PHPExcel

I have a generic method that is responsible for generating the excel I need, what I send to the method is the resource of a query, the method is responsible for tracing the result to generate the excel with culumnas and corresponding rows. As...
asked by 26.04.2017 / 22:07
1
answer

Download BD in several Excel

is that I have a site that downloads the bd in an excel file but the thing is that I arrive at so much data that the excel file arrives damaged, so it occurred to me that I could only upload, say, a thousand data and that when the thousand thous...
asked by 31.07.2018 / 00:01
1
answer

Does anyone know how to read an excel with PhpSpreadsheet in Codeigniter?

I am trying to read an excel file in codeigniter to save it in a database. I was looking for a php library to work with excel and found phpExcel but when I go to the site it tells me that it is deprecated and that it is now phpspreadsheet...
asked by 05.01.2018 / 15:38
2
answers

Bulk file import from excel.CSV Notice: Undefined offset: 1

I make a massive import form of excel.CSV, I care about all the records but when the process ends it shows me this error: Notice: Undefined offset: 1 in C: \ xampp \ htdocs \ import_excel.php on line 27 Notice: Undefined offset: 2 in C: \...
asked by 15.03.2018 / 11:52
1
answer

Do not insert date field in my BD

I make a massive import module of an excel.csv file but in my date field (DATE) it does not insert the data correctly, it only inserts 0000-00-00, the other fields in the import do it without problem only it's in the date field. This is an ex...
asked by 13.03.2018 / 06:41
1
answer

How to validate the number of columns to import PhpExcel?

Good morning, Can someone please explain or tell me how to do it so that they do not let me import files that are passed or have fewer columns than the established ones? Let's say if my table where I'm going to import has 8 columns from th...
asked by 05.01.2018 / 21:11
1
answer

Copy a sheet with PHPExcel

Good morning, I am working with the PHPExcel library to duplicate an Excel spreadsheet. I'm only interested in its content, its format is not. The first thing I do is open the Excel file: $archivo = $_FILES['fichero_usuario']['tmp_name']...
asked by 31.08.2017 / 09:51
1
answer

Problem when exporting MySQL Database to Excel with PHPExcel

I'm trying to export the table from my mysql database using the PHPExcel library, but it does not generate anything for me. I have this link with which I make the call to the export file: <a href="exportar.php">Descargar tabla</a&g...
asked by 21.07.2017 / 20:08
0
answers

Cells to generated records

I would like to add the borders to the rows with records, everything is based on date ranges so there may be 5, 6, 10 rows with information. As you can see only the columns with titles have borders, but where the information is not, that's wh...
asked by 27.12.2018 / 20:50
1
answer

Borders to rows in phpexcel

Hello, I need to know how to put borders on the rows, now I can only put it to the names of the columns, how can I do it. I'm working with PHPExcel . Code: if ($result > 0) { //TODOS LOS TEXTOS CENTRAD...
asked by 21.12.2018 / 23:30