RadSpreadsheet - Working with Multiple sheets

2 posts, 0 answers
  1. Kiran
    Kiran avatar
    2 posts
    Member since:
    May 2014

    Posted 14 May 2014 Link to this post

    I have a situation like, i need to create multiple sheets in the same workbook based on the input file. I am able to create multiple sheets but not able to populate the information in the second sheet.  Any help on this? thank you for your help.
     
    if(i == 0) // first sheet {
    this.radSpreadSheet1.Workbook = formatProvider.Import(sValue[i]);
    this.radSpreadSheet1.Workbook.Sheets[i].Name = sKeys[i];
    }
    else // Second sheet Only two sheets per requirement
    {
    this.radSpreadSheet1.Workbook.Worksheets.Add(); // Adding a new sheet and make it as Active in the below line.
    this.radSpreadSheet1.Workbook.Sheets[i].Workbook.ActiveWorksheet = this.radSpreadSheet1.Workbook.Worksheets[i];
    this.radSpreadSheet1.Workbook.Sheets[i].Name = sKeys[i];
    //this.radSpreadSheet1.Workbook = formatProvider.Import(sValue[i]);
    }
  2. Kiran
    Kiran avatar
    2 posts
    Member since:
    May 2014

    Posted 15 May 2014 Link to this post

    hi team,

    i figured out the solution based on the "Combined Workbook" in this forum.

    Thank you!!
  3. DevCraft banner
Back to Top