xlwings
This forum is now closed. Going forward, please report all ideas as a GitHub issue: https://github.com/ZoomerAnalytics/xlwings/issues
18 results found
-
There is no feature to open password-protected files.
One can not programmatically open a password-protected file.
1 vote -
Open a Excel file protected with password. You have to introduce the password
Open a Excel file protected with password. You have to introduce the password in the open file sentence.
2 votesimplemented with 0.16.1
-
Add Copy Paste Special functionalities (Values, Format, Picture, Clipboard)
It would be good to add those features so that you can add your formated tables to Word, PDF, PPT easily.
Hence you will not have to use win32 library to do this type of operation
5 votesreleased with 0.16.4
-
3 votes
This has been included in v0.7.1
-
Add save as pdf option
I create 1,000s of reports that need to be saved both in Excel and pdf format. It would be nice to be able to save the file in both formats from python.
13 votesmybook.to_pdf() has been released with 0.21.1
-
directly return dataframe in UDF
directly return dataframe in UDF
2 votesReleased with v0.7
-
Listobject Tables Support
If it were able to read from/to listobject tables, we wouldn't need to have to deal with resizing named ranges when data shape is dynamic. The table functionality is dangerous if any cell is empty.
7 votesthis has been released with 0.21.0
-
Suppress Excel update links error message
When calling values from excel files with links to other unavailable workbooks, excel prompts the user to update / disable links. It seems that this cannot be turned off forcing the user to click through for each file examined.
2 votes -
last row used in a column
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 votesThis is available with 0.9.0: http://docs.xlwings.org/en/stable/api.html#xlwings.Range.end
-
Globalized Named Ranges across Sheets
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 anywhere
6 votesThis has been fixed in 0.9.0, see: http://docs.xlwings.org/en/stable/api.html#names
-
Publish a book a xlwings on Amazon.
Structure it for learning or as a numerical cookbook. Either way would be great advertising for a great product.
Kudos.
7 votesThis is now available on the O’Reilly Learning Platform and will be published in April 2021: https://www.oreilly.com/library/view/python-for-excel/9781492080992/
-
udf decorator
Import @xlfunc idea from ExcelPython.
It is easy and pythonic...
5 votesThis is now available with 0.6.0: http://docs.xlwings.org/udfs.html
-
17 votes
Introduced with v0.11
-
Copy all of the Error message with "Ctrl-C" / redirection of Error messages
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 -
9 votes
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
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 subroutine
6 votesDynamic array formulas have now been released with xlwings v0.10
-
15 votes
Released today with v0.5.0
-
long running UDF and waiting OLE
Apologies if this is discussed elsewhere but I haven;t been able to find it if it is. I'll be brief.
A UDF that takes a relatively long time to return can do so after Excel has started to warn about
"Microsoft Excel is waiting for another application to complete an OLE action",
after this point it seems that the python side of things has a problem with returning data to Excel.
I have seen suggestions to use DisplayAlert and the like but this doesn't seem to work. What has worked for me though is co registering a message filter and…
0 votesapp.display_alerts = False should do, see: https://github.com/xlwings/xlwings/issues/120