datatable.DefaultView.ToTable(False,“Column Name”) does miss the last value

Help
1

Hi all,

I am trying to write a column of my datatable back in my excel using datatable.DefaultView.ToTable(False,“Column Name”). This works perfectly fine for all rows (including duplicates) except the last row where nothing is written back in my Excel.
If I use the output function and a write line activity I can see, that in my datatable this row and column the value is given like I want it to have, but somehow it does not get written back in my excel.

Can you help?

Thanks a lot

Natalie

1 Like
2

@natalievolkert

As per my understanding, it didn’t write last row values into Excel right ?

3

Hi @natalievolkert,

Check your write range activity if you have mentioned any range to write the data.

4

Yes exactly this is my problem

1 Like
5

@natalievolkert

Could you please show me screenshot of Write Range activity properties. So that we will check and help you.

6

Thanks,

image
This is how my write range looks

2 Likes
7

Thanks guys I found my mistake. It ist not in the write Range but beforehand when I filtered my Datatable with a skip. This somehow deleted my first row i needed to keep so it just was one row too short

1 Like
8

i hope the issue is with datatable
because write range will write what is given wiith
kindly check that once before write range activity
Cheers @natalievolkert

9

oh
thats the issue
fine
Cheers @natalievolkert

10

Dt.defaultview.totable(“col1”,“col”).copy