private void btnTest_Click(object sender, RoutedEventArgs e)
{
try
{
Microsoft.Win32.OpenFileDialog ofd = new Microsoft.Win32.OpenFileDialog();
if (ofd.ShowDialog().Value == false)
{
return;
}
var read = XlsxFileReader.Open(ofd.FileName);
var data = read.ReadAllRows().ToList();
DataTable dt = new DataTable();
dt.Columns.AddRange(data[0].Select(obj => new DataColumn {
ColumnName = obj
}).ToArray());
dt.Columns[0].ColumnName = "行号";
for (int i = 1; i < data.Count; i++)
{
dt.Rows.Add(data[i]);
}
this.dgvData.ItemsSource = dt.AsDataView();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public static Workbook LoadFromStream(Stream fs)
{
using (var fr = new XlsxFileReader(fs))
{
return(fr.Read());
}
}
