Install-Package FreeSpire.XLS  

using Spire.Xls;
using System.Drawing;

namespace CSVtoPDF
{
    class Program
    {
        static void Main(string[] args)
        {
            // 初始化Workbook對象
            Workbook workbook = new Workbook();

            //加載CSV文件
            workbook.LoadFromFile("庫存.csv", ",", 1, 1);

            // 獲取第一個工作表
            Worksheet sheet = workbook.Worksheets[0];

            // 設(shè)置表格樣式
            sheet.AllocatedRange.Style.Color = Color.White;
            sheet.AllocatedRange.Style.Font.Color = Color.Black;
            sheet.AllocatedRange.Style.Font.Size = 11;
            sheet.AllocatedRange.AutoFitColumns();
            sheet.AllocatedRange.AutoFitRows();

            // 設(shè)置表頭樣式
            CellRange header = sheet.Range[1, 1, 1, sheet.Columns.Length];
            header.Style.Color = Color.LightGreen;
            header.Style.Font.IsBold = true;


            // 配置PDF導(dǎo)出選項
            workbook.ConverterSetting.SheetFitToPage = true;
            workbook.ConverterSetting.SheetFitToWidth = true;
            workbook.ConverterSetting.JPEGQuality = 100;

            // 將CSV文件保存為PDF文件
            sheet.SaveToPdf("CSVtoPDF.pdf");
        }
    }
}

using Spire.Xls;

namespace CSVtoDataTable
{
    class Program
    {
        static void Main(string[] args)
        {
            // 初始化Workbook對象
            Workbook workbook = new Workbook();

            // 加載CSV到工作簿
            workbook.LoadFromFile("庫存.csv", ",", 1, 1);

            // 獲取第一個工作表
            Worksheet sheet = workbook.Worksheets[0];

            // 將第一個工作表導(dǎo)入DataTable
            sheet.ExportDataTable();
        }
    }
}