private void btnExportExcel_Click(object sender, EventArgs e) { try { if (gridViewData.RowCount > 0) { string path = ""; SaveFileDialog saved = new SaveFileDialog(); saved.Filter = "Excel (*.xlsx)|*.xlsx|Excel (*.xls)|*.xls"; if (DialogResult.OK == saved.ShowDialog()) { path = saved.FileName.ToString(); ExportTarget excel = ExportTarget.Xlsx; gridViewData.BestFitColumns(true); gridViewData.OptionsPrint.AutoWidth = false; gridViewData.OptionsPrint.ExpandAllDetails = true; gridViewData.OptionsPrint.PrintVertLines = false; gridViewData.OptionsPrint.PrintHorzLines = false; gridViewData.Export(excel, path); if (DialogResult.OK == XtraMessageBox.Show("Mở file \"" + Path.GetFileName(path) + "\" ?", "", MessageBoxButtons.OKCancel)) { System.Diagnostics.Process.Start(path); } } } else { XtraMessageBox.Show("Không tìm thấy dữ liệu!"); } } catch { } }
void OnExport(object sender, EventArgs e) { ExportTarget exportType = GetCurrentExportType(); string fileName = "grid." + exportType.ToString().ToLower(); IPathService pathServise = GlobalServices.Instance.GetService <IPathService>(); if (pathServise == null) { return; } string filePath = pathServise.GetAbsolutePath(fileName); pathServise.EnsurePathExists(filePath); using (FileStream stream = new FileStream(filePath, FileMode.Create, FileAccess.Write, FileShare.Read)) { if (grid.ExportToExcel(stream, exportType)) { txtPath.Text = stream.AbsolutePath; } else { txtPath.Text = String.Empty; DisplayAlert("GridDemo", "Make sure you have an application for opening " + exportType.ToString() + " files.", "Cancel"); } } }
public static void SaveFileFromGridView(this GridView g) { try { if (g.RowCount != 0) { string path = ""; SaveFileDialog saved = new SaveFileDialog(); saved.Filter = "Excel (*.xlsx)|*.xlsx|Excel (*.xls)|*.xls"; saved.FileName = "Report_" + DateTime.Now.ToString("ddMMyyyy") + ""; if (DialogResult.OK == saved.ShowDialog()) { path = saved.FileName.ToString(); ExportTarget excel = ExportTarget.Xlsx; g.BestFitColumns(true); g.OptionsPrint.AutoWidth = false; g.OptionsPrint.ExpandAllDetails = true; g.OptionsPrint.PrintVertLines = false; g.OptionsPrint.PrintHorzLines = false; g.Export(excel, path); if (DialogResult.OK == XtraMessageBox.Show("Mở file \"" + Path.GetFileName(path) + "\" ?", "", MessageBoxButtons.OKCancel)) { System.Diagnostics.Process.Start(path); } } } else { XtraMessageBox.Show("Không có dữ liệu!", "Thông báo"); } } catch (Exception ex) { XtraMessageBox.Show("Lỗi: " + ex.Message, "Thông báo"); } }
private void ExportProject(ExportTarget Target) { ExportProjectSectionOptions spriteSection; ExportProjectSectionOptions tileSection; using (var exportDialog = new ExportProjectDialog()) { if (exportDialog.ShowDialog() != DialogResult.OK) { return; } spriteSection = exportDialog.SpriteOptions; tileSection = exportDialog.TilesOptions; } switch (Target) { case Enums.ExportTarget.Editor: string content = GenerateProjectCode(spriteSection, tileSection); if (string.IsNullOrWhiteSpace(content)) { return; } TextEditor editor = new TextEditor(currentProject.Name, content); editor.MdiParent = this; editor.Show(); break; case Enums.ExportTarget.Clipboard: string contentc = GenerateProjectCode(spriteSection, tileSection); if (string.IsNullOrWhiteSpace(contentc)) { return; } Clipboard.SetText(contentc); MessageBox.Show("Content copied to clipboard"); break; case Enums.ExportTarget.File: string contentf = GenerateProjectCode(spriteSection, tileSection); if (string.IsNullOrWhiteSpace(contentf)) { return; } using (var dlg = new SaveFileDialog { FileName = currentProject.Name + ".zxbas", Filter = "Basic files (.zxbas)|*.zxbas|Basic files (.bas)|*.bas" }) { if (dlg.ShowDialog() == DialogResult.OK) { File.WriteAllText(dlg.FileName, contentf); } } break; } }
/// <summary> /// Does form load. /// </summary> private void DoFormLoad() { SaveSettingsDialog.InitialDirectory = Settings.GetExportDirectory(); OpenSettingsDialog.InitialDirectory = SaveSettingsDialog.InitialDirectory; SaveSettingsDialog.Filter = ExportTarget.CreateFilters(); OpenSettingsDialog.Filter = SaveSettingsDialog.Filter; LoadEditIntervals(); LoadExportFileFormats(); }
void AddExportTarget(ExportTarget target) { var exportItem = new DXMenuCheckItem() { Caption = target.ToString(), Tag = target }; menuExport.Items.Add(exportItem); exportItem.Click += exportItem_Click; }
private void BeginExport(ExportTarget Target) { using (var dlg = new ExportCharSetDialog()) { if (dlg.ShowDialog() == DialogResult.OK) { ExportEventArgs args = new ExportEventArgs { Prefix = dlg.Prefix, Postfix = dlg.Postfix, SingleDim = dlg.SingleDimension, CharSet = CurrentSet, Target = Target, Colors = dlg.IncludeColors }; Export(this, args); } } }
public void ExportTo(GridCellGroup rootCell, string fileName, ExportTarget target) { switch (target) { case ExportTarget.Xml: { FileStream stream = new FileStream(fileName, FileMode.Create); XmlWriterSettings settings = new XmlWriterSettings { Indent = true, OmitXmlDeclaration = true, ConformanceLevel = ConformanceLevel.Auto }; XmlWriter writer = XmlWriter.Create(stream, settings); SaveResults(rootCell, writer); writer.Close(); } break; } }
public void ExportTo(GridCellGroup rootCell, string fileName, ExportTarget target) { string ext = Path.GetExtension(fileName); AbstractWriter writer = null; switch (target) { case ExportTarget.Xml: writer = new XmlFileWriter(fileName); break; case ExportTarget.Csv: writer = new CsvWriter(fileName, CultureInfo.CurrentCulture.TextInfo.ListSeparator, true); break; case ExportTarget.TabDelimited: writer = new CsvWriter(fileName, "\t", true); break; case ExportTarget.FixedLength: writer = new FlvWriter(fileName, true); break; case ExportTarget.AdoNet: writer = new AdoNetWriter(fileName); break; } if (writer != null) { ResultsetGridBuilder builder = new ResultsetGridBuilder(); Resultset rs = builder.CreateResultset((ResultsetGridBuilder.RootCell)rootCell); writer.Write(rs); } }
private void exportItem_Click(object sender, EventArgs e) { SelectedExport = (ExportTarget)((DXMenuItem)sender).Tag; }
/// ------------------------------------------------------------------------------------ /// <summary> /// RtfCreator constructor. /// </summary> /// ------------------------------------------------------------------------------------ public RtfCreator(PaProject project, ExportTarget target, ExportFormat format, DataGridView grid, WordListCache cache, string rtfEditor) { m_project = project; m_exportTarget = target; m_exportFormat = format; m_grid = grid; if (m_grid != null) { m_graphics = m_grid.CreateGraphics(); // Store the dots per inch value from the grid's graphic object m_pixelsPerInch = m_graphics.DpiX; } m_cache = cache; m_rtfEditor = rtfEditor; m_createSearchItemTabs = CreateSearchItemTabs.FirstTab; m_rtfBldr = new StringBuilder(); // Default value is 1/8" gap between columns. m_colRightPadding = Properties.Settings.Default.RTFExportGapBetweenColumns; // Add support for highlighting the search item if (m_cache.IsForSearchResults) { Dictionary <int, int> colorReferences; RtfHelper.ColorTable(Properties.Settings.Default.QuerySearchItemBackColor, out colorReferences); m_searchItemColorRefNumber = colorReferences[Properties.Settings.Default.QuerySearchItemBackColor.ToArgb()]; } // Sort the visible columns by their display order. m_sortedColumns = new SortedList <int, DataGridViewColumn>(); foreach (DataGridViewColumn col in m_grid.Columns) { if (col.Visible && !(col is SilHierarchicalGridColumn)) { m_sortedColumns[col.DisplayIndex] = col; } } GetPaperAndMarginValues(); CalculateColumnWidths(); OutputRTFHeadingStuff(); // This is only for running tests if (m_maxFieldWidths.Count > 0) { MakeFinalWidthAdjustments(); m_rtfBldr.AppendFormat(@"\paperw{0}\paperh{1}", m_paperWidth, m_paperHeight); m_rtfBldr.AppendFormat(@"\margl{0}\margr{1}", m_leftMargin, m_rightMargin); m_rtfBldr.AppendFormat(@"\margt{0}\margb{1}", m_topMargin, m_bottomMargin); m_rtfBldr.AppendLine(); OutputReportHeadingInformation(); OutputColumnInformation(); OutputDataRows(); WriteToFileOrClipboard(); } if (m_graphics != null) { m_graphics.Dispose(); } }