[python-win32] win32com + Excel + Django + Apache = problem

[user]

This line it's not a "copy past" from my source. In the code every path is
ok, I checked many times.

2011/1/26 Mike Mazurek <mike.mazurek at gmail.com>

> C:\\path\to\\file.xlsx" <-- you need another back slash before the "to"
>
> On Wed, Jan 26, 2011 at 9:09 AM, user <cricogik at gmail.com> wrote:
>
>>
>> Hello,
>>
>> I have some problems while opening Excel (via win32com) document in a web
>> application
>> running under Apache(mod_wsgi)/Windows 2008 Server (there is no
>> problem when the application is running on django developer server -
>> one thread).
>>
>> My code:
>>
>> def my_view(request):
>>       import pythoncom
>>       from win32com.client import DispatchEx
>>
>>       pythoncom.CoInitializeEx(pythoncom.COINIT_MULTITHREADED)
>>       xl = win32com.client.dynamic.Dispatch('Excel.Application')
>>       xl.DisplayAlerts = False
>>       xl.Visible = 0
>>       doc = xl.Workbooks.Open("C:\\path\to\\file.xlsx")
>>       doc.Saved = True
>>       ...
>>       doc.Close(SaveChanges=0)
>>       xl.Quit()
>>       pythoncom.CoUninitialize()
>>
>> Error message:
>>
>> (-2147352567, 'Exception occurred.', (0, u'Microsoft Office Excel',
>> u"Microsoft Office Excel cannot access the file 'C:\\path\to\
>> \file.xlsx'. There are several possible reasons: The file name or path
>> does not exist. The file is being used by another program. The
>> workbook you are trying to save has the same name as a currently open
>> workbook.", u'C:\\Program Files (x86)\\Microsoft Office\\Office12\
>> \1033\\XLMAIN11.CHM', 0, -2146827284), None)
>>
>> I know that problem is localized somewhere in threading, but where?
>> I'm using pythoncom.CoInitializeEx(pythoncom.COINIT_MULTITHREADED).
>> Maybe changing the server will solve the problem?
>>
>> Libs: Django 1.2, Apache 2.2 (mod_wsgi), win32com (latest)
>>
>> I hope somebody can help me.
>>
>> Thank You,
>> regards.
>>
>> _______________________________________________
>> python-win32 mailing list
>> python-win32 at python.org
>> http://mail.python.org/mailman/listinfo/python-win32
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-win32/attachments/20110126/1b322574/attachment.html>