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;
}
}
