locked
Writing to excel file RRS feed

  • Question

  • I would like to write to excel spreadsheets from a 64 bit application.

    I have researched the problem of using jet OLE DB drivers to write to excel spreadsheets in 64 bit.  The solution to this is simple:  there are no OLE DB drivers for 64 bit!  Compiling my application with the target platform of x86 is not a solution at all.  I would no longer be running a 64 bit application, so I do not consider this viable.  I do not care to run the app under WOW64.

    I have heard one reasonable suggestion (http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/213b90cb-5aea-41be-b935-fa995b6322ca/).  This is to create a 32 bit process which acts as an middle man between the excel file and the 64 bit application.  Simply put, you would use your own 32 bit windows service to expose a remoting object to do the writing for you.  Clever, but it seems ugly.

    Is there any conceivable way to write to excel from a 64 bit app?

    Thursday, August 27, 2009 6:17 PM

Answers

  • Yes, use the classes in the Microsoft.Office.Interop.Excel namespace.  Ask questions about it in an Office development newsgroup or forum.

    Hans Passant.
    • Marked as answer by eryang Thursday, September 3, 2009 6:20 AM
    Friday, August 28, 2009 1:59 AM
    Moderator