This has been included in v0.7.1
directly return dataframe in UDF2 votes
Released with v0.7
Table is pretty good way to get a range of cells in, but there are sheets that have multiple tables separated by empty rows. In excel, I can say go down to cell 300k, and move up to get to the end row.
Range('a300000').end(xlUp).row will give me the last row to read.
A similar is done for the last column populated.6 votes
This is available with 0.9.0: http://docs.xlwings.org/en/stable/api.html#xlwings.Range.end
Named ranges only work on one sheet and you have to reference them in the code by sheet reference first. Should be globalized so named ranges can be pulled from anywhere6 votes
This has been fixed in 0.9.0, see: http://docs.xlwings.org/en/stable/api.html#names
Import @xlfunc idea from ExcelPython.
It is easy and pythonic...5 votes
This is now available with 0.6.0: http://docs.xlwings.org/udfs.html
Introduced with v0.11
When having many function calls, the traceback of an Error is quite long and often doesn't fit into the displayed Error Window. Then the relevant part of the error message is not displayed, which makes debugging difficult or even a sorcery. Any way to get your hands on the total error message would be a great improvement IMHO.1 vote
This is now available with 0.6.0 on Windows: http://docs.xlwings.org/udfs.html
Possibility to create functions that can amend values of other cells. This will help to overcome excel's limitations as user cannot do that from a custom function, but only from a subroutine6 votes
Dynamic array formulas have now been released with xlwings v0.10
Released today with v0.5.0