private void BtnExportar_Click(object sender, EventArgs e) { try { if (gvDatos.RowCount > 0) { if (RadMessageBox.Show("El listado se exportará en formato de excel, desea continuar...?", this.Text, MessageBoxButtons.YesNo) == DialogResult.Yes) { SaveFileDialog saveFile = new SaveFileDialog(); saveFile.Filter = "Excel|*.xls"; saveFile.Title = "Guardar Archivo"; saveFile.ShowDialog(); if (saveFile.FileName != "") { var exportar = new ExportToExcelML(gvDatos); exportar.ExportVisualSettings = true; exportar.HiddenColumnOption = HiddenOption.DoNotExport; exportar.ExportHierarchy = true; exportar.FileExtension = "xls"; exportar.SheetName = "Préstamos"; exportar.RunExport(saveFile.FileName); } RadMessageBox.Show("Archivo exportado correctamente", this.Text, MessageBoxButtons.OK, RadMessageIcon.Info); } } } catch (Exception ex) { RadMessageBox.Show("Ocurrió un error al exportar los préstamos\n" + ex.Message, this.Text, MessageBoxButtons.OK, RadMessageIcon.Error); } }
private void RunExportToExcelML(string fileName, ref bool openExportFile) { ExportToExcelML excelExporter = new ExportToExcelML(this.radGridView1); //set export settings excelExporter.ExportVisualSettings = true; excelExporter.ExportHierarchy = true; excelExporter.HiddenColumnOption = HiddenOption.DoNotExport; try { this.Cursor = Cursors.WaitCursor; excelExporter.RunExport(fileName); RadMessageBox.SetThemeName(this.radGridView1.ThemeName); DialogResult dr = RadMessageBox.Show("The data in the grid was exported successfully. Do you want to open the file?", "Export to Excel", MessageBoxButtons.YesNo, RadMessageIcon.Question); if (dr == DialogResult.Yes) { openExportFile = true; } } catch (IOException ex) { RadMessageBox.SetThemeName(this.radGridView1.ThemeName); RadMessageBox.Show(this, ex.Message, "I/O Error", MessageBoxButtons.OK, RadMessageIcon.Error); } finally { this.Cursor = Cursors.Default; } }
public rptfrmDriverCommissionPaymentSummary() { InitializeComponent(); this.Load += new EventHandler(rptfrmDriverCommissionPaymentSummary_Load); ExportToExcelML export = new ExportToExcelML(this.radGridView1); export.ExportVisualSettings = true; export.HiddenColumnOption = HiddenOption.ExportAsHidden; export.HiddenColumnOption = Telerik.WinControls.UI.Export.HiddenOption.DoNotExport; export.ExcelCellFormatting += new Telerik.WinControls.UI.Export.ExcelML.ExcelCellFormattingEventHandler(export_ExcelCellFormatting); // // //radGridView1.Columns["PickupDate"].HeaderText = "Pickup Date-Time"; //radGridView1.Columns["From"].HeaderText = "Pick-up Address"; //radGridView1.Columns["To"].HeaderText = "Drop-off Address"; //radGridView1.Columns["CompanyName"].HeaderText = "Account"; //Me.RadGridView1.Columns(0).ExcelExportType = Export.DisplayFormatType.Text //CompanyName //exporter = new RadGridViewExcelExporter(); //BackgroundWorker worker = new BackgroundWorker(); //worker.DoWork += new DoWorkEventHandler(worker_DoWork); //worker.RunWorkerCompleted += new RunWorkerCompletedEventHandler(bg_RunWorkerCompleted); //worker.RunWorkerAsync(saveFileDialog1.FileName); //exporter.Progress += new ProgressHandler(exportProgress); //this.btnExport.Enabled = false; }
private void RunExportToExcelML(string fileName, ref bool openExportFile) { ExportToExcelML excelExporter = new ExportToExcelML(this.radGridView1); if (this.radTextBoxSheet.Text != String.Empty) { excelExporter.SheetName = this.radTextBoxSheet.Text; } switch (this.radComboBoxSummaries.SelectedIndex) { case 0: excelExporter.SummariesExportOption = SummariesOption.ExportAll; break; case 1: excelExporter.SummariesExportOption = SummariesOption.ExportOnlyTop; break; case 2: excelExporter.SummariesExportOption = SummariesOption.ExportOnlyBottom; break; case 3: excelExporter.SummariesExportOption = SummariesOption.DoNotExport; break; } //set max sheet rows if (this.radRadioButton1.ToggleState == Telerik.WinControls.Enumerations.ToggleState.On) { excelExporter.SheetMaxRows = ExcelMaxRows._1048576; } else if (this.radRadioButton2.ToggleState == Telerik.WinControls.Enumerations.ToggleState.On) { excelExporter.SheetMaxRows = ExcelMaxRows._65536; } //set exporting visual settings excelExporter.ExportVisualSettings = this.exportVisualSettings; try { excelExporter.RunExport(fileName); RadMessageBox.SetThemeName(this.radGridView1.ThemeName); DialogResult dr = RadMessageBox.Show("The data in the grid was exported successfully. Do you want to open the file?", "Export to Excel", MessageBoxButtons.YesNo, RadMessageIcon.Question); if (dr == DialogResult.Yes) { openExportFile = true; } } catch (IOException ex) { RadMessageBox.SetThemeName(this.radGridView1.ThemeName); RadMessageBox.Show(this, ex.Message, "I/O Error", MessageBoxButtons.OK, RadMessageIcon.Error); } }
private void radButton_excel_Click(object sender, EventArgs e) { string filename = DateTime.Now.ToString("yyyy-MM-dd HHmmss.fff"); ExportToExcelML exporter = new ExportToExcelML(this.radGridView1); exporter.RunExport(".\\capture\\data-" + filename + ".xls"); RadMessageBox.Show("data-" + filename + ".xls Saved!!"); }
private void RunExportToExcelML(string fileName, ref bool openExportFile) { ExportToExcelML excelExporter = new ExportToExcelML(this.radGridView1); switch (this.radComboBoxSummaries.SelectedIndex) { case 0: excelExporter.SummariesExportOption = SummariesOption.ExportAll; break; case 1: excelExporter.SummariesExportOption = SummariesOption.ExportOnlyTop; break; case 2: excelExporter.SummariesExportOption = SummariesOption.ExportOnlyBottom; break; case 3: excelExporter.SummariesExportOption = SummariesOption.DoNotExport; break; } //set export settings excelExporter.ExportVisualSettings = this.radCheckBoxExportVisual.IsChecked; excelExporter.ExportHierarchy = this.radCheckBoxExportHierarchy.IsChecked; excelExporter.HiddenColumnOption = HiddenOption.DoNotExport; try { this.Cursor = Cursors.WaitCursor; excelExporter.RunExport(fileName); RadMessageBox.SetThemeName(this.radGridView1.ThemeName); DialogResult dr = RadMessageBox.Show("The data in the grid was exported successfully. Do you want to open the file?", "Export to Excel", MessageBoxButtons.YesNo, RadMessageIcon.Question); if (dr == DialogResult.Yes) { openExportFile = true; } } catch (IOException ex) { RadMessageBox.SetThemeName(this.radGridView1.ThemeName); RadMessageBox.Show(this, ex.Message, "I/O Error", MessageBoxButtons.OK, RadMessageIcon.Error); } finally { this.Cursor = Cursors.Default; } }
private void RunExportToExcelML(object fileName) { try { ExportToExcelML exporter = new ExportToExcelML(this.radGridView1); exporter.ExportVisualSettings = true; if (this.radRadioButton1.ToggleState == Telerik.WinControls.Enumerations.ToggleState.On) { exporter.SheetMaxRows = ExcelMaxRows._1048576; } exporter.ExcelCellFormatting += new ExcelCellFormattingEventHandler(exporter_ExcelCellFormatting); exporter.ExcelTableCreated += new ExcelTableCreatedEventHandler(exporter_ExcelTableCreated); exporter.RunExport(fileName.ToString()); RadMessageBox.SetThemeName("ControlDefault"); string text = "Export finished successfully!"; if (this.InvokeRequired) { this.Invoke(new EventHandler(delegate { RadMessageBox.Show(this, text); })); } else { RadMessageBox.Show(this, text); } } catch (System.IO.IOException ex) { if (this.InvokeRequired) { this.Invoke(new EventHandler(delegate { RadMessageBox.SetThemeName("ControlDefault"); RadMessageBox.Show(this, ex.Message, "I/O Error", MessageBoxButtons.OK, RadMessageIcon.Error); })); } else { RadMessageBox.SetThemeName("ControlDefault"); RadMessageBox.Show(this, ex.Message, "I/O Error", MessageBoxButtons.OK, RadMessageIcon.Error); } } finally { this.WorkCompleted(); } }
public static void ExportExcelProcess(RadGridView _gv) { SaveFileDialog saveFileDialog1 = new SaveFileDialog(); saveFileDialog1.Filter = "Excel files (*.xls)|*.xls|All files (*.*)|*.*"; if (saveFileDialog1.ShowDialog() == DialogResult.OK) { string strFileName = saveFileDialog1.FileName; ExportToExcelML exporter = new ExportToExcelML(_gv);//RadGridView1) string fileName = strFileName; exporter.RunExport(fileName); } }
public static void ExportGridXlSX2(RadGridView rv, string FileName) { //SaveFileDialog dialog = new SaveFileDialog(); //dialog.Filter = "Excel File (*.xls)|*.xls"; //if (dialog.ShowDialog() == DialogResult.OK) //{ ExportToExcelML exporter = new ExportToExcelML(rv); exporter.HiddenRowOption = HiddenOption.DoNotExport; exporter.HiddenColumnOption = HiddenOption.DoNotExport; exporter.RunExport(FileName); // MessageBox.Show("Export Finished"); //} }
private void radButtonElement1_Click(object sender, EventArgs e) { saveFileDialog1.Filter = "*.xls|*.xls"; saveFileDialog1.FileName = "export"; if (saveFileDialog1.ShowDialog() == DialogResult.OK) { radGridView1.Columns[6].ExcelExportType = DisplayFormatType.Text; radGridView1.Columns[7].ExcelExportType = DisplayFormatType.Text; radGridView1.Columns[2].ExcelExportType = DisplayFormatType.Custom; radGridView1.Columns[6].ExcelExportFormatString = "dd.MM.yyyy"; ExportToExcelML exporter = new ExportToExcelML(radGridView1); exporter.RunExport(saveFileDialog1.FileName); System.Diagnostics.Process.Start(saveFileDialog1.FileName); } }
private void btnExportar_Click(object sender, EventArgs e) { SaveFileDialog saveFileDialog = new SaveFileDialog(); try { saveFileDialog.Filter = "Excel files (*.xlsx)|*.xls"; saveFileDialog.RestoreDirectory = true; if (saveFileDialog.ShowDialog() != DialogResult.OK) { return; } if (saveFileDialog.FileName.Equals(String.Empty)) { RadMessageBox.SetThemeName(this.gvDatos.ThemeName); RadMessageBox.Show("Capture el nombre del archivo"); return; } string fileName = saveFileDialog.FileName; ExportToExcelML excelExporter = new ExportToExcelML(this.gvDatos); excelExporter.SheetName = "Datos"; excelExporter.SummariesExportOption = SummariesOption.ExportAll; try { excelExporter.RunExport(fileName); RadMessageBox.SetThemeName(this.gvDatos.ThemeName); if (RadMessageBox.Show("Los datos se han exportado correctamente. Desea abrir el archivo...?", this.Text, MessageBoxButtons.YesNo, RadMessageIcon.Question) == DialogResult.Yes) { Negocio.BaseWinBP.AbrirArchivoExcel(fileName); } } catch (System.IO.IOException ex) { RadMessageBox.Show(this, ex.Message, "Error I/O", MessageBoxButtons.OK, RadMessageIcon.Error); } } catch (Exception ex) { throw ex; } }
public static void RunExportToExcelML(string fileName, RadGridView radGridView) { ExportToExcelML excelExporter = new ExportToExcelML(radGridView); excelExporter.SummariesExportOption = SummariesOption.ExportAll; //set export settings //excelExporter.ExportVisualSettings = this.radCheckBoxExportVisual.IsChecked; //excelExporter.ExportHierarchy = this.radCheckBoxExportHierarchy.IsChecked; excelExporter.HiddenColumnOption = HiddenOption.DoNotExport; try { //this.Cursor = Cursors.WaitCursor; excelExporter.RunExport(fileName); RadMessageBox.SetThemeName(radGridView.ThemeName); DialogResult dr = RadMessageBox.Show("The data in the grid was exported successfully. Do you want to open the file?", "Export to Excel", MessageBoxButtons.YesNo, RadMessageIcon.Question); if (dr == DialogResult.Yes) { try { System.Diagnostics.Process.Start(fileName); } catch (Exception ex) { string message = String.Format("The file cannot be opened on your system.\nError message: {0}", ex.Message); RadMessageBox.Show(message, "Open File", MessageBoxButtons.OK, RadMessageIcon.Error); } } } catch (IOException ex) { RadMessageBox.SetThemeName(radGridView.ThemeName); System.Windows.Forms.MessageBox.Show(ex.Message, "ERR", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { //this.Cursor = Cursors.Default; } }
private void ExportExcel_Click(object sender, EventArgs e) { SaveFileDialog sfd = new SaveFileDialog(); sfd.Filter = String.Format("{0} (*{1})|*{1}", "Excel Files", ".xls"); if (sfd.ShowDialog() == DialogResult.OK) { //Create instance of the exporter. ExportToExcelML exporter = new ExportToExcelML(this.radGridView1); exporter.FileExtension = "xls"; exporter.HiddenColumnOption = Telerik.WinControls.UI.Export.HiddenOption.DoNotExport; exporter.ExportVisualSettings = true; exporter.SummariesExportOption = SummariesOption.DoNotExport; exporter.SheetMaxRows = ExcelMaxRows._1048576; exporter.SheetName = "Sheet"; exporter.ExcelCellFormatting += new Telerik.WinControls.UI.Export.ExcelML.ExcelCellFormattingEventHandler(exporter_ExcelCellFormatting); exporter.ExcelTableCreated += new Telerik.WinControls.UI.Export.ExcelML.ExcelTableCreatedEventHandler(exporter_ExcelTableCreated); exporter.RunExport(sfd.FileName); MessageBox.Show("Export completed"); } }
private void radButtonElement1_Click(object sender, EventArgs e) { saveFileDialog1.Filter = "*.xls|*.xls"; saveFileDialog1.FileName = "export"; if (saveFileDialog1.ShowDialog() == DialogResult.OK) { radGridView1.Columns[6].ExcelExportType = DisplayFormatType.Text; radGridView1.Columns[7].ExcelExportType = DisplayFormatType.Text; radGridView1.Columns[2].ExcelExportType = DisplayFormatType.Custom; radGridView1.Columns[2].ExcelExportFormatString = "dd.MM.yyyy"; if (radGridView1.Columns["Выезд"] != null) { radGridView1.Columns["Выезд"].ExcelExportType = DisplayFormatType.Custom; radGridView1.Columns["Выезд"].ExcelExportFormatString = "dd.MM.yyyy"; } if (radGridView1.Columns["Смерть"] != null) { radGridView1.Columns["Смерть"].ExcelExportType = DisplayFormatType.Custom; radGridView1.Columns["Смерть"].ExcelExportFormatString = "dd.MM.yyyy"; } if (radGridView1.Columns["Дата над. обсл."] != null) { radGridView1.Columns["Дата над. обсл."].ExcelExportType = DisplayFormatType.Custom; radGridView1.Columns["Дата над. обсл."].ExcelExportFormatString = "dd.MM.yyyy"; } ExportToExcelML exporter = new ExportToExcelML(radGridView1); exporter.PagingExportOption = PagingExportOption.AllPages; exporter.RunExport(saveFileDialog1.FileName); System.Diagnostics.Process.Start(saveFileDialog1.FileName); } }
void btnExport_Click(object sender, EventArgs e) { try { if (DialogResult.OK == saveFileDialog1.ShowDialog()) { if (radGridView1 == null) { InitializeExportGrid(); } radGridView1.Columns.Clear(); radGridView1.Columns.Add(new GridViewTextBoxColumn("MonthCommencing", "MonthCommencing")); radGridView1.Columns.Add(new GridViewTextBoxColumn("OperatorLicenceNumber", "OperatorLicenceNumber")); radGridView1.Columns.Add(new GridViewTextBoxColumn("OperatorName", "OperatorName")); radGridView1.Columns.Add(new GridViewTextBoxColumn("PrivateHireLicenceNumber", "PrivateHireLicenceNumber")); radGridView1.Columns.Add(new GridViewTextBoxColumn("FirstName", "FirstName")); radGridView1.Columns.Add(new GridViewTextBoxColumn("Surname", "Surname")); // string Message = string.Empty; DateTime?dtFrom = dtpFromDate.Value.ToDateorNull(); DateTime?dtTill = dtpToDate.Value.ToDateorNull(); int BookingStatusId = 0; string MonthCommencing = string.Empty; if (dtFrom.Value == null) { Message = "Required : From Date"; } if (dtTill.Value == null) { if (!string.IsNullOrEmpty(Message)) { Message = "Required : To Date"; } else { Message += Environment.NewLine;// "Required : To Date"; Message += "Required : To Date"; } } if (!string.IsNullOrEmpty(Message)) { ENUtils.ShowMessage(Message); return; } MonthCommencing = string.Format("{0:dd/MM/yyyy}", dtFrom.Value) + "-" + string.Format("{0:dd/MM/yyyy}", dtTill.Value); if (opAll.IsChecked) { BookingStatusId = 0; } if (opCompleted.IsChecked) { BookingStatusId = Enums.BOOKINGSTATUS.DISPATCHED.ToInt(); } if (opCancelled.IsChecked) { BookingStatusId = Enums.BOOKINGSTATUS.CANCELLED.ToInt(); } // using (TaxiDataContext db = new TaxiDataContext()) { var list = db.stp_OperatorPrivateHireDriverRecord(ddlSubCompany.SelectedValue.ToInt(), dtFrom.Value, dtTill.Value + TimeSpan.Parse("23:59:59"), BookingStatusId, MonthCommencing).ToList(); // grdLister.DataSource = list; radGridView1.RowCount = list.Count; for (int i = 0; i < list.Count; i++) { radGridView1.Rows[i].Cells["MonthCommencing"].Value = list[i].MonthCommencing; radGridView1.Rows[i].Cells["OperatorLicenceNumber"].Value = list[i].OperatorLicenceNumber; radGridView1.Rows[i].Cells["OperatorName"].Value = list[i].OperatorName; radGridView1.Rows[i].Cells["PrivateHireLicenceNumber"].Value = list[i].PrivateHireLicenceNumber; radGridView1.Rows[i].Cells["FirstName"].Value = list[i].FirstName; radGridView1.Rows[i].Cells["Surname"].Value = list[i].Surname; } } ExportToExcelML export = new ExportToExcelML(this.radGridView1); export.ExportVisualSettings = true; export.HiddenColumnOption = HiddenOption.ExportAsHidden; export.HiddenColumnOption = Telerik.WinControls.UI.Export.HiddenOption.DoNotExport; export.ExcelCellFormatting += new Telerik.WinControls.UI.Export.ExcelML.ExcelCellFormattingEventHandler(export_ExcelCellFormatting); // // //radGridView1.Columns["PickupDate"].HeaderText = "Pickup Date-Time"; //radGridView1.Columns["From"].HeaderText = "Pick-up Address"; //radGridView1.Columns["To"].HeaderText = "Drop-off Address"; radGridView1.Columns["MonthCommencing"].HeaderText = "Month Commencing"; radGridView1.Columns["OperatorLicenceNumber"].HeaderText = "Operator Licence Number"; radGridView1.Columns["OperatorName"].HeaderText = "Operator Name"; radGridView1.Columns["PrivateHireLicenceNumber"].HeaderText = "Private Hire Licence Number"; radGridView1.Columns["FirstName"].HeaderText = "First Name"; //CompanyName exporter = new RadGridViewExcelExporter(); BackgroundWorker worker = new BackgroundWorker(); worker.DoWork += new DoWorkEventHandler(worker_DoWork); worker.RunWorkerCompleted += new RunWorkerCompletedEventHandler(bg_RunWorkerCompleted); worker.RunWorkerAsync(saveFileDialog1.FileName); exporter.Progress += new ProgressHandler(exportProgress); this.btnExport.Enabled = false; } } catch (Exception ex) { ENUtils.ShowMessage(ex.Message); } }
private void printTheScheduleButton_Click(object sender, EventArgs e) { SaveFileDialog saveDialog = new SaveFileDialog(); saveDialog.InitialDirectory = @"c:\"; saveDialog.Filter = "Excell File (*.xls)|*.xls"; saveDialog.FilterIndex = 2; saveDialog.RestoreDirectory = true; string filePath = ""; if (saveDialog.ShowDialog() == DialogResult.OK) { filePath = saveDialog.FileName.ToString(); ExportToExcelML exporter = new ExportToExcelML( (documentTabStrip1.TabPanels[documentTabStrip1.SelectedIndex].Controls[0] as TimetableGridview).gridviewSchedule); exporter.HiddenColumnOption = Telerik.WinControls.UI.Export.HiddenOption.DoNotExport; exporter.ExportVisualSettings = true; exporter.SheetName = "Разписание за " + documentTabStrip1.TabPanels[0].Text.ToString(); exporter.ExcelCellFormatting += exporter_ExcelCellFormatting; exporter.RunExport(filePath); } //PrintTheScheduleForm printSchedule = new PrintTheScheduleForm(mDBManager); //printSchedule.Show(); }
void RunExportToExcelML(string fileName, ref bool openExportFile) { ExportToExcelML excelExporter = new ExportToExcelML(this.radGridReport); excelExporter.SheetName = string.Format(@"MNRP{0}{1}", DateTime.Now.ToString("yyyyMMddHHmmss"), DateTime.Now.Millisecond); //excelExporter.SheetMaxRows = ExcelMaxRows._1048576; //ExcelMaxRows._65536 //set exporting visual settings excelExporter.ExportVisualSettings = true; //if (this.radTextBoxSheet.Text != String.Empty) //{ // excelExporter.SheetName = this.radTextBoxSheet.Text; //} //switch (this.radComboBoxSummaries.SelectedIndex) //{ // case 0: // excelExporter.SummariesExportOption = SummariesOption.ExportAll; // break; // case 1: // excelExporter.SummariesExportOption = SummariesOption.ExportOnlyTop; // break; // case 2: // excelExporter.SummariesExportOption = SummariesOption.ExportOnlyBottom; // break; // case 3: // excelExporter.SummariesExportOption = SummariesOption.DoNotExport; // break; //} //set max sheet rows //if (this.radRadioButton1.ToggleState == Telerik.WinControls.Enumerations.ToggleState.On) //{ // excelExporter.SheetMaxRows = ExcelMaxRows._1048576; //} //else if (this.radRadioButton2.ToggleState == Telerik.WinControls.Enumerations.ToggleState.On) //{ // excelExporter.SheetMaxRows = ExcelMaxRows._65536; //} //set exporting visual settings //excelExporter.ExportVisualSettings = this.exportVisualSettings; try { excelExporter.RunExport(fileName); RadMessageBox.SetThemeName(this.radGridReport.ThemeName); DialogResult dr = RadMessageBox.Show("The data in the grid was exported successfully. Do you want to open the file?", "Export to Excel", MessageBoxButtons.OK, RadMessageIcon.Question); if (dr == DialogResult.Yes) { openExportFile = true; } } catch (IOException ex) { RadMessageBox.SetThemeName(this.radGridReport.ThemeName); RadMessageBox.Show(this, ex.Message, "Info", MessageBoxButtons.OK, RadMessageIcon.Error); } }
private void btnExport_Click(object sender, EventArgs e) { try { if (DialogResult.OK == saveFileDialog1.ShowDialog()) { if (radGridView1 == null) { InitializeExportGrid(); } radGridView1.Columns.Clear(); radGridView1.Columns.Add(new GridViewTextBoxColumn("DriverNo", "DriverNo")); radGridView1.Columns.Add(new GridViewTextBoxColumn("NetTotal", "NetTotal")); radGridView1.Columns.Add(new GridViewTextBoxColumn("Rent", "Rent")); radGridView1.Columns.Add(new GridViewTextBoxColumn("AccountBookings", "AccountBookings")); radGridView1.Columns.Add(new GridViewTextBoxColumn("Balance", "Balance")); radGridView1.Columns.Add(new GridViewTextBoxColumn("OfficeToPay", "OfficeToPay")); radGridView1.Columns.Add(new GridViewTextBoxColumn("DriverToPay", "DriverToPay")); radGridView1.Columns.Add(new GridViewTextBoxColumn("BalanceBF", "BalanceBF")); //radGridView1.Columns.Add(new GridViewTextBoxColumn("Total", "Total")); //radGridView1.Columns.Add(new GridViewTextBoxColumn("Active", "Active")); //this.radGridView1.Columns["Telephone"].ExcelExportType = Telerik.WinControls.UI.Export.DisplayFormatType.Text; //this.radGridView1.Columns["Telephone"].ExcelExportType = DisplayFormatType.Custom; // radGridView1.DataSource = query; using (TaxiDataContext db = new TaxiDataContext()) { var list = db.stp_IncomeStatement().ToList(); // grdLister.DataSource = list; radGridView1.RowCount = list.Count; for (int i = 0; i < list.Count; i++) { radGridView1.Rows[i].Cells["DriverNo"].Value = list[i].DriverNo; radGridView1.Rows[i].Cells["NetTotal"].Value = list[i].NetTotal; radGridView1.Rows[i].Cells["Rent"].Value = list[i].Rent; radGridView1.Rows[i].Cells["AccountBookings"].Value = list[i].AccountBookings; radGridView1.Rows[i].Cells["Balance"].Value = list[i].Balance; radGridView1.Rows[i].Cells["OfficeToPay"].Value = list[i].OfficeToPay; radGridView1.Rows[i].Cells["DriverToPay"].Value = list[i].DriverToPay; radGridView1.Rows[i].Cells["BalanceBF"].Value = list[i].BalanceBF; // radGridView1.Rows[i].Cells["Telephone"].ViewInfo.; //radGridView1.Rows[i].Cells["Telephone"].Value = (radGridView1.Rows[i].Cells["Telephone"].Value.ToString().Replace(".", "")); } } // this.radGridView1.Columns["Telephone"].ExcelExportType = DisplayFormatType.Fixed; //this.radGridView1.Columns["Telephone"].ExcelExportType = DisplayFormatType.Custom; ExportToExcelML export = new ExportToExcelML(this.radGridView1); export.ExportVisualSettings = true; export.HiddenColumnOption = HiddenOption.ExportAsHidden; export.HiddenColumnOption = Telerik.WinControls.UI.Export.HiddenOption.DoNotExport; export.ExcelCellFormatting += new Telerik.WinControls.UI.Export.ExcelML.ExcelCellFormattingEventHandler(export_ExcelCellFormatting); // // //radGridView1.Columns["DriverNo"].HeaderText = "Driver No"; //radGridView1.Columns["AccountBookings"].HeaderText = "Account Bookings"; //radGridView1.Columns["OfficeToPay"].HeaderText = "Office To Pay"; //radGridView1.Columns["BalanceBF"].HeaderText = "Balance B/F"; //radGridView1.Columns["DriverToPay"].HeaderText = "Driver To Pay"; radGridView1.Columns["DriverNo"].HeaderText = "Driver"; radGridView1.Columns["AccountBookings"].HeaderText = "A/C Bookings"; radGridView1.Columns["OfficeToPay"].HeaderText = "Office To Pay"; radGridView1.Columns["BalanceBF"].HeaderText = "Blnc B/F"; radGridView1.Columns["DriverToPay"].HeaderText = "Drv To Pay"; // //CompanyName exporter = new RadGridViewExcelExporter(); BackgroundWorker worker = new BackgroundWorker(); worker.DoWork += new DoWorkEventHandler(worker_DoWork); worker.RunWorkerCompleted += new RunWorkerCompletedEventHandler(bg_RunWorkerCompleted); worker.RunWorkerAsync(saveFileDialog1.FileName); exporter.Progress += new ProgressHandler(exportProgress); this.btnExport.Enabled = false; } } catch (Exception ex) { ENUtils.ShowMessage(ex.Message); } }
private void exportButton_Click(object sender, EventArgs e) { SaveFileDialog saveDialog = new SaveFileDialog(); saveDialog.InitialDirectory = @"c:\"; saveDialog.Filter = "Excell File (*.xls)|*.xls"; saveDialog.FilterIndex = 2; saveDialog.RestoreDirectory = true; string filePath = ""; if (saveDialog.ShowDialog() == DialogResult.OK) { try { filePath = saveDialog.FileName.ToString(); ExportToExcelML exporter = new ExportToExcelML(this.gridviewSchedule); exporter.HiddenColumnOption = Telerik.WinControls.UI.Export.HiddenOption.DoNotExport; exporter.ExportVisualSettings = true; exporter.SheetName = "Разписание за " + dropdownListClasses.SelectedItem.Text; exporter.ExcelCellFormatting += exporter_ExcelCellFormatting; exporter.RunExport(filePath); } catch { } } }
void Btn_ExportToExcel_Click(object sender, EventArgs e) { if (this.rgv_ReportDLHR.Visible == true) { if (rgv_ReportDLHR.RowCount != 0) { SaveFileDialog saveFileDialog = new SaveFileDialog(); ExportToExcelML excelExporter = null; try { ExportToExcelML excelML = new ExportToExcelML(this.rgv_ReportDLHR); excelExporter = new ExportToExcelML(this.rgv_ReportDLHR); excelExporter.ExcelCellFormatting += excelExporter_ExcelCellFormatting; excelExporter.ExcelTableCreated += exporter_ExcelTableCreated; this.Cursor = Cursors.WaitCursor; saveFileDialog.Filter = "Excel (*.xls)|*.xls"; if (saveFileDialog.ShowDialog() == DialogResult.OK) { excelExporter.RunExport(saveFileDialog.FileName); DialogResult dr = RadMessageBox.Show("การบันทึกไฟล์สำเร็จ คุณต้องการเปิดไฟล์หรือไม่?", "Export to Excel", MessageBoxButtons.YesNo, RadMessageIcon.Question); if (dr == DialogResult.Yes) { System.Diagnostics.Process.Start(saveFileDialog.FileName); } } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { if (con.State == ConnectionState.Open) con.Close(); } } else { RadMessageBox.Show("ไม่มีข้อมูล"); return; } } else if (this.rgv_ReportDSHR.Visible == true) { if (rgv_ReportDSHR.RowCount != 0) { SaveFileDialog saveFileDialog = new SaveFileDialog(); ExportToExcelML excelExporter = null; try { ExportToExcelML excelML = new ExportToExcelML(this.rgv_ReportDSHR); excelExporter = new ExportToExcelML(this.rgv_ReportDSHR); excelExporter.ExcelCellFormatting += excelExporter_ExcelCellFormatting; excelExporter.ExcelTableCreated += exporter_ExcelTableCreated; this.Cursor = Cursors.WaitCursor; saveFileDialog.Filter = "Excel (*.xls)|*.xls"; if (saveFileDialog.ShowDialog() == DialogResult.OK) { excelExporter.RunExport(saveFileDialog.FileName); DialogResult dr = RadMessageBox.Show("การบันทึกไฟล์สำเร็จ คุณต้องการเปิดไฟล์หรือไม่?", "Export to Excel", MessageBoxButtons.YesNo, RadMessageIcon.Question); if (dr == DialogResult.Yes) { System.Diagnostics.Process.Start(saveFileDialog.FileName); } } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { if (con.State == ConnectionState.Open) con.Close(); } } else { RadMessageBox.Show("ไม่มีข้อมูล"); return; } } else if (this.rgv_ReportCHDHR.Visible == true) { if (rgv_ReportCHDHR.RowCount != 0) { SaveFileDialog saveFileDialog = new SaveFileDialog(); ExportToExcelML excelExporter = null; try { ExportToExcelML excelML = new ExportToExcelML(this.rgv_ReportCHDHR); excelExporter = new ExportToExcelML(this.rgv_ReportCHDHR); excelExporter.ExcelCellFormatting += excelExporter_ExcelCellFormatting; excelExporter.ExcelTableCreated += exporter_ExcelTableCreated; this.Cursor = Cursors.WaitCursor; saveFileDialog.Filter = "Excel (*.xls)|*.xls"; if (saveFileDialog.ShowDialog() == DialogResult.OK) { excelExporter.RunExport(saveFileDialog.FileName); DialogResult dr = RadMessageBox.Show("การบันทึกไฟล์สำเร็จ คุณต้องการเปิดไฟล์หรือไม่?", "Export to Excel", MessageBoxButtons.YesNo, RadMessageIcon.Question); if (dr == DialogResult.Yes) { System.Diagnostics.Process.Start(saveFileDialog.FileName); } } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { if (con.State == ConnectionState.Open) con.Close(); } } else { RadMessageBox.Show("ไม่มีข้อมูล"); return; } } }
private void btnExport_Click(object sender, EventArgs e) { try { if (DialogResult.OK == saveFileDialog1.ShowDialog()) { if (radGridView1 == null) { InitializeExportGrid(); } radGridView1.Columns.Clear(); radGridView1.Columns.Add(new GridViewTextBoxColumn("AccountName", "AccountName")); radGridView1.Columns.Add(new GridViewTextBoxColumn("Address", "Address")); //this.radGridView1.Columns["Telephone"].ExcelExportType = Telerik.WinControls.UI.Export.DisplayFormatType.Text; //this.radGridView1.Columns["Telephone"].ExcelExportType = DisplayFormatType.Custom; // radGridView1.DataSource = query; var list = (from a in General.GetQueryable <Gen_Company>(null) orderby a.CompanyName select new { CompanyName = a.CompanyName, Address = a.Address }).ToList(); radGridView1.RowCount = list.Count; for (int i = 0; i < list.Count; i++) { radGridView1.Rows[i].Cells["AccountName"].Value = list[i].CompanyName; radGridView1.Rows[i].Cells["Address"].Value = list[i].Address; // radGridView1.Rows[i].Cells["Telephone"].ViewInfo.; //radGridView1.Rows[i].Cells["Telephone"].Value = (radGridView1.Rows[i].Cells["Telephone"].Value.ToString().Replace(".", "")); } // this.radGridView1.Columns["Telephone"].ExcelExportType = DisplayFormatType.Fixed; //this.radGridView1.Columns["Telephone"].ExcelExportType = DisplayFormatType.Custom; ExportToExcelML export = new ExportToExcelML(this.radGridView1); export.ExportVisualSettings = true; export.HiddenColumnOption = HiddenOption.ExportAsHidden; export.HiddenColumnOption = Telerik.WinControls.UI.Export.HiddenOption.DoNotExport; export.ExcelCellFormatting += new Telerik.WinControls.UI.Export.ExcelML.ExcelCellFormattingEventHandler(export_ExcelCellFormatting); // // //radGridView1.Columns["PickupDate"].HeaderText = "Pickup Date-Time"; //radGridView1.Columns["From"].HeaderText = "Pick-up Address"; //radGridView1.Columns["To"].HeaderText = "Drop-off Address"; radGridView1.Columns["AccountName"].HeaderText = "Account Name"; //Me.RadGridView1.Columns(0).ExcelExportType = Export.DisplayFormatType.Text //CompanyName exporter = new RadGridViewExcelExporter(); BackgroundWorker worker = new BackgroundWorker(); worker.DoWork += new DoWorkEventHandler(worker_DoWork); worker.RunWorkerCompleted += new RunWorkerCompletedEventHandler(bg_RunWorkerCompleted); worker.RunWorkerAsync(saveFileDialog1.FileName); exporter.Progress += new ProgressHandler(exportProgress); this.btnExport.Enabled = false; } } catch (Exception ex) { ENUtils.ShowMessage(ex.Message); } }
void radButtonExport_Click(object sender, EventArgs e) { if (radGridData.RowCount != 0) { SaveFileDialog saveFileDialog = new SaveFileDialog(); ExportToExcelML excelExporter = null; try { ExportToExcelML excelML = new ExportToExcelML(this.radGridData); excelExporter = new ExportToExcelML(this.radGridData); excelExporter.ExcelCellFormatting += excelExporter_ExcelCellFormatting; excelExporter.ExcelTableCreated += exporter_ExcelTableCreated; this.Cursor = Cursors.WaitCursor; saveFileDialog.Filter = "Excel (*.xls)|*.xls"; if (saveFileDialog.ShowDialog() == DialogResult.OK) { excelExporter.RunExport(saveFileDialog.FileName); DialogResult dr = RadMessageBox.Show("การบันทึกไฟล์สำเร็จ คุณต้องการเปิดไฟล์หรือไม่?", "Export to Excel", MessageBoxButtons.YesNo, RadMessageIcon.Question); if (dr == DialogResult.Yes) { System.Diagnostics.Process.Start(saveFileDialog.FileName); } } } catch (Exception) { } } else { RadMessageBox.Show("ไม่มีข้อมูล"); return; } }
private void btnExport_Click(object sender, EventArgs e) { try { if (DialogResult.OK == saveFileDialog1.ShowDialog()) { if (radGridView1 == null) { InitializeExportGrid(); } radGridView1.Columns.Clear(); radGridView1.Columns.Add(new GridViewTextBoxColumn("DriverNo", "DriverNo")); radGridView1.Columns.Add(new GridViewTextBoxColumn("DriverName", "Name")); radGridView1.Columns.Add(new GridViewTextBoxColumn("VehicleType", "Vehicle")); radGridView1.Columns.Add(new GridViewTextBoxColumn("Owed", "Owed")); radGridView1.Columns.Add(new GridViewTextBoxColumn("Paid", "Paid")); radGridView1.Columns.Add(new GridViewTextBoxColumn("CurrentBalance", "C Balance")); //radGridView1.Columns.Add(new GridViewTextBoxColumn("Driver", "Driver")); //radGridView1.Columns.Add(new GridViewTextBoxColumn("Vehicle", "Vehicle")); //radGridView1.Columns.Add(new GridViewTextBoxColumn("Price", "Price")); using (TaxiDataContext db = new TaxiDataContext()) { var query = db.stp_DriverCommissionPaymentSummary().ToList(); radGridView1.RowCount = query.Count; for (int i = 0; i < query.Count; i++) { // radGridView1.Rows[i].Cells["PickupDate"].Value = " " + string.Format(" {0:dd/MM/yyyy HH:mm} ", query[i].PickupDate) + " "; radGridView1.Rows[i].Cells["DriverNo"].Value = query[i].DriverNo.Replace("=", "").Trim(); radGridView1.Rows[i].Cells["DriverName"].Value = query[i].DriverName.Replace("=", "").Trim(); radGridView1.Rows[i].Cells["VehicleType"].Value = query[i].VehicleType.Replace("=", "").Trim(); //radGridView1.Rows[i].Cells["Customer"].Value = query[i].Customer.Replace("=", "").Trim(); //radGridView1.Rows[i].Cells["Telephone"].Value = string.Format(" {0:F0} ", query[i].Telephone) + "."; //" " + string.Format(" {0:dd/MM/yyyy HH:mm} ", query[i].Telephone.Replace("=", "").Trim()) + " "; radGridView1.Rows[i].Cells["Owed"].Value = query[i].Owed; radGridView1.Rows[i].Cells["Paid"].Value = query[i].Paid; radGridView1.Rows[i].Cells["CurrentBalance"].Value = query[i].CurrentBalance; // radGridView1.Rows[i].Cells["Telephone"].ViewInfo.; //radGridView1.Rows[i].Cells["Telephone"].Value = (radGridView1.Rows[i].Cells["Telephone"].Value.ToString().Replace(".", "")); } } ExportToExcelML export = new ExportToExcelML(this.radGridView1); export.ExportVisualSettings = true; export.HiddenColumnOption = HiddenOption.ExportAsHidden; export.HiddenColumnOption = Telerik.WinControls.UI.Export.HiddenOption.DoNotExport; export.ExcelCellFormatting += new Telerik.WinControls.UI.Export.ExcelML.ExcelCellFormattingEventHandler(export_ExcelCellFormatting); // radGridView1.Columns["DriverNo"].HeaderText = "Driver No"; radGridView1.Columns["DriverName"].HeaderText = "Name"; radGridView1.Columns["VehicleType"].HeaderText = "Vehicle"; //grdLister.Columns["LastStatementNo"].HeaderText = "Last Statement No"; radGridView1.Columns["CurrentBalance"].HeaderText = "C Balance"; // //grdLister.Columns["PickupDate"].HeaderText = "Pickup Date-Time"; //radGridView1.Columns["From"].HeaderText = "Pick-up Address"; //radGridView1.Columns["To"].HeaderText = "Drop-off Address"; //radGridView1.Columns["CompanyName"].HeaderText = "Account"; //Me.RadGridView1.Columns(0).ExcelExportType = Export.DisplayFormatType.Text //CompanyName exporter = new RadGridViewExcelExporter(); BackgroundWorker worker = new BackgroundWorker(); worker.DoWork += new DoWorkEventHandler(worker_DoWork); worker.RunWorkerCompleted += new RunWorkerCompletedEventHandler(bg_RunWorkerCompleted); worker.RunWorkerAsync(saveFileDialog1.FileName); exporter.Progress += new ProgressHandler(exportProgress); this.btnExport.Enabled = false; } } catch (Exception ex) { } }
void RunExportToExcelML(string fileName, ref bool openExportFile) { ExportToExcelML excelExporter = new ExportToExcelML(this.radGridTimeTemp); excelExporter.SheetName = string.Format(@"MNRPSRC{0}{1}", DateTime.Now.ToString("yyyyMMddHHmmss"), DateTime.Now.Millisecond); excelExporter.ExportVisualSettings = true; try { excelExporter.RunExport(fileName); RadMessageBox.SetThemeName(this.radGridTimeTemp.ThemeName); RadMessageBox.Show("The data in the grid was exported successfully.", "Export to Excel", MessageBoxButtons.OK, RadMessageIcon.Info); } catch (IOException ex) { RadMessageBox.SetThemeName(this.radGridTimeTemp.ThemeName); RadMessageBox.Show(this, ex.Message, "Info", MessageBoxButtons.OK, RadMessageIcon.Error); } }