This is a migrated thread and some comments may be shown as answers.

RadSpreadsheet - Working with Multiple sheets

1 Answer 75 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Kiran
Top achievements
Rank 1
Kiran asked on 14 May 2014, 07:41 PM
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]);
}

1 Answer, 1 is accepted

Sort by
0
Kiran
Top achievements
Rank 1
answered on 15 May 2014, 03:57 PM
hi team,

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

Thank you!!
Tags
Spreadsheet
Asked by
Kiran
Top achievements
Rank 1
Answers by
Kiran
Top achievements
Rank 1
Share this question
or