ILIAS icon indicating copy to clipboard operation
ILIAS copied to clipboard
verified publisher icon ILIAS-eLearning

Composer: Add PHPOffice/PhpSpreadsheet for ILIAS 12

Open kergomard opened this issue 1 month ago • 3 comments

This PR suggests adding PHPOffice/PHPSpreadSheat (v. 5.3) as composer dependency.

General Information:

  • [X] this dependency was already used in ILIAS.
  • [X] License: MIT

Usage:

  • Bookingpool
  • Datacollection
  • Exercise
  • MyStaff
  • OrgUnits
  • Polls
  • Category
  • SCORM
  • StudyProgramme
  • Survey
  • Test
  • LearningProgress
  • Tracking
  • Wiki
  • User
  • and possibly more

Wrapped By:

  • \ILIAS\Excel

Reasoning:

  • Is the de facto standard for dealing with spreadsheets in PHP.
  • Is actively developed even if by only one person.
  • In wide use in the code base.
  • Specially xlsx is a very complex standard which we should definitely NOT try to implement ourselves.

Maintenance:

  • Mostly one maintainer oleibmann. Not much information about him available. Regular contributions by others. Part of PHPOffice with more contributors.
  • Regular updates (multiple commits per day).
  • The latest release is from 24.11.2025

Links:

  • Packagist: https://packagist.org/packages/phpoffice/phpspreadsheet
  • GitHub: https://github.com/PHPOffice/PhpSpreadsheet
  • Documentation: https://phpspreadsheet.readthedocs.io/en/latest/

kergomard avatar Dec 01 '25 07:12 kergomard

Jour Fixe, 08 DEC 2025: Dependency is accepted for ILIAS 12.

matthiaskunkel avatar Dec 08 '25 14:12 matthiaskunkel

What is the expectation in terms of performance for large datasets with this compared to the current implementation for excel export? Better/Worse/Same?

fsesterh avatar Dec 09 '25 11:12 fsesterh

@fsesterh : This is the current implementation for excel exports. See above.

kergomard avatar Dec 09 '25 11:12 kergomard