Free Support Forum - aspose.com

Exporting to Excel

Hi,

Does anybody know whether its possible to export a matrix report to Excel and for the report not to have merged cells and the grouped data to be repeated, so that the end user can manipulate the data.

As an example - my matrix report looks like this in SQL Server Reporting Services

Category A WidgetA 200
WidgetB 500
WidgetC 100

but when I export it, I want it to look like this ( with no merged cells)


Category A WidgetA 200
Category A WidgetB 500
Category A WidgetC 100


Can this be done using Apose .Cells ?

Hi,

Thanks for considering Aspose.

Do you use Aspose.Cells for Reporting Services or Aspose.Cells for .Net as both are different products. Could you elaborate it.

Thank you.

Not using either at the moment but looking to find a product that can help my clients achieve this.

Hi,

Well Aspose.Cells for Reporting Sevices product is an SQL Server reporting services rendering extensions, you may try it: check for documenations: http://www.aspose.com/Wiki/Default.aspx/Aspose.Cells.Reporting.Services/

Aspose.Cells is spreadsheet genaration and mangement library. It can do all the tasks which MS Excel can perform. It 's an independent component which does not require MS Excel to be installed either on client of server side. For documenation kindly check: http://www.aspose.com/Wiki/Default.aspx/Aspose.Cells/Homepage.html

Thank you.