• Post Reply Bookmark Topic Watch Topic
  • New Topic

Dynamc slicers and pivot charts in excel using Java  RSS feed

 
RatiKanta pal
Ranch Hand
Posts: 88
Eclipse IDE Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello all,
Do anyone have idea how to implement Dynamc slicers and pivot charts using any api.
I would appreciate if you could send me any link or clue how to do it.I need to implement this in our BI application.

Thanks for your help in advance!cheers!
 
Winston Gutkowski
Bartender
Posts: 10575
66
Eclipse IDE Hibernate Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
RatiKanta pal wrote:Do anyone have idea how to implement Dynamc slicers and pivot charts using any api.
I would appreciate if you could send me any link or clue how to do it.I need to implement this in our BI application.

Well, Apache POI is the most quoted source for "doing stuff" with Excel files, but I have no idea whether it supports either pivot tables or dynamic slicers. Perhaps the link will tell you.

The problem you have is that Excel is a proprietary program (and format; although I beleieve it's XML-based now) and Microsoft does NOT want you doing anything with its stuff without paying them a LOT of money.

So, two other alternatives for you:

1. Get MS to write the program for you. It'll cost you (or your managers) a bundle; but at least you'll have (presumably) a guarantee that it will work. ALWAYS. And maybe you (or they) will learn the cost of buying proprietary software.

2. Convert the file to a format for a program like LibreOffice and then use its Java API to do this stuff. I doubt that there's much you can't do with this approach, but the learning curve is likely to be huge.

Winston
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!