Most voted "phpexcel" questions
It is a PHP library for creating and handling excel spreadsheets, its functionalities range from creating formulas to formatting and styling elements.
Learn more…33 questions
Sort by count of
-
3
votes1
answer510
viewsConditional formatting error if document opened in Microsoft Office
When applying conditional formatting to a spreadsheet xlsx generated with the Phpexcel, the same works smoothly when the document is opened in Libreoffice: $objConditional = new…
-
3
votes5
answers1268
viewsImport spreadsheet with text format using Phpexcel
How to import an excel file as cells in TEXT format code $file_tmp = $_FILES['arquivo']['tmp_name']; try { $FileType = PHPExcel_IOFactory::identify( $file_tmp ); $objReader =…
-
3
votes1
answer86
viewsExcel spreadsheet with unreadable cells when filtering
I’m creating a spreadsheet of Excel using the phpExcel(). When placing filters, the result of the cell C3 and C4 where the subtotal is located SUBTOTAL() looks like this: Unfiltered Filtered Does…
-
2
votes2
answers4279
viewsExport data to Excel using PHP Excel
I’m using the library Phpexcel to export some data from the database. My problem is in relation to some types of data that it puts a simple quotes at the beginning of the number and/or dates '. In…
-
2
votes1
answer952
viewsHow to calculate the value of one cell only what exceeds the other
What formula would you use to calculate a value above a certain number? Example: Area to calculate above 2.00M². The multiplication value was 2.75. How do I record in the cell only 0.75 - and in the…
-
2
votes2
answers784
viewsPhpexcel generates broken spreadsheet
I’m using the Phpexcel class to export a BD table. But I’m having trouble downloading the spreadsheet. To test, enter values manually without making any select in the BD. However when it generates…
-
2
votes0
answers41
viewsProblems with apostrophos using Phpspreadsheet to write xlsx
I have the following problem, I fill out a spreadsheet with a person’s information, however, names like D'Ana generate a problem in xlsx. D'Anna gets a square instead of the bet. the form of writing…
-
2
votes1
answer103
viewsHow could I merge the ties below?
This is the spreadsheet: This is the code: public function loadExcel($file, $dir) { $objReader = PHPExcel_IOFactory::createReader('Excel2007'); $filterValidation = new…
-
2
votes1
answer859
viewsForce download of multiple dynamically generated files with Phpexcel
I have a class responsible for receiving the upload of one or several worksheets .XLS with lots of detailed data (This spreadsheet is default), and convert into another file .XLS leaner for…
-
1
votes1
answer99
viewsReply from PHP Excel in JSON
I’m trying to get an answer to whether the Phpexcel already downloaded, to then proceed with my algorithm. I tried to put in my phpexcel file the following line before Exit; echo…
-
1
votes0
answers618
viewsPhpexcel - Library automatically converts the notation of the date when importing Excel spreadsheet, from dd/mm/yyyy switches to mm/dd/yyyy
I’m going through a problem that’s already making me bald.. In a certain part of an application, I need to import the user’s data through an Excel spreadsheet, for this I am using the Phpexcel…
-
1
votes1
answer2150
viewsPhpexcel, select sheet when importing data to mysql
I want to import data from a spreadsheet but from sheet 2 and I’m not getting it. I have indicated sheet 2 (index 1) as active in this way, but it always enters sheet 1 (index 0): $objWorksheet =…
-
1
votes1
answer242
viewsLaravelexcel is converting the header values of an excel sheet. How to disable this?
I am using the Laravelexcel library to import data from an excel to a database. To get the header data from my spreadsheet, I do the following: Excel::load('file.xls', function($reader) {…
-
1
votes1
answer2208
viewsPhpexcel class line break string
Dear, I have a small problem generating an excel file using the Phpexcel class. I do a query in the database and get a string with an x amount of chars, and insert this value in an excel template.…
-
1
votes1
answer812
viewsProblems with Phpexcel columns
I started to perform the development on my system to generate a file . xls in a very dynamic way. Where you receive the data from a page via POST, and are saved in variables, follow the code:…
-
1
votes1
answer913
viewsExport tabulated text in Excel
Hello I need to generate a text file based on this layout for it to be imported into a system. I’m trying to use Excel, create the cells with the proper sizes as you request the layout. In Excel I…
-
1
votes1
answer662
viewsExcel export in PHP showing error
I have a problem trying to export file to Excel in PHP. I tried with the library PHPExcel even though it is obsolete/discontinued and I tested with PhpSpreadSheet also. But both presented the same…
-
1
votes1
answer3335
viewsRead multiple sets 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’m using the Phpspreadsheet library to read the files. I can do…
-
1
votes1
answer80
viewsDownload two Zipped files in PHP
I am trying to compress two files together in PHP, but I get the following error while trying to open . zip: ! C:\Users\gpsilva\Downloads\your_name (19).zip: Final inesperado do arquivo This problem…
-
1
votes0
answers54
viewsPHPEXCEL generating Notice: Undefined offset: 0 in Excel5.php file
I am trying to use Phpexcel to try to import . xls and convert them to php, to add your information in the database. However, when I import a file . xls, I get the following Notice: Undefined…
-
0
votes2
answers279
viewsMemory error when generating spreadsheet with Phpexcel
I am having problems in generating Excel spreadsheets using Phpexcel when the number of records is too large the memory is insufficient to process the task, there is some way to improve the creation…
-
0
votes1
answer174
viewsError message when opening exported excel file in PHP
use the following code: $this->excel->getActiveSheet()->setTitle('Matemática'); //set cell A1 content with some text $this->excel->getActiveSheet()->setCellValue('A1', $opcao);…
-
0
votes0
answers123
viewsProblems using Phpexcel cache system with Laravel 4.2
I’m trying to use the library’s cache system Phpexcel, but 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…
-
0
votes1
answer674
viewsWhen generating worksheet save it to the server
Hello, I am generating an Excel table using the Phpexcel class, so it generated forced the download, only now I want to generate it save on the server instead of force the download directly, I did…
-
0
votes0
answers74
viewsPhpexcel error generate Excel using CONT.SES Formula with signal =
Good afternoon, I made an implementation to generate an excel spreadsheet where in a cell the formula CONT.SES() should be inserted. But if I put the equal sign (=) before the CONT.SES() ->…
-
0
votes1
answer2356
viewsPhpexcel generates corrupted file . xslx
I want to generate a file .xlsx, with records that were not imported from another table .xlsx, but I can generate the file .xls without problems, already when I try to generate .xlsx, Excel warns…
-
0
votes1
answer655
viewsHow to only get a cell from a CSV file with PHP?
How do I pick up only one row of a specific column? In the code below it shows me all the rows and all the columns you have in the CSV file. I just want a specific cell. Example: Column B - Cars…
-
0
votes1
answer338
viewsFile Corrupted in Phpexcel
While generating Phpexcel database file, the file . xls is coming corrupted, follows picture What would be the mistake, I tried to find but I see nothing wrong. Follow codes. The following PHP code…
-
0
votes1
answer36
viewsRecover values from an array of the next line in the previous line
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] => [F]…
-
0
votes1
answer155
viewsCreate xlsx File with html table
Good, I am trying to pass the values of an HTML table that receives data from a SYBASE database through odbc. When creating an 'xlsx' file formatting excel prevents the created page from opening and…
-
0
votes1
answer38
viewsError exporting to excel
This below is my controller. public function atletaExport(AtletaModalidadeRequest $request){ $alunosModalidade =…
-
-1
votes1
answer31
viewsHow to fetch values from other spreadsheets in the same XSLX using Phpspreadsheet?
I’m making an import of products where I first Gero a model. The template file comes with four spreadsheets: Worksheet -> Standard Sheet for Product Data Fill Environment -> List of…
-
-3
votes2
answers2050
viewsDownload spreadsheet using the Phpexcel class
I found this phpexcel class, I can generate xls files searching Mysql data. It works really well. But I need to take a spreadsheet that is stored as a template in the database and only a few blank…