private void bt_export_Click(object sender, RoutedEventArgs e) { if (GetSelectItemsCount() <= 0) { return; } string filepath = ""; SaveFile(ref filepath); if (string.IsNullOrEmpty(filepath)) { return; } ExcelOper excel = new ExcelOper(filepath); foreach (QueryDataViewModel qvm in obc_qvm) { if (qvm.IsSelected) { this.report = new ReportModelBlock(qvm.SampleComment); excel.PrintOneReportBlcok(report); } } excel.Save(); excel.Quit(); MessageBox.Show("Done!", "Information"); }
private void button_export_Click(object sender, RoutedEventArgs e) { if (obc_project.Count == 0) { return; } string filepath = ""; SaveFile(ref filepath); if (string.IsNullOrEmpty(filepath)) { return; } ExcelOper excel = new ExcelOper(filepath); try { foreach (ProjectEstimateViewModel project in obc_project) { excel.PrintOneProjectEstimateBlcok(project); } MessageBox.Show("成功导出", "Information"); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error"); } finally { excel.Save(); excel.Quit(); } }
private void button_export_Click(object sender, RoutedEventArgs e) { if (obc_budgetary.Count == 0) { return; } string filepath = ""; SaveFile(ref filepath); if (string.IsNullOrEmpty(filepath)) { return; } ExcelOper excel = new ExcelOper(filepath); try { foreach (BudgetaryUpperLimit limit in obc_budgetary) { excel.PrintOneBudgetaryUpperLimitBlock(limit); } MessageBox.Show("成功导出", "Information"); } catch (Exception ex) { MessageBox.Show("过程出现错误", "Error"); } finally { excel.Save(); excel.Quit(); } }
private bool ExportToExcel(string path) { if (this._dt == null || this._dt.Rows.Count == 0) { return(false); } DataTable dt = this._dt.Copy(); dt.TableName = "经济指标统计结果"; dt.Columns["DISTRICTNAME"].Caption = this.gridColumn1.Caption; dt.Columns["DISTRICTAREA"].Caption = this.gridColumn2.Caption; if (dt.Columns["NUMBER"] != null) { dt.Columns["NUMBER"].Caption = this.gridColumn3.Caption; } if (dt.Columns["AREA"] != null) { dt.Columns["AREA"].Caption = this.gridColumn4.Caption; } if (dt.Columns["FLOORAREA"] != null) { dt.Columns["FLOORAREA"].Caption = this.gridColumn5.Caption; } return(ExcelOper.ExportExcel(dt, path, false)); }
private void button_export_Click(object sender, RoutedEventArgs e) { if (obc_department.Count == 0) { return; } string filepath = ""; SaveFile(ref filepath); if (string.IsNullOrEmpty(filepath)) { return; } ExcelOper excel = new ExcelOper(filepath); try { foreach (DepartmentBudgetFilled depart in obc_department) { excel.PrintOneDepartmentBudgetFilledBlock(depart); } MessageBox.Show("成功导出", "Information"); } catch (Exception) { } finally { excel.Save(); excel.Quit(); } }
private bool ExportToExcel(string path) { if (this._dt == null || this._dt.Rows.Count == 0) { return(false); } DataTable dt = this._dt.Copy(); dt.TableName = "区域要素属性统计表"; return(ExcelOper.ExportExcel(dt, path, false)); }
private void btnOutputExcel_Click(object sender, EventArgs e) { if (this._dt == null || this._dt.Rows.Count == 0) { return; } SaveFileDialog dialog = new SaveFileDialog { RestoreDirectory = true, Filter = "Excel Files (*.xls)|*.xls" }; if (DialogResult.OK == dialog.ShowDialog()) { string fileName = dialog.FileName; DataTable dt = this._dt.Copy(); dt.TableName = this.seLimitHeight.Value.ToString("0.00") + "m限高结果表"; dt.Columns["Name"].Caption = "名称"; dt.Columns["fcName"].Caption = "类型"; dt.Columns["OverHeight"].Caption = "超高(m)"; dt.Columns["TerrainHeight"].Caption = "地面高(m)"; dt.Columns["Height"].Caption = "高度(m)"; dt.Columns["Address"].Caption = "地址"; dt.Columns["Contact"].Caption = "联系人"; dt.Columns.Remove("fid"); dt.Columns.Remove("fc"); dt.Columns.Remove("geo"); WaitForm.Start("正在导出...", "请稍后"); bool bExport = ExcelOper.ExportExcel(dt, fileName); if (bExport) { WaitForm.Stop(); XtraMessageBox.Show("导出成功", "提示"); } else { WaitForm.Stop(); XtraMessageBox.Show("导出失败", "提示"); } } }
private bool ExportToExcel(string path) { if (this._dt == null || this._dt.Rows.Count == 0) { return(false); } DataTable dt = this._dt.Copy(); dt.TableName = "管点统计结果"; dt.Columns["PIPENODETYPE"].Caption = "管点类型"; dt.Columns["FIELDNAME"].Caption = "属性"; dt.Columns["PVALUE"].Caption = "分类"; dt.Columns["NUMBER"].Caption = "数量(个)"; dt.Columns["TOTALNUMBER"].Caption = "总数量(个)"; if (!this.gridColumn2.Visible) { dt.Columns.Remove("FIELDNAME"); } return(ExcelOper.ExportExcel(dt, path, true)); }
//检查文件内容 private void CheckFileInOBC(ImportDGViewModel dGViewModel) { if (!File.Exists(dGViewModel.FilePath)) { dGViewModel.Comment = "File Not Exists"; return; } ExcelOper excel = new ExcelOper(dGViewModel.FilePath); try { // CsvHelper csv = new CsvHelper(); //DataTable dt = csv.readCsvTxt(dGViewModel.FilePath); DataTable dt = excel.GetContentFromExcel(); if (dt.DefaultView[5][1].ToString().Trim() == "Ag") { dGViewModel.CsvType = "Ag"; } else if (dt.DefaultView[5][1].ToString().Trim() == "W") { dGViewModel.CsvType = "W"; } else { dGViewModel.Comment = "未能识别文件内容"; return; } dGViewModel.SampleComment = dt.DefaultView[3][1].ToString(); dGViewModel.Csv_VM = new CSVValueViewModel(); dGViewModel.Csv_VM = CSVVM(dGViewModel.CsvType, dt); dGViewModel.FileDir = dGViewModel.Csv_VM.FileDir; } catch (Exception) { dGViewModel.Comment = "未能识别文件内容"; return; } finally { excel.Quit(); } }
private void button_export_Click(object sender, RoutedEventArgs e) { if (obc_import.Count == 0) { return; } string filepath = ""; SaveFile(ref filepath); if (string.IsNullOrEmpty(filepath)) { return; } ExcelOper excel = new ExcelOper(filepath); foreach (ProjectImportMouldViewModel import in obc_import) { excel.PrintOneImportBlock(import); } excel.Save(); excel.Quit(); MessageBox.Show("成功导出", "Information"); }