Export data in excel format #3800

debayan31 · 2015-06-18T04:47:07Z

Is this possible to export grid data in excel format?

Currently we can export data in CSV and PDF format.

PaulL1 · 2015-06-18T04:52:38Z

CSV can be imported to Excel. Excel format is not a documented format, so no we cannot export to it.

debayan31 · 2015-06-18T06:25:37Z

Excel means .xls file.

There may be a issue if I export a grid data which contains comma,semicolon or any special character then after impoting this to Excel, It may not open in desired format.

PaulL1 · 2015-06-18T11:08:13Z

There may be an issue, but the csv format should quote or escape those things appropriately. As noted, .xls isn't a documented/open format, so it's not really possible to build something that creates xls. The normal method is to create csv.

JLLeitschuh · 2015-06-20T01:38:01Z

Actually .xls is a documented/open format:
jqwidgets actually supports xls output: http://www.jqwidgets.com/jquery-grid-export-to-excel/
The format is documented here: http://blogs.msdn.com/b/brian_jones/archive/2005/06/27/433152.aspx

That being said, someone would have to write an implementation to create an exporter for this.
We could alternatively have an optional dependency upon something like this:
http://jordiburgos.com/post/2013/javascript-export-to-excel.html

PaulL1 · 2015-06-20T03:07:01Z

That's interesting, wasn't aware of that. I do think that csv suits most purposes though - exporting to .xls just adds complexity I would have thought.

uguryilmaz · 2015-06-30T08:56:21Z

that would be awesome if someone implements this functionality. most of the companies uses excel export. and most of the grid components of various companies have this export function. i think ui-gird must have this function as well.

JLLeitschuh · 2015-06-30T14:05:18Z

We are open to pull requests to add enhancements.

sunz7 · 2015-10-23T23:56:01Z

+1

bjaraujo · 2015-10-30T09:40:27Z

+1

PaulL1 · 2015-11-18T07:05:18Z

This is a useful request, but not really in the current roadmap. We have far too many good ideas in the repository already, giving the impression that we have a project riven with defects.

Accordingly, I am leaving the enhancement tag on this, but closing it. If someone would like this functionality, we'd welcome a pull request that adds it.

Mastanka · 2015-12-31T15:36:06Z

+1

sidd06 · 2016-01-05T10:34:08Z

+1

Incognito-Nemo · 2016-01-31T18:40:16Z

+1

KennedyIhe · 2016-03-14T16:03:05Z

+1

laviyatziv · 2016-03-24T16:18:04Z

+1

dishant8 · 2016-04-06T18:13:58Z

+1

ganesh-vellanki · 2016-04-07T14:36:49Z

+1

bjaraujo · 2016-04-21T07:47:28Z

Maybe saving the html as xls would be enough?

Example from: http://jordiburgos.com/post/2013/javascript-export-to-excel.html

somedata.xls

<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><!--[if gte mso 9]><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet><x:Name>undefined</x:Name><x:WorksheetOptions><x:DisplayGridlines/></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets></x:ExcelWorkbook></xml><![endif]--></head><body><table>
    <tbody><tr>
        <td>100</td>
        <td>200</td>
        <td>300</td>
    </tr>
    <tr>
        <td>400</td>
        <td>500</td>
        <td>600</td>
    </tr>
</tbody></table></body></html>

chrisruddick · 2016-05-03T18:27:51Z

+1

anasanzari · 2016-06-01T14:17:58Z

+1

rbaras · 2016-06-02T16:38:07Z

+1

Scuttman · 2016-06-10T21:59:36Z

+1

yogeshkumarpa · 2016-06-11T17:50:07Z

+1

oyiadom · 2016-09-12T16:14:08Z

+1

A nice compromise might be to add the tab-delimited format (TSV) as an export option. This would work around the comma-related issue that @debayan31 mentioned with CSV files but still enable users to open the file in Excel. I suspect changing the delimiter from a comma (",") to a tab ("\t") in the source code is trivial. From what I have seen, Microsoft is using the ".txt" file extension (e.g. as opposed to ".tsv") as the standard for tab-delimited files (and, in general, for files delimited with anything other than a comma).

Reference
https://support.office.com/en-us/article/Import-or-export-text-txt-or-csv-files-5250ac4c-663c-47ce-937b-339e391393ba

csvan · 2016-10-20T08:10:03Z

I solved this by converting the standard CSV export to .xlsx via this lib: http://excelbuilderjs.com/. It is relatively simple for most cases.

lreisoliveira · 2016-12-06T17:04:04Z

@csvan http://excelbuilderjs.com is down

lreisoliveira · 2016-12-06T17:05:27Z

About export to xls
+1

For example: this Query works fine http://jsfiddle.net/jqwidgets/6HRU8

