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_year = data.sheets['Sheet1'].copy(name='2022')
I need something like