win32com.client <unknown>.Cells

[gall.pavgal.gall at gmail.com]

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 --> {0}".format(row)
             print "col --> {0}".format(col)
             print "value --> {0}".format(value)
             old_val = s_config.Cells(row+1,col).Value
             s_config.Cells(row+1,col).Value = value
             s_config.Cells(row+1,col).Interior.ColorIndex = 8 # change fon color of CELL
             
         except Exception as err: print err

So, it's work :)

But, when i try call this function from Class, i get error :

row --> 36
col --> 18
value --> 34.99
<unknown>.Cells
row --> 36
col --> 19
value --> 39.99
<unknown>.Cells
127.0.0.1 - - [09/Oct/2015 21:44:47] "POST /cscox-99988 HTTP/1.1" 500 -
Traceback (most recent call last):
  File "C:\Python27\lib\site-packages\flask\app.py", line 1836, in __call__
    return self.wsgi_app(environ, start_response)
  File "C:\Python27\lib\site-packages\flask\app.py", line 1820, in wsgi_app
    response = self.make_response(self.handle_exception(e))
  File "C:\Python27\lib\site-packages\flask\app.py", line 1403, in handle_exception
    reraise(exc_type, exc_value, tb)
  File "C:\Python27\lib\site-packages\flask\app.py", line 1817, in wsgi_app
    response = self.full_dispatch_request()
  File "C:\Python27\lib\site-packages\flask\app.py", line 1477, in full_dispatch_request
    rv = self.handle_user_exception(e)
  File "C:\Python27\lib\site-packages\flask\app.py", line 1381, in handle_user_exception
    reraise(exc_type, exc_value, tb)
  File "C:\Python27\lib\site-packages\flask\app.py", line 1475, in full_dispatch_request
    rv = self.dispatch_request()
  File "C:\Python27\lib\site-packages\flask\app.py", line 1461, in dispatch_request
    return self.view_functions[rule.endpoint](**req.view_args)
  File "D:\WebPython\new\main.py", line 36, in cust_dir
    return define_ID(cscoxId=cscoxId,upload_folder=app.config['UPLOAD_FOLDER'], request=request)
  File "D:\WebPython\new\utils.py", line 51, in define_ID
    return upload_file(session['customer_dir'][0],request)
  File "D:\WebPython\new\utils.py", line 61, in upload_file
    run_exel( config_file=session['config_file'],customer_dir=session['customer_dir'][0],customer_file=os.path.join(upload_folder, filename),log_name=session['cox_id'])
  File "D:\WebPython\new\utils.py", line 84, in run_exel
    customer.merge_to_config()
  File "D:\WebPython\new\main.py", line 119, in merge_to_config
    excel_book.Save()
  File "<COMObject Open>", line 2, in Save
    
com_error: (-2147221008, 'CoInitialize has not been called.', None, None)

Please, help me! :)