Questions tagged as 'phpexcel'

Tagged questions
1
answer

Exporting to Excel in PHP with error

I have a problem when trying to export file to Excel in PHP. I tried with the PHPExcel library even though it was deprecated / deprecated and tested with PhpSpreadSheet as well. But both presented the same error and only in PHP 7....
asked by 14.08.2018 / 23:09
0
answers

Why does not Ajax show php return?

Hello, I am using PHPExcel to import data. I've done an if in php to check if one of the cells in excel has been populated or is 0, and if true it should return an error in an array object, but Ajax does not show that return. PHP:      $uplo...
asked by 11.09.2018 / 13:39
0
answers

PHPExcel error generating Excel using Formula CONT.SES with the =

Good afternoon, I made an implementation to generate an excel sheet where the CONT.SES () formula should be inserted into a cell. But if I put the equal sign (=) before the CONT.SES () - > = CONT.SES the following error message is displaye...
asked by 25.10.2017 / 21:16
1
answer

How to get only one cell from a CSV file with PHP?

How do I get just one row from a specific column? In the code below it shows me all the rows and all the columns it has in the CSV file. I just want a specific cell. Example: Coluna B - Cars Line 2 - Fox Line and column cell - B2 I wa...
asked by 30.06.2017 / 14:47
1
answer

Error message when opening exported excel file in PHP

I use the following code: $this->excel->getActiveSheet()->setTitle('Matemática'); //set cell A1 content with some text $this->excel->getActiveSheet()->setCellValue('A1', $opcao); $this->excel->getActive...
asked by 18.04.2017 / 16:11
1
answer

Problems with PHPExcel columns

I started developing on my system so I could generate a .xls file in a very dynamic way. Where you receive the data of a page via POST, and are saved in variables, follow the code: <?php $tabela = $_POST['txttabela']; $p_colunas = $_POST['c...
asked by 08.04.2017 / 18:56
1
answer

PHPExcel problem with formatting shortcuts

I am generating an excel (.xls) file using PHPExcel (Excel5). When opening the file in excel (2003 and 2010) and trying to use the number formatting shortcuts error always occurs. I tried to format the values through PHPExcel and also the proble...
asked by 27.03.2017 / 16:11
0
answers

Problems using the PHPExcel cache system with Laravel 4.2

I am trying to use the PHPExcel library cache system , however I am still getting memory overflow in my application. I need to use cache because I am generating reports with more than 100,000 records on a server with limited memory. Therefore...
asked by 06.12.2016 / 19:27
1
answer

PHPExcel, select sheet when importing data to mysql

I want to import data from a worksheet but from sheet 2 and I'm not able to. I indicated sheet 2 (index 1) as active in this way, but always goes to sheet 1 (index 0): $ objWorksheet = $ objPHPExcel-> setActiveSheetIndex (1); What will b...
asked by 24.05.2016 / 15:04
2
answers

Spreadsheet download using the PHPExcel class

I found this phpexcel class, I can generate xls files fetching MySQL data. It Works very well. But I need to get a worksheet that is stored as a template in the bank and just a few blank fields. I want to get this worksheet, load, fill cells,...
asked by 25.11.2014 / 18:09