如何使用 C# 讀取包含逗號資料的 CSV 文件

Install-Package IronXL
dotnet add package IronXL

using IronXL;

// Load CSV with automatic comma handling
WorkBook workbook = WorkBook.LoadCSV("data.csv",
    fileFormat: ExcelFileFormat.XLSX,
    listDelimiter: ",");

// Access the parsed data
WorkSheet worksheet = workbook.DefaultWorkSheet;

// Save as Excel if needed
workbook.SaveAs("output.xlsx");

Imports IronXL

' Load CSV with automatic comma handling
Dim workbook As WorkBook = WorkBook.LoadCSV("data.csv", fileFormat:=ExcelFileFormat.XLSX, listDelimiter:=",")

' Access the parsed data
Dim worksheet As WorkSheet = workbook.DefaultWorkSheet

' Save as Excel if needed
workbook.SaveAs("output.xlsx")

using IronXL;
using System;
using System.IO;

// Create sample CSV content with embedded commas
string csvContent = @"Name,Address,Description,Price
""Johnson, Mark"",""123 Main St, Apt 4B"",""High-quality, durable product"",""1,234.56""
""Smith Ltd."",""789 Corporate Blvd, Suite 200"",""Professional, reliable service"",""2,999.00""
""Williams & Co."",""456 Park Ave, Floor 12"",""Lightweight, portable design"",""899.99""";

// Write sample data to a CSV file
File.WriteAllText("sample.csv", csvContent);

// Load CSV with IronXL -- commas inside quoted fields are handled automatically
WorkBook workbook = WorkBook.LoadCSV("sample.csv",
    fileFormat: ExcelFileFormat.XLSX,
    listDelimiter: ",");

WorkSheet ws = workbook.DefaultWorkSheet;

// Read and display each parsed row
foreach (var row in ws.Rows)
{
    if (row.RowNumber == 0) continue; // Skip header row

    string name        = row.Columns[0].StringValue;
    string address     = row.Columns[1].StringValue;
    string description = row.Columns[2].StringValue;
    decimal price      = row.Columns[3].DecimalValue;

    Console.WriteLine($"Customer:    {name}");
    Console.WriteLine($"Address:     {address}");
    Console.WriteLine($"Description: {description}");
    Console.WriteLine($"Price:       ${price:N2}");
    Console.WriteLine();
}

// Export to Excel format for distribution
workbook.SaveAs("parsed_data.xlsx");
Console.WriteLine("Data exported to parsed_data.xlsx");

Imports IronXL
Imports System
Imports System.IO

' Create sample CSV content with embedded commas
Dim csvContent As String = "Name,Address,Description,Price" & vbCrLf &
    """Johnson, Mark"",""123 Main St, Apt 4B"",""High-quality, durable product"",""1,234.56""" & vbCrLf &
    """Smith Ltd."",""789 Corporate Blvd, Suite 200"",""Professional, reliable service"",""2,999.00""" & vbCrLf &
    """Williams & Co."",""456 Park Ave, Floor 12"",""Lightweight, portable design"",""899.99"""

' Write sample data to a CSV file
File.WriteAllText("sample.csv", csvContent)

' Load CSV with IronXL -- commas inside quoted fields are handled automatically
Dim workbook As WorkBook = WorkBook.LoadCSV("sample.csv",
    fileFormat:=ExcelFileFormat.XLSX,
    listDelimiter:=",")

Dim ws As WorkSheet = workbook.DefaultWorkSheet

' Read and display each parsed row
For Each row In ws.Rows
    If row.RowNumber = 0 Then Continue For ' Skip header row

    Dim name As String = row.Columns(0).StringValue
    Dim address As String = row.Columns(1).StringValue
    Dim description As String = row.Columns(2).StringValue
    Dim price As Decimal = row.Columns(3).DecimalValue

    Console.WriteLine($"Customer:    {name}")
    Console.WriteLine($"Address:     {address}")
    Console.WriteLine($"Description: {description}")
    Console.WriteLine($"Price:       ${price:N2}")
    Console.WriteLine()
Next

' Export to Excel format for distribution
workbook.SaveAs("parsed_data.xlsx")
Console.WriteLine("Data exported to parsed_data.xlsx")

using IronXL;
using System;
using System.Text;

// Custom delimiter support -- semicolon-delimited files common in European locales
WorkBook semicolonData = WorkBook.LoadCSV("data.txt",
    fileFormat: ExcelFileFormat.XLSX,
    listDelimiter: ";");

// Handle UTF-8 encoding for international CSV files
WorkBook internationalData = WorkBook.LoadCSV("international.csv",
    fileFormat: ExcelFileFormat.XLSX,
    listDelimiter: ",",
    encoding: Encoding.UTF8);

// Tab-delimited files (TSV format)
WorkBook tsvData = WorkBook.LoadCSV("export.tsv",
    fileFormat: ExcelFileFormat.XLSX,
    listDelimiter: "\t");

// Production-ready error handling for CSV with commas in data
try
{
    WorkBook data = WorkBook.LoadCSV("file.csv",
        fileFormat: ExcelFileFormat.XLSX,
        listDelimiter: ",");

    WorkSheet sheet = data.DefaultWorkSheet;

    Console.WriteLine($"Loaded {sheet.Rows.Count()} rows successfully.");
}
catch (Exception ex)
{
    Console.WriteLine($"CSV parsing error: {ex.Message}");
    // Log and implement appropriate recovery logic
}

Imports IronXL
Imports System
Imports System.Text

' Custom delimiter support -- semicolon-delimited files common in European locales
Dim semicolonData As WorkBook = WorkBook.LoadCSV("data.txt",
    fileFormat:=ExcelFileFormat.XLSX,
    listDelimiter:=";")

' Handle UTF-8 encoding for international CSV files
Dim internationalData As WorkBook = WorkBook.LoadCSV("international.csv",
    fileFormat:=ExcelFileFormat.XLSX,
    listDelimiter:=",",
    encoding:=Encoding.UTF8)

' Tab-delimited files (TSV format)
Dim tsvData As WorkBook = WorkBook.LoadCSV("export.tsv",
    fileFormat:=ExcelFileFormat.XLSX,
    listDelimiter:=vbTab)

' Production-ready error handling for CSV with commas in data
Try
    Dim data As WorkBook = WorkBook.LoadCSV("file.csv",
        fileFormat:=ExcelFileFormat.XLSX,
        listDelimiter:=",")

    Dim sheet As WorkSheet = data.DefaultWorkSheet

    Console.WriteLine($"Loaded {sheet.Rows.Count()} rows successfully.")
Catch ex As Exception
    Console.WriteLine($"CSV parsing error: {ex.Message}")
    ' Log and implement appropriate recovery logic
End Try