var
vExcel:Variant;
vBooks:Variant;
ActiveRange:Variant;
ComDrive:String;
OldStr,NewStr:String;
begin
OldStr := '1';
NewStr := '2';
ComDrive := 'Excel.application';
vExcel := CreateOLEObject( ComDrive );
VBooks := vExcel.workbooks.Open( 'c:\1.xls') ;
vExcel.Visible := true;
activeRange := vExcel.cells.find(OldStr);
activeRange.Replace(OldStr,NewStr,2,1,false);
如何判断系统没查到OldStr字符串? 对于没查到,ActiveRange是什么?
vExcel:Variant;
vBooks:Variant;
ActiveRange:Variant;
ComDrive:String;
OldStr,NewStr:String;
begin
OldStr := '1';
NewStr := '2';
ComDrive := 'Excel.application';
vExcel := CreateOLEObject( ComDrive );
VBooks := vExcel.workbooks.Open( 'c:\1.xls') ;
vExcel.Visible := true;
activeRange := vExcel.cells.find(OldStr);
activeRange.Replace(OldStr,NewStr,2,1,false);
如何判断系统没查到OldStr字符串? 对于没查到,ActiveRange是什么?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货