void Export(bool saveAs) { //foreach(PivotGridField field in gvDashboard.Fields) { // if(field.ValueFormat != null && !string.IsNullOrEmpty(field.ValueFormat.FormatString)) // field.UseNativeFormat = checkCustomFormattedValuesAsText.Checked ? DefaultBoolean.False : DefaultBoolean.True; //} //ASPxPivotGridExporter1.OptionsPrint.PrintHeadersOnEveryPage = checkPrintHeadersOnEveryPage.Checked; //ASPxPivotGridExporter1.OptionsPrint.MergeColumnFieldValues = checkMergeColumnFieldValues.Checked; //ASPxPivotGridExporter1.OptionsPrint.MergeRowFieldValues = checkMergeRowFieldValues.Checked; //ASPxPivotGridExporter1.OptionsPrint.PrintFilterHeaders = checkPrintFilterFieldHeaders.Checked ? DefaultBoolean.True : DefaultBoolean.False; //ASPxPivotGridExporter1.OptionsPrint.PrintColumnHeaders = checkPrintColumnFieldHeaders.Checked ? DefaultBoolean.True : DefaultBoolean.False; //ASPxPivotGridExporter1.OptionsPrint.PrintRowHeaders = checkPrintRowFieldHeaders.Checked ? DefaultBoolean.True : DefaultBoolean.False; //ASPxPivotGridExporter1.OptionsPrint.PrintDataHeaders = checkPrintDataFieldHeaders.Checked ? DefaultBoolean.True : DefaultBoolean.False; string fileName = "PivotGrid"; switch (listExportFormat.SelectedIndex) { case 0: ASPxPivotGridExporter1.ExportPdfToResponse(fileName, saveAs); break; case 1: ASPxPivotGridExporter1.ExportXlsToResponse(fileName, saveAs); break; case 2: ASPxPivotGridExporter1.ExportMhtToResponse(fileName, "utf-8", "ASPxPivotGrid Printing Sample", true, saveAs); break; case 3: ASPxPivotGridExporter1.ExportRtfToResponse(fileName, saveAs); break; case 4: ASPxPivotGridExporter1.ExportTextToResponse(fileName, saveAs); break; case 5: ASPxPivotGridExporter1.ExportHtmlToResponse(fileName, "utf-8", "ASPxPivotGrid Printing Sample", true, saveAs); break; } }
protected void buttonSaveAs_Click(object sender, EventArgs e) { foreach (DevExpress.Web.ASPxPivotGrid.PivotGridField field in ASPxPivotGrid1.Fields) { if (field.ValueFormat != null && !string.IsNullOrEmpty(field.ValueFormat.FormatString)) { field.UseNativeFormat = checkCustomFormattedValuesAsText.Checked ? DefaultBoolean.False : DefaultBoolean.True; } } ASPxPivotGridExporter1.OptionsPrint.PrintColumnAreaOnEveryPage = checkPrintColumnAreaOnEveryPage.Checked; ASPxPivotGridExporter1.OptionsPrint.PrintRowAreaOnEveryPage = checkPrintRowAreaOnEveryPage.Checked; ASPxPivotGridExporter1.OptionsPrint.MergeColumnFieldValues = checkMergeColumnFieldValues.Checked; ASPxPivotGridExporter1.OptionsPrint.MergeRowFieldValues = checkMergeRowFieldValues.Checked; ASPxPivotGridExporter1.OptionsPrint.PrintFilterHeaders = checkPrintFilterFieldHeaders.Checked ? DefaultBoolean.True : DefaultBoolean.False; ASPxPivotGridExporter1.OptionsPrint.PrintColumnHeaders = checkPrintColumnFieldHeaders.Checked ? DefaultBoolean.True : DefaultBoolean.False; ASPxPivotGridExporter1.OptionsPrint.PrintRowHeaders = checkPrintRowFieldHeaders.Checked ? DefaultBoolean.True : DefaultBoolean.False; ASPxPivotGridExporter1.OptionsPrint.PrintDataHeaders = checkPrintDataFieldHeaders.Checked ? DefaultBoolean.True : DefaultBoolean.False; const string fileName = "PivotGrid"; XlsxExportOptionsEx options; switch (listExportFormat.SelectedIndex) { case 0: ASPxPivotGridExporter1.ExportPdfToResponse(fileName); break; case 1: options = new XlsxExportOptionsEx() { ExportType = ExportType.WYSIWYG }; ASPxPivotGridExporter1.ExportXlsxToResponse(fileName, options); break; case 2: ASPxPivotGridExporter1.ExportMhtToResponse(fileName, "utf-8", "ASPxPivotGrid Printing Sample", true); break; case 3: ASPxPivotGridExporter1.ExportRtfToResponse(fileName); break; case 4: ASPxPivotGridExporter1.ExportTextToResponse(fileName); break; case 5: ASPxPivotGridExporter1.ExportHtmlToResponse(fileName, "utf-8", "ASPxPivotGrid Printing Sample", true); break; case 6: options = new XlsxExportOptionsEx() { ExportType = ExportType.DataAware, AllowGrouping = allowGroupingCheckBox.Checked ? DefaultBoolean.True : DefaultBoolean.False, TextExportMode = exportCellValuesAsText.Checked ? TextExportMode.Text : TextExportMode.Value, AllowFixedColumns = allowFixedColumns.Checked ? DefaultBoolean.True : DefaultBoolean.False, AllowFixedColumnHeaderPanel = allowFixedColumns.Checked ? DefaultBoolean.True : DefaultBoolean.False, RawDataMode = exportRawData.Checked }; ASPxPivotGridExporter1.ExportXlsxToResponse(fileName, options); break; } }