Data Grid Export Service
Jump to navigation
Jump to search
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
- Download the installation package.
- Unzip the installation package to a temporary folder.
- Create the folder C:/inetpub/wwwroot/SyncfusionGridExport.
- Copy the installation package contents from the temporary folder to the C:/inetpub/wwwroot/SyncfusionGridExport folder.
- Open Internet Information Service(IIS) manager.
- Select Application Pools > Add Application Pool..., and give the application pool a name.
- Under Sites, right-click Default Web Site and select Add Application...
- Type in "SyncfusionGridExport" as the Alias.
- Select the new created application pool from the Application Pool list.
- Define the Physical path as "C:\inetpub\wwwroot\SyncfusionGridExport".
Installation via Web Deploy
- Copy QprGridExportAddon.zip, Configuration.ps1 and DeployQprGridExportService.ps1 to your local system.
- 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).
- Launch Microsoft PowerShell as an Administrator and navigate to the folder containing the deployment files.
- 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