AxSpreadSheet in c#.net

[Shraddha]

-how to set the wrap mode to all the cells in AxSpreadSheet
-on click event how to change the row height and column width to view the data
-how to andle autofilter event programatically

 

[Alvin Bruney [ASP.NET MVP]]

With the axspreadsheet, you have intellisense. Simply search for the
functionality on the cell object.

--

Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book, 2nd Edition
Exclusively on www.lulu.com/owc $19.99

 

[Rapiant]

Alvin, how come AxSpreadsheet doesn't have 'Range' listed under intellisense
while using VB? Any suggestions? Maybe I'm not importing all the right stuff?

With the axspreadsheet, you have intellisense. Simply search for the
functionality on the cell object.

--

Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book, 2nd Edition
Exclusively on www.lulu.com/owc $19.99
-------------------------------------------------------

-how to set the wrap mode to all the cells in AxSpreadSheet
-on click event how to change the row height and column width to view the
data
-how to andle autofilter event programatically

 

[Alvin Bruney [ASP.NET MVP]]

It does, as the return value from a cell(s) object. Every cell or group of
cells is a range. Here is an example

private AxMicrosoft.Office.Interop.Owc11.AxSpreadsheet
axSpreadsheet1;
Range oRange=(Range)axSpreadsheet1.ActiveSheet.Cells[2,1];
oRange.set_Value(XlRangeValueType.xlRangeValueDefault,5);
oRange=(Range)axSpreadsheet1.ActiveSheet.Cells[2,2];
oRange.set_Value(XlRangeValueType.xlRangeValueDefa ult,5);


--

Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book, 2nd Edition
Exclusively on www.lulu.com/owc $19.99
-------------------------------------------------------

Alvin, how come AxSpreadsheet doesn't have 'Range' listed under
intellisense
while using VB? Any suggestions? Maybe I'm not importing all the right
stuff?

With the axspreadsheet, you have intellisense. Simply search for the
functionality on the cell object.

--

Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book, 2nd Edition
Exclusively on www.lulu.com/owc $19.99
-------------------------------------------------------

-how to set the wrap mode to all the cells in AxSpreadSheet
-on click event how to change the row height and column width to view
the
data
-how to andle autofilter event programatically