I am filtering an excel, I need to remove “-”, which has a value of “0”, with the Select dt.Select ("[Total] <> ‘0’") method. CopyToDatatable () I get error
Assign: Can’t find the [MARK] column could you help me. the name of the column is in G4
Can you share your excel sheet with sample data.
sorry the excel is a macro in the column apart from being duplicated the name in column 2 and 6 is not in cell 1 but in 4, until four are empty cells and the first one a numerical data