Spread for ASP.NET 8.0 Product Documentation > Developer's Guide > Customizing the Appearance > Customizing the Appearance of Rows and Columns > Customizing the Number of Rows or Columns |
When you create a sheet, it is automatically created with three rows and four columns. You can change the number to up to two billion rows and columns.
Set the RowCount or ColumnCount property for the Sheets shortcut.
This example code sets the first sheet to have 10 columns and 100 rows.
C# |
Copy Code
|
---|---|
FpSpread1.Sheets[0].RowCount = 100; FpSpread1.Sheets[0].ColumnCount = 10; |
VB |
Copy Code
|
---|---|
FpSpread1.Sheets(0).RowCount = 100 FpSpread1.Sheets(0).ColumnCount = 10 |
Set the RowCount or ColumnCount property for a SheetView class.
This example code sets the first sheet to have 100 rows and 10 columns.
C# |
Copy Code
|
---|---|
FarPoint.Web.Spread.SheetView Sheet0; Sheet0 = FpSpread1.Sheets[0]; Sheet0.RowCount = 100; Sheet0.ColumnCount = 10; |
VB |
Copy Code
|
---|---|
Dim Sheet0 As FarPoint.Web.Spread.SheetView Sheet0 = FpSpread1.Sheets(0) Sheet0.RowCount = 100 Sheet0.ColumnCount = 10 |