ActiveX/Office
-
자동화 - 파이썬ActiveX/Office 2017. 9. 11. 22:04
import win32com.clientexcel = win32com.client.Dispatch("Excel.Application")excel.Visible = Truewb = excel.Workbooks.Add()ws = wb.Worksheets("Sheet1")ws.Cells(1, 1).Value = "..."wb.SaveAs('...')excel.Quit() import win32com.clientexcel = win32com.client.Dispatch("Excel.Application")excel.Visible = Truewb = excel.Workbooks.Open('...')ws = wb.ActiveSheet... ws.Cells(1, 1).Value ...excel.Quit() 참조 사이..
-
자동화 - MFCActiveX/Office 2009. 8. 8. 22:30
* 엑셀 // to automate Microsoft Excel 97, Excel 2000, or Excel 2002 1. 새로운 MFC 어플리케이션 프로젝트를 생성한다. 2. 자동화 서버의 타입 라이브러리로 부터 래퍼 클래스(IDispatch)를 생성한다. Microsoft Excel 97 Microsoft Excel 8.0 Object Library // Excel8.olb, excel8.h Microsoft Excel 2000 Microsoft Excel 9.0 Type Library C:\Program Files\Microsoft Office\Office\Excel9.olb // excel9.h Microsoft Excel 2002 // OfficeXP Microsoft Excel 10.0 Typ..
-
Add-In - C++ActiveX/Office 2009. 8. 8. 22:26
IDTExensibility2 the Microsoft Add-In Designer Type Library (Msaddndr.dll) OnConnection OnDisconnection OnAddInsUpdate a COM add-in is installed or removed OnStartupComplete OnBeginShutdown ComAddin.h 참조 사이트: http://support.microsoft.com/kb/230689/en-us/