steinchen84
asked on
JSP to CSV generates blank lines
I am generating a csv-file through a JSP, but the csv has a lot of blank lines at the beginning of the file. If opened with MS-Excel, it starts writing in line 12. I would like it to start writing in line 1 though. What do I need to modify? Have tried different things, like comment out.flush() or changing response.setHeader information.
Does anybody know what causes the blanks?
Does anybody know what causes the blanks?
response.setContentType("application/savetodisk;charset=UTF-8");
response.setHeader("Content-Disposition","attachement; filename=list.csv");
out.flush();
out.println("ID; TITLE");
out.println("");
...
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thank you for multiple solutions and explanations!
Removing the linebreaks after the directives worked for me.
Removing the linebreaks after the directives worked for me.
JSP
JavaServer Pages (JSP) allow the development of dynamically generated web pages. It uses the Java programming language; JSP pages are translated into servlets at runtime, with each servlet being cached and reused until the JSP is modified. JSP allows Java code to be interleaved with static web markup content, so the resulting page can be compiled and executed on the server to deliver the content.
16K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
We can't use the Tomcat trimSpaces parameter because we have plenty of places where we want JSP values printed with a space between them (like user names, e.g.). But for people just starting a site, they could always make sure that they put the character in where they want spaces.
We decided to switch to servlets for the CSV files, just to avoid the blank lines at the top of the CSV page.