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'm currently using PhpSpreadSheet Library and I wanna write into an existing spreadSheet. Is that possible?
If yes, how? I didn't see any possibility in the documentation.
Thanks!
I have an excel file which has a time input.
Mar 01, 2018 | Thursday | 8:00 AM | 5:00 PM
Mar 02, 2018 | Friday | 8:00 AM | 5:00 PM
But when my code tries to read those cells, the output becomes a float (for example 8:00 AM becomes…
I am really mad at PHPSpreadsheet, and why the functions are not named as in PHPExcel, or why in documentation doesn't mention something about "PHPExcel_Worksheet_Drawing", where can I find it in PHPSpreadsheet?.
In PHPExcel I have this:
$objDrawing…
With phpspreadsheet
Is there a way to protect the Excel sheet with a password so users cannot read without the password?
I know you can protect a cell or a sheet from writing but I am looking for a way to protect the entire file from being open,…
[checking for Apache 2.0 handler-module support via DSO through APXS...
Sorry, I cannot run apxs. Possible reasons follow:
Perl is not installed
apxs was not found. Try to pass the path using --with-apxs2=/path/to/apxs
Apache was not built using…
I have a spreadsheeet outputted from PHPExcel, and everything displays perfectly.
I have protected the sheet as follows:
$objPHPExcel->getActiveSheet()->getProtection()->setSheet(true);
which works fine.
In the sheet I have a table, in which some…
I´m working with phpspreadsheet and I want to modify an xlsx file with 4 sheets. I only want to insert data in 2 sheets, but I want to copy all 4 sheets to the new xlsx file. When I do that I get this error:
Fatal error: Allowed memory size of…
I want to make export results with Laravel Excel, but the results did not match what I wanted.
what I want is like this
I want all cells to be wrapped in text and have a complete border.
This is my code:
class SdgsExportView2 implements FromView,…
By using PhpSpreadsheet, it will export the html data to xlsx format. But it cannot add data to a specific worksheet in the excel sheet. How the data write to a specific worksheet? I have to write htmlstring1 to worksheet 1 and htmlstring2 to…
I'm pulling a spreadsheet from an FTP directory and I need to read it with PHPSpreadsheet. I can read a local file just fine, but not sure how to do it when I'm getting a stream of data.
Is this even possible? I'm not finding much in documentation…
Default row height in excel is -1 which show 15 in excel.This row height automatically resize to 15.75 after add content.So, I set new default row height,15 for all rows. Still, row height getting auto resize. Then, I try to set row height for all…
I'm trying to get value from a cell using getFormattedValue, in the cell it is showing as 22 5/8 and the value I'm getting from getFormattedValue is 23\ ?/8
If I use getCalculatedValue I'm getting the value 22.64
How I can fix this issue?
I use PhpOffice\PhpSpreadsheet with Apcu caching, and i have this error
Error: Cell entry A1 no longer exists in cache. This probably means that the cache was cleared by someone else.
$pool = new \Cache\Adapter\Apcu\ApcuCachePool();
$simpleCache =…
I have generated a valid spreadsheet and I am able to save it with the documented save method :
$writer = new Xlsx($spreadsheet);
$writer->save('file.xlsx');
But how can I use the storages disks provided by Laravel ? Can I get the content of the…
