OWC Spreadsheet with C#

[nickless]

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

 

[someone]

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!