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

25 results found

  1. Add cell formatting features

    • Set foreground color (background color already exists)
    • Cell alignment
    • Set font size
    • Bold, Italics, Underline, etc
    40 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. 29 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. 25 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. UDF for Excel for Mac 2016

    Similar to the functionality developed for windows

    16 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. Pivottable Creation & Refresh

    Ability to designate a range of data to create/update a pivottable.
    Basic Needs:
    - Create/Refresh Data for PivotTable
    - Create Calculated Item/Fields
    - Designate Fields/Columns

    Nice to Have:
    Create slicers
    Creating PivotCharts
    Formatting/Grouping of Data

    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

  6. Add support for Excel RealTimeData (RTD)

    It would be nice if a UDF could return a Excel RealTimeData (RTD) object so that data could be streamed into excel. pyxll has something similar to this for example.

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

    1 comment  ·  Admin →
  8. 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 →
  9. support general python object as return type or argument in UDF

    Sometime, I want to UDF to return a general Python object in XL cell. And I can call other UDF with these object as argument. Something like "cached object " feature in pyxll.

    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

  10. Ctrl + D functionality in xlwings

    sometime I have an already existing sheet with formulas and specific format , I just want to update the sheet on a daily basis using a scheduled python script

    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. When transfering nan values to Excel, have them appear as #N/A instead of 65535.

    I know one can change nan values to None and get blanks in Excel, but it would be really great if nan were to translate to the #N/A error. Alternatively, provide some means of setting errors in Excel (preferably so that it can happen when transferring a range rather than cell by cell so it would be fast).

    4 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. 4 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. Add duplicate worksheet function

    Whenever you have a template inside the Workbook, which may be used to generate several worksheets having similar style a copy worksheet functionality would be great!

    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

  14. Command printing of a sheet through xlwings (pdf, printer,...)

    Would be great to command printing automatically
    I often use xlwings to generate report through an .xls predefined layout
    Printing would finish the automatisation

    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

  15. Automatically import a module with the same name of the excel file ending with .py

    this way you could avoid prefixing the code with import

    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

  16. Give the option to specify the behavior of .vertical / .horizontal

    Currently, .vertical and .horizontal work in such a way that as long as cell as contiguous, they will be read in. Sometimes people will separate information with an empty row, but the data still ought to be read in. It would be nice to be able to specify whether you would like to read up to the last filled in Cell, or if you would like to read up to the first empty Cell.

    Thanks

    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

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

  18. Allow colour to be set in a similar fashion to value (with Range)

    It would be good if colour (and other formatting) could be set in the same manner as value. For example setting Range("A1").color = [(0, 0, 0), (255, 0, 0), (0, 255, 0), (0, 0, 255)] would set the first 4 cells in the row to black, red, green, blue.

    It would be good to be able to run map functions on lists/series/dataframes to generate formatting. In my case I want to be able to mark positive/negative regression with color.

    It's possible to do this manually, but it is slow to iterate over all the cells in the data.

    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

  19. Connect to existing kernel

    When I open a workbook and run macro (with optimize connection=True) it creates a pythonw kernel (on Windows 7 and Office 2010).

    If I close the book and reopen it and run the macro, it creates another process, instead of connecting to existing one.

    If I keep closing and opening the workbook it creates several new pythonw kernels.

    If I connect to existing kernel I obtain two results:
    1) avoid memory and resource consumption
    2) use resident objects from previous calculations.

    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

    The behaviour you’re seeing is not the intended one and part of the reason why this feature is still labeled “experimental”. If you create your Workbook.caller() reference within a function in the python module, it should however correctly exit the pythonw process when leaving Excel. A full/proper integration of these two librararies (xlwings/ExcelPython) is one of the next planned steps though.

  20. Allow clear() and clear_contents() on merged cells

    allow the .clear() and .clear_contents to operate on merged cells. Current workaround: range.api.MergeArea.ClearContents().

    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

    0 comments  ·  Admin →
← Previous 1

xlwings

Categories

Feedback and Knowledge Base