Upgrade phpoffice/phpspreadsheet

Hi @LaRatota
In composer.json file of module add "phpoffice/phpspreadsheet": "^2.0" probably will update and download new release when install using composer.

Hi @dineshkumarbollu,

No, I've tried, and it doesn't work. That's why I created the issue hehe

I don’t want to complain, but another module I use, Permission Spreadsheet → , requires phpspreadsheet 2.2.0 or greater for its latest version, which I can’t satisfy while vbo_export requires 1.6. I can’t help with the coding, but I will with testing if it comes to that.

I second #4, I would like to see an update too. Happy to test!

There is a security issue with phpspreadsheet < 2.2.1: https://github.com/advisories/GHSA-ghg6-32f9-2jp7

Please update this project asap...

+1 ,on each deploy we have the message that the current version of phpoffice/phpspreadsheet (^1.6) is unsupported.

If the library version is updated to 2, I found that some functions must be updated since now are deprecated.
For example I tested the upgrade to the 2.2.1 version of the library and I have to replace this function in src/Plugin/Action/VboExportXlsx.php to fix export in XLSX:

setCellValueExplicitByColumnAndRow()` use the equivalent `setCellValueExplicit()

So it turned out I still have this on one of my projects, thanks for the work done, on it.

Please test.

Actually.. I need to release this so the library downloads automatically and there are no composer issues. Please create follow-ups if something still needs fixing.

Thanks, works like a charm!

Thank you very much!

Automatically closed - issue fixed for 2 weeks with no activity.