Excel export footer

hojiev@gmail.com

i want export data to excel with footer

hojiev@gmail.com

else i need automatic calc for excel formula after exporting to excel

excel formula =G2+H2+СУММ(J2:U2) after exporting not calced automatic

kthorngren

You will need to customize the export if you want to create cells with formulas. Maybe this thread will help:
https://datatables.net/forums/discussion/41778

Kevin

allan

want export data to excel with footer

Use the footer option of the excel button type to include the footer.

Allan

hojiev@gmail.com

$('#dataTable77').DataTable({
drawCallback:function() { zSumArr(this,[6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21],6); },
dom: 'Bfrtip',
buttons: [
{
extend: 'excel',
text: 'Save current page',
footer: true,
exportOptions: {
modifier: {
page: 'current'
}
}
}
],
"pageLength": 100

} );

header:false - is worked , but footer:true can't export footer
or i must import any lib?
pls help guys )

hojiev@gmail.com

buttons.html5.min.js
jszip.min.js
dataTables.buttons.min.js
jquery.gritter.js
jquery.gritter.js
dataTables.bootstrap.js

hojiev@gmail.com

buttons.html5.min.js
jszip.min.js
dataTables.buttons.min.js
jquery.gritter.js
jquery.gritter.js
dataTables.bootstrap.js

allan

Happy to take a look at a test case showing the issue. All you should need to do is add the footer: true option has you have done.

Allan

hojiev@gmail.com

it is code correct ?
but it is still not exported footer

hojiev@gmail.com

• @version 1.10.7
  
  • @file jquery.dataTables.js

kthorngren

I built an example for you to start from. I used the Footer Callback example to build a summation in the footer.

http://live.datatables.net/yesaxili/1/edit

The example works.

I'm not sure what the function zSumArr is. Maybe you can update the example to show the problem you are having.

Kevin

hojiev@gmail.com

Thank you
The error was in sumArr