Free Support Forum -

? re cells and Grid

Evaluating product. Trying to display worksheets created programatically with cells in gridcontrol. The worksheets property is readonly. Seems that only way to load into grid is via file or stream...can cells.worksheets object be loaded directly into grid? Thanks

I think you are trying to use Aspose.Cells objects with Aspose.Cells.GridWeb control. Well, since Aspose.Cells and Aspose.Cells.GridWeb are different components (one is library and other is control) and have different sets of data with their own architectures and attributes, so objects' conversion is not possible.

You may try to save workbook to memory stream using Workbook.Save(stream, ___) method of Aspose.Cells component and then use ImportExcelFile method of GridWeb.WebWorksheets APIs.

Thank you.