Posts Tagged ‘Grid-to-Excel’

Grid to PDF and Excel Online Service

Wednesday, March 14th, 2012

This is a quick note on the export to PDF and Excel functionality for dhtmlxGrid. The export functionality is also available as an online service so you do not have to download and install the server-side extensions (available for PHP, ASP.NET and Java).

To use the online export service, you need to add just one line of code (see below). For user convenience you can attach this function to Export to PDF/Excel button with onclick event. With this code, the grid will send its configuration and data to the server which will process it and return the required document: PDF or Excel file.

Grid to PDF:

grid.toPDF("http://dhtmlxgrid.appspot.com/export/pdf");

Grid to Excel:

grid.toExcel("http://dhtmlxgrid.appspot.com/export/excel");

 
Grid to Excel

 
The export service works with dhtmlxGrid v.2.6 and above. The document generated with the online service will have a short note and link to http://dhtmlx.com. If you would like to use this service in a commercial project, this note can be removed (please contact us at sales[at]dhtmlx.com for the details).

If you decide to use the locally installed export services, you can find the download links and detailed instructions here: Grid to PDF and Grid to Excel.

2 comments »
  Tags: , ,

Export to PDF/Excel Functionality Updated

Thursday, January 26th, 2012

Export to PDF functionality for dhtmlxScheduler is now available for ASP.NET (in addition to PHP and Java services). If you are using dhtmlxScheduler with ASP.NET and need to print your event calendar, there is now an easy and quick way for it.

Download and use Scheduler-to-PDF for ASP.NET

dhtmlxScheduler - Export to PDF

dhtmlxScheduler - Export to PDF

 
Grid-to-Excel export library for ASP.NET has also been updated. We’ve fixed the issue with background coloring, so now the resulting Excel file preserves the colors of the original grid.

dhtmlxGrid - Export to Excel

dhtmlxGrid - Export to Excel

Download the newest Grid-to-Excel library for ASP.NET

Although we haven’t announced it, the export functionality (to PDF/Excel) for dhtmlxScheduler has already been available for Java for a while. Here is the download link: Scheduler-to-PDF for Java

You can find all available versions of export libraries, as well as other useful resources, on the Goodies page.

2 comments »
  Tags: , , , , , ,

Grid-to-PDF and Grid-to-Excel Now Available for ASP.NET

Wednesday, November 9th, 2011

We’re happy to introduce an ASP.NET version of export feature for dhtmlxGrid. If you are using dhtmlxGrid in your ASP.NET application or website, you can now easily transfer the grid data to Excel or PDF. The export result preserves the structure and layout of the original grid.

Download the packages which contain the files necessary to provide export support:

 

dhtmlxGrid - Export to Excel

dhtmlxGrid - Export to Excel

There is no special documentation for ASP.NET, but you can learn how to use the export services from the documentation for PHP version:

 
The approach is very simple so it shouldn’t be a problem to understand how to install the export feature. For any technical questions, you can contact us on the forum.

If you need the export feature for PHP or Java, you can download the required packages on the Goodies page (this page also lists other tools that can be useful for your development with DHTMLX).

2 comments »
  Tags: , , , ,

Grid-to-Excel, Grid-to-PDF Available for Java

Thursday, January 13th, 2011

dhtmlxGrid now offers 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 release, so you can now download the packages and enjoy ready-to-use export functionality:

Export to Excel
Export to PDF

There is also a .zip archive with an example that demonstrates how this functionality works for PDF and Excel. Export-to-PDF adds printing capabilities for dhtmlxGrid deployed in the Java-based interface, while the Export-to-Excel feature enables you to send online grid data to the desktop environment.

dhtmlxGrid-to-Excel - Export Result

dhtmlxGrid-to-Excel - Export Result

To get an idea of how to use these export services, see the documentation for PHP:

dhtmlxGrid-to-PDF
dhtmlxGrid-to-Excel

The approach is almost the same. If you’re familiar with Java technology, you’ll easily learn how to use the export functionality in your own web applications. For any technical questions, contact us on Forum.

13 comments »
  Tags: , , , ,

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

Friday, September 10th, 2010

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.

23 comments »
  Tags: , , , , , ,

Export dhtmlxGrid to Excel

Thursday, April 29th, 2010

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

 
Having developed a way to export grid data to an external format, we found it hard to stop at just PDF.

We have been often asked about the possibility of exporting dhtmlxGrid to MS Excel format. (What could be more natural than transporting data from one kind of spreadsheet to another?) Until now, the only way to export grid data to Excel was going through CSV format, which was causing the loss of information about grid structure and visual appearance.

The Grid-to-Excel service allows you to save the current state of the grid into the .xls file, keeping the grid structure and visual settings. So if the grid looks like this on the page:

Grid-to-Excel. HTML page.

Grid-to-Excel. HTML page.

The result in Excel will look like:

Grid-to-Excel. MS Excel document.

Grid-to-Excel. MS Excel document.

You can see a working example here.

To install the Grid-to-Excel service locally, you need to download this package, which contains two folders:

./server – copy this folder onto the server (PHP 5.x required)
./client – copy files from this folder to the codebase of the grid

After that, to enable Grid-to-Excel functionality, you should add the following code to the page with dhtmlxGrid:

             <script src="./codebase/dhtmlxgrid_export.js">
             scheduler.toExcel ("http://some.com/server/generate.php");

Note that the http path is the path to the script of the export service.

So now you can enjoy a ready solution to easily export data from dhtmlxGrid to Excel spreadsheet. For the configuration details, you may also check the documentation.

62 comments »
  Tags: , , ,