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 instance
Workbook workbook = new Workbook();
//Load a CSV file
workbook.LoadFromFile(@"C:\Users\Administrator\Desktop\Input.csv", ",");

//Get the first worksheet
Worksheet worksheet = workbook.Worksheets[0];

//Export data from the worksheet to a DataTable
DataTable 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;
}
}
}

【VB.NET】

Imports Spire.Xls
Imports System
Imports System.Data
Imports System.Windows.Forms

Namespace ConvertCsvToExcel
Public Partial Class Form1
Inherits Form
Public Sub New()
InitializeComponent()
End Sub

Private Sub button1_Click(ByVal sender As Object, ByVal e As EventArgs)
'Create a Workbook instance
Dim workbook As Workbook = New Workbook()
'Load a CSV file
workbook.LoadFromFile("Input.csv", ",")

'Get the first worksheet
Dim worksheet As Worksheet = workbook.Worksheets(0)

'Export data from the worksheet to a DataTable
Dim 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 = dt
End Sub
End Class
End Namespace

歡迎下載|體驗更多E-iceblue產品