Problem getting excel to work in Visual Studio (C#)

  • Thread starter Thread starter Harald Antonsen
  • Start date Start date
H

Harald Antonsen

Hi,

I'm trying to develop en application in Vusial Studio (C#)
towards excel. But I cannot get anything to work. Trying
to find a object (a command button) or even outputting
text to cell (rng.Value2("Hello world");) throws an
exception.

The exception have the message: HRESULT: 0x800A03EC.

What is wrong? I cannot find any information out there
that helps.

//Harald Antonsen :)
 
I don't know too much abaut C#, but...
rng.Value2("Hello world")
Range is an object, for example: multiple of cells.

I'll show, how to do this from VB using OLE:

Sub Test()
Dim ExApp as Excel.Application
Dim ExWbk as Workbook
Dim ExWsh as WorkSheet
Dim rng as Excel.Range

Set ExApp = CreateObject("Excel.Application") 'open Excel
Set ExWbk = ExApp.Workbooks.Open "path" 'open Workbook
Set ExWsh = ExWbk.Worksheets("sheet1") 'whichone sheet
Set rng = ExWsh.Range("A1") 'cell, for example A1

rng.Value = "Hello World!"

Set rng = Nothing 'free memory
Set ExWsh = Nothing
ExWbk.Close SaveChanges:=False
Set ExWbk = Nothing
ExApp.Quit SaveChanges:=False
Set ExApp = Nothing

End Sub


I hope, it was helpfull...
 
Sorry, typo in my example code. Should ofcource be
rnd.Value2 = "Hello World";

Code still don't work! :)

//Harald Antonsen
 
Oooops, my typo in the post. should be rnd.Value2 = "Hello
World";

Problem sill exists.

//Harald Antonsen
 
Hi Harald,
I'm trying to develop en application in Vusial Studio (C#)
towards excel. But I cannot get anything to work. Trying
to find a object (a command button) or even outputting
text to cell (rng.Value2("Hello world");) throws an
exception.

The exception have the message: HRESULT: 0x800A03EC.

What is wrong? I cannot find any information out there
that helps.

If you go to msdn.microsoft.com and search for 'Visual Studio Tools for
Office', you should find lots of c# examples that might help.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.co.uk
 
Just adding to what Stephen has said, I don't think you can hook a
commandbutton's events in .NET without Visual Studio Tools for Office.
VSTO provides many accessor methods (e.g. get_Range) to deal with the
problem of C# not supporting parameterized properties (that why you're
using Value2, right?)

If you don't have VSTO available to you, you'll probably want to start
using a lot of hyperlinks because the SheetFollowHyperlink is the most
useful event! See that following article MSDN for lots of non-VSTO C#
code:

Understanding the Excel Object Model from a .NET Developer's
Perspective:

http://msdn.microsoft.com/vstudio/o...brary/en-us/odc_vsto2003_ta/html/excelobj.asp

--
 
Back
Top