Update excel sheet without over writing old value


#1

Hi,
iam using build table and adding to excel sheet
every time i run xaml it Updates excel sheet by over writing old value i don’t want my old data to be over written
can anyone help me out


#2

I think you ll need to use Append Range instead of Write Range.

can you provide more information or share the xaml.


#3

LMS_Tracker.xaml (38.8 KB)

it erases out data


#4

if i use append range i can’t add headers :unamused:


#5

For writing 1 value in excel use Write range… for subsequent values use append range…
this way you ll get the headers and data appended.


#6

Thank you :slight_smile: