wps表格中,如下图从左边的格式变成右边的格式要怎么批量处理,数据量比 ...答:Private Sub CommandButton1_Click()Range("e2:f20000").Select Selection.ClearContents i = 2 y = 2 Do While Cells(i, 2) <> ""If InStr(Cells(i, 3), ",") > 0 Then a = Split(Cells(i, 3), ",")For r = 0 To UBound(a)Cells(y, 5) = Cells(i, 2)Cells(y, 6)...