RadSpreadsheet - Working with Multiple sheets

[Kiran]

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]);
}

[Kiran]

hi team,

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

Thank you!!