Is it possible to create an excel with multiple sheets in it?

Created on 3 August 2021, over 3 years ago
Updated 8 August 2023, over 1 year ago

Problem/Motivation

Steps to reproduce

Proposed resolution

Remaining tasks

User interface changes

API changes

Data model changes

πŸ’¬ Support request
Status

Active

Version

1.2

Component

User interface

Created by

πŸ‡ΊπŸ‡ΈUnited States genellann

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

  • πŸ‡ΊπŸ‡ΈUnited States mferanda

    Lookup addSheet() for phpspreadsheet

  • πŸ‡©πŸ‡ͺGermany Elin Yordanov

    Apparently it does not possible with this module, since in the `encode` method below, the active sheet index is hard coded to 0.

          // Instantiate a new excel object.
          $xls = new Spreadsheet();
          $xls->setActiveSheetIndex(0);
          $sheet = $xls->getActiveSheet();
    
          // Set headers.
          $this->setHeaders($sheet, $data, $context);
    
          // Set the data.
          $this->setData($sheet, $data);
    
  • Status changed to Postponed: needs info 9 days ago
  • πŸ‡«πŸ‡·France mably

    @genellann could you explain a bit more in detail why you would need to create an Excel file with multiple sheets in it?

Production build 0.71.5 2024