Please… I need the server configuration (grid to excel) for java, but i don’t find in blog or site. Someone could post one code sample in jsp… pls.
(Export Grid to Excel server/side) for jsp, Pls Someone could post… pls.
tks/all.
grab
dhtmlx.com/x/download/regular/gr … l-java.zip
there is a war file inside which contains full service.
It maps /generate url to the ExcelGenerator class which process post request in necessary way
public void doPost(HttpServletRequest req, HttpServletResponse resp) throws IOException {
String xml = req.getParameter("grid_xml");
xml = URLDecoder.decode(xml, "UTF-8");
(new ExcelWriter()).generate(xml, resp);
}
Tks… =]
In/JSP :
String xml = request.getParameter("grid_xml");
xml = URLDecoder.decode(xml, "UTF-8");
new ExcelWriter().generate(xml, response);
To change the name of file, change the (ExcelWriter.java) Line: 67.
Coment this line and you can set in your “toExcel.JSP” ===V
response.setHeader("Content-Disposition", "attachment;filename="+fileNameVar+".xls");tks/all
William Morais
Hi, I need hide some columns of Excell with Java. How I can do it?.
Thanks.
Hi,
if column is hidden at client side, then it should be hidden in generated excel. There is no way to hide another columns.