eightyknots/phpspreadsheet-bundle

A Symfony bundle to integrate with PHPOffice's PhpSpreadsheet library

phpspreadsheet-bundle's Issues

Notice: Undefined index: $

Related to PHPOffice/PhpSpreadsheet#1326
Needs update PhpSpreadsheet to 1.13.0

Use CellCache

Hi,

I am using this repo for several projects and I am facing an issue due to a big xls export (more than 30K rows) on a sf 3.4 project.

The PhpSpreadSheet documentation talks about CellCaching to save up memory, but how can I use it from this bundle ? I found no solution anywhere else...

Thanks for any information you can give me :)

Can't be installed for Symfony 3.4

Hi,

your bundle can't be installed for a Symfony 3.4 project, here is the error :
spomky-labs/base64url v2.0.1 requires php ^7.1 -> your PHP version (5.6.16) does not satisfy that requirement

Is it possible to change your spomky library ?

Attempted to load class "Factory"

Attempted to load class "Factory" from namespace "Yectep\PhpSpreadsheetBundle".
Did you forget a "use" statement for e.g. "Symfony\Component\Lock\Factory" ?

I'm on Symfony 3.4.6.
Someone has the same problem? Solutions?

Error after updating using composer update

After updating project using composer update I get following error message:

Circular reference detected for service "phpoffice.spreadsheet", path: "phpoffice.spreadsheet -> Yectep\PhpSpreadsheetBundle\Factory -> phpoffice.spreadsheet".

Symfony 5 autowiring error

Hi, @yectep!

After moving project to Symfony 5, have got an error:

Cannot autowire service "path\to\project\service\class": argument "$spreadsheetFactory" of method "__construct()" references class "Yectep\PhpSpreadsheetBundle\Factory" but no such service exists. You should maybe alias this class to the existing "phpoffice.spreadsheet" service.

It could be fixed by declearing an alias for phpofficebundle_spreadsheet_class. I've created a pull request #18 with related fix. Can you review it?

A tree builder without a root node is deprecated since Symfony 4.2 and will not be supported anymore in 5.0.

Hi,
I want to use your bundle with Symfony. But I get this message : A tree builder without a root node is deprecated since Symfony 4.2 and will not be supported anymore in 5.0.

I wrote your solution in Configuration file but it doesn't work.
Can you to resolve this problem ?

Thank you

Alexandre

Service "phpoffice.spreadsheet" not found

I followed the README instructions and when I try to use :

$newSpreadsheet = $this->get('phpoffice.spreadsheet')->createSpreadsheet();

I have this error :

Service "phpoffice.spreadsheet" not found: even though it exists in the app's container, the container inside "App\Controller\MyController" is a smaller service locator that only knows about the "doctrine" ... and "twig" services. Try using dependency injection instead.

There's nothing about "phpoffice.spreadsheet" in my /config/services.yaml
Do I have something to add manually ?

I'm using Symfony 4.4.2

Please create v0.0.6 tag, so that composer can update the bundle

Please

Support Symfony 7

Since Symfony 4 is dead, I would also propose a new version of this bundle, with only the supported versions of Symfony, e.g.

^5.4 || ^6.3 || ^7.0

I think it may be a bit difficult to support version 4 and version 7, and of course I'd much rather see support for the current version of Symfony.

phpoffice.spreadsheet service is not public

The README shows how to use this bundle by getting the 'phpoffice.spreadsheet' service from the container. This service is private by default starting with Symfony 3.4. Resolution should be to mark service as public in bundle config or show how to use service through dependency injection.

The TreeBuilder::root() method called for the "yectep_phpoffice" configuration is deprecated since Symfony 4.3

The "Symfony\Component\Config\Definition\Builder\TreeBuilder::root()" method called for the "yectep_phpoffice" configuration is deprecated since Symfony 4.3, pass the root name to the constructor instead.

Work only in symfony 2.7 ?

thank you !