I have explore spreadsheet and able to show data using WCF call (via stream) on sliverlight page.
But the base excel workbook have 2 sheet
1. Row data
2. Display to user with computation/formulas.
Row data sheet is kept hidden in the base excel workbook (created using MS Excel 2013).
when I show the base workbook in spread sheet control the hidden Row data sheet also visible.
Please let me know any way to hide this Row Datasheet when excel file viewed in silverlight spreadsheet control?
Thanks in advance.