25 results found

1. Add a feature to hide columns or rows

   I am working on automation project and I think it would be amazing if there was a feature to hide columns/rows

   1 vote

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Edit…  ·  Delete…  ·  Admin →

2. Enable .number_format to accept array and array of arrays like .value

   I have an application that has to a lot of modifications to the numberformats based on data from an outside application and it is very slow in a Python loop. If .numberformat could accept an array of arrays in the same way that .value can it would speed up my application and simplify my processing. Thanks!

   1 vote

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Edit…  ·  Delete…  ·  Admin →

3. Add option opening a corrupted workbook

   Some of the workbooks I work with open as a corrupt workbook. To me there appears to be nothing wrong, but excel seems to think so. When opening these through a VBA macro, I use the "CorruptLoad:=xlExtractData" parameter, but in xlwings this throws a pywintypes.com_error message.

   1 vote

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Edit…  ·  Delete…  ·  Admin →

4. Better functionality on Table

   As a recent user to xlwings I think it is an amazing tool to link Excel and Python! However, when doing my little Python IO functions I had to tweak a few things that I believe could be part of the xlwing functionality:

   When you do the opposite and paste a Pandas DF into excel, you may find your value shave been changed because excel believes 0001234 is 1234 and 12345E7 is 12345x10^7. To avoid that I have to first select the range and make the format = "@". This could be sorted by adding a new argument so the cells take the format of the pandas' DF for instance. For instance:

   • Range("A1", format='@').value = df or maybe
   • Range("A1", format='fromdf').value = df

   PS: I also believe the default value of atleast_2d should be "True" to avoid rookie mistakes!

   As a recent user to xlwings I think it is an amazing tool to link Excel and Python! However, when doing my little Python IO functions I had to tweak a few things that I believe could be part of the xlwing functionality:

   When you do the opposite and paste a Pandas DF into excel, you may find your value shave been changed because excel believes 0001234 is 1234 and 12345E7 is 12345x10^7. To avoid that I have to first select the range and make the format = "@". This could be sorted by adding a new argument so the… more

   1 vote

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Edit…  ·  Delete…  ·  Admin →

5. Add support for embedding attachments (OLEObjects)

   win32com.client lets you use the com function for embedding obejects like so: wb.ActiveSheet.OLEObjects().Add(Filename=fname, Link=False)

   Would be nice to be able to do this sort of operation exclusively with xlwings instead of needing to hand control of a workbook back and forth between xlwings and win32com.

   Great tool, thanks!

   1 vote

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   1 comment  ·  Delete…  ·  Admin →