致力于测试团队建设和自动化测试开发,欢迎有兴趣者一起研究讨论
text文件按要求将数据写入Excel
上一篇 /
下一篇 2008-06-27 18:34:21
/ 个人分类:QTP
51Testing软件测试网x
rr*X&k开发给过来的数据都是text格式,密密麻麻,可读性很差,没办法,只好自己做一个脚本,将text内容按自己要求写入到Excel中去
1qv:Pw#@?x0
Cqb/] GY(f/P s eb0Code如下:
*V#_
MYGX0
51Testing软件测试网brN&c`U1J7h
w
`Wo
0B'eY8G;PEz0Function TextToExcel(TxtFile , ExcelFile)51Testing软件测试网$l|/["}}*} ^*q
}9N
'TxtFile:需要转换的Text文件路径
#hv1l&GJp0 'ExcelFile:转换后的Excel文件路径
W
{5`8La _-t0 Const ForReading = 1 51Testing软件测试网-|@X^%D|v
$Xgk_0oN%E@M0 '创建对象51Testing软件测试网^ F#win"Yc*J
Set fso=createobject("scrīpting.filesystemobject")
;pu BXpu"dz0 Set ExcelBook = CreateObject("Excel.Application")
7Y(B^.k7OlO!t0 Set ExcelSheet = CreateObject("Excel.Sheet")
E:]S ]f@0
T(Oozt qg0 '打开一个文本文件
AOQGBD'[g0 Set f1=fso.opentextfile(TxtFile, ForReading)51Testing软件测试网'G)yVF|
$w3x/O%a(Z0 '读取改文件所有内容51Testing软件测试网|*B&w7ZuA4c
51Testing软件测试网daG!Xz;S^ temp= f1.ReadAll
VG!Ot_;Y tn0 51Testing软件测试网"LE4RV&H
'按需要进行处理51Testing软件测试网(x'v+xbLV(c
Arr = Split(temp , ",")51Testing软件测试网[9oC6zl5B4SM!x
51Testing软件测试网.yPN6{E3}51Testing软件测试网Y&@m\y3[9wDC(lv
If fso.FileExists(ExcelFile) Then
&aUx|rMV0 fso.DeleteFile ExcelFile , True
!b-X4o$a,vt\$fy0 End If51Testing软件测试网Ze FPq+F
51Testing软件测试网r1X#w
~5Y
Mq1x ExcelSheet.Application.visible = False51Testing软件测试网{*`\,ecoNv
51Testing软件测试网Rk7cHN'pD
v
'将内容逐个写入Excel中
UaY'kWsU#g^ a'x0 For i = LBound(Arr) To UBound(Arr)51Testing软件测试网1].~k~s2B:j
{
ExcelSheet.Activesheet.Cells(i+1 , 1).value = Arr(i)
%j4l+S#{4e ^0 Next51Testing软件测试网5Tyc-ZVf
51Testing软件测试网
l z4a0^I#`^ ExcelSheet.SaveAs ExcelFile51Testing软件测试网A3U:{D1rl.KKD
h
l
ExcelBook.Quit
w;m}x#z$`,r0
7A4Ixt5pf0 '释放对象51Testing软件测试网4?"a5r$l.F1B,g3[z'Q
Set MyExcelSheet = Nothing
2MP3[v,dn^0 Set MyExcelBook = Nothing
l1[!}KQqs0gs d0 Set ExcelSheet = Nothing
.g`L,U,o0QKu0PCxV0 Set ExcelBook = Nothing
!wn&S9k n ~q,j0 Set f1 = Nothing
{J l8}*w;um,s
G0 Set fso = Nothing
#FtMz(i8r"hx J1WO0End Function51Testing软件测试网7_V2I;o F} DV
收藏
举报
TAG:
QTP