Using data filter add multiples times the same information in my excel file

[Soudios (Sou)]

I want to use data filter to remove empty rows but when i use it it add multiples times the same information

[Palaniyappan (Forum Leader)]

Hi

Make sure you are using the output datatable obtained from filter datable and not any other table
But still

Did this thread help you resolve this

Removing empty rows from excel sheet or datatable

hi can you tell me the simplest way that how to remove empty row from excel sheet ?? i have implemented the below way but i want simplest way from below solution abc.xlsx (11.4 KB) Main.xaml (16.1 KB)

Cheers @Soudios

[Soudios (Sou)]

@Palaniyappan

i tried but it doesnt work for me, i need to create the excel file and then i need to remove the empty rows

[Palaniyappan (Forum Leader)]

@Soudios

need to create the excel file and then i need to remove the empty rows

Yeah the above tagged post works in other way like first it removes the empty rows in the datatable and then will be written to excel

@Soudios