wicket-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From BrianWilliams <brianwilliams33...@yahoo.com>
Subject Generating spreadsheet to send to Client fails in 1.6
Date Wed, 31 Jul 2013 17:13:34 GMT
Hello,

I had code in Wicket 1.x that worked perfectly to dynamically generate a
spreadsheet and send it to the user.  I had to rewrite it for the new
Response classes in 1.6:

    public void generateExcel(String filename, List<List&lt;? extends
Object>> dataList) {
        HSSFWorkbook myWorkBook = new HSSFWorkbook();
        HSSFSheet mySheet = myWorkBook.createSheet();
        ... (generate sheet from dataList using HSSFSheet methods)
        WebResponse response = (WebResponse)getResponse();
        webResponse.setContentType("application/vnd.ms-excel");
        webResponse.setAttachmentHeader(filename + ".xls");
        OutputStream out = webResponse.getOutputStream();
        myWorkBook.write(out);
        out.close();
    }

The sheet is still being populated as I need, and the client is asked to
open or save the <filename>.xls file (as expected).

The problem with 1.6 is: the current page is sent rather than the sheet I've
built.   My .xls viewer complains that the file is not in the correct format
and, when I display it anyway, contains the original Wicket page, head, css,
javascript and all.

The same problems happens when generating xml from the same data list:

    WebResponse response = (WebResponse)getResponse();
    response.setContentType("application/xml");
    response.setAttachmentHeader(filename + ".xml");
    XMLStreamWriter out =
XMLOutputFactory.newInstance().createXMLStreamWriter(response.getOutputStream());

    out.writeStartDocument();
    ... (generate XML document from dataList)
    out.writeEndDocument();
    out.close();

This also sends the original HTML page to the client. 

Both methods worked perfectly before I migrated to Wicket 1.6, but now the
Response (returned by getResponse()) seems to behave differently.  Any
ideas?  Thank you very much.



--
View this message in context: http://apache-wicket.1842946.n4.nabble.com/Generating-spreadsheet-to-send-to-Client-fails-in-1-6-tp4660579.html
Sent from the Users forum mailing list archive at Nabble.com.

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@wicket.apache.org
For additional commands, e-mail: users-help@wicket.apache.org


Mime
View raw message