KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I'm using C# to manipulate an Excel worksheet. The following two pieces of code should work the same, but one works and the other throws an exception. I wonder why. This works: oRange = (Excel.Range)oSheet.get_Range("A1","F1"); oRange.EntireColumn.AutoFit(); This throws an exception: oRange = (Excel.Range)oSheet.get_Range(oSheet.Cells[1, 1],oSheet.Cells[4,4]); oRange.EntireColumn.AutoFit(); Exception: RuntimeBinderException occurred. "object" does not contain a definition for 'get_Range' The oSheet is instantiated as follows: Excel.Worksheet oSheet = new Excel.Worksheet(); Am I supposed to instantiate both differently?
Tags (comma-separated)
Save Edits
Cancel