I would like to be able to have two spreadsheet controls on my form and open two separate excel docs into each spreadsheet control. I would then like to move one worksheet from the 2nd spreadsheet control into the 1st spreadsheet. Is this possible? Or is it possible to upload sheets from multiple excel files into one spreadsheetcontrol?
PSPannir Selvam S Syncfusion Team September 14, 2016 01:22 PM UTC
Thanks for using Syncfusion product.
Currently Spreadsheet do not have default support to move the worksheets between the Spreadsheet.However, you can achieve your requirement by copying the worksheets from one workbook into another workbook using XlsIO and then import that workbook into Spreadsheet2 and remove the worksheet from Spreadsheet1 like below code snippet.