python - Writing to an open excel file

Question

I want to write to an open excel sheet. I did this:

import win32com.client

app = win32com.client.GetActiveObject("Excel.Application")

but got errors:

AttributeError: module 'win32com.gen_py.00020813-0000-0000-C000-000000000046x0x1x9' 
  has no attribute 'CLSIDToClassMap'

Can someone please help?

Answer 1

Try to use:

import win32com.client
app = win32com.client.gencache.EnsureDispatch('Excel.Application')