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
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
0 comments