FarPoint.Web.Spread Assembly > FarPoint.Web.Spread.Model Namespace > DefaultSheetDataModel Class : NextNonEmptyColumnInRow Method |
'Declaration Public Overrides Function NextNonEmptyColumnInRow( _ ByVal row As Integer, _ ByVal column As Integer _ ) As Integer
'Usage Dim instance As DefaultSheetDataModel Dim row As Integer Dim column As Integer Dim value As Integer value = instance.NextNonEmptyColumnInRow(row, column)
FarPoint.Web.Spread.Model.DefaultSheetDataModel dataModel = new FarPoint.Web.Spread.Model.DefaultSheetDataModel(); DataSet ds = new DataSet(); DataTable name; name = ds.Tables.Add("Name"); name.Columns.Add("FirstName", Type.GetType("System.String")); name.Columns.Add("LastName", Type.GetType("System.String")); name.Rows.Add(new object[] {"John", "Doe"}); name.Rows.Add(new object[] {"Sally ", "Jones"}); name.Rows.Add(new object[] {"Terry", "Hernandez"}); dataModel.DataSource = ds; FpSpread1.ActiveSheetView.DataModel = dataModel; dataModel.AddUnboundRows(1, 2); name.Rows.Add(new object[] {"Jane", "Simpson"}); int i; i = dataModel.NextNonEmptyColumnInRow(1, 2); Response.Write(i.ToString());
Dim dataModel As New FarPoint.Web.Spread.Model.DefaultSheetDataModel Dim ds As New DataSet Dim name As DataTable name = ds.Tables.Add("Name") name.Columns.Add("FirstName", Type.GetType("System.String")) name.Columns.Add("LastName", Type.GetType("System.String")) name.Rows.Add(New Object() {"John", "Doe"}) name.Rows.Add(New Object() {"Sally ", "Jones"}) name.Rows.Add(New Object() {"Terry", "Hernandez"}) dataModel.DataSource = ds FpSpread1.ActiveSheetView.DataModel = dataModel dataModel.AddUnboundRows(1, 2) name.Rows.Add(New Object() {"Jane", "Simpson"}) Dim i As Integer i = dataModel.NextNonEmptyColumnInRow(1, 2) Response.Write(i.ToString())
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6