Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,359,848
Community Members
 
Community Events
168
Community Groups

Copy hidden rows python

Hello,
I need help because I am working on an excel file and I need to copy paste only the filter result without the hidden cells.
Here is the beginning of my code.

import xlwings as xw

# Open workbook
#wb = xw.Book()
wb = r"C:\Users\user\Desktop\Project.xlsx"
data = xw.Book(wb)
ws_m = data.sheets['Data']
ws_m.api.Range("A2").CurrentRegion.AutoFilter(Field:=4,Criterial:="2022")
ws_year = data.sheets['Sheet1'].copy(name='2022')

 

I need something like

data.sheets['Data'].unmerge_Cells

 

Thank you

0 comments

Comment

Log in or Sign up to comment
TAGS

Atlassian Community Events