private async void BtnLoad_Click(object sender, EventArgs e) { LsvLoadData.Items.Clear(); Cursor.Current = Cursors.WaitCursor; using (var Opf = new OpenFileDialog() { Filter = "Excel Workbook|*.xlsx", ValidateNames = true }) { if (Opf.ShowDialog() == DialogResult.OK) { ReadAndWrite readAndWrite = new ReadAndWrite(Opf.FileName); var tuple = await readAndWrite.ReadAsync();//ReadWithInteropExcel(); foreach (var item in tuple.Item1) { ListViewItem listViewItem = new ListViewItem() { Text = item.Key.ToString() }; listViewItem.SubItems.Add(item.Value.ToString()); LsvLoadData.Items.Add(listViewItem); } /*int debug = 0; * //using (var stream=File.Open(Opf.FileName,FileMode.Open,FileAccess.Read)) * var op = new ExcelQueryFactory(Opf.FileName); * var data = from d in op.Worksheet<Info>("Info") * select d; * _Application _app = new Excel.Application(); * Workbook workbook = _app.Workbooks.Open(Opf.FileName); * Worksheet worksheet = _app.ActiveSheet as Worksheet; * //Worksheet worksheet = workbook.Sheets[1]; * Excel.Range xlRange = worksheet.UsedRange; * * int count = xlRange.Columns.Count; * * var a = worksheet.Cells[2, 2].Value2; * workbook.Close(); * _app.Quit();*/ } } Cursor.Current = Cursors.Default; }
private async void BtnSave_Click(object sender, EventArgs e) { Cursor.Current = Cursors.WaitCursor; using (var save = new SaveFileDialog() { Filter = "Excel Workbook|*.xlsx", ValidateNames = true }) { List <string> list = new List <string>() { "D" }; if (save.ShowDialog() == DialogResult.OK) { ReadAndWrite readAndWrite = new ReadAndWrite(save.FileName); await readAndWrite.SaveAsync(list); } } MessageBox.Show("Done!", "Save file", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1); Cursor.Current = Cursors.Default; }