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 want to "autowrap" a long text.
I tried
$cell_st =[
'alignment' =>['wrap' => true]
];
$spreadsheet->getActiveSheet()->getStyle('A2:A50')->applyFromArray($cell_st);
It looks its behaviour doesn't reflect the excel autowrap option
Hi I am working in yii2. I have a function in which I am making an excel file through my mysql query.
$sql = "SELECT SUM(OGP_Created) AS OGP_Created,SUM(UnVerifiedMSN) AS
Un_Verified_Meters,SUM(VerifiedMeters) AS Verified_Meters,SDCode AS
…
I have a requirement to use PHPOffice/PhpSpreadsheet, to install PhpSpreadsheet I followed this link.
So I installed PhpSpreadsheet into my project using 'composer' by running the command
composer require phpoffice/phpspreadsheet
at command…
I'm trying to set the size of an Excel chart created by phpSpreadsheet.
I used the following code, but the layout settings do not seem to have any effect:
// Define chart position and size
$layout = new…
I have to code a php script which will write some values in a spreadsheet.
PhpSpreadsheet will be used for this work.
First, is it possible to write in a existing file without overwritting the existing strings and formulas?
==> I guess yes by using…
Recently i updated my PhpSpreadsheet version to 1.2.1, and suddenly it stoped reading my xls files. I tried using three methods to get the data within the files, to no sucess.
$inputFileType = IOFactory::identify($filePath);
$reader =…
Using PHPSpreadsheet to create a custom line graph. I have data loaded into the spreadsheet and it is properly building the graph. However, I am not able to adjust the color of the lines in the graph. When I try to apply a color to my series, the…
I am using phpspreadsheet in my project which works fine on localhost but when I migrated to production server, it is throwing following error :
PHP Parse error: syntax error, unexpected 'class' (T_CLASS), expecting identifier (T_STRING) in…
I have been using PhpSpreadsheet for the first time and always worked great. However today I needed to make one file where the template copies over several sheets (over 300 sheets).
Looked the documentation and it uses the clone method.
However,…
I'm wondering how to best incorporate PHPSpreadsheet into Joomla! applications, on shared hosting.
With PHPExcel, you just uploaded the library.
PHPSpreadsheet is using Composer, which is new to me, but looks straightforward enough. However, I see…
for my project I'm using PHPSpreadsheet for exporting data in Excel and PDF format.
If from the website, when I press on the respective download buttons, I can easily download the .xlsx and .pdf files, I have problems with the app (iOs Swift…
Currently I try to use this PHP Spreadsheet Bundle for Symfony 4:
https://github.com/roromix/SpreadsheetBundle
But my attempts to use this bundle are not successful.
Can't find it as a service (php bin/console debug:autowiring)
and the way below is…
