Felix Zumstein

Sort of, yes. You could also just do `ws1.range("A2:Z20").api.Value2` and transform the date serial into a Python datetime yourself. While xlwings doesn't have a helper function for that, I believe...

Makes sense. I think I made it `None` for now as I think the information is missing on macOS.

This looks like an issue with Excel and/or pywin32, a dependency of xlwings. Do you get the same when running `xw.Book()`? See e.g., https://windowsreport.com/class-not-registered-vba/

please post the full traceback/error message, thanks!

I removed your invalid commands from the last comment to not confuse other users. So yeah, I think you should try to repair Excel, it's not an issue with xlwings...

Setting the formula property should probably just be an alias to setting the value property, which will resolve this issue.

Can you attach a spreadsheet to replicate? You might not be using the right type code. Try with ```python from appscript import k sh1.api.used_range.special_cells(type=k.cell_type_visible) ```

Looks like an issue with AppleScript (not appscript): when you run the following AppleScript, it only selects the first 15 areas: ```AppleScript tell application "Microsoft Excel" activate object worksheet "Sheet1"...

Not really, no, but if you can work with a VBA macro, you could call this from xlwings via `mybook.macro()`

Does xlwings work if you run it from Python? You might get a better idea if you unlock the xlwings add-in in the VBA editor (password is `xlwings`) and see...