Hi,

I was trying to export xls and doc, but fails filename and fails extension, here is the solution 💊

💻 Current line (line 279):
window.open('data:application/vnd.ms-'+defaults.type+';filename=exportData.doc;' + base64data);

Replace the current line with:
⚡ powerful new lines:

var anchor = document.createElement('a');//Create an anchor element
document.body.appendChild(anchor); //Add it to document
anchor.href = 'data:application/vnd.ms' + (defaults.type === 'doc' ? 'word' : '-' + defaults.type) + ';filename=exportData.doc;' + base64data; //Create content and mime type
anchor.download = 'exportData.' + (defaults.type === 'excel' ? 'xls' : (defaults.type === 'powerpoint' ? 'ppt' : defaults.type)); //Custom filename+ext (ext fix)                  
anchor.click();//Launch

Office MIME Types:

• http://filext.com/faq/office_mime_types.php

✅ Tested on: Chrome, Firefox.
(Sorry IE).

😬

Hello, nice work on this plugin. I noticed that some of the output types, like PDF for instance, appear within the same browser window. This can be confusing to some users who do not realize they need to hit the back button to get back to the page. They may close the window instead.

Could you modify the plugin so the output always appears in a new browser window?

Hi,
First, great tool.
But it's not working with DataTables with pagination https://datatables.net/.
If I have a table with 10 rows per page your script will export only that 10 rows in excel, for example.

如题！ 目前是否支持翻页呢？？如何实现 ？ 静候答复！！

Can someone please post a fiddle or an example of how to call in the approach files, initialize and export a table to PDF on a button press? I think either I called in the wrong files or I'm failing to understand how to properly initialize the plugin. Thanks.

Update (Resolved): I was able to resolve my issue once I found this link with examples.
http://ngiriraj.com/pages/htmltable_export/demo.php

I have a table that uses rowspan & colspan. When i try to use the ignoreColumn & ignoreRow then dont work correctly with it. Also both rowspan & colspan uses indexes to ignore , it would be nice to have also a possibility of doing it with a class name . This can help ignore rows / columns dynamically.

Dear,
I have a dataTable with 3288 rows, the export to excel is ok with dataTable arround 1000 rows but when the number of rows too many, it can't export to excel.
Please help me is there anyway to fix it?
Thank you.

Is there any way to change my default's worksheet when exporting an excel type using this plugin?
The default name is: 'xlsWorksheetName'.
In code, I already set up its tableName but it does not change worksheet name.

Thanks in advance

When the Powerpoint option is used, Powerpoint opens and a new slide is created, but the table is not included.

Hi and Thanks to your action
I add all js to my php file.
1- Please tell me how add those to jquery Plugin?

XML

is there a dependency on excel version ? the excel is created perfectly fine with version 2010 but with 2007 it is distorted

When i download the file the file name is in encoded form. I dont want it to be encoded. I need to enter the filename manually or during intialisation

When exporting as a csv the file format .csv isn't appended to the downloaded file.

When opening the excel file downloaded in office 2013 I get the following message:

The file format and extension of download.xls don't match. the file could be corrupted or unsafe.

also is would great to have an option to name the downloaded files. So for example you could have 'mydata-10-09-2014.csv'

When converting table to PDF only first four columns are selected rest are ignored.

Hi,

I am using this extension and I have some questions:

1. Why does csv not save as .csv?

• I have to rename the file and add .csv
• same with txt, sql, and word

Also when choosing to export as PDF it looks like this:

jquery 2.0 not support

Hi team,

I was working with custom page. In my application i have a table with data and i need to export the data in to an excel sheet. I used the same code which is given in this site. Its working very fine in Chrome browser. But its not at all working in Internet Explorer. Can anyone tell me what we need to change it in the plugin.

Thanks
Nagarajan
9841766690****

