Click here to Skip to main content
15,896,727 members
Home / Discussions / C#
   

C#

 
GeneralRe: How to create an Type from string Pin
Corinna John7-May-04 23:29
Corinna John7-May-04 23:29 
GeneralRe: How to create an Type from string Pin
cyonite8-May-04 4:58
cyonite8-May-04 4:58 
AnswerRe: How to create an Type from string Pin
Heath Stewart7-May-04 9:25
protectorHeath Stewart7-May-04 9:25 
GeneralRe: How to create an Type from string Pin
cyonite7-May-04 13:42
cyonite7-May-04 13:42 
GeneralRe: How to create an Type from string Pin
Heath Stewart8-May-04 19:10
protectorHeath Stewart8-May-04 19:10 
GeneralPerformanceCounter problem Pin
bgd16087-May-04 5:50
bgd16087-May-04 5:50 
Generalexcel Pin
dcronje7-May-04 5:40
dcronje7-May-04 5:40 
GeneralRe: excel Pin
Heath Stewart7-May-04 9:23
protectorHeath Stewart7-May-04 9:23 
Use the Microsoft PIAs (Primary Interop Assemblies) that can be downloaded from http://msdn.microsoft.com[^] for Office XP or that come on the CD with Office 2003 Professional. Add a reference to Microsoft.Office.Interop.Excel.dll and create a new instance of the ApplicationClass in the Microsoft.Office.Interop.Excel namespace. This creates a new instance of the Excel application (invisible at first - set its Visible property to true to display it).

Then load a new workbook or template using Workbooks.Open. That will give you a Workbook instance. Cast this to a WorkbookClass and use the Sheets property to get the Sheet you want. Use the Item property to get a Worksheet. Cast this to a WorksheetClass and you can now get the Cells property. This is all documented in the Office Programming Reference what to do and where to go from there (like the various ways you can reference cells).

 

Microsoft MVP, Visual C#
My Articles
GeneralFunctions and references Pin
surgeproof7-May-04 5:38
surgeproof7-May-04 5:38 
GeneralRe: Functions and references Pin
Heath Stewart7-May-04 9:16
protectorHeath Stewart7-May-04 9:16 
GeneralRe: Functions and references Pin
surgeproof7-May-04 23:16
surgeproof7-May-04 23:16 
GeneralRe: Functions and references Pin
Heath Stewart8-May-04 19:20
protectorHeath Stewart8-May-04 19:20 
GeneralRe: Functions and references Pin
surgeproof10-May-04 4:50
surgeproof10-May-04 4:50 
GeneralWorking with XML file Pin
Alex Getman7-May-04 5:35
Alex Getman7-May-04 5:35 
GeneralRe: Working with XML file Pin
TigerNinja_7-May-04 8:35
TigerNinja_7-May-04 8:35 
GeneralSystem.Drawing Problem Pin
Russell Jones7-May-04 4:29
Russell Jones7-May-04 4:29 
GeneralRe: System.Drawing Problem Pin
Mike Dimmick7-May-04 4:48
Mike Dimmick7-May-04 4:48 
GeneralRe: System.Drawing Problem Pin
Heath Stewart7-May-04 4:51
protectorHeath Stewart7-May-04 4:51 
GeneralRe: System.Drawing Problem Pin
Russell Jones10-May-04 3:33
Russell Jones10-May-04 3:33 
GeneralString Pin
bertcox7-May-04 3:17
bertcox7-May-04 3:17 
GeneralRe: String Pin
Heath Stewart7-May-04 3:31
protectorHeath Stewart7-May-04 3:31 
GeneralRe: String Pin
Jeff Varszegi7-May-04 4:20
professionalJeff Varszegi7-May-04 4:20 
GeneralRe: String Pin
Heath Stewart7-May-04 4:25
protectorHeath Stewart7-May-04 4:25 
GeneralRe: String Pin
Jeff Varszegi7-May-04 4:45
professionalJeff Varszegi7-May-04 4:45 
GeneralRe: String Pin
Heath Stewart7-May-04 4:47
protectorHeath Stewart7-May-04 4:47 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.