|
不知道你的要求是什么,感觉像是练习题,因为又是空串,又是中文逗号,又是英文逗号分隔符,又是引号,又是日期换文本格式,又是字符串中含不可见空格,又是某些列不取,只能一会Print一会write。。。。。。。。附件供参考
Sub Demo()
Dim Arr, i&, j&, FileNum As Integer
Arr = ActiveSheet.Range("A2").CurrentRegion
FileNum = FreeFile
Open ThisWorkbook.Path & "\" & ThisWorkbook.Name & ".Txt" For Output As #FileNum
For i = 2 To UBound(Arr)
Write #FileNum, Format(Arr(i, 1), "yyyy-m-dd");
Print #FileNum, Chr(34); Arr(i, 2); Chr(34); ",";
Write #FileNum, Trim(Str(Arr(i, 3)));
Print #FileNum, ","; ","; ",";
Write #FileNum, Trim(Str(Arr(i, 5)));
Print #FileNum, ","; ","; ","; ","; ","
Next
Close #FileNum
End Sub
|
评分
-
1
查看全部评分
-
|