扩展方向

// Vertical Spill Direction
const columns = ['customerId'];
columns.forEach((columnName, i) => {
       templateSheet.setValue(0, i, `${columnName[0].toUpperCase()}${columnName.substring(1)}`);
       templateSheet.setTemplateCell(1, 0, {
                 type: 'Group',
                 binding: `Orders[CustomerId]`,
                 spillDirection: 'Vertical',  
      });
});

// Horizontal Spill Direction
const columns = ['customerId'];
columns.forEach((columnName, i) => {
       templateSheet.setValue(0, i, `${columnName[0].toUpperCase()}${columnName.substring(1)}`);
       templateSheet.setTemplateCell(1, 0, {
                 type: 'Group',
                 binding: `Orders[CustomerId]`,
                 spillDirection: 'Horizontal',  
      });
});

// No Spill Direction
const columns = ['customerId'];
columns.forEach((columnName, i) => {
       templateSheet.setValue(0, i, `${columnName[0].toUpperCase()}${columnName.substring(1)}`);
       templateSheet.setTemplateCell(1, 0, {
                 type: 'Group',
                 binding: `Orders[CustomerId]`,
                 spillDirection: 'None',  
      });
});