Updated Export Functionality (to PDF, Excel) for Grid and Scheduler

| Comments (29)

A few months ago we told you about the new export functionality available for dhtmlxGrid (export to PDF and Excel) and dhtmlxScheduler (export to PDF). These features were ‘fresh’ and had a few imperfections, but they have been since tested and improved. Today we present the update pack that eliminates all the known bugs.

What’s New
Though the bug fixes were a great deal of work, we’ve also made a number of improvements to each feature. For example, there are two major enhancements in dhtmlxScheduler-to-PDF. The first one is the option to export Unit View to PDF, which you couldn’t do in the previous version.

Scheduler - Export to PDF

dhtmlxScheduler - Export to PDF

The second improvement for the Scheduler-to-PDF service is support for custom colors. Now you can view the colored events in a PDF file, the same way as they would look in dhtmlxScheduler embedded on a webpage.

As for dhtmlxGrid, we have removed all the limitations for export functionality, which could be quite annoying if you used grids with complex structures. Now both grid-to-PDF and grid-to-Excel features support:

  • Hidden columns
  • Footer
  • Custom colors

 
So with this update you are free to use the advanced grid options without having to worry about problems on export.

dhtmlxGrid - Export to PDF

dhtmlxGrid - Export to PDF

The Grid-to-Excel service also allows custom content, which means that you can add some additional content (e.g., a company logo) to the Excel file generated from dhtmlxGrid.

Downloads
Use the links below to download the newest PHP version of the export packages:

 
UPDATE: If you need the export functionality for Java or ASP.NET, you can download these packages here.

 
Documentation
Answers to configuration questions concerning the mentioned features can be found in the appropriate documentation:

 
What’s Next
In the future, we plan to extend the list of the Scheduler views available for export to PDF, and the next update will bring printing capabilities to the TimeLine View, for both tree and cell modes. If you have any ideas or suggestions on export functionality for both dhtmlxGrid and dhtmlxScheduler, feel free to share them in the comments.

