Excel Spreadsheet inside a CallBackPanel

[Administrator]

Hi,

Is it possible to display a Excel file or spreadsheet inside a CallbackPanel on the web?

Also, is it possible to select a spreadsheet from an open workbook on the web and export the selected spreadsheet to external Excel file?

Please attach examples.

Thanks,

Rekha

[Melba Winshia]

Hi Rekha,

Thanks for your interest in Essential XlsIO.

1) Issue 1:(display a Excel file or spreadsheet inside a CallbackPanel)

No, it not possible to display a Excel file or spreadsheet inside a CallbackPanel on the web. Essential XlsIO is a Non UI component that can be used in both ASP.NET and windows forms applications. Its a .NET library that can provide your .NET applications with the capability to read and write Microsoft Excel files [XLS and SpreadsheetML Files] without depending on Microsoft Excel.

2) Issue 2: (to select a spreadsheet from an open workbook on the web and export the selected spreadsheet to external Excel file)

It is possible to copy a selected spreadsheet from one workbook and export to external excel file. Please refer the following code snippet to achieve this

[C#]

//Copy the first worksheet from Source workbook to destination workbook.
destinationWorkbook.Worksheets.AddCopy(sourceWorkbook.Worksheets[0]);

Please refer the following sample which implements the above said feature:

http://websamples.syncfusion.com/samples/XlsIO.Web/4.4.0.51/57598/main.htm

Kindle let me know if you have any other questions.

Regards,
Melba

[Administrator]

Hi Melba,

Thank you for your quick reply and support!

Rekha

[Melba Winshia]

Hi Rekha,

Thanks for the update!

Kindly let me know if you have any other questions.

Regards,
Melba