Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range vs IRange What's the difference?
Hi
I found a C# example of an Excel add-in at http://www.codeproject.com/dotnet/excelnetauto.asp. I made some changes to this project and made a function that takes an Excel.Range as a parameter. Intellisense showed that there is an interface called IRange as well as Range. What's the difference? When would you want to use an IRange? TIA, Fredrik Here's my added C# function. public int GetRangeSize1(Excel.Range range) { return range.Columns.Count * range.Rows.Count; } |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range vs IRange What's the difference?
IRange is neither an Excel or VBA object, method or property.
As far as I know the only way it could be used in the above is as a Variable as in Sub GetIRangeValue() Dim IRange as Integer Dim Rng as Range Set Rng = Sheet1.Range("A1") IRange = Rng.Value Msgbox IRange End Sub "Fredrik Wahlgren" wrote: Hi I found a C# example of an Excel add-in at http://www.codeproject.com/dotnet/excelnetauto.asp. I made some changes to this project and made a function that takes an Excel.Range as a parameter. Intellisense showed that there is an interface called IRange as well as Range. What's the difference? When would you want to use an IRange? TIA, Fredrik Here's my added C# function. public int GetRangeSize1(Excel.Range range) { return range.Columns.Count * range.Rows.Count; } |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range vs IRange What's the difference?
No, you have dim'ed Irange as as an integer. If you use VB6 or VB.NET you
can do this Dim r as Excel.Irange C# Excel.IRange r; It compiles fine but I don't understand how I would use this variable. IRange will also appear if you use the OLE/COM Object viewer and create an idl file from excel.exe /Fredrik "gocush" /delete wrote in message ... IRange is neither an Excel or VBA object, method or property. As far as I know the only way it could be used in the above is as a Variable as in Sub GetIRangeValue() Dim IRange as Integer Dim Rng as Range Set Rng = Sheet1.Range("A1") IRange = Rng.Value Msgbox IRange End Sub "Fredrik Wahlgren" wrote: Hi I found a C# example of an Excel add-in at http://www.codeproject.com/dotnet/excelnetauto.asp. I made some changes to this project and made a function that takes an Excel.Range as a parameter. Intellisense showed that there is an interface called IRange as well as Range. What's the difference? When would you want to use an IRange? TIA, Fredrik Here's my added C# function. public int GetRangeSize1(Excel.Range range) { return range.Columns.Count * range.Rows.Count; } |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range vs IRange What's the difference?
Sorry, I thought you were asking how IRange could be used in programing VBA.
In vba the first letter "i" or "I" is usually used to indicate that you have dimmed your variable as an integer - as in my example. This is not absolutely required but good programming practice. As for programming in C# as you are doing, that is beyond the scope of this forum and should be posted to an appropriate forum. "Fredrik Wahlgren" wrote: No, you have dim'ed Irange as as an integer. If you use VB6 or VB.NET you can do this Dim r as Excel.Irange C# Excel.IRange r; It compiles fine but I don't understand how I would use this variable. IRange will also appear if you use the OLE/COM Object viewer and create an idl file from excel.exe /Fredrik "gocush" /delete wrote in message ... IRange is neither an Excel or VBA object, method or property. As far as I know the only way it could be used in the above is as a Variable as in Sub GetIRangeValue() Dim IRange as Integer Dim Rng as Range Set Rng = Sheet1.Range("A1") IRange = Rng.Value Msgbox IRange End Sub "Fredrik Wahlgren" wrote: Hi I found a C# example of an Excel add-in at http://www.codeproject.com/dotnet/excelnetauto.asp. I made some changes to this project and made a function that takes an Excel.Range as a parameter. Intellisense showed that there is an interface called IRange as well as Range. What's the difference? When would you want to use an IRange? TIA, Fredrik Here's my added C# function. public int GetRangeSize1(Excel.Range range) { return range.Columns.Count * range.Rows.Count; } |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range vs IRange What's the difference?
Fredrik,
Recently I wrote a sets of classes that all Implement my "IBarCodeFormat" interface. This allows you to write something like: Dim ThisBarCodeFormat as IBarCodeFormat Set ThisBarCodeFormat =New EAN13 or Set ThisBarCodeFormat =New EAN8 or Set ThisBarCodeFormat =New Code39 as you can be sure that the class signatures will match the interface (by definition) So for you, I would guess the class "Range" Implements the "IRange" interface. However, I'm not sure if that is any use to you, unless may be you wanted to write your own "MyRange" class that had the same signature as Excel's, but different functionality. This is from a VB/VBA perspective on using Implements. C# or VB.Net may well be different due to their appraoch to object, inheritance etc. NickHk "Fredrik Wahlgren" wrote in message ... No, you have dim'ed Irange as as an integer. If you use VB6 or VB.NET you can do this Dim r as Excel.Irange C# Excel.IRange r; It compiles fine but I don't understand how I would use this variable. IRange will also appear if you use the OLE/COM Object viewer and create an idl file from excel.exe /Fredrik "gocush" /delete wrote in message ... IRange is neither an Excel or VBA object, method or property. As far as I know the only way it could be used in the above is as a Variable as in Sub GetIRangeValue() Dim IRange as Integer Dim Rng as Range Set Rng = Sheet1.Range("A1") IRange = Rng.Value Msgbox IRange End Sub "Fredrik Wahlgren" wrote: Hi I found a C# example of an Excel add-in at http://www.codeproject.com/dotnet/excelnetauto.asp. I made some changes to this project and made a function that takes an Excel.Range as a parameter. Intellisense showed that there is an interface called IRange as well as Range. What's the difference? When would you want to use an IRange? TIA, Fredrik Here's my added C# function. public int GetRangeSize1(Excel.Range range) { return range.Columns.Count * range.Rows.Count; } |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sum the difference in a range | Excel Worksheet Functions | |||
Date Range & Difference | Excel Worksheet Functions | |||
Count difference based on Range | Excel Worksheet Functions | |||
Labelling a row so it can be used as an offset for sum, difference or range | Excel Discussion (Misc queries) | |||
Difference between range.formula and range.formulalocal | Excel Programming |