Is multiple recordsets supported?

Aspose.Cells Product Family
1

We have stored-procedures that return multiple recordsets. Is there any way that I can map those recordsets to multiple style definitions in Aspose.Cells?
For example, the stored_proc returns recordset0, recordset1 & recordset2. In Aspose.Cells, can I define three styles and say these styles are for these three recordsets respectively?

Thanks!

2

Hi,

Thanks for considering Aspose.

I am not very clear about your need. Anyhow, I think you mean you got multiple records based on different datatables (3 in numbers) right! Well, I think you may import the records from datatables using Cells.ImportDataTable() method or using other methods like Cells.ImportFromDataReader(), Cells.ImportDataRow, Cells.ImportArray() methods etc. You can define named ranges based on the area of the records for a datatable, create a style object, specify the formatting attribute for the style and apply the style for the range. In this way you may create and apply three different style objects based on three sets of data ranges.

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/importing-data-to-worksheets.html

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/named-ranges.html

Thank you.