I am trying to extract data from an excel file, according to a specific condition and then store it in another excel file.
- I am able to read all data from the ‘Companies Dataset’ excel file and store it to a data table.
- Using For Each Row from data table and using the If condition, I then try to Add Data Row in a new data table. But at this point I am getting error msg.- Add Data Row: Object reference not set to an instance of an object.
My goal is to copy only selected data into a new excel file.