protected void Grid1_ServerExcelExporting(object sender, Syncfusion.JavaScript.Web.GridEventArgs e)
{
ExcelExport exp = new ExcelExport();
//Items needs below assembly reference
// using Syncfusion.EJ.Export;
//using Syncfusion.XlsIO;
//Added manually, also it will add references to assembly in WEB.config file
DataView dv = (DataView)SqlDataSource1.Select(new DataSourceSelectArguments());
DataTable dt = dv.Table;
IWorkbook book = exp.Export(Grid1.Model, dt, "Export.xlsx", ExcelVersion.Excel2010, true, true, "flat-lime", true);
//When the Grid has some null values from DB It causes exception while exporting, so better to avoid DBNull- An exception of type 'System.InvalidCastException' occurred in mscorlib.dll but was not handled in user code Additional information: Object cannot be cast from DBNull to other types.
// Inserted new row for adding title
book.ActiveSheet.InsertRow(1);
// Merging the sheet from Range A1 to D1 for adding title space
book.ActiveSheet.Range["A1:D1"].Merge();
//Adding the title using Text property
book.ActiveSheet.Range["A1"].Text = "Some Content Title";
book.ActiveSheet.Range["A1"].CellStyle.HorizontalAlignment = ExcelHAlign.HAlignCenter;//set text alignment
//Adding footer using SetValue method
book.ActiveSheet.SetValue(book.ActiveSheet.Rows.Length + 2, book.ActiveSheet.Columns.Length - 3, "CopyRights");
book.SaveAs("Export.xlsx", ExcelSaveType.SaveAsXLS, System.Web.HttpContext.Current.Response, ExcelDownloadType.Open);
}
protected void FlatGrid_ServerPdfExporting(object sender, Syncfusion.JavaScript.Web.GridEventArgs e)
{
PdfExport exp = new PdfExport();
exp.Export(FlatGrid.Model, (IEnumerable)FlatGrid.DataSource, "Export.pdf", true, true, "flat-lime");
}
protected void EmployeesGrid_ServerPdfExporting(object sender, Syncfusion.JavaScript.Web.GridEventArgs e)
{
PdfExport exp = new PdfExport();
PdfDocument document = exp.Export(EmployeesGrid.Model, (IEnumerable)EmployeesGrid.DataSource, "Export.pdf", true, true, "flat-lime", true);
exp.Export(OrdersGrid.Model, (IEnumerable)OrdersGrid.DataSource, "Export.pdf", true, true, "flat-lime", false, document, "Second Grid");
}
protected void EmployeesGrid_ServerExcelExporting(object sender, Syncfusion.JavaScript.Web.GridEventArgs e)
{
ExcelExport exp = new ExcelExport();
IWorkbook workbook = exp.Export(EmployeesGrid.Model, (IEnumerable)EmployeesGrid.DataSource, "Export.xlsx", ExcelVersion.Excel2010, true, true, "flat-lime", true);
exp.Export(OrdersGrid.Model, (IEnumerable)OrdersGrid.DataSource, "Export.xlsx", ExcelVersion.Excel2010, true, true, "flat-lime", false, workbook, MultipleExportType.AppendToSheet, "Orders Grid");
}
protected void FlatGrid_ServerExcelExporting(object sender, Syncfusion.JavaScript.Web.GridEventArgs e)
{
//ExcelExport exp = new ExcelExport();
//exp.Export(FlatGrid.Model, (IEnumerable)FlatGrid.DataSource, "Export.xlsx", ExcelVersion.Excel2013, true, true, "flat-lime");
ExportExcel_Click();
}
protected void courseGrid_ServerDeleteRow(object sender, Syncfusion.JavaScript.Web.GridEventArgs e)
{
try
{
EditAction(e.EventType, e.Arguments["data"]);
}
catch (Exception ex)
{
MessageBox.swalModal(this.Page, "error", "en:internal error[" + ex.Message.Replace("'", "") + "]", "");
}
}
protected void EmployeesGrid_ServerWordExporting(object sender, Syncfusion.JavaScript.Web.GridEventArgs e)
{
WordExport exp = new WordExport();
GridProperties obj = ConvertGridObject(e.Arguments["model"].ToString());
GridWordExport exp1 = new GridWordExport()
{
IsTemplateColumnIncluded = true, IsHideColumnIncude = false, Theme = "flat-lime", FileName = "Export.docx"
};
exp.Export(obj, (IEnumerable)EmployeesGrid.DataSource, exp1);
}
protected void courseGrid_ServerPdfExporting(object sender, Syncfusion.JavaScript.Web.GridEventArgs e)
{
try
{
PdfExport exp = new PdfExport();
exp.Export(courseGrid.Model, (IEnumerable)courseGrid.DataSource, "Export.pdf", false, false, true, "flat-lime");
}
catch (Exception ex)
{
MessageBox.swalModal(this.Page, "error", "en:internal error[" + ex.Message.Replace("'", "") + "]", "");
}
}
protected void Grid1_ServerEditRow(object sender, Syncfusion.JavaScript.Web.GridEventArgs e)
{
EditAction(e.EventType, e.Arguments["data"]);
}
protected void Grid1_ServerWordExporting(object sender, Syncfusion.JavaScript.Web.GridEventArgs e)
{
WordExport exp = new WordExport();
exp.Export(Grid1.Model, (IEnumerable)Grid1.DataSource, "CCP-Export.docx", true, true, "flat-lime");
}
protected void Grid1_ServerExcelExporting(object sender, Syncfusion.JavaScript.Web.GridEventArgs e)
{
ExcelExport exp = new ExcelExport();
exp.Export(Grid1.Model, (IEnumerable)Grid1.DataSource, "CCP-Export.xlsx", ExcelVersion.Excel2010, true, true, "flat-lime");
}
protected void FlatGrid_ServerWordExporting1(object sender, Syncfusion.JavaScript.Web.GridEventArgs e)
{
}
