CSV文件格式有关问题 期待用VBA解决
CSV文件格式问题 期待用VBA解决
CSV文件用记事本打开 可以看到很多带双引号的数据.但用excel打开后 然后重新保存。再用记事本打开,这些双引号都没的了。想加入一些VBA脚本 实现在保存的时候把双引号保留下来,怎样实现?
保存前用记事本打开:
"DO_Date","M_Serial_No","S_Serial_No","MAC_Address","Model"
"20091028","ONT0095261","2102316708108A000085","56-70-B3-53-6C-98","T060G"
"20091028","ONT0095211","2102316708108A000054","56-70-B3-53-6C-99","T060G"
"20091028","ONT0095262","2102316708108A000079","56-70-B3-53-6C-10","T060G"
保存后.用记事本打开:(双引号不见了)
DO_Date,M_Serial_No,S_Serial_No,MAC_Address,Model
20091028,ONT0095261,2102316708108A000085,56-70-B3-53-6C-98,T060G
20091028,ONT0095211,2102316708108A000054,56-70-B3-53-6C-99,T060G
20091028,ONT0095262,2102316708108A000079,56-70-B3-53-6C-10,T060G
------解决方案--------------------
更正上帖
CSV文件用记事本打开 可以看到很多带双引号的数据.但用excel打开后 然后重新保存。再用记事本打开,这些双引号都没的了。想加入一些VBA脚本 实现在保存的时候把双引号保留下来,怎样实现?
保存前用记事本打开:
"DO_Date","M_Serial_No","S_Serial_No","MAC_Address","Model"
"20091028","ONT0095261","2102316708108A000085","56-70-B3-53-6C-98","T060G"
"20091028","ONT0095211","2102316708108A000054","56-70-B3-53-6C-99","T060G"
"20091028","ONT0095262","2102316708108A000079","56-70-B3-53-6C-10","T060G"
保存后.用记事本打开:(双引号不见了)
DO_Date,M_Serial_No,S_Serial_No,MAC_Address,Model
20091028,ONT0095261,2102316708108A000085,56-70-B3-53-6C-98,T060G
20091028,ONT0095211,2102316708108A000054,56-70-B3-53-6C-99,T060G
20091028,ONT0095262,2102316708108A000079,56-70-B3-53-6C-10,T060G
------解决方案--------------------
更正上帖
- VB code
Set fs = CreateObject("Scripting.FileSystemObject") Set a = fs.CreateTextFile("c:\testfile.csv", True) for r=1 to 65536 for c=1 to 256 v=sheet1.cells(r,c) if isempty(v) then exit for else if c=1 then a.Write("""" & v & """") else a.Write(",""" & v & """") endif end if next c a.WriteLine("") if c=1 then exit for next r a.Close Set a=Nothing Set fs=Nothing