How to Copy the contents with line breaks from a JTable to Excel with line breaks included

Question

Hai I have an application in which I have a JTable with line breaks(pressing Enter key while editing) included in each and every cell.The problem is when I copy the contents from my JTable to Excel I am not getting the contents in same format as in my Jtable(with line breaks) to my excel that is with line breaks.Is there any way to solve my problem.I have to get the contents from my jtable to excel in the same format with line breaks.

Thank You Chaithu

Answer 1

How are you copying the contents? Are you using the build in copy support?(ie select all contents and copy w/ ctrl-c), or did you write something yourself to do the copy and paste?

You may have to do the latter, and make sure that you insert the necessary line break characters in to the text.

Answer 2

I don't know much about DnD. I think that typically you use a delimiter for each cell data (like comma or tab) and then a newline for each row of data.

So if your cell data contains newline characters you would probably need to wrap the cell data in "...". This would mean you need to write a custom TransferHandler for the table. The old TableTransferHandler from the JDK5 tutorial might help you get started.