Export Data from a Table

[Karen Schaper <ka...@gmail.com>]

Hi,

I am trying to export the contents of DefaultDataTable

to an excel spreadsheet.

I found this post...

http://www.nabble.com/export-excel-file-via-an-OutputStream-td16416239.html#a16416239

which had a snippet of code in which the user indicates no longer
outputs the data but a fragment of html.  There were responses but I'm
not following on how to get the data from the data table into the output
stream for an excel spreadsheet.

Here's the snippet of code that I was looking at.

Button button = new Button("excelExport")
 { 
    public void onSubmit() { 
        getRequestCycle().setRequestTarget( 
        new ComponentRequestTarget(dataTable) 
        ); 
        WebResponse wr = (WebResponse)getResponse();
        wr.setContentType( "excel/ms-excel;
name="+getMSExcelFilename() ); 
        wr.setHeader( "content-disposition",
"attachment;filename="+getMSExcelFilename() ); 
    } 
};

Any help is greatly appreciated!

Thanks

Karen




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