Display Aspose.Cells.Worksheet in Aspose.Cells.GridWeb

Aspose.Cells Product Family
1

I built a worksheet using Aspose.Cells that I want to display on the GridWeb control.

The Aspose.Cells.Worksheet is different from an Aspose.Cells.GridWeb.Data.Worksheet!!! What is the best way to display a Worksheet object using the GridWebControl?

2

Hi,

Well, Aspose.Cells and Aspose.Cells.GridWeb are different in many aspects, one is a library and other is control, both have different architectures, so we cannot parse objects regarding their API. I think you may built a spreadsheet using the Aspose.Cells library, you can save it as an Excel file (either to disk or streams) and then you can display the contents of the worksheets on the control (e.g you may use WebWorksheets.ImportExcelFile() method) by importing it.


Thank you.

3

Code snippet:

WebWorksheets sheets = grid.WebWorksheets;
Workbook workbook = new Workbook();
sheets.ImportExcelFile(workbook.SaveToStream());