Break the column by
delimiter to distribute the values among rows.

Break the column by
delimiter to distribute the values among rows.

anshgupta1298anshgupta1298 Posts: 3Questions: 3Answers: 0

There are 2 columns in a row for my table. One is the key and other is the value.
The value can be single or multiple. If multiple, they are separated by <br>. Like:

K1 -> V1 <br> V2 <br> V3

Now I want to export this into an Excel file such that there will be a single row for each value. Like:

K1 -> V1
K1 -> V2
K1 -> V3

I want to do this using datatables but cannot find any success. Can anyone help plz.

Answers

  • kthorngrenkthorngren Posts: 20,145Questions: 26Answers: 4,736

    This thread has an example of adding rows to the Excel export. Another option is this thread which shows how to create new lines with Excel.

    Kevin

Sign In or Register to comment.