Displaying excel files in portlet

Hi,

I want to display excel file in the portlet using portal beans. I set my view as raw and when I call

getBean().getBinaryViewURL(getPortalPageContext(), "survey_results_download_view", "", ht);
page displays

Page could not be built -- module may not support this view.when I use getBean().getFullViewURL("survey_results_download_view", ht);I get page but only as text not as excel. I have set the content type

in jsp as<%@ page contentType="application/vnd.ms-excel" %>This page displays as excel when I invoked outside portal but portlet  is displaying as text/html.Is there any other things that need to be set or configured.

My pbd file has the following view

Find more posts tagged with

Comments

Sreenivasa_Rao_Venepalli

Hi,

We have exported csv file from PBD .

We have built link using

getBean().getBinaryViewURL(getPortalPageContext(), "survey_results_download_view", null, ht);

And we have written JSPView class for corresponding “VIEW”, and in the pageStart() method, we are flushing the content.

HttpServletResponse response = this.getPortalPageContext().getResponse();

response.setContentType("text/csv");

response.setHeader("Content-Disposition", "attachment;filename=user_search_export.csv");

response.setHeader("Pragma", "public");

response.setHeader("Cache-Control", "cache");

response.setHeader("Cache-Control", "must-revalidate");

out = response.getWriter();

out.write(tmp.toString());

out.write("\r\n");

out.flush();

out.close()

and Leave serviceHTML() method empty if you want.

Thanks & Regards,

Sreenivasa Rao Venepalli,

Open Text (India) Pvt.Ltd,

Mobile # +91-9866121761.

From: eLink Entry: OpenText Portal Forum [mailto:vignetteportal@elinkkc.opentext.com]
Sent: Thursday, July 28, 2011 11:36 AM
To: eLink Recipient
Subject: Displaying excel files in portlet

Displaying excel files in portlet

Posted by mohammed.ahmed@chemtura.com (ahmed, mohammed) On 2011/07/28 02:05

Hi,

I want to display excel file in the portlet using portal beans. I set my view as raw and when I call

getBean().getBinaryViewURL(getPortalPageContext(), "survey_results_download_view", "", ht);
page displays

Page could not be built -- module may not support this view.

when I use getBean().getFullViewURL("survey_results_download_view", ht);

I get page but only as text not as excel. I have set the content type

in jsp as

<%@ page contentType="application/vnd.ms-excel" %>

This page displays as excel when I invoked outside portal but portlet

 is displaying as text/html.

Is there any other things that need to be set or configured.

My pbd file has the following view

[To post a comment, use the normal reply function]
Forum:	OpenText Portal Forum
Livelink Server:	knowledge-wlweb01

Mario_Sanz_Villacorta

If you only want to display an excel in a portlet you can use an iframe from html view and you can get as result an embeded excel in your portal page.

maybe this is a silly solution but maybe you only need to show an embeded excel

bye,

Mario

Mohammed_Ahmed

I still get the same error message

page cannot be built

Now I am doing display logic in class file as per your suggestion instead of jsp.

This links is called from jsp which has code

<mod:view class="com.epicentric.portalbeans.beans.surveybean.SurveyResultsView">

<a href="<%= view.getDownloadSummaryResultsURL() %>" class="epi-buttonLink" target="_blank">

where getDownloadSummaryResultsURL is

public String getDownloadSummaryResultsURL()
   {

         String sViewResultsURL =
            //getBean().getBinaryViewURL(getPortalPageContext(), "survey_results_download_view", null, ht);

        // above didn't work I commented out, ht is hashtable already set
            getBean().getFullViewURL("survey_results_download_view", ht);
         return sViewResultsURL;
   }
pbd definition for csv download is

Here is the class which actual does the csv display

package com.epicentric.portalbeans.beans.surveybean;

import com.epicentric.common.Log;
import com.epicentric.i18n.format.FormattableBundle;
import com.epicentric.i18n.locale.LocaleManager;
import com.epicentric.portalbeans.GenericBeanView;
import com.epicentric.portalbeans.GenericPortalBean;
import com.epicentric.portalbeans.PortalBean;
import com.epicentric.portalbeans.PortalBeanDescriptor;
import com.epicentric.portalbeans.PortalPageContext;

import java.io.IOException;
import java.io.PrintWriter;
import java.text.DateFormat;
import java.text.NumberFormat;
import java.text.SimpleDateFormat;
import java.util.Enumeration;
import java.util.Hashtable;
import java.util.Locale;

import javax.servlet.http.HttpServletResponse;

public class SurveyResultsDownloadView extends SurveyResultsView {

    public SurveyResultsDownloadView(PortalBean bean,
            PortalPageContext pageContext) {
        super(bean, pageContext, "");
        this.nSrveyState = requestInt("surveystate");
    }

    public SurveyResultsDownloadView(PortalBean bean,
            PortalPageContext pageContext, String jsp_page) {
        super(bean, pageContext, jsp_page);
        this.nSrveyState = requestInt("surveystate");
    }

