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
Brody
0 comments