Excel Example

[Guest]

Hello, I am trying to follow along with Microsoft example of the different
ways to create an excel file
(http://support.microsoft.com/default.aspx?scid=kb;en-us;306023#12). The
article tells me to create a reference to the "Net" component "ADODB". I see
no name like this. I thought that this was accomplished by creating a using
statement pointing to System.Data. How do I create such a reference?

I did create a reference to the Microsoft.Excel object (library 10). I
added a using statement for "Microsoft.Office.Core;", I even created one
for "Microsoft.Office.Interop.Excel;", but every reference to the "Excel"
object highlights telling me "Namespace name 'Excel' could not be found are
you missing a directive? What using statement do I use to eliminate this
error?

Maybe this is related to the first issue.

Thanks in advance for your assistance!!!

 

[microsoft.news.com]

i just went through the samething. I had to copy the interop.excel.dll to my
project bin folder then I was OK.

 

[Guest]

That DLL is in my bin folder....

i just went through the samething. I had to copy the interop.excel.dll to my
project bin folder then I was OK.

 

[microsoft.news.com]

at the top of your code you need

using excel
using system.runtime.interopServices;
using System.Reflection;