C# 使用 IronXL 讀取 CSV 資料中的逗號

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;
class CsvParser
{
    static void Main()
    {
        // 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""";
        // Save sample to file
        System.IO.File.WriteAllText("sample.csv", csvContent);
        // Load CSV with IronXL
        WorkBook workbook = WorkBook.LoadCSV("sample.csv",
            fileFormat: ExcelFileFormat.XLSX,
            listDelimiter: ",");
        WorkSheet ws = workbook.DefaultWorkSheet;
        // Read and display parsed data
        foreach (var row in ws.Rows)
        {
            if (row.RowNumber == 0) continue; // Skip header
            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($"Product: {description}");
            Console.WriteLine($"Price: ${price:N2}\n");
        }
        // Export to Excel format
        workbook.SaveAs("parsed_data.xlsx");
    }
}

Imports IronXL
Imports System

Class CsvParser
    Shared Sub Main()
        ' 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"""
        ' Save sample to file
        System.IO.File.WriteAllText("sample.csv", csvContent)
        ' Load CSV with IronXL
        Dim workbook As WorkBook = WorkBook.LoadCSV("sample.csv",
                                                    fileFormat:=ExcelFileFormat.XLSX,
                                                    listDelimiter:=",")
        Dim ws As WorkSheet = workbook.DefaultWorkSheet
        ' Read and display parsed data
        For Each row In ws.Rows
            If row.RowNumber = 0 Then Continue For ' Skip header
            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($"Product: {description}")
            Console.WriteLine($"Price: ${price:N2}" & vbCrLf)
        Next
        ' Export to Excel format
        workbook.SaveAs("parsed_data.xlsx")
    End Sub
End Class

// Custom delimiter support for CSV parsing in C#
WorkBook workbook = WorkBook.LoadCSV("data.txt",
    fileFormat: ExcelFileFormat.XLSX,
    listDelimiter: ";");  // Semicolon-delimited
// Handle different encodings when reading CSV files
var csvWithEncoding = WorkBook.LoadCSV("international.csv",
    fileFormat: ExcelFileFormat.XLSX,
    listDelimiter: ",",
    encoding: System.Text.Encoding.UTF8);
// Error handling for CSV with comma in data
try
{
    var data = WorkBook.LoadCSV("file.csv");
    // Process data
}
catch (Exception ex)
{
    Console.WriteLine($"CSV parsing error: {ex.Message}");
    // Implement appropriate error recovery
}

Imports System
Imports System.Text

' Custom delimiter support for CSV parsing in VB.NET
Dim workbook As WorkBook = WorkBook.LoadCSV("data.txt", fileFormat:=ExcelFileFormat.XLSX, listDelimiter:=";") ' Semicolon-delimited

' Handle different encodings when reading CSV files
Dim csvWithEncoding = WorkBook.LoadCSV("international.csv", fileFormat:=ExcelFileFormat.XLSX, listDelimiter:=",", encoding:=Encoding.UTF8)

' Error handling for CSV with comma in data
Try
    Dim data = WorkBook.LoadCSV("file.csv")
    ' Process data
Catch ex As Exception
    Console.WriteLine($"CSV parsing error: {ex.Message}")
    ' Implement appropriate error recovery
End Try