    public void pageStart()
       {

        String tmp = "Hello";
        PrintWriter out = null;
        HttpServletResponse response = this.getPortalPageContext().getResponse();

                                response.setContentType("text/csv");

                                response.setHeader("Content-Disposition", "attachment;filename=user_search_export.csv");

                                response.setHeader("Pragma", "public");

                                response.setHeader("Cache-Control", "cache");

                                response.setHeader("Cache-Control", "must-revalidate");

                                try {
                                    out = response.getWriter();
                                } catch (IOException e) {
                                    // TODO Auto-generated catch block
                                    e.printStackTrace();
                                }

                                out.write(tmp);

                                out.write("\r\n");

                                out.flush();

                                                        out.close();


       }
    public void serviceHTML() {

    }
}

WebContent.zip

Sreenivasa_Rao_Venepalli

Hi,

If I am not wrong, you need to use “getBinaryViewURL” not a “getFullViewURL” method.

I didn’t get you..why you commented getBinaryViewURL() method code.

Thanks & Regards,

Sreenivasa Rao Venepalli,

Open Text (India) Pvt.Ltd,

Mobile # +91-9866121761.

From: eLink Entry: OpenText Portal Forum [mailto:vignetteportal@elinkkc.opentext.com]
Sent: Friday, July 29, 2011 11:28 AM
To: eLink Recipient
Subject: RE Displaying excel files in portlet 2

[Attachments exceeded pre-set size limits. Use the links provided to access]

RE Displaying excel files in portlet 2

Posted by mohammed.ahmed@chemtura.com (ahmed, mohammed) On 2011/07/29 01:54

I still get the same error message

page cannot be built

Now I am doing display logic in class file as per your suggestion instead of jsp.

This links is called from jsp which has code

<mod:view class="com.epicentric.portalbeans.beans.surveybean.SurveyResultsView">

<a href="<%= view.getDownloadSummaryResultsURL() %>" class="epi-buttonLink" target="_blank">

where getDownloadSummaryResultsURL is

public String getDownloadSummaryResultsURL()
   {

         String sViewResultsURL =
            //getBean().getBinaryViewURL(getPortalPageContext(), "survey_results_download_view", null, ht);

   ! ;     // above didn't work I commented out, ht is hashtable already set
            getBean().getFullViewURL("survey_results_download_view", ht);
         return sViewResultsURL;
   }
pbd definition for csv download is

Here is the class which actual does the csv display

package com.epicentric.portalbeans.beans.surveybean;

import com.epicentric.common.Log;
import com.epicentric.i18n.format.FormattableBundle;
impo! rt com.epicentric.i18n.locale.LocaleManager;
import c! om.epicentric.portalbeans.GenericBeanView;
import com.epicentric.portalbeans.GenericPortalBean;
import com.epicentric.portalbeans.PortalBean;
import com.epicentric.portalbeans.PortalBeanDescriptor;
import com.epicentric.portalbeans.PortalPageContext;

import java.io.IOException;
import java.io.PrintWriter;
import java.text.DateFormat;
import java.text.NumberFormat;
import java.text.SimpleDateFormat;
import java.util.Enumeration;
import java.util.Hashtable;
import java.util.Locale;

import javax.servlet.http.HttpServletResponse;

public class SurveyResultsDownloadView extends SurveyResultsView {

    public SurveyResultsDownloadView(PortalBean bean,
            PortalPageContext pageContext) {
        super(bean, pageContext, "");
&! nbsp;       this.nSrveyState = requestInt("surveystate");
    }

    public SurveyResultsDownloadView(PortalBean bean,
            PortalPageContext pageContext, String jsp_page) {
        super(bean, pageContext, jsp_page);
        this.nSrveyState = requestInt("surveystate");
    }

    public void pageStart()
       {

        String tmp = "Hello";
        PrintWriter out = null;
        HttpServletResponse response = this.getPortalPageContext().getResponse();

   !           &nbs! p;                 response.setContentType("text/csv");

                                response.setHeader("Content-Disposition", "attachment;filename=user_search_export.csv");

                                response.setHeader("Pragma", "public");

                                response.setHeader("Cache-Control", "cache");

  &nb! sp;                             response.setHeader("Cache-Control", "must-revalidate");

                                try {
                                    out = response.getWriter();
                                } catch (IOException e) {
                              &n! bsp;     // TODO Auto-generated catch block                                     e.printStackTrace();
                                }

                                out.write(tmp);

                                out.write("\r\n");

                   !              out.flush();

                                                        out.close();

                                     &nbs! p;
       ! }
    public void serviceHTML() {

    }
}

Attachment Links:

WebContent.zip (272 KB)

[To post a comment, use the normal reply function]
Topic:	Displaying excel files in portlet
Forum:	OpenText Portal Forum
Livelink Server:	knowledge-wlweb01

Mohammed_Ahmed

When I use getBinaryViewURL I am getting page cannot be build error nothing is displayed. I mentioned that in my earlier post.