Questions tagged as 'phpexcel'

Tagged questions
1
answer

PHP Excel response in JSON

I'm trying to get an answer to see if the PHPExcel PHPExcel file already downloaded, and then proceed with my algorithm. I tried to put in the phpexcel file the following line before the exit; echo json_encode(array("teste" => 1));...
asked by 05.06.2017 / 20:45
1
answer

LaravelExcel is converting the header values of an excel spreadsheet. How to disable this?

I'm using the LaravelExcel library to import data from an excel into a database. To get the header data from my worksheet, do the following: Excel::load('file.xls', function($reader) { $nomeDasColunas = $reader->get()->first()-&...
asked by 25.07.2016 / 15:53
1
answer

String with class break PHPExcel

Hi, I'm having a small problem generating an excel file using the PHPExcel class. I make a query in the database and get a string with an amount x of chars, and I enter this value into an excel template. But when the string exceeds 43 chars I ne...
asked by 02.09.2015 / 14:42
0
answers

PHPExcel - Library automatically converts date notation when importing Excel worksheet, from dd / mm / yyyy changes to mm / dd / yyyy

I'm going through a problem that is already making me bald .. In a certain part of an application, I need to import user data through an Excel spreadsheet, so I'm using the PHPExcel library. However, when I edit the information in Ms Excel...
asked by 21.07.2015 / 15:46
1
answer

PHPExcel generates corrupted .xslx file

I want to generate a .xlsx file, with the records that were not imported, from another table .xlsx , however I can generate the .xls file without problems, when I try to generate .xlsx , Excel warns that the file is cor...
asked by 20.01.2017 / 13:39
1
answer

Read multiple sheets xlsx file with PHP - PhpSpreadsheet

I have a file in xlsx format with two spreadsheets and I need to read the data in PHP to create an import script in the database. I am using the PhpSpreadsheet library to read the files. I can do it when I only have one worksheet in the docum...
asked by 03.09.2018 / 04:30
1
answer

When generating spreadsheet save it to the server

Hello, I am generating a table in Excel using the class PHPExcel, so I generated the force for the download, but now I want it to generate it save to the server instead of force the download directly, I did not find in the documentation, the part...
asked by 27.09.2017 / 21:38
2
answers

Memory error generating spreadsheet with PHPExcel

I'm having problems generating Excel spreadsheets using PHPExcel when the number of records is too large, the memory is insufficient to process the job, is there any way to improve the creation of this file through some caching system?     
asked by 19.10.2016 / 21:52
1
answer

Retrieve values from an array of the next line in the previous row

I have an array in the format below: Array ( [0] => Array ( [A] => 000001001000003001 [B] => VLR REF COMPENSACAO DE VENDA CONFORME CO1 [C] => 1.1.2.01.020001 [D] => Z4 [E] =>...
asked by 26.10.2018 / 18:40
0
answers

Undefined index PHPExcel - data to be saved

When inserting a file you are giving the following message:    Undefined index The code of the line that is giving the error is this: utf8_decode($objPHPExcel->getActiveSheet()->getCellByColumnAndRow($coluna, $linha)->getValue(...
asked by 11.10.2018 / 04:13