public void TestOpenXmlRead() { var fname = TestData.GetFileName("TestOpenXmlCrate.xlsx"); var dt = ExcelOpenXml.GetSheet(fname, "tab1"); Assert.IsTrue(File.Exists(fname)); }
private void BtnOpenXmlImport_Click(object sender, EventArgs e) { OpenFileDialog openFileDialog = new OpenFileDialog(); openFileDialog.Title = "导入信息表"; openFileDialog.Filter = "Excel文档(*.xlsx)|*.xlsx"; if (openFileDialog.ShowDialog() == DialogResult.OK) { //var dataTable = ExcelOpenXml.GetSheet(openFileDialog.FileName); var dataTable = ExcelOpenXml.GetSheet(openFileDialog.FileName); gridView.DataSource = dataTable; } }