Datatable, Excel, RowNumber

[manikandan.murugan]

Hi Team,

I have a Data table mentioned below,

How to write the serial number as mentioned below,

Kindly help me to solve this.

Thanks in Advance

[ppr (Peter Preuss)]

the very essential approach:

• for each row in datatable | currentRow in dtDataVar - configure the index output: idx var
  • Assign Activity: currentRow(“SNo”) = idx + 1 OR as String (idx + 1).toString

[ppr (Peter Preuss)]

Alternate:

Adding Index Column in DataTable using LINQ

we can avoid the LINQ and achieve it by: Build DataTable - Configure an empty DataTable with 1 Col - RowNum, Configure AutoIncrement [grafik] dtMarked Then use a Merge DataTable Activity and merge your DataTable into dtMarked

And:

Adding Index Column in DataTable using LINQ

we can set the start value by: Assign Activity: dtMarked.Columns("RowNum").AutoIncrementSeed = 1 do it before the merge datatable

OR:
DataTable reconstruction and LINQ by using Enumerable.Range(…

[manikandan.murugan]

Thank you so much @ppr