Spread for ASP.NET 9.0 Product Documentation > Developer's Guide > Customizing the Appearance > Customizing the Appearance of Rows and Columns > Adding a Row or Column |
You can add one or more rows or columns to a sheet, and specify where the row or column is added. You can use the methods in the SheetView class or the methods in the DefaultSheetDataModel class.
For adding an unbound row to a sheet in a component that is bound to a data source, refer to Adding an Unbound Row.
This example code adds two columns before column 6.
C# |
Copy Code
|
---|---|
FpSpread1.Sheets[0].AddColumns(6,2); |
VB |
Copy Code
|
---|---|
FpSpread1.Sheets(0).AddColumns(6,2) |
This example code adds two columns before column 6.
C# |
Copy Code
|
---|---|
FarPoint.Web.Spread.SheetView Sheet0; Sheet0 = FpSpread1.Sheets[0]; Sheet0.AddColumns(6,2); |
VB |
Copy Code
|
---|---|
Dim Sheet0 As FarPoint.Web.Spread.SheetView Sheet0 = FpSpread1.Sheets(0) Sheet0.AddColumns(6, 2) |