Skip to Content
author's profile photo Former Member
Former Member

Export Portal data to Excel

hi!

I'm working with EP6. I need to get data from a portal IView (stored in a TableView, for example) in Excel format. Anybody can help me?

Thanks.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 16, 2004 at 03:10 PM

    Hi Mauro,

    unfortunately this is no standard feature in SAP EP as it is in the ABAP world. But I did something similar recently in a customer project:

    There exists a free Java API for generating and parsing Excel documents. Check http://jakarta.apache.org/poi/ , it's really useful.

    You could for instance iterate through your table view's model and generate an Excel document "on the fly" using the HSSF ("horrible spreadsheet format" 😉 ) of POI and make this document available by - say - a download button in your iView.

    Hope that helps,

    Dominik

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 20, 2005 at 02:40 PM

    Hi,

    Based on your suggestions, I have created the described IView with the Excel data format. The problem I have is how to include this IView in the current context. Basically, I have the onExelExportButtonClick() method within my JSPDynPage to capture the event. From this method, how do I instantiate the IView to display the excel data? Please provide the sample code if you can.

    Thank you,

    Tom

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.