Messages

1

Help for ParamQuery Grid (free version) / Re: Need help with Excel export for struts 1.1

« on: January 18, 2017, 02:48:36 pm »

 redirectURL='<%=request.getContextPath()%>'+'/ExcelAction.do?type=excel';


This is the code that I have written to map the url to the action but it does not work.
Any pointers would be appreciated.

2

Help for ParamQuery Grid (free version) / Re: Need help with Excel export for struts 1.1

« on: January 18, 2017, 09:17:00 am »

Forgot to add that I am unable to download the excel using the above code. Can someone let me know where I am going wrong.

3

Help for ParamQuery Grid (free version) / Need help with Excel export for struts 1.1

« on: January 18, 2017, 09:14:50 am »

In the exportExcel method, Can someone please tell me what should be the code for the url parameter for a Struts 1.1 version application.

I am using the below Java Action class.



package com.action.export

public class ExcelAction {

public String excel(String excel, String extension, HttpServletRequest request) throws IOException {
      
        String filename="";
        if (extension.equals("csv") || extension.equals("xml")) {
            filename = "pqGrid." + extension;
            HttpSession ses = request.getSession(true);
            ses.setAttribute("excel", excel);
        }
        return filename;
    }
   
   public void excel(String filename, HttpServletRequest request, HttpServletResponse response) throws IOException {
      
        if (filename.equals("pqGrid.csv") || filename.equals("pqGrid.xml")) {
            HttpSession ses = request.getSession(true);
            String excel = (String) ses.getAttribute("excel");
                       
            byte[] bytes =  excel.getBytes(Charset.forName("UTF-8").toString());
                   
            response.setContentType("text/plain");
           
            response.setHeader("Content-Disposition",
                    "attachment;filename=" + filename);
            response.setContentLength(bytes.length);
            ServletOutputStream out = response.getOutputStream();
            out.write(bytes);
           
            out.flush();
            out.close();
        }
    }

}



In the JSP file, I am using the below code for the export function

"click": function (evt) {
                           
                            var redirectURL="";
                     redirectURL='<%=request.getContextPath()%>'+'/ExcelAction.do?type=excel';
                           
                           
                            jQuery("#grid_table").pqGrid("exportExcel", { url: redirectURL, sheetName: "pqGrid sheet" });
  }

The filepath for the JSP is WebContent/pages/TestFile.jsp