DataTable 表示内存中的关系数据表。它可以从 Microsoft SQL Server 之类的数据源或 CSV 或 Excel 之类的文件中填充。在本文中,您将学习如何从 CSV 填充 DataTable,或者换句话说,如何在 C# 和 中使用Spire.XLS for .NET将 CSV 转换为 DataTable 。
Spire.XLS for .NET下载
第 1 步:为 .NET 安装 Spire.XLS
首先,您需要添加 Spire.XLS for .NET 包中包含的 DLL 文件作为 .NET 项目中的引用。DLL 文件可以从此链接下载或通过NuGet安装。
PM> Install-Package Spire.XLS
第 2 步:在 C# 和 中将 CSV 转换为 DataTable
以下是将 CSV 转换为 DataTable 的主要步骤:
初始化Workbook类的实例。使用Workbook.LoadFromFile()方法加载 CSV 文件,并将文件路径和 CSV 文件的分隔符/分隔符以字符串的形式作为参数传递。通过Workbook.Worksheets[sheetIndex]属性按索引(从零开始)获取所需的工作表。使用Worksheet.ExportDataTable()方法将数据从工作表导出到 DataTable 。
(ExportDataTable() 方法有几个重载可用于控制数据的导出方式,例如 ExportDataTable(CellRange range, bool exportColumnNames, bool computedFormulaValue):此重载允许您指定要导出的范围以及是否导出公式的列名和计算值。
【C#】
using Spire.Xls;using System;using System.Data;using System.Windows.Forms;namespace ConvertCsvToExcel{public partial class Form1 : Form{public Form1(){InitializeComponent();}private void button1_Click(object sender, EventArgs e){//Create a Workbook instanceWorkbook workbook = new Workbook();//Load a CSV fileworkbook.LoadFromFile(@"C:\Users\Administrator\Desktop\Input.csv", ",");//Get the first worksheetWorksheet worksheet = workbook.Worksheets[0];//Export data from the worksheet to a DataTableDataTable dt = worksheet.ExportDataTable();//This overload enables you to specify the range to be exported along with whether to export column names and calculated values of formulas//DataTable dt = worksheet.ExportDataTable(worksheet.Range["A1:C10"], true, true);//Show the DataTable in a DataGridView control (optional)dataGridView1.DataSource = dt;}}}
【】
Imports Spire.XlsImports SystemImports System.DataImports System.Windows.FormsNamespace ConvertCsvToExcelPublic Partial Class Form1Inherits FormPublic Sub New()InitializeComponent()End SubPrivate Sub button1_Click(ByVal sender As Object, ByVal e As EventArgs)'Create a Workbook instanceDim workbook As Workbook = New Workbook()'Load a CSV fileworkbook.LoadFromFile("Input.csv", ",")'Get the first worksheetDim worksheet As Worksheet = workbook.Worksheets(0)'Export data from the worksheet to a DataTableDim dt As DataTable = worksheet.ExportDataTable()'This overload enables you to specify the range to be exported along with whether to export column names and calculated values of formulas'DataTable dt = worksheet.ExportDataTable(worksheet.Range["A1:C10"], true, true);'Show the DataTable in a DataGridView control (optional)dataGridView1.DataSource = dtEnd SubEnd ClassEnd Namespace
欢迎下载|体验更多E-iceblue产品或加入Q群(767755948)