I have some data in the DB and would like to be able to export it to a CSV file and provide a link so the user can download it.
Is there any mechanism provided by Spring 3 for this?
Do you know how could I do that?
-
Spring doesn't provide CSV support. There are plenty CSV libraries for Java, though (just search for "java csv").skaffman– skaffman2011-02-01 17:36:56 +00:00Commented Feb 1, 2011 at 17:36
Add a comment
|
1 Answer
I guess it should be easy to build a CSV or any text file view. Here are suggested steps:
Create a View class (you can name it as
CSVView) extendingorg.springframework.web.servlet.view.AbstractViewOverride
renderMergedOutputModelas follows (pseudo code):
BufferedWriter writer = new BufferedWriter(response.getWriter())
response.setHeader("Content-Disposition","attachment; filename=\"file.csv\"");
myDbData = (Whatever) modelMap.get("modelKey");
some kind of loop {writer.write(myDbData csv row); writer.newLine(); }
finally writer.flush(); writer.close();
After that just return ModelAndView with model (object Whatever with modelKey) and view as CSVView in the controller.
1 Comment
Boris Treukhov
an alternative solution can be found stackoverflow.com/questions/9913732/…, but it's a matter of taste.