Check the previous article for more information on: Javascript export to Excel

Updated to v3.3.0

The ExcellentExport library is having a lot of visits, from people coming directly to the page or redirected by search engines. So, I decided to update it.

I have got some ideas from comments on the blog or discussions on reddit.

Download the new version from: ExcellentExport.js v3.3.0

Revision history:

3.3.0

• Remove columns by index
• Filter rows by value
• Updated build to Webpack 4.x.x

3.2.1

• Update npm dependencies to fix vulnerabilities

3.2.0

• Update npm dependencies to fix vulnerabilities

3.1.0

• Fix old API for base64 and escaping problem.

3.0.0

• XLSX support. This bumps the build size to 640 KB.
• New API: ExcellentExport.convert(…)
• Autogenerate download filename.
• Data input from arrays or HTML Tables.
• Multiple sheets for XLS or XLSX formats.

2.1.0 (24/09/2017)

• Add Webpack build.
• Create UMD JavaScript module. Library can be loaded as a module (import, RequireJS, AMD, etc…) or standalone as window.ExcelentExport.

2.0.3 (21/01/2017)

• Fix export as a module.
• Changed minifier to UglifyJS.

2.0.2 (10/01/2017)

• Fix CSV Chinese characters and other special characters display error in Windows Excel.
• Fix URL.createObjectURL(…) on Firefox.

2.0.0 (03/10/2016)

• Now it can export to big files +2MB.
• Minimum IE 11.
• Links open with URL.createObjectURL(…).
• NPM package available.
• Using Semantic versioning (2.0.0 instead of 2.0).
• Module can be loaded standalone or with RequireJS.
• Change license to MIT.

1.5

• Possibility to select a CSV delimiter.
• Bower package available.
• Compose package available.

1.4

• Add LICENSE.txt with GPL v3.
• UTF-8 characters fixed.

1.3

• Added minified version.

1.1

• Added CSV data export

1.0

• Added Excel data export

Working example

New API

ExcellentExport.convert(options, sheets);

options

     {
        anchor: String/Element,
        format: 'xlsx'/'xls'/'csv',
        filename: String
     }

sheets: array

Each of the elements of the sheets parameter:

     {
        name: 'Sheet 1', // Sheet name
        from: {
            table: String/Element, // Table ID or table element
            array: [...], // Array with data
            arrayHasHeader: true, // Array first row is the header
            removeColumns: [...], // Array of column indexes (from 0)
            filterRowFn: function(row) {return true} // Return true to keep
        },
        ...
     }

Conclusion

Now ExcellentExport.js basically works on all browsers. It is ready for you to use on your projects.

Check on github or this blog for updates. ExcellentExport.js.