Title: [SOLVED AS AN EXTENSION] Printing - Convert to csv, xls, pdf from datagrid Post by: jega on May 04, 2018, 07:14:04 AM HI.
I'm a very happy user of easyui. Today i got an advertising of jqwidget, and was looking at it. EasyUI and jqWidget can do many of the same things but also some different things. One thing that i find very nice is the feature in jqxgrid. Data export and data printing. I think that a lot of people will love these features. Any chance for that in easyui ?? Or when ?? ;-) Regards Jesper Title: Re: Printing - Convert to csv, xls, pdf from datagrid Post by: Alfred on May 04, 2018, 07:31:26 AM It would be nice if Easyui could integrate the same. I am using MPDF for PDF, PHPExcel for Excel and for chart, HighChart. So I depend a lot on third party library.
Title: Re: Printing - Convert to csv, xls, pdf from datagrid Post by: jarry on May 06, 2018, 01:32:39 AM The exporting extension can be downloaded from https://www.jeasyui.com/extension/downloads/datagrid-export.zip
Title: Re: Printing - Convert to csv, xls, pdf from datagrid Post by: jega on May 06, 2018, 01:04:05 PM Hi Jarry
Thanks for the code Printing works fine, but export to excel fails. Error description SCRIPT122: Det dataområde, der blev sendt til et systemkald, er for småt. (In English: The dataarea which is send to a systemcall, is too small) Error in line 59 alink[0].click(); Tried different things, but can't get it to work Jesper Title: Re: Printing - Convert to csv, xls, pdf from datagrid Post by: jarry on May 06, 2018, 06:56:40 PM The IE has the url length limit. Please re-download the 'datagrid-export.js' file to fix this issue.
Title: Re: Printing - Convert to csv, xls, pdf from datagrid Post by: jega on May 06, 2018, 10:48:23 PM Hi Jarry
This works. BUT. Then i had a problem with Danish charset. Added <meta http-equiv="content-type" content="application/vnd.ms-excel; charset=UTF-8"> before <head> and i now have Danish in the excel file What about toCSV and toPDF ;-) Title: Re: Printing - Convert to csv, xls, pdf from datagrid Post by: thecyberzone on May 07, 2018, 01:58:00 AM And what about Convert2PDF ???
Title: Re: Printing - Convert to csv, xls, pdf from datagrid Post by: jarry on May 08, 2018, 01:05:04 AM Call the 'toArray' method to get the array data and use the pdfmake library to create the pdf.
Code: var body = $('#dg').datagrid('toArray'); Title: Re: Printing - Convert to csv, xls, pdf from datagrid Post by: jega on May 08, 2018, 11:51:38 PM Hi Jarry
Have no method toArray ??? Title: Re: Printing - Convert to csv, xls, pdf from datagrid Post by: jarry on May 09, 2018, 06:14:23 PM Please download a newer version from from https://www.jeasyui.com/extension/downloads/datagrid-export.zip
Title: Re: Printing - Convert to csv, xls, pdf from datagrid Post by: proceno72 on May 09, 2018, 11:39:31 PM Please download a newer version from from https://www.jeasyui.com/extension/downloads/datagrid-export.zip Wow, I've been waiting for a while this kind of extension. When it will be "official" and then documented? As I wrote on ather post, it could be a good practice on extensions site pages to show a changelog, a version number or at least a "last modified date". It's very difficult for me realize if I'm using the latest version of any extensionTitle: Re: Printing - Convert to csv, xls, pdf from datagrid Post by: Pierre on May 09, 2018, 11:42:16 PM Jarry, this is awesome, thank you for your work. :)
Title: Re: Printing - Convert to csv, xls, pdf from datagrid Post by: jega on May 10, 2018, 01:22:24 AM Downloaded the new version.
On calling var body = $('#dg').datagrid('toArray'); i get this error SCRIPT438: The object does not support the feature or method 'toArray' jquery.easyui.min.js (11055,1) jquery.easyui.min.js is version 1.5.5.1 Same problem on two different IIS servers Title: Re: Printing - Convert to csv, xls, pdf from datagrid Post by: jarry on May 10, 2018, 02:52:01 AM Please look at this example http://code.reloado.com/ulosin4/2/edit#preview
Title: Re: Printing - Convert to csv, xls, pdf from datagrid Post by: jega on May 10, 2018, 05:38:47 AM Hi Jarry
The sample works fine yes, but i have the same code, and mine fails. What i found was, that i do not have the function toArray() in datagrid-export.js When i download the newest zip file, i still get an zip file with an old version. Maybe a cache problem. Downloaded the file from https://www.jeasyui.com/easyui/datagrid-export.js instead, and now i have a datagrid-export.js with the toArray function, and everything works. Jesper Title: Re: Printing - Convert to csv, xls, pdf from datagrid Post by: chorauoc on May 13, 2018, 05:12:25 AM Hey,
Can you please add this extension in the Extension section in the WEB, because this is not available yet, have to come here to this post to get it Title: Re: Printing - Convert to csv, xls, pdf from datagrid Post by: jarry on May 13, 2018, 07:41:18 AM It can be obtained on https://www.jeasyui.com/extension/datagrid_export.php
|