.js

 table id="esTables" class="table table-bordered table-hover"
데이타 리스트 엑셀 다운로드 / csv utf-8 데이타 깨진현상 안생기도록 옵션처리

var buttons = new $.fn.dataTable.Buttons(table, {
buttons:[
{
extend:'collection',
text: '내보내기',
className:'btn',
buttons: [
{ extend: 'copyHtml5', footer: true },
{ extend: 'excelHtml5',
  text: 'Excel',
  footer: true,
  filename: $('.box-title b').html(),
  title: $('.box-title b').html(),
  exportOptions:{
columns: ':visible'
  }
},
{  extend: 'csvHtml5',
footer: true,
        stripHtml: false,
extension: '.csv',
charset: 'utf-8',
fieldBoundary: '',
    filename: $('.box-title b').html(),
    orientation:'landscape',
    title: $('.box-title b').html(),
bom: true

},
{ extend: 'pdfHtml5', footer: true },
{ extend: 'print', footer: true}

]
}
]

#엑셀다운로드