版主,您好!如下表,新增行后ID列自动添加序列号,具体函数我在论坛上找到了,就是不清楚粘贴在哪里实现这个功能,谢谢!
Dim r As Row = Tables("华为衰减器数据上传表").InsertNew()
Dim idx As Integer = 1
If r.index > 0 Then
idx = Tables("华为衰减器数据上传表").rows(r.index - 1)("ID") + 1
End If
For i As Integer = r.index To Tables("华为衰减器数据上传表").rows.count - 1
Tables("华为衰减器数据上传表").rows(i)("ID") = idx
idx += 1
Next