Push the data to OLAP and build Pivot Tables

Aspose.Cells Product Family
1

Hi,

Does your product support pushing the data from resultset into Excel OLAP and build pivot tables?

Currently we push the data into Data Sheet and Excel Pivot Tables already build would refer this data.

Is there anyway we could avoid the above mentioned method and directly push the data to OLAP?

Thanks
Raj

2

Hi,

Thanks for your posting and using Aspose.Cells for Java.

After initial investigation, we think, this feature is not supported. However, we need to look into further.

Could you search on internet and provide us your reference article links describing this feature in detail as per MS-Excel?

Probably, this document is relevant.

  • http://olappivottableextend.codeplex.com/

Also, if you want to import/export data which is present in Ms-Excel workbook, then such things can be achieved using the methods mentioned in these articles.