Comments

  1. ikhsan September 18, 2010 at 7:34 am

    hi dhtmlx team,

    my grid have a different colour format, but when i try to export the grid, it’s still produce blue-white coloured,
    when i try to disabling this color format,

    $colors = Array();
    if (isset($cell->attributes()->bgColor)) {
    $colors[‘bg’] = (string) $cell->attributes()->bgColor;
    }
    //just commenting this part
    /* else {
    if ($i%2 == 0) {
    $color = $this->scaleOneColor;
    } else {
    $color = $this->scaleTwoColor;
    }
    $colors[‘bg’] = $color;
    }*/

    it says this error

    /var/www/html/hr/core/convert/gridPdfWrapper.php at 253 : Undefined index: bg

  2. Jerry September 21, 2010 at 6:49 am

    Hi dhtmlx team,

    I am wondering if it’s possible to print a bunch of months in one pdf, and of course one month per page.

    Like I want to print from August to October, and it would generate a pdf with 3 pages.

    Great thanks for your help. Your works are awesome. Come on.

    • ivan September 21, 2010 at 1:04 pm

      The Scheduler can export in PDF only current view, so it is not possible to export multiple months at once (at least not without heavy customization).

  3. josh October 20, 2010 at 6:18 am

    is there an approx. eta for the java version of this utility?

    • ivan October 20, 2010 at 4:13 pm

      Most likely the Java version will be released in a month or two.

      • luis December 10, 2010 at 4:35 am

        Hello, have you released the Java version yet?

        • Inga December 23, 2010 at 2:36 pm

          No, unfortunately we haven’t released it yet. The release has been postponed.

        • ivan January 13, 2011 at 1:09 pm

          We’ve released the Java version for dhtmlxGrid: http://www.dhtmlx.com/blog/?p=855

    • ivan January 13, 2011 at 1:09 pm

      The Java version is available, please check: http://www.dhtmlx.com/blog/?p=855

  4. Christian January 13, 2011 at 8:19 pm

    It would be nice to find a way that data to export (excel and pdf) ist taken direktly by the datasource from the server. So the performance for large tables could increase!

  5. Tory Ariyanto March 12, 2011 at 9:40 am

    Thank’s For DHX Team….. ur product help me so much. Thanks….. From Tory ariyanto Indonesia

  6. Tory Ariyanto March 13, 2011 at 8:39 am

    I use phpMyadmin and version of the php is 5.2.0
    when I test the sample of grid2excel, it’s only open blank page… help me please….

  7. Grid-to-Excel, Grid-to-PDF Available for... March 18, 2011 at 7:02 pm

    […] export to Excel and PDF services for Java. This functionality has been already introduced for PHP, but we are finally releasing the Java version. We know that many of you have been expecting this […]

    • Ganesh July 25, 2012 at 5:24 pm

      but where is the document for java?
      how to use dhtmlx grid to excel package?

      • Ivan August 1, 2012 at 12:46 pm

        Ganesh, unfortunately there is no separate documentation for Java but the way of using the export service is the same.

  8. Trapti Gautam July 19, 2011 at 2:02 am

    Hello,

    We are using dhtmlx scheduler java version in our application. Now there is a requirement where we want to print the timeline into pdf . Looking at blog here i can see you have introduced functionality for print to pdf in dhtmlx grid . When are you guys thinking of introducing printopdf functionality for timeline in java. this is an utmost requirement for us right now .Please advice.

    thanks

    • Stanislav July 21, 2011 at 1:39 pm

      Will be available as part of oncoming scheduler 3.0 ( not later than end of July )

  9. Steve Monteith August 30, 2012 at 10:21 pm

    We are trying to use both grid2excel and grid2pdf using php. The first column in all of our grids are hidden. The grid2excel works great (hides the first column). The grid2pdf hides the first header column BUT does not hide the first data row column so the grid2pdf is incorrectly generated and of no use. I just updated the files to make sure I had the most recent files. Can this issue be resolved?

    Thanks

    Steve

    • Ivan September 17, 2012 at 4:09 pm

      Steve, the described use case works correctly at local machine. Please submit this issue to our forum (registration is free and quick).

      If possible, please provide the grid initialization code or complete demo. Our technical team will help you to resolve this problem.

  10. alex December 12, 2012 at 3:32 pm

    I want to export data of my website of common test result of my student please visit my website http://sagenext.net and reply on my email.

  11. goldtower August 21, 2013 at 11:22 am

    Hi dhtmlx team,

    I want to add a footer to my grid, and calculate the sum of one column. But I can not achieve, I think I need your help. Can I get the source of the “Auto-calculated values in footer/header”?
    Great thanks for your help. Your works are awesome. Come on.
    Auto-calculated values in footer/header

    • Ivan August 21, 2013 at 1:49 pm

      Please post your question on the forum (registration is free). Forum is the right place for technical questions.

  12. John binkowski January 19, 2014 at 1:14 am

    Cannot access in Dropbox
    Message says wait below pinwheel turning
    Without access to Dropbox this app is useless to me

    • Ivan January 22, 2014 at 12:30 pm

      This post doesn’t say anything about Dropbox. Are you sure you are asking about export functionality for dhtmlxGrid and dhtmlxScheduler?

  13. Sathish.D August 4, 2015 at 10:36 am

    Below export to excel functionality works nice two weeks before, but it is not working , please rectify this i am eagerly waiting anyone help??? pls

    function ExporttoExcel() {
    mygrid.toExcel(‘../dhtmlxserver/generate.php’);
    mygrid.toExcel(“http://dhtmlxgrid.appspot.com/export/excel”);
    }

    • jamaleddine August 10, 2015 at 12:21 pm

      Hello Sathish.D I have the same problem as you to export Excel data, if you manage to find a solution contact me (ayoub.jamaledine@gmail.com)
      Thank you

Leave a Reply