Ahh, that makes sense. Thanks for such a valuable resource, George! Cheers, Matthew
On Jan 29, 2012, at 7:57 PM, George Simon K wrote: > Hi Mathew, > > POI uses GAE restricted classes. > Please refer to > http://code.google.com/p/googleappengine/wiki/WillItPlayInJava > Alternate way is to use jxl library. > > Thanks > George > > On Sun, Jan 29, 2012 at 7:17 AM, Matthew Johnson <ijustmakecof...@gmail.com> > wrote: > I'm working on an export to XLS service using Apache POI 3.6, and I've > encountered a NoClassDefFoundError exception when using the autosize column > feature. > > The code: > > Sheet sheet = wb.createSheet("Viewpath Timesheet (date range)"); > PrintSetup printSetup = sheet.getPrintSetup(); > printSetup.setLandscape(true); > sheet.setFitToPage(true); > sheet.setHorizontallyCenter(true); > > //Set first four columns width to autosize. > for (int i = 0; i <= 4; i++) { > sheet.autoSizeColumn(i); //Commenting this line out resolves the error. > } > > Produces... > > WARNING: /export/timesheet > javax.servlet.ServletException: java.lang.NoClassDefFoundError: > java.awt.font.FontRenderContext is a restricted class. Please see the Google > App Engine developer's guide for more details. > at > org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:862) > at > org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791) > at > org.apache.jsp.export.timesheet_jsp._jspService(timesheet_jsp.java:406) > ... > Caused by: java.lang.NoClassDefFoundError: java.awt.font.FontRenderContext is > a restricted class. Please see the Google App Engine developer's guide for > more details. > at > com.google.appengine.tools.development.agent.runtime.Runtime.reject(Runtime.java:51) > at > org.apache.poi.hssf.usermodel.HSSFSheet.autoSizeColumn(HSSFSheet.java:1694) > at > org.apache.poi.hssf.usermodel.HSSFSheet.autoSizeColumn(HSSFSheet.java:1662) > at org.apache.jsp.export.timesheet_jsp.toXls(timesheet_jsp.java:154) > at > org.apache.jsp.export.timesheet_jsp._jspService(timesheet_jsp.java:396) > > ...Whaa..? Like a good baby-java dev, I checked the GAE developers guide as > directed, but couldn't find anything useful. I upgraded to POI 3.7 for kicks, > but the error remained. Anyone have experience with POI + Excel Spreadsheets > + GAE? Anyone? ...Bueller? > > Cheers, > Matthew > > -- > You received this message because you are subscribed to the Google Groups > "Google App Engine for Java" group. > To post to this group, send email to google-appengine-java@googlegroups.com. > To unsubscribe from this group, send email to > google-appengine-java+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/google-appengine-java?hl=en. > > > -- > You received this message because you are subscribed to the Google Groups > "Google App Engine for Java" group. > To post to this group, send email to google-appengine-java@googlegroups.com. > To unsubscribe from this group, send email to > google-appengine-java+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/google-appengine-java?hl=en. -- You received this message because you are subscribed to the Google Groups "Google App Engine for Java" group. To post to this group, send email to google-appengine-java@googlegroups.com. To unsubscribe from this group, send email to google-appengine-java+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-appengine-java?hl=en.