Extra Rows in Excel

[Sahil_Goyal]

Hi Experts,
I recently faced a problem in which whenever I am trying to print the data in a Datarow corresponding to the next column, the data is coming in the next line from where the data in the present column is ending. I am using for each in which, For each data I am using DataTable.Newline of that particular row in which I want to print my Data.
The output that I don’t want:

The Output I want:

I am doing it like this:

Please look and help

[Divyashreem (Divyashree Muddagangaiah)]

add data row will append the data to the table, if you are iterating and getting each columns at once hence use add data column instead of add data row.

[Sahil_Goyal]

Hi There,
Can we iterate through the rows while adding data column?

[Divyashreem (Divyashree Muddagangaiah)]

Yes, you can.