static PivotXlsxExportOptions GetXlsxOptions()
{
PivotXlsxExportOptions options = new PivotXlsxExportOptions();
options.CustomizeCell += Options_CustomizeCell;
return(options);
}
private void btnExport_Click(object sender, EventArgs e)
{
try
{
if (pivotGridUserLoginDetails.DataSource == null)
{
XtraMessageBox.Show("Cannot export data");
return;
}
string filePath = @"C:\Employee Attendance\";
string fileName = filePath + "Employee_Attendance-" + DateTime.Now.ToString("dd-MM-yyyy-hh-mm-ss") + ".xlsx";
SplashScreenManager.ShowForm(this, typeof(Masters.WaitForm1), true, true, false);
if (!Directory.Exists(filePath))
{
Directory.CreateDirectory(filePath);
}
var pivotOptions = new PivotXlsxExportOptions();
pivotOptions.ExportType = DevExpress.Export.ExportType.WYSIWYG;
pivotOptions.SheetName = Convert.ToDateTime(dateEditFromDate.Text).ToString("dd-MMM-yyy") + " - " + Convert.ToDateTime(dateEditToDate.Text).ToString("dd-MMM-yyy");
pivotGridUserLoginDetails.ExportToXlsx(fileName, pivotOptions);
// XtraMessageBox.Show("Exported Successfully ");
SplashScreenManager.CloseForm(false);
System.Diagnostics.Process.Start(fileName);
}
catch
{
SplashScreenManager.CloseForm(false);
XtraMessageBox.Show("Failed to export attendance");
}
finally
{
SplashScreenManager.CloseForm(false);
}
}
private void btn_exportarexcel_Click(object sender, EventArgs e)
{
try
{
string ruta = "c:\\DATA";
if (!Directory.Exists(ruta))
{
Directory.CreateDirectory(ruta);
}
DevExpress.Export.ExportSettings.DefaultExportType = DevExpress.Export.ExportType.DataAware;
var pivotExportOptions = new PivotXlsxExportOptions {
ExportType = DevExpress.Export.ExportType.WYSIWYG
};
string doc = "c:\\DATA\\TmpGF" + DateTime.Now.Millisecond.ToString() + DateTime.Now.Second.ToString() + DateTime.Now.Day.ToString() + DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + ".xlsx";
pvt_datos2.ExportToXlsx(doc, pivotExportOptions);
ProcessStartInfo startInfo = new ProcessStartInfo
{
FileName = "EXCEL.EXE",
Arguments = doc
};
Process.Start(startInfo);
}
catch (Exception ex)
{
MessageBox.Show(@"No se pudo exportar el archivo , error sugerido :" + "\n" + ex.Message, @"Alerta", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
}
public ActionResult ExportToXLSX_WYSIWYG()
{
PivotXlsxExportOptions options = new PivotXlsxExportOptions();
options.ExportType = DevExpress.Export.ExportType.WYSIWYG;
return(PivotGridExtension.ExportToXlsx(PivotGridHelper.Settings, Models.NwindModel.GetData(), options));
}
private void btn_exportar_Click(object sender, EventArgs e)
{
string ruta = "c:\\DATA";
if (!Directory.Exists(ruta))
{
Directory.CreateDirectory(ruta);
}
DevExpress.Export.ExportSettings.DefaultExportType = DevExpress.Export.ExportType.DataAware;
var pivotExportOptions = new PivotXlsxExportOptions {
ExportType = DevExpress.Export.ExportType.WYSIWYG
};
string doc = "c:\\DATA\\Tmpdetafiltro" + DateTime.Now.Millisecond.ToString() + DateTime.Now.Second.ToString() + DateTime.Now.Day.ToString() + DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + ".xlsx";
dtg_datos.ExportToXlsx(doc, pivotExportOptions);
ProcessStartInfo startInfo = new ProcessStartInfo
{
FileName = "EXCEL.EXE",
Arguments = doc
};
Process.Start(startInfo);
}
protected void ASPxButton1_Click(object sender, EventArgs e)
{
var exportOptions = new PivotXlsxExportOptions();
exportOptions.CustomizeCell +=
new CustomizePivotCellEventHandler(exportOptions_CustomizeCell);
ASPxPivotGridExporter1.ExportXlsxToResponse("PivotGrid", exportOptions);
}
protected void ASPxButton1_Click(object sender, EventArgs e)
{
PivotXlsxExportOptions options = new PivotXlsxExportOptions();
options.CustomizeSheetHeader += options_CustomizeSheetHeader;
options.CustomizeSheetFooter += options_CustomizeSheetFooter;
ASPxPivotGridExporter1.ExportXlsxToResponse("Pivot", options);
}
public ActionResult ExportToXLS()
{
string start = (string)Session["Start"];
string end = (string)Session["End"];
string companyId = (string)Session["CompanyID"];
string accountId = string.Empty;
PivotXlsxExportOptions exportOptions = new PivotXlsxExportOptions()
{
ExportType = DevExpress.Export.ExportType.WYSIWYG
};
List <JournalViewModel> model = (List <JournalViewModel>)IWSLookUp.GetJournal(start, end, accountId, companyId);
return(PivotGridExtension.ExportToXlsx(PivotGridHelper.Settings, model.ToList(), exportOptions));
}
private void btn_exportarexcel_Click(object sender, EventArgs e)
{
var pivotExportOptions = new PivotXlsxExportOptions {
ExportType = DevExpress.Export.ExportType.WYSIWYG
};
string doc = "c:\\DATA\\Tmppyg" + DateTime.Now.Millisecond.ToString() + DateTime.Now.Second.ToString() + DateTime.Now.Day.ToString() + DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + ".xlsx";
pvt_datos2.ExportToXlsx(doc, pivotExportOptions);
ProcessStartInfo startInfo = new ProcessStartInfo
{
FileName = "EXCEL.EXE",
Arguments = doc
};
Process.Start(startInfo);
}
private void barButtonItem1_ItemClick(object sender, ItemClickEventArgs e)
{
#region #filepathCreating
string filePath;
var saveDialog = new SaveFileDialog();
saveDialog.DefaultExt = "xlsx";
saveDialog.FileName = "PivotGrid.xlsx";
saveDialog.Filter = "Excel files (*.xlsx)|*.xlsx|All files (*.*)|*.*";
saveDialog.ShowDialog();
filePath = saveDialog.FileName;
#endregion
var exportOptions = new PivotXlsxExportOptions();
exportOptions.CustomizeCell +=
new CustomizePivotCellEventHandler(exportOptions_CustomizeCell);
if (filePath != "")
{
pivotGridControl1.ExportToXlsx(filePath, exportOptions);
}
}
