Row count Problem in spread sheet

Posted by: stylish16 on 8 September 2017, 2:52 pm EST

  • Posted 8 September 2017, 2:52 pm EST

    Hi,

    I have made a spreadsheet in which i have taken 50 rows by setting row count property from designer & populating this rows from table in DB.

    But, In case in future, rows added in Table are greater than 50, then how can i add more rows.

    I think by increasing row count again through designer is not a good way.

    I am also inserting new rows in DB from this sheet.

    What will happen in a scenario like i want to add new row in db but rows are already full in spread sheet?

    How can i generate row automatically through code? Provide me some code for doing this.

    Suggest me proper way through if rows are full.

    Thanks in advance.

     

  • Replied 8 September 2017, 2:52 pm EST

    Sounds like you want to add unbound rows





    AddUnboundRows Method
    See Also Example



    FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.Model
    Namespace
    > DefaultSheetDataModel
    Class
    : AddUnboundRows Method


    Adds unbound rows to the data model.

    Syntax










    Visual Basic (Declaration)
    Public Sub AddUnboundRows( _
    ByVal row As Integer, _
    ByVal count As Integer _
    )








    Visual Basic (Usage)Copy Code
    Dim instance As DefaultSheetDataModel
    Dim row As Integer
    Dim count As Integer

    instance.AddUnboundRows(row, count)








    C#
    public void AddUnboundRows( 
    int row,
    int count
    )

    Parameters



    row
    Row index at which to add the new rows
    count
    Number of rows to add

    Example


    This example
    adds unbound rows to the data model.







    C#Copy Code
    FarPoint.Win.Spread.Model.DefaultSheetDataModel
    dataModel = new FarPoint.Win.Spread.Model.DefaultSheetDataModel(5,
    5);
    dataModel.AddCustomName(
    "TWICESUM", "2*SUM(A1,A2)", 1, 1);
    dataModel.SetFormula(1, 1,
    "TWICESUM");
    dataModel.SetValue(0, 0,
    10);
    dataModel.SetValue(1, 0, 10);
    fpSpread1.ActiveSheet.Models.Data =
    dataModel;








    Visual BasicCopy Code
    Dim ds As New DataSet()
    Dim emp As New DataTable("Employees")
    Dim div As New DataTable("Division")
    emp.Columns.Add("LastName")
    emp.Columns.Add("FirstName")
    emp.Rows.Add(New
    Object() {"Jones", "Marianne"})
    emp.Rows.Add(New
    Object() {"Fieldes", "Anna"})
    div.Columns.Add("Section")
    div.Columns.Add("Specialty")
    div.Rows.Add(New
    Object() {"Finance", "Taxes"})
    div.Rows.Add(New
    Object() {"Mergers", "Legal"})
    ds.Tables.AddRange(New DataTable() {emp, div})
    Dim dataModel As New
    FarPoint.Win.Spread.Model.DefaultSheetDataModel()
    dataModel.DataSource =
    ds
    dataModel.DataMember = "Division"
    dataModel.AddUnboundRows(1,
    3)
    FpSpread1.ActiveSheet.Models.Data =
    dataModel

    See
    Also



Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels