PhpSpreadsheet is a library written in pure PHP and providing a set of classes that allow you to read from and to write to different spreadsheet file formats, like Excel and LibreOffice Calc.
I have downloaded composer successfully and I am trying to use the phpospreadsheet library but I keep getting these errors although this is a basic code. it works on windows but not on linux.
Code Sample:
require 'vendor/autoload.php';
…
The excel files has multiple tabs (sheets)
I would like to display a specific sheet or a way to navigate between sheets using a form submit button.
include 'vendor/autoload.php';
use PhpOffice\PhpSpreadsheet\IOFactory;
use…
I'm using the following to save and download Excel files in PHP.
$writer = IOFactory::createWriter($spreadsheet, 'Xlsx');
$writer->save('php://output');
It used to be ok, but recently when the records reach 6k rows, I get a 504 gateway time-out…
Is there a way to add a placeholder text to a cell using PhpSpreadsheet?
I want a piece of text to be placeholder, so clients can instantly type in that cell instead of first needing to remove the text in that cell.
I'm trying to set a cell value to TRUE or FALSE with PhpSpreadsheet 1.16.0, but the result is not what I want.
My code:
$sheet->getCell('A1')
->setValueExplicit(true, DataType::TYPE_BOOL);
This is what I get when I open the file with…
I try to install a specific spreachsheet lib with this command:
composer require phpoffice/phpspreadsheet:1.8.2 (because I have Php5 version)
I have this error :
Your requirements could not be resolved to an installable set of packages.
Problem 1
-…
I am using php and I want to export two HTML tables to excel file with two sheets each has one table.
I followed documentation but it only create one sheet with one table.
I'm replacing PHPExcel with PHPSpreadheet and it works OK in test script, but shows blank screen when used in my app (). In PHP settings, I have display_errors enabled, but I get blank screen (and empty log) nevertheless.
Specifically, just…
I'm really new to the spreadsheet, I built the entire table and managed to search for items in the database, however, I have to put the borders on the lines of items searched in the database, as I don't know how many product lines have, I used the…
I have developed a web application that generates some files using phpSpreadSheet and I have this application in an Ubuntu Server. phpSpreadSheet uses memory of the server to generate this files, but when I generate files like 10 times I get this…
Im trying to export my table player mysql to an excel file with phpspreadsheet. The problem is that when the file is downloaded, when we open the file, we have the html page in the file (with the excel content). Because of that, the file is…
I have to edit a worksheet, which uses VLOOKUP.
In my template, VLOOKUP has to search for a value using an index, which is formatted like this:
When I now edit the template in PhpSpreadsheet and change a value or an index, which forces to…
While printing column and row from an array it's showing blank not exporting any data
$inn_table = "";
if ($result['qualification']['dd1'] != "") {
$dd1 = explode(",", $result['qualification']['dd1']);
}
if ($result['qualification']['dd2'] !=…
Using PHPSpreadsheet, I created a Style object and set everything it needed. For instance:
$dateformat = new PhpOffice\PhpSpreadsheet\Style\NumberFormat();
$dateformat->setFormatCode($row['format']);
But I don't see any way to pass that object to…
Here is my array output in browser which i need to print as row and column associatively in PHPEXCEL.Please suggest me how to export it as row and columns.
FirstArray
(
[0] => EY>Yes
[1] => Media Type>Category B
[2] => Coverage…
