Hi, Can you please let me know which module did add gwt.xml file to work with WritableWorkbook. I have a situation to work with Excel in GWT but not able to find any module
On Tuesday, 4 May 2010 19:22:28 UTC+5:30, Dima wrote: > > Hi, > > I try to create a test.xsl on the server without saving the file on > the server. My application is running fine in hosted mode, but once > compiled and uploud(Tomcat) I get a nasty exception. Probably my > servleturl is not correct. > > My code: > > Client:---------------------------- > final String link = GWT.getModuleBaseURL() + "myfiledownload"; > > RequestBuilder builder = new > RequestBuilder(RequestBuilder.GET,link); > > try { > builder.sendRequest(null, new > RequestCallback() { > public void onError(Request request, Throwable > t) { > Window.alert("Error bei getExcel"); > } > public void onResponseReceived(Request > request,Response response) > > if(response.getStatusCode() == 200) { > Window.Location.replace(link); > } else if(response.getStatusCode() == 404) { > Window.alert("Service not available."); > } > } > }); > } catch (RequestException re) { > GWT.log("Error", re); > } > ------------------------------------------------------------------- > web.xml > > <servlet> > <servlet-name>myfiledownload</servlet-name> > <servlet-class>module.server.MyFileServlet</servlet-class> > </servlet> > <servlet-mapping> > <servlet-name>myfiledownload</servlet-name> > <url-pattern>/myfiledownload</url-pattern> > </servlet-mapping> > -------------------------------------------- > MyApp.gwt.xml > > <module> > ... > <servlet path="/myfiledownload" class="module.server.MyFileServlet"/> > </module> > --------------------------------------- > Server > > package module.server; > > > public class MyFileServlet extends HttpServlet { > private static final long serialVersionUID = 1L; > > public void doGet(HttpServletRequest request, HttpServletResponse > response) throws IOException { > try { > // Get Excel Data > ByteArrayOutputStream bytes = generateExcelReport(); > > // Initialize Http Response Headers > response.setHeader("Content-disposition", "attachment; > filename=exportUsers.xls"); > response.setContentType("application/vnd.ms-excel"); > > // Write data on response output stream > if (bytes != null) { > response.getOutputStream().write(bytes.toByteArray()); > } > } catch (Exception e) { > response.setContentType("text/plain"); > response.getWriter().print("An error as occured"); > } > } > > public ByteArrayOutputStream generateExcelReport() throws IOException, > WriteException{ > > > /* Stream containing excel data */ > ByteArrayOutputStream outputStream = new > ByteArrayOutputStream(); > > /* Create Excel WorkBook and Sheet */ > WritableWorkbook workBook = > Workbook.createWorkbook(outputStream); > WritableSheet sheet = workBook.createSheet("User List", > 0); > > /* Generates Headers Cells */ > WritableFont headerFont = new > WritableFont(WritableFont.TAHOMA, 12, > WritableFont.BOLD); > WritableCellFormat headerCellFormat = new > WritableCellFormat(headerFont); > headerCellFormat.setBackground(Colour.PALE_BLUE); > sheet.addCell(new Label(1, 1, "LastName", > headerCellFormat)); > sheet.addCell(new Label(2, 1, "FirstName", > headerCellFormat)); > > /* Generates Data Cells */ > WritableFont dataFont = new > WritableFont(WritableFont.TAHOMA, 12); > WritableCellFormat dataCellFormat = new > WritableCellFormat(dataFont); > int currentRow = 2; > > > /* Write & Close Excel WorkBook */ > workBook.write(); > workBook.close(); > > return outputStream; > > } > } > --------------------------------------- > > Please help my... > > -- > You received this message because you are subscribed to the Google Groups > "Google Web Toolkit" group. > To post to this group, send email to google-we...@googlegroups.com > <javascript:>. > To unsubscribe from this group, send email to > google-web-toolkit+unsubscr...@googlegroups.com <javascript:>. > For more options, visit this group at > http://groups.google.com/group/google-web-toolkit?hl=en. > > -- You received this message because you are subscribed to the Google Groups "GWT Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to google-web-toolkit+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/google-web-toolkit/6449bd84-6002-4d7c-ac41-d40333dd6861%40googlegroups.com.