加载Excel表格信息

引入EPPlus 类库 using OfficeOpenXml; //加载信息 private static void LoadInformation() { using (ExcelPackage package = new ExcelPackage(new FileInfo("charactor_config.xlsx"))) { ExcelWorksheet sheet = package.Workbook.Worksheets["charactor"]; int rowStart = sheet.Dimension.Start.Row; int rowEnd = sheet.Dimension.End.Row; for (int i = rowStart + 1; i <= rowEnd; i++) { Card card = new Card(); card.Id = sheet.GetValue(i, 1).ToString(); card.Property = sheet.GetValue(i, 2).ToString(); card.Name = sheet.GetValue(i, 3).ToString(); card.Attack = sheet.GetValue(i, 4).ToString(); CardList.Add(card); } foreach (var item in CardList) { Console.WriteLine(item); } } }