using Excel

[엑셀 프로그램 열어서 값 넣기]

>>> import win32com.client
>>> xl = win32com.client.Dispatch("Excel.Application")
>>> xl.Visible = True
>>> xl.Workbooks.Add()

>>> exl = xl.ActiveWorkbook.ActiveSheet

>>> exl.Cells(1,1).Value = 'abc'


[엑셀의 레인지 설정]

>>> import win32com.client
>>> xl = win32com.client.Dispatch("Excel.Application")
>>> exl = xl.ActiveWorkbook.ActiveSheet

>>> print exl.Range("B2:D2")
((1.0, 2.0, 3.0),)
>>> print exl.Range("B2:F3")
((1.0, 2.0, 3.0, 4.0, 5.0), (u'a', u'b', u'c', u'd', u'e'))
>>> print exl.Range(exl.cells(2,2), exl.cells(2,5))
((1.0, 2.0, 3.0, 4.0),)


[셀 병합 하기]

>>> print exl.Range(exl.cells(4,2), exl.cells(4,5)).Merge()