csharp 提取excel示例代码
时间: 2023-09-05 07:13:29 浏览: 54
以下是 C# 提取 Excel 示例代码:
```csharp
using System;
using System.Data;
using System.Data.OleDb;
class Program
{
static void Main(string[] args)
{
// 连接字符串
var connString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=path/to/excel.xlsx;Extended Properties='Excel 12.0 Xml;HDR=YES;'";
// SQL 查询语句
var selectSql = "SELECT * FROM [Sheet1$]";
// 使用 OleDbDataAdapter 读取 Excel 数据
using (var conn = new OleDbConnection(connString))
using (var adapter = new OleDbDataAdapter(selectSql, conn))
{
conn.Open();
var dataset = new DataSet();
adapter.Fill(dataset);
// 输出结果
foreach (DataTable table in dataset.Tables)
{
foreach (DataRow row in table.Rows)
{
foreach (DataColumn col in table.Columns)
{
Console.Write(row[col] + "\t");
}
Console.WriteLine();
}
}
}
}
}
```