Export Footer - Excel Export

Malvika11 · January 2016

Hello,
I want to insert "Current Date" as a footer and have it exported to Excel. I added that as a separate row, but it doesnt export that particular row.
How can the footer be also exported?
Thanks in Advance.
Here is the code:

$(document).ready(function() { var buttonCommon = { exportOptions: { trim:true, format: { header: function ( data, columnIdx ) { switch(columnIdx) { case 9: return 'Budget Variance ($)' break; case 11: return 'Budget Variance (%)' break; default: return data } } } } }; $('#Table').DataTable( { dom: 'Bfrtip', buttons: [ $.extend( true, {}, buttonCommon, { extend: 'excelHtml5', title: 'Dashboard Table' ,exportOptions: { columns: [ 0, 1, 2,3, 5, 7,9,11] } } ) ], "iDisplayLength": 50, } ); } );

</head>
<body>

<

div class="row-fluid">

<

div class="col-md-12">

                            <div class="panel panel-info                                ">
                                <div class="panel-heading">
                                    <h4> <tr> Hello &nbsp; &nbsp;</tr>

                                          <tr> Total Projects:  </tr>
                                          <tr> World </tr>
                                          <tr>  &nbsp; &nbsp; Datatable Tryout   </tr>


                                </div>
                                    <div class="panel-body">
                                        <div class="table table-responsive" >
                                            <table class = "table table-bordered"  id="Table">
                                                <thead>

                                    FOOTER I WANT TO EXPORT:
                  <td><cfoutput>#DateFormat(Now())#,
                                                #TimeFormat(Now())#</cfoutput> </td>




                                                <tr>


                                                    <TH class="small text-wrap text-center" rowspan="2"> ORRID</TH>
                                                    <TH class="small text-wrap text-center" rowspan="2"> Project Name</TH>
                                                    <TH class="small text-wrap text-center" rowspan="2"> Client Agency</TH>
                                                    <TH class="small text-wrap text-center" rowspan="2"> Managing Agency</TH>
                                                    <TH class="small text-wrap text-center" rowspan="2"> Baseline Budget</TH>
                                                    <TH class="small text-wrap text-center" rowspan="2" style="display:none"> Baseline Budget ($)</TH>
                                                    <TH class="small text-wrap text-center" rowspan="2"> EAC</TH>
                                                    <TH class="small text-wrap text-center" rowspan="2" style="display:none"> EAC ($)</TH>
                                                    <TH class="small text-wrap text-center" colspan="2" > Budget Variance</TH>
                                                    </tr>
                                                    <tr>
                                                    <th class="small text-wrap text-center" id="myID">$</th>
                                                    <TH class="small text-wrap text-center" style="display:none"> $ </TH>
                                                    <th class="small text-wrap text-center">%</Th>
                                                    <TH class="small text-wrap text-center" style="display:none"> % </TH></tr>

                        <tbody>
                                                <cfloop query="qryBudget">



                                                <tr>

                                                    <TD class="small text-wrap text-left">1</TD>
                                                    <TD class="small text-wrap text-left">2</TD>
                                                    <TD class="small text-wrap text-center">3</TD>
                                                    <TD class="small text-wrap text-center">4</TD>
                                                    <TD class="small text-wrap text-right">$5</TD>

                                                    <TD class="small text-wrap text-right">7</TD>

                                                    <TD class="small text-wrap text-right">$8</TD>



                                                     <TD class="small text-wrap text-center"  >10</TD>


                                                </tr>




                                                </tbody>

                                                    </thead>

Export Footer - Excel Export

Export Footer - Excel Export

Howdy, Stranger!

Categories

DataTables

Export Footer - Excel Export

Export Footer - Excel Export

Howdy, Stranger!

Quick Links

Categories

DataTables