export/copy to excel

[thezoggy]

noticed that on this 'grid' they have a export to excel/pdf and also a copy to excel..
http://demos.telerik.com/kendo-ui/grid/excel-export
http://demos.telerik.com/kendo-ui/grid/copy-to-excel

didnt tablesorter used to have the export feature? cant seem to find it...

[thezoggy]

looks like this was brought up under: #963
wonder if we could just serve up a copy to csv since thats just serializing the data?

[Mottie]

Hi @thezoggy!

The output widget allows you to output csv, tsv and JSON. Excel should still properly load these files.

To copy data directly to excel would require a method to select table cells. I don't have anything like that yet.

[Mottie]

I just tested it, I saved a CSV file with a .xls extension and loaded it in Excel. It thought the file was corrupt, but still allowed me to load it... everything looks good.

[thezoggy]

thanks, couldnt find that one.. also btw that page looks like its missing the page header section..
https://mottie.github.io/tablesorter/docs/example-widget-output.html

[thezoggy]

on that output widget..
i would say offer up an option to change if it includes the header/footer in the output: no header+footer, header only, none
since normally I've never seen a footer in a csv file.. and i know the header is optional..

[Mottie]

LOL thanks... there are a lot of demos missing the page header; it's hard to be consistent ;)

As for the header & footer.. there are options:

• output_headerRows
• output_includeFooter

I just haven't included the options in the popup, which by the way is completely customizable.

[thezoggy]

yeah, the option is in one popup but not in the other.. no worries :)

[Mottie]

Actually, the headerRows option is set up to include all header rows, or just the last. I need to add a includeHeaders option.

[Mottie]

I discovered that if you set the output_separator to a tab ("\t"), open a popup and copy the contents... you can now paste directly into Excel and the data will be added into separate cells.

[thezoggy]

nice, good to know