Hi David,
Have you done that yourself...Do you have a sample code..??
Thanks
Nitin
[EMAIL PROTECTED] 02.09.2005 10:40:57 pm >>>
Hi Nitin,
Thanks for that.....
You're welcome. I'v been lurking, and am glad to contribute.
Is it possible to generate an HTML/JSP from Servlet, that contains
two
frames one with a normal HTML tags and other with the Excel embedded
in
it..??
Yes, you could generate HTML from a JSP or a Servlet with Frames (or
better divs) one of which is Excel, but that would have to be a
Servlet....
Regards,
David
Regards
Nitin
[EMAIL PROTECTED] 02.09.2005 9:58:38 pm >>>
Hi,
You need to produce binary files with a Servlet. JSP is for
producing
text data.
I had to learn this the hard way, our PDFs would always display
until
we hit the combination of Acrobat 6.02, Tomcat 4.1.29 and IE 6.0.
One
of the Tomcat developers corrected us, and a Servlet did solve the
problem.
Shortly after that we found POI and starting producing XLS in a
servlet
instead of a CSV text file.
You also will want to
response.setContentType("application/vnd.ms-excel" );
response.setHeader("Content-disposition",
"inline;filename="+filename);
And we've also found that ending your url with "&ext=.xls" can help.
Note that this is all because of how MS IE "sniffs" file types.
Regards,
David Fisher
On Sep 2, 2005, at 4:52 AM, Nitin Nair wrote:
Hi,
I am trying to open an Excel document with multiple sheets using
HSSF
POI. I have written the code for creating the Workbook and
Worksheet
in
the JSP. However when the JSP is invoked, nothing is displayed. I
have
attached the JSP.
I am creating the Worksheet in the following manner.
response.setContentType("application/vnd.ms-excel");
org.apache.poi.hssf.usermodel.HSSFWorkbook excelDoc = new
org.apache.poi.hssf.usermodel.HSSFWorkbook();
org.apache.poi.hssf.usermodel.HSSFSheet excelSheet =
excelDoc.createSheet(sheetName);
short
rowCount = 0;
org.apache.poi.hssf.usermodel.HSSFRow
excelRow = excelSheet.createRow((short)rowCount);
excelRow.createCell((short)0).setCellValue("Date");
excelRow.createCell((short)1).setCellValue("Time");
excelRow.createCell((short)2).setCellValue("Timezone");
excelRow.createCell((short)3).setCellValue("Called
Number/Email/Network Address");
excelRow.createCell((short)4).setCellValue("Destination");
excelRow.createCell((short)5).setCellValue("Invoice
Text");
excelRow.createCell((short)6).setCellValue("Billed
Qty");
excelRow.createCell((short)7).setCellValue("Volume");
excelRow.createCell((short)8).setCellValue("Total
Charge");
excelRow.createCell((short)9).setCellValue("Time
Band");
excelRow.createCell((short)10).setCellValue("Usage
Category");
excelRow.createCell((short)11).setCellValue("Event
Type Code");
excelRow.createCell((short)12).setCellValue("Event
Sub Type Code");
rowCount++;
Any help will be highly appreciated.
Regards
Nitin
---------------------------------------------------------------------
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/
---------------------------------------------------------------------
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/
---------------------------------------------------------------------
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/
---------------------------------------------------------------------
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/
---------------------------------------------------------------------
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/
