Write Range from linq

Hi all, I have a bot that filters an excel table for me and provides me with the filtered data for a new table.
Before it writes the data into a new table, I want it to check if there is already a table that matches the new one.

If so, it should check via read column whether the ID is already in the new table. If the ID is not yet in the new table, it should add it.

My current problem is that it always completely overwrites the new table instead of adding the new row, who can help me with this?

Add Data

Hi @NHoe

Check wheather there is Count in Dt which Youre going to write the data

IF DT.Rows.Count>0

Then Part —>Append Range

Else part—>Write Range


Thank you, that was the solution!

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.