How to download csv file without writing it using OpenCsv

Question

I am using OpenCsv API and now i am stuck in some problem.Here's my code

protected void processRequest(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html;charset=UTF-8"); PrintWriter out = response.getWriter(); try { List<UserRegData> userRegDataList = new ArrayList<UserRegData>(); HttpSession session = request.getSession(); userRegDataList = (List<UserRegData>) session.getAttribute("referralData"); List<String[]> dataToWrite = new ArrayList<String[]>(); String csv = "E:\\carewave_backup\\csv\\UserReferral.csv"; CSVWriter writer = new CSVWriter(new FileWriter(csv)); for (UserRegData obj : userRegDataList) { dataToWrite.add(new String[]{obj.getReferred_by_name(), obj.getInvitee_name(), obj.getInvitee_email(), obj.getInvitee_date(), obj.getIsInviteeRegistered(), obj.getDate_of_invitee_registered()}); } writer.writeAll(dataToWrite); writer.close(); } catch (Exception ex) { ex.printStackTrace(); } finally { out.close(); } }

This servlet basically retrieves list from session and writes it to csv file.This servlet is triggered after user clicks download csv button.Now what i need is, browser should give a download dialogue.Is there anyway to download it in csv format without writing it to file first?.

Why do you think you have to write it to a file on the server? Rather than writer.writeAll write the lines directly to the response after setting the content-type to text/csv. — Jim Garrison
– Jim Garrison, Commented Oct 22, 2013 at 7:10

Jim Garrison · Accepted Answer · 2013-10-22 07:14:22Z

I assume you're asking about how to stream the output on the server directly to the client without writing it first to a temp file on the server.

You don't need to write the data to a file first.

Set the resonse content-type to text/csv
Call getOutputStream() on the response object
Write the contents of dataToWrite as individual lines to the output stream

No disk file needed.

Collectives™ on Stack Overflow

How to download csv file without writing it using OpenCsv

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related