How to delete multiple columns for the attached excel here , Below are the options are tried
- Used Filter Data Table- I have provided the column name in the Filter Wizard- Output column-Remove. It does remove only the header not the entire column.
2.Similar way tried for the Remove Data column. Attached the sample xaml herewith.This also remove the header of the column not the entire column,
3.Tried with Default view also like this dt = dt.DefaultView.ToTable(False, “Column1”, “Column2”, “Column3”), This also not deleting the column,instead the second column name override the first column.
Requirment: To delete the multiple columns in excel. In the attached excel, I want to delete the course and fee. It will be helpful if you could share the xaml file.Main.xaml (11.3 KB)