Adding Index Column in DataTable using LINQ

[vrdabberu (Varunraj Dabberu)]

Hi @NILESH.BOT369

→ Build Data Table

Output-> outputDataTable

→ Read Range Workbook

Output-> dt

→ Use Below syntax in Assign:

outputDataTable = (From row In dt.AsEnumerable()
                   Let indexValue = dt.Rows.IndexOf(row) + 1
                   Let orderAmountString = row("Order Amount").ToString().Replace("₹", "").Trim().Replace(",","").Trim()
                   Let orderAmount As Integer = If(Integer.TryParse(orderAmountString, Nothing), Convert.ToInt32(orderAmountString), 0)
                   Select outputDataTable.Rows.Add(indexValue, row("Order Number").ToString(), row("Name").ToString(), row("City").ToString(), row("ID").ToString(), orderAmount)).CopyToDataTable()

→ Write Range Workbook

Regards