演示效果

實現方案

1.首先導入需要的Dll(這部分可能需要你自己搜一下)

Epplus.dll

Excel.dll

ICSharpCode.SharpZipLib.dll

2.在你的解決方案的的依賴項->添加引用->瀏覽->選擇1中的這幾個Dll點擊確定。(添加依賴)

3.然后看代碼內容

附上源碼

using Excel;
using System.Data;
using System.IO;
using System.Windows;namespace WpfApp1
{/// <summary>/// Interaction logic for MainWindow.xaml/// </summary>public partial class MainWindow : Window{public MainWindow(){InitializeComponent();}private void Button_Click(object sender, RoutedEventArgs e){System.Text.Encoding.RegisterProvider(System.Text.CodePagesEncodingProvider.Instance);FileStream excelListStream = File.Open(AppDomain.CurrentDomain.BaseDirectory + "Data.xlsx", FileMode.Open, FileAccess.Read, FileShare.Read);var excelListStreamRead = ExcelReaderFactory.CreateOpenXmlReader(excelListStream);DataSet excelListResult = excelListStreamRead.AsDataSet();string Data = "";for (int i = 1; i < excelListResult.Tables[0].Rows.Count; i++){string _info;_info = excelListResult.Tables[0].Rows[0][0].ToString() + ":" + excelListResult.Tables[0].Rows[i][0].ToString() +excelListResult.Tables[0].Rows[0][1].ToString() + ":" + excelListResult.Tables[0].Rows[i][1].ToString() +excelListResult.Tables[0].Rows[0][2].ToString() + ":" + excelListResult.Tables[0].Rows[i][2].ToString() +excelListResult.Tables[0].Rows[0][3].ToString() + ":" + excelListResult.Tables[0].Rows[i][3].ToString()+"\n";Data += _info;}content.Text = Data;//content是我文本框的名字}}
}

4.趕緊去試試吧，用Excel管理起來你的WPF項目