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

Questions regarding Excel Export from Table

Hello,

i've implemented the Excel Export described in this blog:

/people/sap.user72/blog/2006/05/04/enhancing-tables-in-webdynpro-java-150-custom-built-table-utilities

It works fine, but i have 2 question:

- You have to add your Columns who want to get in Excel in the ArrayList. I have a table with LayoutOption (make Columns Visible/Invisible) and want to get all visible columns in my Excel list. You can i realize that?

- My Excel List is shown in my existing Browser Window, but i want to open a new Window, how can i do that?

Kind Regards,

Christopher

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Apr 11, 2008 at 08:23 AM

    Is the code that shows/hides the table columns part of your component? If yes, you could keep the list of visible columns in a context attribute (of type ArrayList<String>) and update this list every time some table column is shown/hidden.

    About the link: I would expect that when using target="" a new browser window opens. Isn't that the case?

    Armin

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 11, 2008 at 10:32 AM

    Of course target "" is the right way, it's friday 😉

    the other idea is great and works perfectly..

    another problem with my table:

    text in some table cells are always capital letters (texts comes from sap tables (rfc),where the text is not save in capital letters!!), are there settings in my table or data types to deactivate this?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 11, 2008 at 02:19 PM

    Hello Cristopher,

    For the first Qst:

    Lets think in this way; you have set two column fields invisible and in wdModifyView() check if the columns are visible set a flag and accordingly you can set the header at the getColumnInfo() function.

    Preferably use switch case to check the ArrayList selection and adding values to it.

    For the second Qst:

    Its all about the Browser property; where you have to set the option New window should be opened in new window. This will work.

    +in case of Mozilla; in Tools->option->Tab->new window should be open in

    new window

    new Tab

    +

    Select new window

    Regards

    -Vinod V

    *

    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.