Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
Problem/Motivation
The merge cells option (merge_cells) considers sheet indices and not sheet names.
Steps to reproduce
Use any sheet name in the merge_cells option.
array('merge_cells' => array(
'Worksheet 1' => array(
'A1:C1',
'D1:G1',
),
))
Proposed resolution
Update the file phpexcel.inc.
Replace the line 142 :
$sheet = $xls->setActiveSheetIndex($sheet_name);
with :
$sheet = $xls->setActiveSheetIndexByName($sheet_name);
Remaining tasks
No more tasks.
User interface changes
No change.
API changes
No change.
Data model changes
No change.
Comments
Comment #2
motame CreditAttribution: motame as a volunteer commented