C# 将 CSV 转化为 Excel

using System;using System.IO;using OfficeOpenXml;
class Program{    static void Main()    {        // 1. 读取CSV文件        string csvFilePath = "path/to/your/csv/file.csv";        string[] csvLines = File.ReadAllLines(csvFilePath);
        // 2. 创建Excel工作簿        ExcelPackage.LicenseContext = LicenseContext.NonCommercial;        using (ExcelPackage package = new ExcelPackage())        {            // 创建一个新的工作表            ExcelWorksheet worksheet = package.Workbook.Worksheets.Add("Sheet1");
            // 3. 写入数据            for (int i = 0; i < csvLines.Length; i++)            {                string[] values = csvLines[i].Split(',');                for (int j = 0; j < values.Length; j++)                {                    worksheet.Cells[i + 1, j + 1].Value = values[j];                }            }
            // 4. 保存Excel文件            string excelFilePath = "path/to/your/excel/file.xlsx";            FileInfo excelFile = new FileInfo(excelFilePath);            package.SaveAs(excelFile);        }
        Console.WriteLine("CSV文件已成功转化为Excel文件。");    }}