private void buttonCalc_Click(object sender, RoutedEventArgs e) { int num = ExcelData.dataTable.Rows.Count; if (GloableVar.whetherReadSuc == 1 | num >= 2) { CalculateYM yM = new CalculateYM(); GloableVar.fringeNum = Convert.ToInt32(this.textBoxNum.Text); double result = yM.CalResult(GloableVar.fringeNum); this.textBoxShowAns.Text = Convert.ToString(Math.Round(result, 6)); string exePath = Environment.CurrentDirectory; string txtPath = null; txtPath = exePath + "\\result.txt"; TxtWrite(txtPath, this.textBoxShowAns.Text); string txtPath1 = null; txtPath1 = exePath + "\\friage.txt"; TxtWrite(txtPath1, this.textBoxNum.Text); string xlsxPath = null; xlsxPath = exePath + "\\dataSave.xlsx"; ExcelUtility.DataTableToExcel(xlsxPath, ExcelData.dataTable); ExportCurrentData(); } else { MessageBox.Show("没有输入数据或者读取数据失败,无法计算!", "Warnning!"); } }
public void ExportCurrentData() { System.DateTime currentTime = new System.DateTime(); currentTime = System.DateTime.Now; string folderPath = System.Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments).ToString() + "\\Young Modulus\\"; string excelPath = currentTime.ToString("yyyyMMdd_HHmmss") + "_" + this.textBoxNum.Text + "_" + this.textBoxShowAns.Text; ExcelUtility.DataTableToExcel(folderPath + excelPath + ".xlsx", ExcelData.dataTable); }
public void ShowLastData() { string exePath = Environment.CurrentDirectory; string txtPath = null; string xlsxPath = null; xlsxPath = exePath + "\\dataSave.xlsx"; ExcelDataTable.dt = ExcelUtility.ExcelToDataTable(xlsxPath, true); dataGridShowLast.ItemsSource = ExcelDataTable.dt.DefaultView; }
public void ReadExcelData() { string address = ""; string filePath = this.textBoxDataAddress.Text; int j = 0; if (filePath[0] == '"') { address = filePath.Substring(1, filePath.Length - 2); } else { address = filePath; } ExcelData.dataTable = ExcelUtility.ExcelToDataTable(address, true); }
public void ExportLastData() { try { var saveFileDialog = new Microsoft.Win32.SaveFileDialog() { Filter = "Excel(*.xlsx *.xls)|*.xlsx;*.xls" }; var result = saveFileDialog.ShowDialog(); if (result == true) { string path = saveFileDialog.FileName; ExcelUtility.DataTableToExcel(path, ExcelDataTable.dt); this.textBoxLastDataAddress.Text = "导出数据成功!路径:" + path; } } catch { MessageBox.Show("导出数据失败!", "Warnning!"); } }
public void ExportData() { try { var saveFileDialog = new Microsoft.Win32.SaveFileDialog() { Filter = "Excel(*.xlsx *.xls)|*.xlsx;*.xls" }; var result = saveFileDialog.ShowDialog(); if (result == true) { string path = saveFileDialog.FileName; ExcelUtility.DataTableToExcel(path, ExcelData.dataTable); this.textBlockWhetherExport.Text = "导出成功!"; } Timer(); } catch { MessageBox.Show("导出数据失败!", "Warnning!"); } }