csvan · 2016-12-06T21:38:18Z

@lreisoliveira the maintainer shut it down. It was fine when I posted that.

rawatshailender · 2017-01-05T14:02:48Z

+1

Romender · 2017-02-04T00:22:55Z

+1

gokhancelik · 2017-04-24T20:44:30Z

I can achive using jx-xlsx https://github.com/SheetJS/js-xlsx
and FileSaver.
Running plunkr here

http://plnkr.co/edit/DVhIUgGD04yDXtjp7ReW

feliperugai · 2017-08-03T20:26:16Z

@gokhancelik that's exactly what I needed. It works like a charm. Thank you!

alejandrorossi · 2017-09-25T18:29:29Z

+1

dcm93 · 2017-10-11T23:41:06Z

@gokhancelik I am trying to use your excel exporter service but I can't figure out what is your property "e" in the range object in the addCell function. Thanks in advance!

nashnight · 2017-10-13T00:12:06Z

SheetJS Angular demo shows ui-grid import and export: https://github.com/SheetJS/js-xlsx/tree/master/demos/angular

bobisch · 2018-03-15T22:07:06Z

Apparently this functionality now exists in ui-grid proper, since v4.0.11 (2017-11-20), through the exporterMenuExcel and exporterExcel* options (due to merging in PR #6199 (Excel export), per @csvan or @monster910).

In fact, it appears to be enabled by default, even if the required support modules are not available.
To work it requires the "excel-builder" npm module and maybe some other dependencies. That could be the source of some other issues reported - #6581, others?

The big problem, as mentioned above by @lreisoliveira, is that excel-builder is no longer supported.
It seems to be pretty dead. See https://github.com/stephenliberty/excel-builder.js and the big No longer maintained statement at the top.

Question: should we be looking at a replacement for excel-builder? Possibly SheetJS/js-xlsx - https://github.com/SheetJS/js-xlsx

Alternatively: Someone should take over excel-builder support or one of the (several) existing forks could be promoted as official?

Also, the "enhancement" and "waiting-response" tags and milestone are probably not appropriate for this issue anymore - it's confusing because this thread comes up in searches and the reason for closing it makes it sound like it's still an issue.

monster910 · 2018-03-18T05:12:12Z

XLSX is a good choice as it also has import/parse capabilities. It lacks the capabilities of excel-builder without a license.

All open source is roll your own. Feel free to create a new branch and work on a new Excel export.

PaulL1 added the waiting-response label Jun 18, 2015

JLLeitschuh added the type: enhancement label Jun 20, 2015

JLLeitschuh added the grid-exporter label Jun 30, 2015

JLLeitschuh added this to the Future milestone Jun 30, 2015

PaulL1 closed this as completed Nov 18, 2015

Export data in excel format #3800

Export data in excel format #3800

Comments

debayan31 commented Jun 18, 2015

PaulL1 commented Jun 18, 2015

debayan31 commented Jun 18, 2015

PaulL1 commented Jun 18, 2015

JLLeitschuh commented Jun 20, 2015

PaulL1 commented Jun 20, 2015

uguryilmaz commented Jun 30, 2015

JLLeitschuh commented Jun 30, 2015

sunz7 commented Oct 23, 2015

bjaraujo commented Oct 30, 2015

PaulL1 commented Nov 18, 2015

Mastanka commented Dec 31, 2015

sidd06 commented Jan 5, 2016

Incognito-Nemo commented Jan 31, 2016

KennedyIhe commented Mar 14, 2016

laviyatziv commented Mar 24, 2016

dishant8 commented Apr 6, 2016

ganesh-vellanki commented Apr 7, 2016

bjaraujo commented Apr 21, 2016

chrisruddick commented May 3, 2016

anasanzari commented Jun 1, 2016

rbaras commented Jun 2, 2016

Scuttman commented Jun 10, 2016

yogeshkumarpa commented Jun 11, 2016

oyiadom commented Sep 12, 2016 • edited

csvan commented Oct 20, 2016

lreisoliveira commented Dec 6, 2016

lreisoliveira commented Dec 6, 2016 • edited

csvan commented Dec 6, 2016

rawatshailender commented Jan 5, 2017

Romender commented Feb 4, 2017

gokhancelik commented Apr 24, 2017 • edited

feliperugai commented Aug 3, 2017

alejandrorossi commented Sep 25, 2017

dcm93 commented Oct 11, 2017

nashnight commented Oct 13, 2017

bobisch commented Mar 15, 2018

monster910 commented Mar 18, 2018

oyiadom commented Sep 12, 2016 •

edited

lreisoliveira commented Dec 6, 2016 •

edited

gokhancelik commented Apr 24, 2017 •

edited