Hi and Thanks to your action
I add all js to fist of my php file.
1- Please tell me i must add blow js to jquery Plugin?
"tableExport.js" and "jquery.base64.js" if Yes how?
Also my table in mysql database is "result".
2-I must change "customer " to "result" in php code?

when I use exceldownload,the Firefox explorer seems to have some characters problems.It shows that "you are openning ....+PC9yenieYLLm+8mdejUUMSTW+...",rather than "you are openning the file named download'",could anyone help with my problem?

All columns in a table are not exported to pdf out of 13 only 4 are showing.
I also want to show arabic data from my same table,but it is showing in incorrect way.

I try to export file

i add this

<a  href="#"   onclick="$('#tabledata').tableExport({ type: 'excel', escape: 'false' });" style="background-color: #3399FF; color: #FFFFFF; font-weight: bold; font-size: medium">XLS</a>

<a  href="#"   onclick="$('#tabledata').tableExport({ type: 'pdf', escape: 'false' });"  style="background-color: #3399FF; color: #FFFFFF; font-weight: bold; font-size: medium">PDF</a>

now the problem i have 6columns in table but pdf display only 4 columns

check image
http://i.stack.imgur.com/r4Etu.png

Hi Thanks for the tutorial i want to add borders on table when the html table is export to pdf can you help me on this....?

Hi, I tried using this plugin to export datatable to excel. It works fine with chrome but not with Internet Explorer. Any work around or a settings that could help? Please suggest. Thanks!!

I notice that in options there is a ignoreColumn propertie is there anything to ignore a row?

Btw Awesome plugin!

When the text options are used (like CSV), and the output is opened in notepad, carriage returns and line feeds CRLF are not included at the end of data rows. This may cause complications for applications that consume the output as they may require CRLF to denote when a particular data line ends.

The tfoot tags are not being included in exportation

I am thinking about using this plug in on my web table. I have a html table and some cells have background colors. When I import the data to the excel, will those cell colors be imported as well? Thanks

Hi good evening, i make a change when export to excel, is better make a Blob object :)

var ext = "doc";
if(defaults.type == "excel"){
ext = ".xls";
}

var blob = new Blob([excelFile], { type: 'text/plain' });
var a = document.createElement('a');
a.href = window.URL.createObjectURL(blob);
a.download = defaults.tableName + ext;
a.click();

//window.open('data:application/vnd.ms-'+defaults.type+';filename=otro.doc;' + base64data);

The export function doesnt work at all, and I got Uncaught TypeError: Cannot read property 'encode' of undefined , tableExport.js line 55.

I am using jquery 2.0.2.

Hello, I have to save the export directly into a folder on the server and then pass a URL to the user? My user wants not download directly

How can I export all data table rows because it just export the first 10 rows as pagination show in page

The extension of the excel export is xls, which is rather outdated.
Does this mean the format is actually oldschool pre-2007 xls, or does it use xlsx behind the scenes?

And if not, could that become an option?

I've installed the show-export plug-in for the table, followed the installation guide, added the scripts etc. then added the code for the table.. but it doesn't show. It's completely stumped me, so I reninstalled with the aid of a friend and still no luck!

The code for my table:

<table 
data-toggle="table" 
data-url="/assets/ajax/get-export-docs.php" 
data-show-columns="true"
data-search="false" 
data-show-refresh="true"
data-show-toogle="true"
data-show-export="true"
data-side-pagination="server"
data-pagination="true" 
data-page-list="[5, 10, 20, 50, 100, 200]" 
data-query-params="queryParams"  
data-toolbar="#filter-bar"
data-show-filter="true"
data-height="500" id="export-table">

my script code:

<!-- Show export plug in -->
<script src="/assets/plugins/tableExport-jquery-plugin/tablExport.jquery.json"></script>
<script type="text/javascript" src="/assets/plugins/tableExport-jquery-plugin/tableExport.js"></script>
<script type="text/javascript" src="/assets/plugins/tableExport-jquery-plugin/jquery.base64.js"></script>
<script type="text/javascript" src="html2canvas.js"></script>
<script type="text/javascript" src="jspdf/libs/sprintf.js"></script>
<script type="text/javascript" src="jspdf/jspdf.js"></script>
<script type="text/javascript" src="jspdf/libs/base64.js"></script>

