Skip to content

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

  1. 17 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

  2. 15 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

  3. 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 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

  4. 9 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

  5. 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 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Admin →
  6. 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 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

  7. 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 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

  8. 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 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Admin →
  9. 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 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

  10. 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 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

  11. udf decorator

    Import @xlfunc idea from ExcelPython.

    It is easy and pythonic...

    5 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

  12. 3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

  13. 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 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

  14. directly return dataframe in UDF

    directly return dataframe in UDF

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

  15. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    completed  ·  0 comments  ·  Admin →
  16. There is no feature to open password-protected files.

    One can not programmatically open a password-protected file.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    completed  ·  0 comments  ·  Admin →
  17. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    completed  ·  3 comments  ·  Admin →
  18. 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 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

xlwings

Categories

Feedback and Knowledge Base