CSV not creating properly using outputStreamWriter

Question

Hi I am writing to CSV file like below

Writer  bw3 =  new BufferedWriter(
                new OutputStreamWriter(new FileOutputStream(outFileConversation),"UTF-8"));

But Still if i open CSV in textpad all cell with complete data will be there but in Excel some text contents are moved to next cell even next line if text content is big

So I replaced all special chars from text like \n,\t,\","," etc also I used UTF-8 but still why in excel text content not wrapping to single cell ?

Any problem in writing to CSV ? or Excel not able to read huge text content ?

Can you share a bit more of a code about how do you perform write operation? — Chirag Parmar
– Chirag Parmar, Commented Nov 2, 2016 at 4:41

Community · Accepted Answer · 2017-05-23 12:33:18Z

1

Please be aware that when you have UTF-8 encoding, there are some additional steps that you should follow, as explained here

edited May 23, 2017 at 12:33

CommunityBot

11 silver badge

answered Nov 2, 2016 at 4:47

Carlos Monroy Nieblas

2,2932 gold badges21 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Sanvi Over a year ago

I also found that String literal having 65535 length onward not able to print as size exceeds. So how to increase this length or how to break text without breaking the line display?

Collectives™ on Stack Overflow

CSV not creating properly using outputStreamWriter

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related