Gantt Exporting services
15 Mar 2018 / 6 minutes to read
Description
Find the Gantt exporting type below:
- Excel export.
Excel export
URL
http://js.syncfusion.com/ejServices/api/JSGanttExport/ExcelExport
Parameter
Type1:
Name | Type | Description |
GanttProperties | Object | It takes Gantt model properties that should be passed to export |
datasource | object | It holds the data to be exported in an Excel |
GanttExportSettings | object | Returns the exporting settings like unicode support, columns fit to width, and hidden column. |
Type2:
Name | Type | Description |
GanttProperties | Object | It takes Gantt model properties that should be passed to export |
datasource | object | It holds the data to be exported in an Excel |
excelName | String | It specifies the file name and extension to be downloaded |
excelVersion | String | Excel version in which workbook should download |
GanttExportSettings | object | Returns the exporting settings like unicode support, columns fit to width, and hidden column. |
Type3:
Name | Type | Description |
GanttProperties | Object | It takes Gantt model properties that should be passed to export |
datasource | object | It holds the data to be exported in an Excel |
excelName | String | It specifies the file name and extension to be downloaded |
excelVersion | String | Excel version in which workbook should download |
GanttExportSettings | object | Returns the exporting settings like unicode support, columns fit to width, hidden column. |
filePath | String | With this parameter, you can set the location where the exporting file should be downloaded. It can be the local or server machine file path. |
Type4:
Name | Type | Description |
GanttProperties | Object | It takes Gantt model properties that should be passed to export |
datasource | object | It holds the data to be exported in an Excel |
GanttExportSettings | object | Returns the exporting settings like unicode support, columns fit to width, and hidden column. |
multipleExport | Boolean | Is a boolean argument, the value `false` specifies that the exporting is completed and downloaded, and the value `true` specifies the export Gantt internally and appends it to something else before download starts. |
headerText | String | headerText is to specify the title for export workbook. |
Type5:
Name | Type | Description |
GanttProperties | Object | It takes Gantt model properties that should be passed to export |
datasource | object | It holds the data to be exported in an Excel |
GanttExportSettings | object | Returns the exporting settings like unicode support, columns fit to width, and hidden column. |
excelName | String | With this parameter, you can set the downloaded file name. By default, it is set to “Export” |
multipleExport | Boolean | Is a boolean argument, the value `false` specifies that the exporting is completed and downloaded, and the value `true` specifies the export Gantt internally and appends something else to it before download starts. |
headerText | String | headerText is to specify the title for export workbook. |
Type6:
Name | Type | Description |
GanttProperties | Object | It takes Gantt model properties that should be passed to export |
datasource | object | It holds the data to be exported in an Excel |
GanttExportSettings | object | Returns the exporting settings like unicode support, columns fit to width, and hidden column. |
excelName | String | With this parameter, you can set the downloaded file name. By default, it is set to “Export” |
filePath | String | With this parameter, you can set the location where the exporting file should be downloaded. It can be the local or server machine file path. |
multipleExport | Boolean | Is a boolean argument, the value `false` specifies that the exporting is completed and downloaded, and the value `true` specifies the export Gantt internally and appends something else to it before download starts. |
headerText | String | headerText is to specify the title for export workbook. |
Type7:
Name | Type | Description |
GanttProperties | Object | It takes Gantt model properties that should be passed to export |
datasource | object | It holds the data to be exported in an Excel |
GanttExportSettings | object | Returns the exporting settings like unicode support, columns fit to width, and hidden column. |
Workbook | Object | It specifies multiple exporting in which workbook file export should append; it holds the internally stored excel files, which were exported previously. |
multipleExport | Boolean | Is a boolean argument, the value `false` specifies that the exporting is completed and downloaded, and the value `true` specifies the export Gantt internally and appends something else to it before download starts. |
headerText | String | headerText is to specify the title for export workbook. |
Type8:
Name | Type | Description |
GanttProperties | Object | It takes Gantt model properties that should be passed to export |
datasource | object | It holds the data to be exported in an Excel |
GanttExportSettings | object | Returns the exporting settings like unicode support, columns fit to width, and hidden column. |
excelName | string | With this parameter, you can set the downloaded file name. By default, it is set to “Export”. |
Workbook | Object | It specifies multiple exporting in which workbook file export should append; it holds the internally stored excel files, which were exported previously. |
multipleExport | Boolean | Is a boolean argument, the value `false` specifies that the exporting is completed and downloaded, and the value `true` specifies the export Gantt internally and appends something else to it before download starts. |
headerText | String | headerText is to specify the title for export workbook. |
Type9:
Name | Type | Description |
GanttProperties | Object | It takes Gantt model properties that should be passed to export |
datasource | object | It holds the data to be exported in an Excel |
GanttExportSettings | object | Returns the exporting settings like unicode support, columns fit to width, and hidden column. |
excelName | string | With this parameter, you can set the downloaded file name. By default, it is set to “Export”. |
filePath | String | With this parameter, you can set the location where the exporting file should be downloaded. It can be the local or server machine file path. |
Workbook | Object | It specifies multiple exporting in which workbook file export should append; it holds the internally stored excel files, which were exported previously. |
multipleExport | Boolean | Is a boolean argument, the value `false` specifies that the exporting is completed and downloaded, and the value `true` specifies the export Gantt internally and appends something else to it before download starts. |
headerText | String | headerText is to specify the title for export workbook. |
Type10:
Name | Type | Description |
GanttProperties | Object | It takes Gantt model properties that should be passed to export |
datasource | object | It holds the data to be exported in an Excel |
GanttExportSettings | object | Returns the exporting settings like unicode support, columns fit to width, and hidden column. |
excelName | string | With this parameter, you can set the downloaded file name. By default, it is set to “Export”. |
multipleExport | Boolean | Is a boolean argument, the value `false` specifies that the exporting is completed and downloaded, and the value `true` specifies the export Gantt internally and appends something else to it before download starts. |
Workbook | Object | It specifies multiple exporting in which workbook file export should append; it holds the internally stored excel files, which were exported previously. |
MultipleExportType | Object | It specifies, in case of multiple export, it returns the exporting type whether the file should append to the sheet or it should export to a new sheet |
headerText | String | headerText is to specify the title for export workbook. |
Request
<body ng-controller="GanttCtrl">
<!--Add Gantt control here-->
<div id="GanttContainer" ej-gantt
//...
e-toolbarclick="toolbarClick"
>
</div>
<script>
function toolbarClick(args){
this.exportGrid = this["export"];
if (args.itemName == "Excel Export") {
this.exportGrid('http://js.syncfusion.com/ejServices/api/JSGanttExport/ExcelExport', "", false);
args.cancel = true;
}
}
angular.module('listCtrl', ['ejangular'])
.controller('GanttCtrl', function($scope) {
//...
$scope.toolbarClick = "toolbarClick";
});
</script>
</body>
Following example will take part in the project service.
public void ExcelExport()
{
string gridModel = HttpContext.Current.Request.Params["GanttModel"];
GanttProperties gridProperty = ConvertGridObject(gridModel);
ExcelExport exp = new ExcelExport();
TaskDetailsCollection taskCollection = new TaskDetailsCollection();
IEnumerable<TaskDetails> result = taskCollection.GetDataSource();
exp.Export(gridProperty, result, "ExcelExport.xlsx", ExcelVersion.Excel2010, new GanttExportSettings() { Theme = ExportTheme.FlatAzure });
}
Was this page helpful?
Yes
No
Thank you for your feedback!
Thank you for your feedback and comments. We will rectify this as soon as possible!
An unknown error has occurred. Please try again.
Help us improve this page