enthought / enthought/comtypes

List of 1-tuple not passed to Excel as column array

Open
#48 1 comment 0 reactions 0 assignees View on GitHub
bug
Dominant language
Python
Stars
345
Forks
105
PR merge metrics
No merged PRs in 30d

Description

The following code fails, and I would expect it to fill the "A" column with the values 0-9. Instead, it blanks the cell values.

``` python

import comtypes.client as cc
xl = cc.CreateObject("Excel.Application")
xl.Visible = True
xl.Workbooks.Add()
sheet = xl.ActiveSheet

# Doesn't work as expected
sheet.Range("A1:A10").Value[:] = zip(range(10))

# Does work as expected
sheet.Range("A1:A10").Value[:] = np.array(zip(range(10)))
```

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.