Data Grid Export Service

Data Grid contents can be exported to Microsoft Excel, Microsoft Word, or a PDF document. The exporting is done by a separate export web service add-on.

Prerequisites

The following prerequisites are needed for installing the data grid export web service:

• .NET Framework 4.6.1 or later.
• Microsoft Internet Information Services.

Additionally, installation via Web Deploy has the following prerequisites:

• Microsoft Web Deploy 3.0 or later installed on the system - http://www.iis.net/downloads/microsoft/web-deploy
• Microsoft PowerShell 2.0 or later running as an Administrator

Installing

Manual Installation

1. Download the installation package.
2. Unzip the installation package to a temporary folder.
3. Create the folder C:/inetpub/wwwroot/SyncfusionGridExport.
4. Copy the installation package contents from the temporary folder to the C:/inetpub/wwwroot/SyncfusionGridExport folder.
5. Open Internet Information Service(IIS) manager.
6. Select Application Pools > Add Application Pool..., and give the application pool a name.
7. Under Sites, right-click Default Web Site and select Add Application...
   1. Type in "SyncfusionGridExport" as the Alias.
   2. Select the new created application pool from the Application Pool list.
   3. Define the Physical path as "C:\inetpub\wwwroot\SyncfusionGridExport".

Installation via Web Deploy

1. Copy QprGridExportAddon.zip, Configuration.ps1 and DeployQprGridExportService.ps1 to your local system.
2. Open Configuration.ps1 into text editor and modify the values according to your system and desired installation type. With the $customAppPoolCredentials setting you can define whether the application pool will be run as a user defined in $appPoolUser setting (password for the account will be requested during the installation).
3. Launch Microsoft PowerShell as an Administrator and navigate to the folder containing the deployment files.
4. Run .\DeployGridExportService.ps1 and input the application pool user password when requested (if you chose to use custom credentials)

After the installation, the export servers are available in the following URLs:

• Excel: http://<YourHostname>/SyncfusionGridExport/excelExport
• Word: http://<YourHostname>/SyncfusionGridExport/wordExport
• PDF: http://<YourHostname>/SyncfusionGridExport/pdfExport