Data is added in 3rd row in excel file

Help Activities
1

Hi, i have a scenario where the data is added in 3rd row instead of 2nd row… Used build data tables, add data rows & write range activities
Find the screen shot fyr…

IMG_20230817_122327
IMG_20230817_1223271920×1440 475 KB

IMG_20230817_122353
IMG_20230817_1223534160×3120 1.95 MB

Plz suggest me correct approach…

2

@Somanath_Somu

image

Remove the rows in the build datatable

3

May be that is because of one extra row
image

4

May I know Did you write the column header in excel sheet seperately?

5

Removed, but still same

6

Nope not added in excel file

8

image
Can u try this

Regards,

9

Hi @Somanath_Somu

can you share the entire row screenshot in the excel

as i think you are getting only some values starting form Column R
in the third row right ?

10

Hi @Somanath_Somu ,

Input
image

Output
image

Workflow
image

Use assign activity

dt.Rows(0).ItemArray = dt.Rows(1).ItemArray

Thanks,

11

Any Updates? @Somanath_Somu

12

hi @Somanath_Somu

can you this before write and place the variable in the datatable of writerange

dt.AsEnumerable.Where(function(row) Not row.ItemArray.Any(Function(col) String.IsNullOrEmpty(col.ToString))).CopyToDataTable