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

  • javascript
    • <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 });

}