i do not find much documentation about OWC usage with ASP.NET C# online. ss = Server.CreateObject("OWC11.SpreadSheet"); sheet = ss.Sheets.Item(1); sheet.Range("C1:""E1").NumberFormat = "mmm-yy;@"; sheet.Range("C1:""E1").HorizontalAlignment = ss.Constants.xlHAlignLeft; sheet.Range("A1:""E1").AutoFilter(); sheet.Columns.AutoFit(); code works fine with classic ASP. I am trying to Implement the same in .NET with C#. Range is not available for usage like above (Range exists as an Interface) Any pointers on how to go about implementing it. Thanks in advance, Niranjan
nickless wrote in news:18c38a5b-bbe5-454b- ac74-ac55f500ab67@f36g2000hsa.googlegroups.com: > i do not find much documentation about OWC usage with ASP.NET C# > online. > > ss = Server.CreateObject("OWC11.SpreadSheet"); > sheet = ss.Sheets.Item(1); > > sheet.Range("C1:""E1").NumberFormat = "mmm-yy;@"; > sheet.Range("C1:""E1").HorizontalAlignment = > ss.Constants.xlHAlignLeft; > sheet.Range("A1:""E1").AutoFilter(); > sheet.Columns.AutoFit(); > > code works fine with classic ASP. > I am trying to Implement the same in .NET with C#. > Range is not available for usage like above (Range exists as an > Interface) > Any pointers on how to go about implementing it. > > Thanks in advance, > Niranjan > I am having similar problems - but have found that Range is implemented using Property get_Range. Similarly .offset is implemented as get_Offset. With .Cells you need to use .get_Item. I am now trying to find out how you get / set cell values!
