private void btnViewData_Click(object sender, EventArgs e) { try { if (txtFilePath.Text != "") { DataTable dt = OpenFileExcel.getDataExcelFromFileToDataTable(txtFilePath.Text); dt.Rows.RemoveAt(0); UC_ViewData uc = new UC_ViewData(dt); frmShowWindow frm = new frmShowWindow(); frm.Controls.Clear(); uc.Dock = DockStyle.Fill; frm.Text = "Hiển thị dữ liệu"; frm.Controls.Add(uc); frm.ShowDialog(); } else { XtraMessageBox.Show("Bạn chưa chọn file để hiển thị"); } } catch (Exception ex) { XtraMessageBox.Show("" + ex.Message, "Lỗi"); } }
private void btnOpenFile_Click(object sender, EventArgs e) { try { OpenFileDialog op = new OpenFileDialog(); op.Filter = "Excel .xlsx|*.xlsx|Excel .xls|*.xls"; if (DialogResult.OK == op.ShowDialog()) { btnStart.Enabled = false; btnStart2.Enabled = false; txtFilePath.Text = op.FileName.Trim(); Thread t = new Thread(new ThreadStart(() => { try { lsData = OpenFileExcel.getDataExcelFromFileToList(op.FileName.Trim()); lsData.RemoveAt(0); lsAllData = loadDataToList(lsData); btnStart.Invoke((MethodInvoker) delegate { btnStart.Enabled = true; }); btnStart2.Invoke((MethodInvoker) delegate { btnStart2.Enabled = true; }); } catch (Exception ex) { XtraMessageBox.Show("" + ex.Message, "Thông báo lỗi"); } })); t.Start(); } } catch (Exception ex) { XtraMessageBox.Show("" + ex.Message, "Lỗi"); } }
private void cbbSheet_SelectedIndexChanged(object sender, EventArgs e) { _dataTempView = new DataTable(); string selectSheet = cbbSheet.Text; _dataTempView = OpenFileExcel.getDataExcelFromFileToDataTable(txtPathFile1.Text, selectSheet); gridControl1.DataSource = _dataTempView; }
private void btnGetForm_Click(object sender, EventArgs e) { FolderBrowserDialog f = new FolderBrowserDialog(); f.Description = "Chọn thư mục lưu trữ form dữ liệu"; string filePath = ""; if (f.ShowDialog() == DialogResult.OK) { filePath = OpenFileExcel.moveFile(f.SelectedPath); if (DialogResult.OK == XtraMessageBox.Show("Mở file \"" + Path.GetFileName(filePath) + "\" ?", "", MessageBoxButtons.OKCancel)) { System.Diagnostics.Process.Start(filePath); } } }
private void btnChooseFile1_Click(object sender, EventArgs e) { try { Dictionary <string, object> data = OpenFileExcel.getInfoFiles(); if (data != null) { txtPathFile1.Text = data["fileName"].ToString(); data.Remove("fileName"); foreach (var item in data) { cbbSheet.Properties.Items.Add(item.Value.ToString().Trim(new char['\'']).Replace("\'", "")); } cbbSheet.SelectedIndex = 0; } } catch (Exception ex) { XtraMessageBox.Show("Lỗi: " + ex.Message); } }