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! :)
--
https://mail.python.org/mailman/listinfo/python-list
