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'am using NetBeans IDE 8.2, I created a PHP application and using the composer within the IDE, I installed a package "phpspreadsheet" :
The package is then installed in the vendor folder and I even have the autocompletion when using the package's…
I'm currently working on automize some work processes. An Excel File (*.xlsx) should be written. Normally people do this by hand. Now I want to do this with PHP-code. I'm using PHPSpreadsheet. I started put in general table structure and now wanted…
i need some help with phpspreadsheet, i'm trying to load an excel spreadsheet, add something to it and then save it as a pdf, the problem is that when i load a template , saving as pdf doesn't work
ps : when i create a new spreadsheet it works…
I have a ZF3 project with a controller which opens excel-files and compares them with an template which will be openened, too.
On my development notebook (xampp) everything works fine, at my production system (ubuntu) the phpspreadsheet causes…
I'm using PHPSpreadSheet, but when I have a column in my Excel sheet like =B4 and I use getValue() in PHPSpreadSheet I literally get that value: "=B4".
So when I look at the source code I see that I can use getCalculatedValue(), but that method is…
I use https://github.com/PHPOffice/PhpSpreadsheet
I need to add digital signature to xls document to verify authenticity of document. Is it possible with this or maybe other PHP library? Can anyone point me a direction how to do this?
I'm using PHP , the system should download an excel file once the button clicked. Here's my code - I don't know what's wrong with this since I am using the existing code of the previous IT employee here.
public function exportToExcel($data) {
…
An uncaught Exception was encountered
Type: Error
Message: Class "PhpOffice\PhpSpreadsheet\Spreadsheet" not found
Filename: /home/u764710592/domains/pemserp.com/public_html/sandbox/application/controllers/Reports.php
Line Number: 77
Backtrace:
File:…
I have a working environment with many exports using Laravel-Excel (maatwebsite.nl).
In an export I would like to achieve the following.
I have multiple sheets and would like to have a sheet where i would use a Vlookup formula that searches values…
I am trying to make an import excel data to mysql using php and trying to install composer require phpoffice/phpspreadsheet
but the error below always appear.
Installation failed, deleting ./composer.json.
In RequireCommand.php line 217:
…
I have a problem with phpspreadsheet.
I need to pass data to a php file generating an excel file.
I can do it with a
window.location.href='pagegeneratingexcel.php?parameter=parvalue';
In the pagegenerating excel I can easily retrieve the…
Good day evening my goal here is when the excel has an empty date it will display in the data table an empty output, but it displays 01/01/1970 after I import excel empty data i had use strtotime format
empty data in my excell
Display in my…
I have an Excel (XLSX) file with a column containing values in different currencies, e.g. "CAD 4711.00", "NOK 56.78", "CHF 123.45".
Now I try to read data from these cells and I just cannot get the currencies. The best I can do is get the value…
Can anyone please explain what "NULL" represents and why it mentions NULL and what other values or types we can mention instead of null in the following line of code
$worksheet->fromArray( $criteria, NULL, 'A1' );
Please help me to understand this…
