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?

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

---

Hans Passant.

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

---

Hans Passant.

Try with GemBox spreadsheet component