public static void ExportTo(this PivotGridControl pvtGrid, string fileName, bool openAfterExport = false) { var ext = new FileInfo(fileName).Extension; switch (ext) { case ".csv": pvtGrid.ExportToCsv(fileName); break; case ".htm": case ".html": pvtGrid.ExportToHtml(fileName); break; case ".bmp": pvtGrid.ExportToImage(fileName); break; case ".mht": pvtGrid.ExportToMht(fileName); break; case ".pdf": pvtGrid.ExportToPdf(fileName); break; case ".rtf": pvtGrid.ExportToRtf(fileName); break; case ".txt": pvtGrid.ExportToText(fileName); break; case ".xls": pvtGrid.ExportToXls(fileName); break; case ".xlsx": pvtGrid.ExportToXlsx(fileName); break; default: throw new Exception("გთხოვთ აირჩიოთ სწორი ფაილის ტიპი."); } if (openAfterExport) { try { Process.Start(fileName); } catch { //if (throwError) throw; } } }
static void DoExportEx(string title, string filter, string exportFormat, PivotGridControl grid) { if (grid == null) { return; } string fname = grid.FindForm().Text; fname = fname.Replace(" ", ""); fname = fname.Replace('/', '_'); //fname = FileUtility.GetValidateItemName(fname); fname = fname + "_" + DateTime.Now.ToString("yyyyMMddHHmmss"); string fileName = ShowSaveFileDialog(title, filter, fname); if (string.IsNullOrEmpty(fileName) == false) { PivotGridExportHelper exporter = new PivotGridExportHelper(); exporter.exportGrid = grid; exporter.stop = false; exporter.thread = new Thread(new ThreadStart(exporter.StartExport)); exporter.thread.Start(); Cursor currentCursor = Cursor.Current; Cursor.Current = Cursors.WaitCursor; switch (exportFormat) { case "htm": grid.ExportToHtml(fileName); break; case "mht": grid.ExportToMht(fileName); break; case "pdf": grid.ExportToPdf(fileName); break; case "xls": grid.ExportToXls(fileName); break; case "rtf": grid.ExportToRtf(fileName); break; case "txt": grid.ExportToText(fileName, "\t"); break; } exporter.EndExport(); Cursor.Current = currentCursor; OpenFile(fileName); } }
public void ExportToExcel(PivotGridControl gcDxCualquierGrid) { SaveFileDialog saveDialog = new SaveFileDialog(); saveDialog.Title = "Guardar como"; saveDialog.DefaultExt = ".xls"; saveDialog.AddExtension = true; saveDialog.CheckPathExists = true; saveDialog.Filter = "Archivos de Microsoft Excel 2007 (*.xls)|*.xls|Todos los archivos (*.*)|*.*"; saveDialog.ShowDialog(); XlsExportOptions options = new XlsExportOptions(); options.TextExportMode = TextExportMode.Text; if (!string.IsNullOrEmpty(saveDialog.FileName)) { gcDxCualquierGrid.ExportToXls(saveDialog.FileName, options); } }
public static void ExportToExcel(PivotGridControl pivotGrid, string docName) { SaveFileDialog dialog = new SaveFileDialog(); dialog.Title = "Save Excel File"; dialog.Filter = "Excel files (*.xls)|*.xls"; dialog.FileName = StringHelper.Trim(docName.Replace('/', '_') + ".xls"); if (dialog.ShowDialog() == DialogResult.OK) { pivotGrid.ExportToXls(dialog.FileName); if (MessageBox.Show("Excel File을 여시겠습니까?", "Open", MessageBoxButtons.OKCancel) == DialogResult.OK) { System.Diagnostics.Process ps = new System.Diagnostics.Process(); ps.StartInfo.FileName = dialog.FileName; ps.Start(); } } }
public static void ExportGridToFile(PivotGridControl grid, string ext) { switch (ext) { case "xls": grid.ExportToXls(File.ShowSaveFileDialog(ext), true); return; case "pdf": grid.ExportToPdf(File.ShowSaveFileDialog(ext)); return; case "htm": grid.ExportToHtml(File.ShowSaveFileDialog(ext)); return; case "rtf": grid.ExportToRtf(File.ShowSaveFileDialog(ext)); return; } }
public static string ExportToExcel(PivotGridControl pivot, TextExportMode exportMode) { try { var fileName = GetSaveExcelFileName(); var extension = Path.GetExtension(fileName); if (extension == ".xls") { pivot.ExportToXls(fileName, new XlsExportOptions( exportMode, true)); } else if (extension == ".xlsx") { pivot.ExportToXlsx(fileName, new XlsxExportOptions( exportMode, true)); } else { return ""; } return fileName; } catch { } return ""; }