I have a form in excel where each column is a response. Having read the excel, based on the status (3rd row) of each response (column), I would like to add columns marked as ready to a data table to be processed. Any ideas on how best to do this would be much appreciated!
Are you trying to add a new column to data table based on a value from existing column ?
If yes, then you need to read the excel,
loop through it, use if condition (ex. row(3).toString.equals("yourresponse))
then assign the rows to new data table.
Then finally write it to a new excel sheet.