can anybody copy datavalidation values to another excel sheet?

[neetesh kumar]

you can add in my code

import pandas as pd

import xlsxwriter

from openpyxl import load_workbook

import openpyxl

wb=openpyxl.load_workbook('D:/excel3/Men-Women Footwear (1) (2).xlsx')

ws=wb['Men']

dest_sheet = wb.create_sheet()

with pd.ExcelWriter('D:/excel3/Men-Women Footwear (1) (2).xlsx', engine='openpyxl') as writer:

    h=ws.data_validations.dataValidation

    for y in h:

        if y.type == "list":

        #print (y)

            t= str(y.sqref)

            a=y.formula1

            # print(a)

             

            

            # here give your data

        #print(t,y.promptTitle)

            try:

                dest_sheet[t] = "="+str(y.formula1)

             

            except: 

                continue 

        

        secondMockData ={a}

        secondMockDF= pd.concat([pd.DataFrame(dest_sheet[t]) for x in dest_sheet[t]],axis=1)

        print(secondMockDF)

        for row_data in secondMockDF.itertuples():

            for x in range(0,len(row_data)):

                dest_sheet.cell(row=dest_sheet.max_row,column=dest_sheet.max_column).value = row_data[x]  

    secondMockDF.to_excel(writer)

    writer.save()

wb.save("D:/nkiop.xlsx")