After that i am writing it to an Excel using Write Range workbook activity. but the excel formula is pasted as String value instead of Row number. Attached screenshot for your reference.
Instead of using add data column default value. once we done with the write range open the excel file and use write cell to write the following formula =Row() and use autofill range formula to get your desired value. thanks.
it was partly replicable. With an update to the EXCEL Activities (Package Manager) Version 2.11.4 it was working in a first test round, when using the English function name at a non-english localized Excel
@Srini84 & @kirankumar.mahanthi1 - we cannot do write cell which makes the process too complex because we have dictionary<string, Datatable>. and we are adding this formula as default value while adding new column.
@ppr - I have tried updating the latest Excel Activities package and also using English function name. But still same issue.
Thank you all for your valuable feedback. we have planned to go with DB instead of spreadsheet.
Since there is no solution, I can’t close this ticket.