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

Displaying Excel worksheet in portal

Hi gyus,

is it possible to display excel sheet in portal? I tried URL iView with file:///d:\... protocol, but it doesn't work.

Is there any way, how to do it?

Thanx, Peter

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 02, 2007 at 09:30 AM

    Hi all,

    we integrate office tools in portal. but i've a question.

    when i push the excel or word shortcut in portal, it asks me to open or save the xsl or doc. if i push the open button portal displays excel or word sheet in seperate web browser. but we don't want it in web browser. is it possible to open the sheets as itself (not in web browser).

    best regards

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 22, 2006 at 08:18 PM

    Peter,

    Pls check if your URL is valid, trying to open it from browser.

    I dont think you can do d:\ within file:///

    -Dileep

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Peter,

      The HTTP alias is an alternative name to the location of a static resource on the Web server (such as an HTML page).

      <u><b>Defining Aliases Using Visual Administrator</b></u>

      Use Visual Administrator tool to manage aliases on a virtual host. Open the Runtime screen of HTTP Service running on server. Next:

      ...

      1. Choose the virtual host, for which you want to define alias, from the list

      2. Choose Alias tab

      3. Enter the name of the alias and the corresponding path to a directory on the local file system

      4. Choose Add

      The name of the alias and the directory path it points to must appear in a list on the screen. Make sure you choose Save Properties to permanently save your changes.

      For more info, see: http://help.sap.com/saphelp_nw2004s/helpdata/en/ee/0618d0899001408d821096c85ff8a2/content.htm

      Regards,

      SK

      <i>PS: Plz assign points for helpful answers!</i>

  • author's profile photo Former Member
    Former Member
    Posted on May 24, 2006 at 04:23 AM

    Peter,

    You can integrate office documents (word and excel only) into the portal using Web Dynpro.

    The help documentation that comes with Netweaver Developer Studio covers how to do this. Here is a sample from the documentation:

    The implementation of the OfficeControl UI element supports:

    · Opening a new document by calling the method ShowDocument:

    WDOfficeControlMethods.showDocument(IWDController refToTheController, String strControlId

    · Opening an existing document by calling the method ShowDocument:

    WDOfficeControlMethods.showDocument(IWDController refToTheController, String strControlId

    · Saving the document by calling the method SaveDocument:

    WDOfficeControl.saveDocument(IWDController refToTheController, String strControlId

    · Closing the document by calling the method CloseDocument:

    WDOfficeControlMethods.closeDocument(IWDController refToTheController, String strControlId

    The prerequisite for using the OfficeControl UI element is the installation of one of the following software programs:

    · Microsoft Office 2000

    · Microsoft Office XP

    Hope this helps.

    -Mike

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 25, 2006 at 10:59 AM

    Hi Peter,

    You can use document iView for the same also.

    If you have the excel file in the portal,

    1. Go to Content Admin - > KM Content.

    2. Select the file . Go To Details - > Properties - > Access links

    3. Get the Target Url.

    4. Create a document iView in Content Admin -> Portal Content - > New - > iView

    5. Specify the Target URL in the document Path.

    6. Preview.

    7. You will be asked to open or save the file.

    Regards,

    venkat.

    [Pls reward points if useful]

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 25, 2006 at 03:01 PM

    correct way to invoke is

    file:///c:/

    even for windows environment.

    Regards,

    Piyush

    ps: please mark if useful.

    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.