is there something wrong? I've also checked firebug and clicked the script links to see if that was the reason but they go to that document.

Export to PNG doesn't work on Chrome.
Version tested 35.0.1916.153 m

http://ngiriraj.com/pages/htmltable_export/demo.php

Is anyone else getting this sort of error? I don't know if this is an issue with jsPDF, jsPDF autotable, or this library.

I have attached my table, the function call, and the restulting pdf.

<a href="#" onclick="$('.pvtTable').tableExport( {type: 'pdf',jspdf: {format: 'bestfit', autotable: {tableWidth: 'wrap'}}});">PDF</a>

tableExport(2).pdf

What is the package name of this plugin? i need to do: bower install tableExport.jquery.plugin

When I see the last update I guess so.

Have UTF-8 character problem.

Failed to load resource: the server responded with a status of 500 (Internal Server Error)
/js/tableExport.js Synchronous XMLHttpRequest on the main thread is deprecated because of its detrimental effects to the end user's experience. For more help, check http://xhr.spec.whatwg.org/.

Hi When exporting a file the .csv extension isn't beeing aded. Is this a Bug?

Hello,

I have a little disagrement with my table structure : colspans and rowspans are not 'translate' from Html to Excel causing shifts in the exported file :/

any idea to solve that ?

This may be beyond the capabilities of JavaScript but I thought I would ask anyway.

This plugin does not work in Internet Explorer because I believe it sends the output as a data URI (http://en.wikipedia.org/wiki/Data_URI_scheme).

From what I read here (http://www.jquerybyexample.net/2012/10/export-table-data-to-excel-using-jquery.html ), IE requires a response header. Is it possible to generate a header on the client side in some way so this plugin works for IE? There is a solution here (http://www.jquerybyexample.net/2014/04/export-table-to-excel-jquery-ie.html ) but is a server side solution.

Maybe a post in the links above could provide a workable client side solution? A reply from David Rainsford here (http://stackoverflow.com/questions/393647/response-content-type-as-csv ) looks interesting.

Unhandled exception at line 136, column 7 in http://localhost:19211/Scripts/export/jquery.base64.js
0x800a139e - JavaScript runtime error: INVALID_CHARACTER_ERR: DOM Exception 5

Hi all,

is there someone motivated to fork, maintain and enhance this project ?

wheni export a table with chinese,the plugin throw this exception:
"uncaught exception: INVALID_CHARACTER_ERR: DOM Exception 5"

Hello i would like to add some text before table and a title in my PDF but i don't know how i can make it.
There is my code

$('#table_div').bootstrapTable({
        exportOptions : {
            fileName : 'liste_deduction_patro',
            worksheetName : 'deductions_patro',
            jspdf : {
                orientation : 'l',
                autotable: {styles: {cellPadding: 2,
                                     rowHeight: 12,
                                     fontSize: 8,
                                     fillColor: 255,       
                                     textColor: 50,         
                                     fontStyle: 'normal',   
                                     overflow: 'ellipsize', 
                                     halign: 'left',        
                                     valign: 'middle'      
                                    },
                            headerStyles: {fillColor: [52, 73, 94],
                                           textColor: 255,
                                           fontStyle: 'bold',
                                           halign: 'center'
                                          },
                            alternateRowStyles: {fillColor: 245
                                                },
                                                createdHeaderCell: function (cell, data) {},
                            tableExport: {onAfterAutotable: null,
                                          onBeforeAutotable:null,
                                          onTable: null
                                         }
                           }
            },
            ignoreColumn : [0]
        }
    });

If the HTML contains cells using rowspan then the table is not exported properly. Can support be added to accommodate the use of rowspan?

i can export but can export text in array func