enthought / enthought/comtypes
List of 1-tuple not passed to Excel as column array
Open
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
Assessment
This issue has not been assessed yet.