ASP.NET has an easy way to return a DataGrid as a Microsoft Excel file:
Dim stringwriter As New System.IO.StringWriter()
Dim htmlwriter As New System.Web.UI.HtmlTextWriter(stringwriter)
DataGrid1.RenderControl(htmlwriter)
Response.AppendHeader("content-disposition",
"attachment;filename=name.xls")
Response.Write(stringwriter.ToString())
Response.End()
What is nice is that the Excel worksheet reflects the styling of the
DataGrid. I don't suppose that the DataTable of Wicket Extensions has
anything like this capability. Is there an easy way to do this?
I've looked at the JExcelAPI and jXLS, but these solutions are much too
low-level for me -- much harder to use than the simple code above. I
can do without the fancy formatting; I'm willing to settle for code that
simply returns the user a default Excel file whose grid is filled from
an arbitrary two-dimensional array of strings (or list of lists, or
whatever).
What is the simplest solution?
/Frank Silbermann
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid3432&bid#0486&dat1642
_______________________________________________
Wicket-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/wicket-user
