C#-client using MS Word ?

[Chris]

Hi,

everything works apart from the last line :-((
rng.Value2.ToSt ring()

An exception is thrown : "Old format or invalid type library"
It gets compiled though (so he recognizes the property 'Value2').
So I suppose I'm using a incompatible type lib.

I'm using Excel 2002 : Excel 10.0 Object Library

Any ideas ? Maybe ... using another way to retrieve the value of a cell ?

thnx

Chris

"Arne Janning" <sp************ *****@msn.com> wrote in message
news:uH******** ******@TK2MSFTN GP09.phx.gbl...

Chris wrote:

Thanks a lot for that !!!

Chris

Hi Chris,

perhaps I should have been more precise when I wrote about "casting" the
OLEFormat to an Excel.Applicati onClass. This is not as easy as one
might think of. If you search for a solution, you won't find an answer.

http://groups.google.de/groups?q=OLE...bject%20dotnet

The cast is only possible if you activate the Ole-Object first. Below
please find the full source code for reading an the Value out of cell
"A1" in an Excel-Sheet that has been embedded inside a Word Document:

private void button1_Click(o bject sender, System.EventArg s e)
{
//C# cannnot handle optional params
object miss = Type.Missing;
//new Word.Applicatio n
Microsoft.Offic e.Interop.Word. ApplicationClas s app = new
Microsoft.Offic e.Interop.Word. ApplicationClas s();
//File we want to open
//Has to be an object for C#
object fileName = @"C:\\test.doc" ;
//open the file, use VB.NET in the future
DocumentClass doc = (DocumentClass) app.Documents.O pen(ref fileName,
ref miss, ref miss, ref miss, ref miss, ref miss, ref miss, ref miss,
ref miss, ref miss, ref miss, ref miss, ref miss, ref miss, ref miss,
ref miss);

//make Word visible
app.Visible = true;

//let's say our Excel-Sheet is the first Object in the document
Microsoft.Offic e.Interop.Word. OLEFormat ole =
doc.InlineShape s[1].OLEFormat;
string progID = ole.ProgID;
//it won't work without activating the Ole-Object first!!!
ole.Activate();
//for Excel 2003; just for security reasons. One can leave this away
if (progID == "Excel.Sheet.8" )
{
//cast the Ole-Object to an Excel.Workkook-Object
Workbook wbk = (Workbook) ole.Object;
//get a reference to the first sheet
Worksheet sht = (Worksheet) wbk.Worksheets[1];
//get Cell "A1"
Microsoft.Offic e.Interop.Excel .Range rng =
(Microsoft.Offi ce.Interop.Exce l.Range) sht.get_Range(" A1", "A1");
//show the value of "A1"
MessageBox.Show (rng.Value2.ToS tring());
}
}

You see that some of the Methods in C# look different from what we have
been using in Excel-VBA. Instead of simply using sht.Range("A1") you
have to use Microsoft.Offic e.Interop.Excel .Range rng =
(Microsoft.Offi ce.Interop.Exce l.Range) sht.get_Range(" A1", "A1")

Some good articles to start Programming Excel with C#:

"HOWTO: Automate Microsoft Excel from Microsoft Visual C# .NET"
http://support.microsoft.com/?id=302084

"HOW TO: Handle Events for Excel by Using Visual C# .NET"
http://support.microsoft.com/?id=302815

"HOW TO: Transfer XML Data to Microsoft Excel 2002 by Using Visual C#

.NET"

http://support.microsoft.com/?id=307029

"HOWTO: Create an Excel Macro Using Automation from Visual C# .NET"
http://support.microsoft.com/?id=303872

Cheers

Arne Janning

[Nicholas Paldino [.NET/C# MVP]]

Chris,

What version of Excel are you running this against?
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"Chris" <ch********@pan dora.be> wrote in message
news:p3******** **************@ phobos.telenet-ops.be...

Hi,

everything works apart from the last line :-((
rng.Value2.ToSt ring()

An exception is thrown : "Old format or invalid type library"
It gets compiled though (so he recognizes the property 'Value2').
So I suppose I'm using a incompatible type lib.

I'm using Excel 2002 : Excel 10.0 Object Library

Any ideas ? Maybe ... using another way to retrieve the value of a cell ?

thnx

Chris

"Arne Janning" <sp************ *****@msn.com> wrote in message
news:uH******** ******@TK2MSFTN GP09.phx.gbl...

Chris wrote:

> Thanks a lot for that !!!
>
> Chris
>
Hi Chris,

perhaps I should have been more precise when I wrote about "casting" the OLEFormat to an Excel.Applicati onClass. This is not as easy as one
might think of. If you search for a solution, you won't find an answer.
http://groups.google.de/groups?q=OLE...bject%20dotnet

The cast is only possible if you activate the Ole-Object first. Below
please find the full source code for reading an the Value out of cell
"A1" in an Excel-Sheet that has been embedded inside a Word Document:

private void button1_Click(o bject sender, System.EventArg s e)
{
//C# cannnot handle optional params
object miss = Type.Missing;
//new Word.Applicatio n
Microsoft.Offic e.Interop.Word. ApplicationClas s app = new
Microsoft.Offic e.Interop.Word. ApplicationClas s();
//File we want to open
//Has to be an object for C#
object fileName = @"C:\\test.doc" ;
//open the file, use VB.NET in the future
DocumentClass doc = (DocumentClass) app.Documents.O pen(ref fileName, ref miss, ref miss, ref miss, ref miss, ref miss, ref miss, ref miss,
ref miss, ref miss, ref miss, ref miss, ref miss, ref miss, ref miss,
ref miss);

//make Word visible
app.Visible = true;

//let's say our Excel-Sheet is the first Object in the document
Microsoft.Offic e.Interop.Word. OLEFormat ole =
doc.InlineShape s[1].OLEFormat;
string progID = ole.ProgID;
//it won't work without activating the Ole-Object first!!!
ole.Activate();
//for Excel 2003; just for security reasons. One can leave this away if (progID == "Excel.Sheet.8" )
{
//cast the Ole-Object to an Excel.Workkook-Object
Workbook wbk = (Workbook) ole.Object;
//get a reference to the first sheet
Worksheet sht = (Worksheet) wbk.Worksheets[1];
//get Cell "A1"
Microsoft.Offic e.Interop.Excel .Range rng =
(Microsoft.Offi ce.Interop.Exce l.Range) sht.get_Range(" A1", "A1");
//show the value of "A1"
MessageBox.Show (rng.Value2.ToS tring());
}
}

You see that some of the Methods in C# look different from what we have been using in Excel-VBA. Instead of simply using sht.Range("A1") you
have to use Microsoft.Offic e.Interop.Excel .Range rng =
(Microsoft.Offi ce.Interop.Exce l.Range) sht.get_Range(" A1", "A1")

Some good articles to start Programming Excel with C#:

"HOWTO: Automate Microsoft Excel from Microsoft Visual C# .NET"
http://support.microsoft.com/?id=302084

"HOW TO: Handle Events for Excel by Using Visual C# .NET"
http://support.microsoft.com/?id=302815

"HOW TO: Transfer XML Data to Microsoft Excel 2002 by Using Visual C#

.NET"

http://support.microsoft.com/?id=307029

"HOWTO: Create an Excel Macro Using Automation from Visual C# .NET"
http://support.microsoft.com/?id=303872

Cheers

Arne Janning

[Chris]

Hi Nicolas,

I'm using Excel 2002 (10.2614.3501) SP1
Excel 10.0 Object Library

Chris

"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard .caspershouse.c om> wrote in
message news:eg******** ******@TK2MSFTN GP11.phx.gbl...

Chris,

What version of Excel are you running this against?
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"Chris" <ch********@pan dora.be> wrote in message
news:p3******** **************@ phobos.telenet-ops.be...

Hi,

everything works apart from the last line :-((
rng.Value2.ToSt ring()

An exception is thrown : "Old format or invalid type library"
It gets compiled though (so he recognizes the property 'Value2').
So I suppose I'm using a incompatible type lib.

I'm using Excel 2002 : Excel 10.0 Object Library

Any ideas ? Maybe ... using another way to retrieve the value of a cell ?

thnx

Chris

"Arne Janning" <sp************ *****@msn.com> wrote in message
news:uH******** ******@TK2MSFTN GP09.phx.gbl...
> Chris wrote:
>
> > Thanks a lot for that !!!
> >
> > Chris
> >
> Hi Chris,
>
> perhaps I should have been more precise when I wrote about "casting"

the > OLEFormat to an Excel.Applicati onClass. This is not as easy as one
> might think of. If you search for a solution, you won't find an answer. >
> http://groups.google.de/groups?q=OLE...bject%20dotnet
>
> The cast is only possible if you activate the Ole-Object first. Below > please find the full source code for reading an the Value out of cell > "A1" in an Excel-Sheet that has been embedded inside a Word Document: >
> private void button1_Click(o bject sender, System.EventArg s e)
> {
> //C# cannnot handle optional params
> object miss = Type.Missing;
> //new Word.Applicatio n
> Microsoft.Offic e.Interop.Word. ApplicationClas s app = new
> Microsoft.Offic e.Interop.Word. ApplicationClas s();
> //File we want to open
> //Has to be an object for C#
> object fileName = @"C:\\test.doc" ;
> //open the file, use VB.NET in the future
> DocumentClass doc = (DocumentClass) app.Documents.O pen(ref fileName, > ref miss, ref miss, ref miss, ref miss, ref miss, ref miss, ref miss, > ref miss, ref miss, ref miss, ref miss, ref miss, ref miss, ref miss, > ref miss);
>
> //make Word visible
> app.Visible = true;
>
> //let's say our Excel-Sheet is the first Object in the document
> Microsoft.Offic e.Interop.Word. OLEFormat ole =
> doc.InlineShape s[1].OLEFormat;
> string progID = ole.ProgID;
> //it won't work without activating the Ole-Object first!!!
> ole.Activate();
> //for Excel 2003; just for security reasons. One can leave this away > if (progID == "Excel.Sheet.8" )
> {
> //cast the Ole-Object to an Excel.Workkook-Object
> Workbook wbk = (Workbook) ole.Object;
> //get a reference to the first sheet
> Worksheet sht = (Worksheet) wbk.Worksheets[1];
> //get Cell "A1"
> Microsoft.Offic e.Interop.Excel .Range rng =
> (Microsoft.Offi ce.Interop.Exce l.Range) sht.get_Range(" A1", "A1");
> //show the value of "A1"
> MessageBox.Show (rng.Value2.ToS tring());
> }
> }
>
> You see that some of the Methods in C# look different from what we have > been using in Excel-VBA. Instead of simply using sht.Range("A1") you
> have to use Microsoft.Offic e.Interop.Excel .Range rng =
> (Microsoft.Offi ce.Interop.Exce l.Range) sht.get_Range(" A1", "A1")
>
> Some good articles to start Programming Excel with C#:
>
> "HOWTO: Automate Microsoft Excel from Microsoft Visual C# .NET"
> http://support.microsoft.com/?id=302084
>
> "HOW TO: Handle Events for Excel by Using Visual C# .NET"
> http://support.microsoft.com/?id=302815
>
> "HOW TO: Transfer XML Data to Microsoft Excel 2002 by Using Visual C# .NET"
> http://support.microsoft.com/?id=307029
>
> "HOWTO: Create an Excel Macro Using Automation from Visual C# .NET"
> http://support.microsoft.com/?id=303872
>
> Cheers
>
> Arne Janning

[Arne Janning]

Chris wrote:

I'm using Excel 2002 (10.2614.3501) SP1
Excel 10.0 Object Library

Hi Chris,

Primary Interop Assemblies for Excel 2002 installed or not?

Cheers

Arne Janning

[Arne Janning]

Arne Janning wrote:

Chris wrote:

I'm using Excel 2002 (10.2614.3501) SP1
Excel 10.0 Object Library

For me,

rng.get_Value(m iss).ToString()

works as well.

miss was Type.Missing.

Cheers

Arne Janning