在 C# 中讀取 CSV 檔案
IronXL提供一行程式碼解決方案,使用LoadCSV方法在C#中讀取CSV檔案。 它支持自定義分隔符,並可直接轉換為Excel格式,以便在.NET應用程式中順利進行資料處理。
此範例展示如何通過IronXL的LoadCSV方法讀取CSV檔案,並以最少的程式碼將其儲存為Excel工作簿。
-
1使用 IronXL 安裝 NuGet Package Manager
-
2複製並運行這段程式碼。
WorkBook wb = WorkBook.LoadCSV("data.csv", ExcelFileFormat.XLSX, listDelimiter: ","); wb.SaveAs("output.xlsx");Dim wb As WorkBook = WorkBook.LoadCSV("data.csv", ExcelFileFormat.XLSX, listDelimiter:=",") wb.SaveAs("output.xlsx")Dim wb As WorkBook = WorkBook.LoadCSV("data.csv", ExcelFileFormat.XLSX, listDelimiter:=",") wb.SaveAs("output.xlsx") -
3部署到您的生產環境進行測試
立即在您的項目中開始使用 IronXL,並使用 免費試用
最小工作流程(5 個步驟)
- 下載並安裝C# CSV讀取程式庫
- 建立一個 C# 或 VB 項目
- 將此頁面的代碼示例添加到您的項目中
- 指定 CSV 路徑和輸出名稱與格式
- 執行專案以檢視文件
在 .NET 應用程式中讀取 CSV 文件
- 安裝用於讀取 CSV 檔案的 C# 庫 (IronXL)
- 在 C# 中讀取 CSV 文件
- 指定文件格式和分隔符
步驟 1
如何安裝IronXL程式庫?
在 MVC、ASP 或 .NET Core 中使用 IronXL 讀取 CSV 檔案之前,您需要先安裝 IronXL。 以下是快速攻略。
為什麼我應該使用NuGet包管理器?
- 在Visual Studio中,選擇專案選單
- 管理 NuGet 套件
- 搜尋
IronXL.Excel - 安裝
有哪些替代安裝方法?
或從Iron Software網站下載:https://ironsoftware.com/csharp/excel/packages/IronXL.zip
對於使用Docker容器的.NET開發者,IronXL可以在您的Docker環境中進行配置。 該程式庫還支持在Azure Functions和AWS Lambda上部署,以進行基於雲的CSV處理。
操作指南
如何以程式方式讀取CSV檔案?
現在開始專案!
我需要導入哪個命名空間?
新增IronXL命名空間:
// This namespace is required to access the IronXL functionalities
using IronXL;// This namespace is required to access the IronXL functionalities
using IronXL;Imports IronXLImports IronXL如何加載和轉換CSV檔案?
使用 IronXL 和 C# 程式化地加入讀取 CSV 檔案的程式碼:
// Load the CSV file into a WorkBook object, specifying the file path, format, and delimiter
WorkBook workbook = WorkBook.LoadCSV("Read_CSV_Ex.csv", fileFormat: ExcelFileFormat.XLSX, listDelimiter: ",");
// Access the default worksheet within the loaded workbook
WorkSheet ws = workbook.DefaultWorkSheet;
// Save the workbook as an Excel file with a specified name
workbook.SaveAs("Csv_To_Excel.xlsx");// Load the CSV file into a WorkBook object, specifying the file path, format, and delimiter
WorkBook workbook = WorkBook.LoadCSV("Read_CSV_Ex.csv", fileFormat: ExcelFileFormat.XLSX, listDelimiter: ",");
// Access the default worksheet within the loaded workbook
WorkSheet ws = workbook.DefaultWorkSheet;
// Save the workbook as an Excel file with a specified name
workbook.SaveAs("Csv_To_Excel.xlsx");' Load the CSV file into a WorkBook object, specifying the file path, format, and delimiter
Dim workbook As WorkBook = WorkBook.LoadCSV("Read_CSV_Ex.csv", fileFormat:=ExcelFileFormat.XLSX, listDelimiter:=",")
' Access the default worksheet within the loaded workbook
Dim ws As WorkSheet = workbook.DefaultWorkSheet
' Save the workbook as an Excel file with a specified name
workbook.SaveAs("Csv_To_Excel.xlsx")' Load the CSV file into a WorkBook object, specifying the file path, format, and delimiter
Dim workbook As WorkBook = WorkBook.LoadCSV("Read_CSV_Ex.csv", fileFormat:=ExcelFileFormat.XLSX, listDelimiter:=",")
' Access the default worksheet within the loaded workbook
Dim ws As WorkSheet = workbook.DefaultWorkSheet
' Save the workbook as an Excel file with a specified name
workbook.SaveAs("Csv_To_Excel.xlsx")有哪些進階的CSV讀取選項?
IronXL 提供處理各種配置的 CSV 檔案的功能。 您可以指定不同的分隔符(分號、制表符、管道),並處理不同編碼的檔案:
// Example: Reading CSV with custom delimiter
WorkBook workbook = WorkBook.LoadCSV("data.csv",
fileFormat: ExcelFileFormat.XLSX,
listDelimiter: ";"); // Using semicolon as delimiter
// Access specific cells after loading
var cellValue = workbook.DefaultWorkSheet["A1"].Value;
// Iterate through rows
foreach (var row in workbook.DefaultWorkSheet.Rows)
{
// Process each row
foreach (var cell in row)
{
Console.WriteLine(cell.Value);
}
}// Example: Reading CSV with custom delimiter
WorkBook workbook = WorkBook.LoadCSV("data.csv",
fileFormat: ExcelFileFormat.XLSX,
listDelimiter: ";"); // Using semicolon as delimiter
// Access specific cells after loading
var cellValue = workbook.DefaultWorkSheet["A1"].Value;
// Iterate through rows
foreach (var row in workbook.DefaultWorkSheet.Rows)
{
// Process each row
foreach (var cell in row)
{
Console.WriteLine(cell.Value);
}
}' Example: Reading CSV with custom delimiter
Dim workbook As WorkBook = WorkBook.LoadCSV("data.csv", fileFormat:=ExcelFileFormat.XLSX, listDelimiter:=";") ' Using semicolon as delimiter
' Access specific cells after loading
Dim cellValue = workbook.DefaultWorkSheet("A1").Value
' Iterate through rows
For Each row In workbook.DefaultWorkSheet.Rows
' Process each row
For Each cell In row
Console.WriteLine(cell.Value)
Next
Next' Example: Reading CSV with custom delimiter
Dim workbook As WorkBook = WorkBook.LoadCSV("data.csv", fileFormat:=ExcelFileFormat.XLSX, listDelimiter:=";") ' Using semicolon as delimiter
' Access specific cells after loading
Dim cellValue = workbook.DefaultWorkSheet("A1").Value
' Iterate through rows
For Each row In workbook.DefaultWorkSheet.Rows
' Process each row
For Each cell In row
Console.WriteLine(cell.Value)
Next
Next在處理之前,CSV檔案的樣子是什麼?
LoadCSV方法如何運作?
建立一個Workbook物件。 LoadCSV 方法在 Workbook 物件中指定要讀取的CSV檔案、讀取的格式以及分隔符。 在本例中,使用逗號作為分隔符。
創建一個Worksheet物件,CSV內容將放置於此。 然後,檔案會以新的名稱和格式儲存。 當您需要在不同的試算表格式之間轉換時,此過程會非常有用。
我能否高效處理大型CSV檔案?
IronXL 已針對效能進行最佳化,並能有效率地處理大型 CSV 檔案。 對於處理大規模資料集的開發者,該程式庫在最近的版本中提供了顯著的性能提升。 處理大型檔案時,請考慮這些最佳實務:
// Reading large CSV files with memory optimization
WorkBook workbook = WorkBook.LoadCSV("large_dataset.csv",
fileFormat: ExcelFileFormat.XLSX,
listDelimiter: ",");
// Process data in chunks
var worksheet = workbook.DefaultWorkSheet;
int rowCount = worksheet.RowCount;
int batchSize = 1000;
for (int i = 0; i < rowCount; i += batchSize)
{
// Process rows in batches
var endIndex = Math.Min(i + batchSize, rowCount);
for (int j = i; j < endIndex; j++)
{
var row = worksheet.GetRow(j);
// Process individual row
}
}// Reading large CSV files with memory optimization
WorkBook workbook = WorkBook.LoadCSV("large_dataset.csv",
fileFormat: ExcelFileFormat.XLSX,
listDelimiter: ",");
// Process data in chunks
var worksheet = workbook.DefaultWorkSheet;
int rowCount = worksheet.RowCount;
int batchSize = 1000;
for (int i = 0; i < rowCount; i += batchSize)
{
// Process rows in batches
var endIndex = Math.Min(i + batchSize, rowCount);
for (int j = i; j < endIndex; j++)
{
var row = worksheet.GetRow(j);
// Process individual row
}
}Imports System
Imports IronXL
' Reading large CSV files with memory optimization
Dim workbook As WorkBook = WorkBook.LoadCSV("large_dataset.csv",
fileFormat:=ExcelFileFormat.XLSX,
listDelimiter:=",")
' Process data in chunks
Dim worksheet = workbook.DefaultWorkSheet
Dim rowCount As Integer = worksheet.RowCount
Dim batchSize As Integer = 1000
For i As Integer = 0 To rowCount - 1 Step batchSize
' Process rows in batches
Dim endIndex As Integer = Math.Min(i + batchSize, rowCount)
For j As Integer = i To endIndex - 1
Dim row = worksheet.GetRow(j)
' Process individual row
Next
NextImports System
Imports IronXL
' Reading large CSV files with memory optimization
Dim workbook As WorkBook = WorkBook.LoadCSV("large_dataset.csv",
fileFormat:=ExcelFileFormat.XLSX,
listDelimiter:=",")
' Process data in chunks
Dim worksheet = workbook.DefaultWorkSheet
Dim rowCount As Integer = worksheet.RowCount
Dim batchSize As Integer = 1000
For i As Integer = 0 To rowCount - 1 Step batchSize
' Process rows in batches
Dim endIndex As Integer = Math.Min(i + batchSize, rowCount)
For j As Integer = i To endIndex - 1
Dim row = worksheet.GetRow(j)
' Process individual row
Next
Next如何導出CSV數據到其他格式?
閱讀 CSV 檔案後,您可能需要將資料匯出為各種格式。 IronXL支持多種導出選項,包括XLSX到CSV轉換、JSON、XML和HTML。 以下是如何匯出成不同格式:
// Load CSV and export to multiple formats
WorkBook workbook = WorkBook.LoadCSV("input.csv", ExcelFileFormat.XLSX, ",");
// Export to different formats
workbook.SaveAs("output.xlsx"); // Excel format
workbook.SaveAsJson("output.json"); // JSON format
workbook.SaveAsXml("output.xml"); // XML format
// Export specific worksheet to CSV with custom delimiter
workbook.DefaultWorkSheet.SaveAsCsv("output_custom.csv", ";");// Load CSV and export to multiple formats
WorkBook workbook = WorkBook.LoadCSV("input.csv", ExcelFileFormat.XLSX, ",");
// Export to different formats
workbook.SaveAs("output.xlsx"); // Excel format
workbook.SaveAsJson("output.json"); // JSON format
workbook.SaveAsXml("output.xml"); // XML format
// Export specific worksheet to CSV with custom delimiter
workbook.DefaultWorkSheet.SaveAsCsv("output_custom.csv", ";");' Load CSV and export to multiple formats
Dim workbook As WorkBook = WorkBook.LoadCSV("input.csv", ExcelFileFormat.XLSX, ",")
' Export to different formats
workbook.SaveAs("output.xlsx") ' Excel format
workbook.SaveAsJson("output.json") ' JSON format
workbook.SaveAsXml("output.xml") ' XML format
' Export specific worksheet to CSV with custom delimiter
workbook.DefaultWorkSheet.SaveAsCsv("output_custom.csv", ";")' Load CSV and export to multiple formats
Dim workbook As WorkBook = WorkBook.LoadCSV("input.csv", ExcelFileFormat.XLSX, ",")
' Export to different formats
workbook.SaveAs("output.xlsx") ' Excel format
workbook.SaveAsJson("output.json") ' JSON format
workbook.SaveAsXml("output.xml") ' XML format
' Export specific worksheet to CSV with custom delimiter
workbook.DefaultWorkSheet.SaveAsCsv("output_custom.csv", ";")在Web應用中如何處理CSV數據?
對於ASP.NET開發者,IronXL提供了簡單的整合,以在網頁應用程式中讀取CSV檔案。 您可以在 MVC 或 Web API 專案中上傳和處理 CSV 檔案:
// Example: Processing uploaded CSV file in ASP.NET
public ActionResult UploadCSV(HttpPostedFileBase file)
{
if (file != null && file.ContentLength > 0)
{
// Save uploaded file temporarily
var fileName = Path.GetFileName(file.FileName);
var path = Path.Combine(Server.MapPath("~/App_Data/"), fileName);
file.SaveAs(path);
// Load and process CSV
WorkBook workbook = WorkBook.LoadCSV(path, ExcelFileFormat.XLSX, ",");
// Convert to DataTable for easy display
var dataTable = workbook.DefaultWorkSheet.ToDataTable();
// Clean up temporary file
System.IO.File.Delete(path);
return View(dataTable);
}
return RedirectToAction("Index");
}// Example: Processing uploaded CSV file in ASP.NET
public ActionResult UploadCSV(HttpPostedFileBase file)
{
if (file != null && file.ContentLength > 0)
{
// Save uploaded file temporarily
var fileName = Path.GetFileName(file.FileName);
var path = Path.Combine(Server.MapPath("~/App_Data/"), fileName);
file.SaveAs(path);
// Load and process CSV
WorkBook workbook = WorkBook.LoadCSV(path, ExcelFileFormat.XLSX, ",");
// Convert to DataTable for easy display
var dataTable = workbook.DefaultWorkSheet.ToDataTable();
// Clean up temporary file
System.IO.File.Delete(path);
return View(dataTable);
}
return RedirectToAction("Index");
}' Example: Processing uploaded CSV file in ASP.NET
Public Function UploadCSV(file As HttpPostedFileBase) As ActionResult
If file IsNot Nothing AndAlso file.ContentLength > 0 Then
' Save uploaded file temporarily
Dim fileName = Path.GetFileName(file.FileName)
Dim path = Path.Combine(Server.MapPath("~/App_Data/"), fileName)
file.SaveAs(path)
' Load and process CSV
Dim workbook As WorkBook = WorkBook.LoadCSV(path, ExcelFileFormat.XLSX, ",")
' Convert to DataTable for easy display
Dim dataTable = workbook.DefaultWorkSheet.ToDataTable()
' Clean up temporary file
System.IO.File.Delete(path)
Return View(dataTable)
End If
Return RedirectToAction("Index")
End Function' Example: Processing uploaded CSV file in ASP.NET
Public Function UploadCSV(file As HttpPostedFileBase) As ActionResult
If file IsNot Nothing AndAlso file.ContentLength > 0 Then
' Save uploaded file temporarily
Dim fileName = Path.GetFileName(file.FileName)
Dim path = Path.Combine(Server.MapPath("~/App_Data/"), fileName)
file.SaveAs(path)
' Load and process CSV
Dim workbook As WorkBook = WorkBook.LoadCSV(path, ExcelFileFormat.XLSX, ",")
' Convert to DataTable for easy display
Dim dataTable = workbook.DefaultWorkSheet.ToDataTable()
' Clean up temporary file
System.IO.File.Delete(path)
Return View(dataTable)
End If
Return RedirectToAction("Index")
End Function如何處理具有複雜數據的CSV檔案?
處理包含公式、特殊字符或混合數據類型的CSV檔案時,IronXL提供可靠的處理能力。 您可以處理公式並適當格式化單元格數據:
// Handle CSV with special requirements
WorkBook workbook = WorkBook.LoadCSV("complex_data.csv",
ExcelFileFormat.XLSX,
listDelimiter: ",");
var worksheet = workbook.DefaultWorkSheet;
// Apply formatting to cells
worksheet["A1:A10"].Style.Font.Bold = true;
worksheet["B1:B10"].FormatString = "$#,##0.00"; // Currency format
// Add formulas after loading CSV data
worksheet["D1"].Formula = "=SUM(B1:B10)";// Handle CSV with special requirements
WorkBook workbook = WorkBook.LoadCSV("complex_data.csv",
ExcelFileFormat.XLSX,
listDelimiter: ",");
var worksheet = workbook.DefaultWorkSheet;
// Apply formatting to cells
worksheet["A1:A10"].Style.Font.Bold = true;
worksheet["B1:B10"].FormatString = "$#,##0.00"; // Currency format
// Add formulas after loading CSV data
worksheet["D1"].Formula = "=SUM(B1:B10)";Imports IronXL
' Handle CSV with special requirements
Dim workbook As WorkBook = WorkBook.LoadCSV("complex_data.csv", ExcelFileFormat.XLSX, listDelimiter:=",")
Dim worksheet = workbook.DefaultWorkSheet
' Apply formatting to cells
worksheet("A1:A10").Style.Font.Bold = True
worksheet("B1:B10").FormatString = "$#,##0.00" ' Currency format
' Add formulas after loading CSV data
worksheet("D1").Formula = "=SUM(B1:B10)"Imports IronXL
' Handle CSV with special requirements
Dim workbook As WorkBook = WorkBook.LoadCSV("complex_data.csv", ExcelFileFormat.XLSX, listDelimiter:=",")
Dim worksheet = workbook.DefaultWorkSheet
' Apply formatting to cells
worksheet("A1:A10").Style.Font.Bold = True
worksheet("B1:B10").FormatString = "$#,##0.00" ' Currency format
' Add formulas after loading CSV data
worksheet("D1").Formula = "=SUM(B1:B10)"圖書館快速訪問
常見問題
IronXL提供什麼一行程式解決方案來讀取C#中的CSV檔案?
IronXL提供了LoadCSV方法,讓您能使用簡單指令在C#中讀取CSV檔案。
如何使用IronXL將CSV檔案轉換為Excel?
您可以透過LoadCSV方法載入CSV檔案,然後使用SaveAs方法將其儲存為Excel檔案。
當使用IronXL讀取CSV檔案時,我可以使用自定義分隔符嗎?
可以,IronXL支援自定義分隔符,允許您在LoadCSV方法中指定不同字符,如分號、標籤或管道。
IronXL是否能有效地處理大型CSV檔案?
IronXL針對效能進行最佳化,能有效地處理大型CSV檔案,適合處理龐大的資料集。
有哪些不同的檔案格式可以使用IronXL匯出CSV資料?
使用IronXL,您可以將CSV資料匯出至多種格式,包括Excel (XLSX)、JSON、XML和HTML。
如何在ASP.NET MVC網頁應用中使用IronXL讀取CSV檔案?
在ASP.NET MVC網頁應用中,您可以使用IronXL的LoadCSV方法處理上傳的CSV檔案,並轉換成DataTable顯示。
IronXL是否提供處理複雜CSV資料的高級選項?
是的,IronXL提供高級功能,如使用公式、處理特殊字符,以及在處理複雜CSV檔案時設定儲存格資料格式。
我能透過Visual Studio中的NuGet安裝IronXL嗎?
可以,您可以使用Visual Studio中的NuGet套件管理器安裝IronXL,搜索IronXL.Excel並將其添加到您的專案中。
在我的C#專案中使用IronXL功能需要導入什麼命名空間?
要訪問IronXL功能,您需要將IronXL命名空間導入到您的C#專案中。
哪些類型的專案可以從IronXL的CSV檔案處理中獲益?
IronXL對.NET應用程式,包括MVC、ASP和.NET Core專案很有幫助,這些專案需要流暢的CSV讀取和轉換。
Curtis Chau 擁有卡爾頓大學計算機科學學士學位,專注於前端開發,擅長於 Node.js、TypeScript、JavaScript 和 React。Curtis 熱衷於創建直觀且美觀的用戶界面,喜歡使用現代框架並打造結構良好、視覺吸引人的手冊。


