Questions tagged as 'phpspreadsheet'

Tagged questions
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
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
0
answers

PhpSpreadsheet failed

I am doing an excel amount to the database, everything was working correctly and from time to time I get error 500. Doing tests seems that the reader.load is failing but I do not know how to solve it. require_once 'phpoffice/vendor/autoload.ph...
asked by 10.11.2018 / 17:52
1
answer

Date Format PhpSpreadSheet

I have an Excel file with several fields, including a date type field. I am using PhpSpreadSheet to read the Excel cells and load them in a query but I realized that when reading the cell that contains a date, it reads it as a number, for exampl...
asked by 10.11.2018 / 02:13
2
answers

PHPSpreadSheet 20000 records

I recently worked with the PHPSpreadSheet library to read and create Excel files with a browser. The problem is this: I have tried to create an Excel based on records of a table in SQL, the result of the query is approximately 20,000...
asked by 09.11.2018 / 16:45
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
1
answer

Page Break PhpExcel or PhpSpreadsheet

Porfis as I made a page break in PHPEXCEL or PHPSPREADSHEET     
asked by 22.07.2018 / 20:44
0
answers

phpspreadsheet does not save the xlsx file to server

I publish this question, because I have really searched a lot in the documentation of PHPSpreadsheet (successor of PHPExcel), in forums, in examples, etc ... and I have not found a solution to my problem, I put the panorama: I wrote a code to...
asked by 19.07.2018 / 01:30
0
answers

I already opened the template processor and made the changes that I need but I need help with the code that allows me to download the template already edited

$sheet = \PhpOffice\PhpSpreadsheet\IOFactory::load(Storage_path('baja_tension.xlsx')); //Seleccionamos la hoja $sheet->setActiveSheetIndex(0); //Obtenemos sus datos $activeSheet = $sheet->getActiveSheet(); $p=14;...
asked by 11.07.2018 / 17:30
0
answers

Generate Excel file with PhpSpreadsheet in Codeigniter from a view

I am trying to generate an Excel file with CodeIgniter and the PhpSpreadsheet library from a view. The report that I need to do is not a list but much more complex and I can generate them more quickly with a view and sending parameters. This is...
asked by 26.07.2018 / 22:50