Regarding excel

[Kurra_Kranthi]

Hi @arivu96, In my excel we need to add two columns and result should print to next column but I’m getting the following result.
Please find the attachment.
Thanks.

[KarthikByggari]

@Kurra_Kranthi

Remove rowsCount from Expression. Just “C1:C11” is sufficient if no.of rows are fixed.
If number of rows are dynamic use the expression “C1:C” + rowsCount

Regards.
Karthik Byggari

[arivu96 (Arivazhagan A)]

Hi @Kurra_Kranthi,

Try below code
"C1:C" + rowsCount .ToString()

send your xaml file i ll check and give the best solution for ur process.

Regards,
Arivu

[Kurra_Kranthi]

@KarthikByggari Thanks its working!

[Kurra_Kranthi]

@arivu96 last row is missing.Please find the attachment.

[arivu96 (Arivazhagan A)]

Can you send ur xaml file I ll check and update you.

Regards,
Arivu

[Kurra_Kranthi]

sum_excelDT.xaml (7.2 KB)

[arivu96 (Arivazhagan A)]

Hi @Kurra_Kranthi,

Excel sheet doesn’t have the headers but in the read range you have checked the add headers property that’s why you are not getting the result for the last row. uncheck and try again

Regards,
Arivu

[Kurra_Kranthi]

Yea, sure