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
I think you ll need to use Append Range instead of Write Range.
can you provide more information or share the xaml.
if i use append range i can’t add headers
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.