David,
For some reason it doesn't open up the existing file. It opens up a new
excel document in the browser.
Can you tell me what I am doing wrong?
Here is the servlet:
*
protected* *void* doGet(HttpServletRequest request, HttpServletResponse
response) *throws* ServletException, IOException {
// *TODO* Auto-generated method stub
*try* {
response.setContentType("application/vnd.ms-excel" );
// String filename = request.getParameter("filename");
// String filename = (String)request.getAttribute("selected");
// String filename = "test.xls";
HttpSession session = request.getSession();
String filename = (String)session.getAttribute("selected");
String path = "c://downloads//" + filename;
response.setHeader("Content-disposition", "inline;filename="+path);
// HSSFWorkbook wb = new HSSFWorkbook();
InputStream inp = *new* FileInputStream(path);
//InputStream inp = new FileInputStream("workbook.xlsx");
Workbook wb = (Workbook) WorkbookFactory.*create*(inp);
Sheet *sheet* = ( wb).getSheetAt(0);
// create your workbook using Apache POI
wb.write(response.getOutputStream());
} *catch* (Exception e) {
e.printStackTrace();
}
}
Thanks,
Veena
On Mon, Oct 26, 2009 at 11:44 AM, David Fisher <[email protected]>wrote:
> (JSP) This works for a web server which follows the servlet spec. If this
> is your path then you will need to study how the WEB-INF directory works.
> You do not want to serve binary content directly from a jsp.
>
> (or Swing) - If you are talking about an application that creates an excel
> and the launches the file in Excel you will need to look into the Java
> Process class. Write your Excel file to the filesystem and then launch excel
> and the file.
>
> I hope this points you in the proper direction.
>
> Regards,
> Dave
>
>
> On Oct 26, 2009, at 7:51 AM, veena pandit wrote:
>
> Excellent idea! But could you tell me how the servlet fits into my JSF
>> project.
>> I have a jsp page that allows the user to select the file. The selected
>> file is
>> an xls file and is pulled from the database. I want to show the file as a
>> xls document in a browser(or swing). So if I use your example, how would
>> I factor it in? Not sure how to define the navigation rules.
>>
>> Thanks
>>
>> On Mon, Oct 26, 2009 at 8:50 AM, David Fisher <[email protected]
>> >wrote:
>>
>> In Apache Tomcat we have a servlet that does something like this:
>>>
>>> public class MyExcelServlet extends HttpServlet {
>>> public void doGet (HttpServletRequest request, HttpServletResponse
>>> response) throws ServletException, IOException {
>>> try {
>>> response.setContentType("application/vnd.ms-excel" );
>>> response.setHeader("Content-disposition",
>>> "inline;filename="+filename);
>>> HSSFWorkbook wb = new HSSFWorkbook();
>>> // create your workbook using Apache POI
>>> wb.write(response.getOutputStream());
>>> } catch (Exception e) {
>>>
>>> }
>>> }
>>> }
>>>
>>> On Oct 26, 2009, at 6:34 AM, @lan Williamson wrote:
>>>
>>> That is the bit you are going to have to code up yourself
>>>
>>>>
>>>> The purpose of POI is to give you the low-level functions to which to
>>>> operate with an EXCEL file.
>>>>
>>>>
>>>>
>>>> veena pandit wrote:
>>>>
>>>> Hi,
>>>>>
>>>>> It looks like all the examples on the page here:
>>>>>
>>>>> http://poi.apache.org/spreadsheet/examples.html
>>>>>
>>>>> are examples that produce an excel file. I need an example
>>>>> that opens the file as a swing application.or in the browser,
>>>>> Is there such an example?
>>>>>
>>>>>
>>>> ---------------------------------------------------------------------
>>>> To unsubscribe, e-mail: [email protected]
>>>> For additional commands, e-mail: [email protected]
>>>>
>>>>
>>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: [email protected]
>>> For additional commands, e-mail: [email protected]
>>>
>>>
>>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
>
>
