FpSpread1.Sheets[0].ColumnCount = 7;
FpSpread1.Sheets[0].PageSize = 50;
FpSpread1.Sheets[0].RowCount = 50;
FarPoint.Web.Spread.GeneralCellType genrl = new FarPoint.Web.Spread.GeneralCellType();
genrl.ErrorMessage = "You must use numbers!!";
for(int i = 0;i <= 49;i++)
{
FpSpread1.Sheets[0].Cells[i, 0].CellType = genrl;
FpSpread1.Sheets[0].Cells[i, 0].Value = 100 + i;
}
FpSpread1.Sheets(0).ColumnCount = 7
FpSpread1.Sheets(0).PageSize = 50
FpSpread1.Sheets(0).RowCount = 50
Dim genrl As New FarPoint.Web.Spread.GeneralCellType()
genrl.ErrorMessage = "You must use numbers!!"
For i As Integer = 0 To 49
FpSpread1.Sheets(0).Cells(i, 0).CellType = genrl
FpSpread1.Sheets(0).Cells(i, 0).Value = 100 + i
Next i