Output in Excel Sheet

[Vijaylakshmi_2 (Vijaylakshmi R)]

Hi,
I have been getting the write data through excel, passing the output by append range workbooks. I am getting the output but not in a proper order, there a full empty row after each output data.
What can be the issue, where Is the code going wrong? Have attached an image below for clear understanding.

[Kismet_Tosun (Kısmet Tosun)]

Hi, @Vijaylakshmi_2

Strengthen the selectors

[pravallikapaluri]

Hi @Vijaylakshmi_2

before appending, ensure there are no extra rows with only whitespace characters or null values. You can filter the DataTable before appending.This removes rows where all columns are either empty or contain only whitespace.

DataTable = DataTable.AsEnumerable().Where(Function(row) Not row.ItemArray.All(Function(field) String.IsNullOrWhiteSpace(field.ToString()))).CopyToDataTable()

[lrtetala (Lakshman Reddy)]

Hi @Vijaylakshmi_2

Can you try with Filter Data Table activity

Regards,