Felix Zumstein

this needs further investigation on the exact conditions, but apparently when reading named ranges that span across double-letter cell addresses, they are off. This is only regarding the xlwings Reader...

`with xw.Book(...) as wb` leaves empty Excel instance behind

2

I use the with statement to manipulate Excel objects like this: ```python with xw.Book("excel股票分表.xlsx") as wb: for sheet in wb.sheets: print(sheet.name) # 设置日期列单元格的格式 sheet.range("A:A").number_format = "yyyy-mm-dd" chart = sheet.charts.add() chart.chart_type...

UDFs: AttributeError: Range.CLSID

30

@njwhite, something must have slipped through my testing, but from 0.20.0 I now get below error when using legacy dynamic arrays: ``` import xlwings as xw import numpy as np...

Currently this is added automatically as it contains Python files but isn't required for the wheels.

xlwings Reports: handle placeholders that aren't provided

3

Removing the `{{ placeholder }}` would be an improvement compared to the current situation where the placeholder is left on the template. Providing `placeholder=""` is a current workaround though.

freeze pane for office.js

1

## Summary by CodeRabbit - **New Features** - Introduced the ability to freeze and unfreeze panes in Excel sheets. - Added `freeze_panes` property to the `Sheet` class for easy access...

utils.py: ``` def np_datetime_to_datetime(np_datetime): ts = (np_datetime - np.datetime64("1970-01-01T00:00:00Z")) / np.timedelta64(1, "s") dt_datetime = dt.datetime.utcfromtimestamp(ts) return dt_datetime ```