加载Excel表格信息

最新推荐文章于 2023-11-03 12:01:11 发布

愚公丨Acmen

最新推荐文章于 2023-11-03 12:01:11 发布

阅读量269

点赞数

CC 4.0 BY-SA版权

分类专栏： C# 文章标签： cs 编程

本文链接：https://blog.youkuaiyun.com/sinat_36373961/article/details/60967117

C# 专栏收录该内容

25 篇文章

订阅专栏

引入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);
                }
            }
        }