后面的UNION 不知道要怎么样删除
Dim MergeStr As new StringBuilder
Dim MergeCell As String
For i As Integer = 0 To 10000
MergeStr.AppendLine( "se le ct " & i & " UN IO N ")
Next
Dim v As String
v = mergestr.ToString()'将合并好的字符串转换成单个的字符串
If v.EndsWith(Chr(10))
V = V.TrimE nd(Chr(10))
v = v.TrimEnd(" ")
v = v.TrimEnd("N")
End If
Output.Show(v)
显示结果是:sel ec t 9696 UNION
se lect 9697 UN IO N
se lec t 9698 U NIO N
se lect 9699 UN ION