【.NET】【C#】NPOI Excel的使用

.NET下 NPOI Excel的使用

using NPOI.XSSF.UserModel;
using System.Diagnostics;

namespace ConsoleApp1
{
    internal class Program
    {
        static void Main(string[] args)
        {
            var wb = new XSSFWorkbook();
            var sheet = wb.CreateSheet("测试sheet1");
            var row0 = sheet.CreateRow(0);
            var row1 = sheet.CreateRow(1);
            row0.CreateCell(0).SetCellValue("测试标题1");
            row1.CreateCell(0).SetCellValue("测试内容1");
            row0.CreateCell(1).SetCellValue("测试标题2");
            row1.CreateCell(1).SetCellValue("测试内容2");
            sheet.SetColumnWidth(0, 50 * 256); // 50个英文字符
            using var fs = new FileStream(@"D:\files\测试.xlsx", FileMode.Create);
            wb.Write(fs);
            wb.Close();
            Process.Start("explorer.exe", @"D:\files\测试.xlsx");
        }
    }
}

效果如下图

using NPOI.XSSF.UserModel;

namespace ConsoleApp1
{
    internal class Program
    {
        static void Main(string[] args)
        {
            using var fs = new FileStream(@"D:\files\测试.xlsx", FileMode.Open);
            var wb = new XSSFWorkbook(fs);
            var sheet = wb.GetSheetAt(0);
            for (int i = 0; i < sheet.PhysicalNumberOfRows; i++)
            {
                var row = sheet.GetRow(i);
                for (int j = 0; j < row.Cells.Count; j++)
                {
                    Console.Write(row.Cells[j].StringCellValue + "\t");
                }
                Console.WriteLine();
            }
            wb.Close();
        }
    }
}