导出excel到csv
导出excel到csv
提问于 2013-07-26 01:52:25
我想将数据从excel复制到。下面是我要复制数据的方式。例如，我希望将excel的单元格G4中的数据复制到csv中的A4中。
"Excel ---> CSV
"D4-->A4
"F4&all excluding the first character in G4-->B4
"K4-->E4
"L4-->F4
"N4-->G4
"P4-->I4下面是我的密码。它根据我的需要创建和填充数据，除非它在复制到G4中的B4时不会删除csv中的第一个字符。有人能告诉我如何改变我的代码来实现这一点吗？
Sub csvfile()
Dim fs As Object
Dim a As Object
Dim lngRow As Long
Dim X
Set fs = CreateObject("Scripting.FileSystemObject")
Set a = fs.CreateTextFile("C:\temp\" & Environ("username") & ".csv", True)
X = Range([d4], Cells(Rows.Count, "P").End(xlUp)).Value2
For lngRow = 1 To UBound(X) - 15
a.writeline X(lngRow, 1) & "," & X(lngRow, 3) & X(lngRow, 4) & ",,," & X(lngRow, 8) & "," & X(lngRow, 9) & "," & X(lngRow, 11) & ",," & X(lngRow, 13)
Next
a.Close
End Sub回答 1
Stack Overflow用户
回答已采纳
发布于 2013-07-26 01:56:37
您可以像这样操作第四列(G)：
全码
Sub csvfile()
Dim fs As Object
Dim a As Object
Dim lngRow As Long
Dim X
Set fs = CreateObject("Scripting.FileSystemObject")
Set a = fs.CreateTextFile("C:\temp\" & Environ("username") & ".csv", True)
X = Range([d4], Cells(Rows.Count, "P").End(xlUp)).Value2
For lngRow = 1 To UBound(X) - 15
If Len(X(lngRow, 4)) > 0 Then X(lngRow, 4) = Right$(X(lngRow, 4), Len(X(lngRow, 4)) - 1)
a.writeline X(lngRow, 1) & "," & X(lngRow, 3) & X(lngRow, 4) & ",,," & X(lngRow, 8) & "," & X(lngRow, 9) & "," & X(lngRow, 11) & ",," & X(lngRow, 13)
Next
a.Close
End Sub页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/17871618
复制相关文章
相似问题
腾讯云开发者
