Jan 17, 2020 05:35 AM|ttprettycoder|LINK
I want to iterate through all the excel files in the D drive and come over the data to export an excel file.
If there are 3 excel files in D drive: test1.xlsx ,test2.xlsx and test3.xlsx,
I want to filter these all data from excel files which TYPE=2,and then export one excel file to show
Name ,Excel NAME and TYPE,like
I'll be very grateful if someone can help me.