Re: win32com.client .Cells

2015-10-12 Thread Chris Angelico
On Tue, Oct 13, 2015 at 1:37 AM, Michiel Overtoom wrote: > Hi, > >> excel_book=Excel.Workbooks.Open('D:\WebPython\Config3.xlsx') > > Shouldn't this be: > > excel_book=Excel.Workbooks.Open('D:\\WebPython\\Config3.xlsx') > or > excel_book=Excel.Workbooks.Open(r'D:\WebPython\Config3.xlsx') >

Re: win32com.client .Cells

2015-10-12 Thread Michiel Overtoom
Hi, > excel_book=Excel.Workbooks.Open('D:\WebPython\Config3.xlsx') Shouldn't this be: excel_book=Excel.Workbooks.Open('D:\\WebPython\\Config3.xlsx') or excel_book=Excel.Workbooks.Open(r'D:\WebPython\Config3.xlsx') ? -- https://mail.python.org/mailman/listinfo/python-list

Re: win32com.client .Cells

2015-10-12 Thread pupsik kc
Very Thanks Irmen! It's helped me. -- https://mail.python.org/mailman/listinfo/python-list

Re: win32com.client .Cells

2015-10-09 Thread Irmen de Jong
On 9-10-2015 20:45, [email protected] wrote: > Hi Guys, > > i wrote small function : > > Excel = win32com.client.Dispatch("Excel.Application") [...] > com_error: (-2147221008, 'CoInitialize has not been called.', None, None) > > Please, help me! :) > First hit on google when search

win32com.client .Cells

2015-10-09 Thread gall . pavgal . gall
Hi Guys, i wrote small function : Excel = win32com.client.Dispatch("Excel.Application") excel_book=Excel.Workbooks.Open('D:\WebPython\Config3.xlsx') s_config=excel_book.Worksheets('VA Prices') def writtenCell(row,col,value): try: global s_config print "row --