Adriana, It is tough to say anything about your problem without looking at the exception stack trace. For null pointer exception, it is crucial to know which reference was null (and this information can only be guessed by stacktrace)
Regards, Tahir > -----Original Message----- > From: Adriana Rozo [mailto:[EMAIL PROTECTED] > Sent: Friday, May 11, 2007 10:06 PM > To: POI Users List > Subject: Re: Mail attachment > > Hi all, > > I have the same problem, > this is my code snippet > > //HttpServletResponse > getResponse().setContentType("application/vnd.ms-excel"); > getResponse().setHeader("Content-disposition","attachment; filename= > "+theNameFile+".xls" ); > getResponse().setHeader("Cache-Control"," private"); > > OutputStream unStream = null; > try { > unStream = getResponse().getOutputStream(); > workbook.write(unStream); //IT CRASHES > unStream.flush(); > unStream.close(); > ... > > -->> I'm using poi-3.0-alpha1-20050704 > But I obtain a NullPointerException > > I tryed: > > ByteArrayOutputStream byteOutS = new ByteArrayOutputStream(); > wb.write(byteOutS);//IT CRASHES > byte[] excelBytes=byteOutS.toByteArray(); > > And once again NullPointerException > > does it work only with FileOutputStream? > > thanks > -- > Adriana > p.d. sorry for my english... (ó_ò) > > On 10/17/06, Brett Procek <[EMAIL PROTECTED]> wrote: > > > > Anil Komareddi <anil <at> effone.net> writes: > > > > > > > > > > > I'm trying to generate an excel spreadsheet and then email it as an > > > attachment. The generation part works fine. I can save this to a file > > > and view it. I can attach an existing spreadsheet file to an email and > > > send it and it goes out ok. The problem is when I try to generate the > > > spreadsheet and attach it without saving it first. > > > > > > This is what I'm doing: > > > > > > 1. Generate the workbook > > > 2. Get the data byte array from the workbook using > > > HSSFWorkbook.getBytes() > > > 3. Prepare a javax.activation.Datasource using this byte array where > the > > > getInputStream method is as follows: > > > > > > public InputStream getInputStream() > > > throws IOException > > > { > > > if (_data == null) > > > { > > > throw new IOException("no data"); > > > } > > > > > > return new ByteArrayInputStream(_data); > > > } > > > > > > 4. The emailer code itself, looks like this: > > > > > > "Lost Document Summary Information" > > > > > > > I had this same issue and figured out the problem. Invoking > > HSSFWorkbook.getBytes() does not return all of the data necessary to re- > > construct a complete Excel file. An excel file itself contains more than > > the > > raw contents of the file. The 'getBytes()' method apparently seems to > > miss > > other excell file meta data, including the file summary information, > etc. > > > > Instead, in order to write the file out as an attachment, or stream, you > > must > > invoke the 'write()' method on the workbook itself, passing in a > > OutputSteam. > > > > - Brett > > > > > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > Mailing List: http://jakarta.apache.org/site/mail2.html#poi > > The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ > > > > > > > -- > Adriana > --.--.--.--.--.--.--.--.--.--.--.--.--.--.--.--.--.--. > Your grace has found me just as I am, > empty handed but alive in Your hands --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
