Need help for downloading .xls or .csv file having special character

[Abhishek Purwar]

Hi all,

I have one problem.

I am writing data in response output stream and then set header as "content-disposition" : "attachment.filename=" + <filename>.

I have given file name having extension as xls or cvs because i want the content to be in this format file.

How should i set character encoding for file because data have some special character and so file shows different character in windows and different in linux???

Kindly provide me some solution.

Thanks to everyone for their suggestion.

[Abhishek Purwar]

I have fixed this issue.

Solution :

Need to set the charset for response output stream.

BufferedWriter bw = new BufferedWriter(new OutputStreamWriter(out,"ISO-8859-1"));

where out is response output stream.

[Rene Larsen]

You can also try to set this for a Excel document:

response.setContentType("application/excel");

and when it is a CSV document - this one:

response.setContentType("text/plain");

The data you are writing to the output stream, does it have the right encoding ??

Normally it would be a byte array you are writing to the output - but if the data in the byte array doesn't have the correct encoding, then you can't do anything about it when you try to serve it.