Install-Package FreeSpire.XLS

using Spire.Xls;
class Program
{
    static void Main(string[] args)
    {
        // 創(chuàng)建 Workbook 實(shí)例
        Workbook workbook = new Workbook();

        // 加載 CSV 文件
        // 參數(shù)說(shuō)明：文件名，分隔符，起始行，起始列
        workbook.LoadFromFile("student.csv", ",", 1, 1);

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

        // 獲取使用的行數(shù)和列數(shù)
        int rowCount = sheet.LastRow;
        int colCount = sheet.LastColumn;

        Console.WriteLine($"文件包含 {rowCount} 行，{colCount} 列數(shù)據(jù)");
        Console.WriteLine("==============================");

        // 遍歷所有數(shù)據(jù)并輸出
        for (int row = 1; row <= rowCount; row++)
        {
            for (int col = 1; col <= colCount; col++)
            {
                Console.Write(sheet.Range[row, col].Value + "\t");
            }
            Console.WriteLine();
        }
    }
}

using System.Data;
using Spire.Xls;

namespace CsvReadDemo
{
    class Program
    {
        static void Main(string[] args)
        {
            // 1. 創(chuàng)建Workbook實(shí)例（Free Spire.XLS將CSV視為特殊的Excel工作簿）
            Workbook workbook = new Workbook();

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

            // 3. 獲取第一個(gè)工作表（CSV文件對(duì)應(yīng)一個(gè)工作表）
            Worksheet worksheet = workbook.Worksheets[0];

            // 4. 將工作表數(shù)據(jù)導(dǎo)出到DataTable
            DataTable dataTable = worksheet.ExportDataTable();

            // 5. 遍歷輸出數(shù)據(jù)（驗(yàn)證讀取結(jié)果）
            Console.WriteLine("CSV文件內(nèi)容：");
            // 輸出列名
            foreach (DataColumn column in dataTable.Columns)
            {
                Console.Write(column.ColumnName + "\t");
            }
            Console.WriteLine();

            // 輸出行數(shù)據(jù)
            foreach (DataRow row in dataTable.Rows)
            {
                foreach (var cellValue in row.ItemArray)
                {
                    Console.Write(cellValue.ToString() + "\t");
                }
                Console.WriteLine();
            }

            // 釋放資源
            workbook.Dispose();
        }
    }
}

using Spire.Xls;

namespace CsvReadDemo
{
    class Program
    {
        static void Main(string[] args)
        {
            Workbook workbook = new Workbook();
            workbook.LoadFromFile("student.csv", ",", 1, 1);
            Worksheet worksheet = workbook.Worksheets[0];

            // 1. 讀取指定單元格（第3行第2列，注意：行/列索引從1開(kāi)始）
            string cellValue = worksheet.Range[3, 2].Text;
            Console.WriteLine("第3行第2列的值：" + cellValue);

            // 2. 讀取指定行（第4行所有數(shù)據(jù)）
            Console.WriteLine("\n第4行所有數(shù)據(jù)：");
            for (int col = 1; col <= worksheet.LastColumn; col++)
            {
                Console.Write(worksheet.Range[4, col].Text + "\t");
            }

            // 3. 讀取指定列（第1列所有數(shù)據(jù)）
            Console.WriteLine("\n\n第1列所有數(shù)據(jù)：");
            for (int row = 1; row <= worksheet.LastRow; row++)
            {
                Console.WriteLine(worksheet.Range[row, 1].Text);
            }

            workbook.Dispose();
        }
    }
}