按如下代码删除sqlquery中空行,不起作用.也可能是删除了以后没刷新?
With Tables("工资窗1_Table1") For i As Integer = .BottomPosition To .TopPosition Step -1 If .Rows(i)("人员名单")="" .Rows(i).Delete() End If NextEnd With