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
-
Add cell formatting features
- Set foreground color (background color already exists)
- Cell alignment
- Set font size
- Bold, Italics, Underline, etc
40 votes -
29 votes
-
25 votes
We don’t have OO/LO on our roadmap anytime soon. But we would love to hear some feedback about pyoo.
-
UDF for Excel for Mac 2016
Similar to the functionality developed for windows
16 votes -
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/ColumnsNice to Have:
Create slicers
Creating PivotCharts
Formatting/Grouping of Data15 votes -
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 -
9 votes
-
7 votes
Reopening this as with Win Excel >2013 it’s possible to create a Bokeh app in theory…
-
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 -
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 -
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 -
4 votes
-
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 -
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 automatisation3 votes -
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 -
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 votesCould you give please a concrete example of a table that currently doesn’t get read in correctly? thanks!
-
3 votes
volatile is now available with v0.10.3, I am going to take it out of this idea
-
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 -
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 votesThe 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.
-
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