680
社区成员
发帖
与我相关
我的任务
分享
String ls_SaveName, ls_Named, ls_Str
Int li_ExcelOk, li_Net
OleObject ExcelServer
ExcelServer = CREATE OleObject
li_ExcelOk = ExcelServer.ConnectTonewObject("excel.application")
IF li_ExcelOk <> 0 THEN
MessageBox( "信息提示", "连接EXCEL失败,请检查计算机中是否安装了EXCEL!" )
RETURN
END IF
li_Net = GetFileOpenName("选择文件", ls_SaveName,ls_Named,"xls","Excel文件(*.xls),*.xls")
IF li_Net > 0 THEN
IF ls_SaveName = "" THEN RETURN
ExcelServer.WorkBooks.Open(ls_SaveName)
//把excel内容复制到剪贴板
ExcelServer.ActiveSheet.Cells.Copy
ls_Str = Clipboard("")
//在这操作ls_Str,查找替换
//ls_str = 'asa1~r~nasd'
//把替换后的ls_Str赋到剪贴板
Clipboard( ls_Str )
ExcelServer.Application.Cells.Select
ExcelServer.Application.Selection.ClearContents
ExcelServer.Application.Range("A1").Select
ExcelServer.ActiveSheet.Paste
ExcelServer.ActiveWorkbook.Save()
ExcelServer.Quit()
ExcelServer.DisConnectObject()
Destroy ExcelServer
ELSE
MessageBox('信息提示','没有指定文件!')
RETURN
END IF
MessageBox( '', 'OK' )