C# 读取 Excel xlsx 文件

编写 read_excel.cs 如下

using System;using System.Collections.Generic;using System.ComponentModel;using System.IO;using System.Data;using System.Linq;using System.Text;using System.Data.OleDb;namespace ReadExcel{public partial class Program{static void Main(string[] args){if (args.Length <1){Console.WriteLine(" usage: read_excel your_file.xlsx ");return ;}if (! File.Exists(args[0])){Console.WriteLine("Error: {0} not exists.", args[0]);return ;}if (Path.GetExtension(args[0]) != ".xlsx"){Console.WriteLine("Tip: can only read file.xlsx");}string filePath = args[0]; // your_excel_file_path string connStr = string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=\"Excel 12.0 Xml;HDR=YES;IMEX=1\"", filePath); using (OleDbConnection conn = new OleDbConnection(connStr)){conn.Open(); string sheet1 = "Sheet1"; string query = string.Format("SELECT * FROM [{0}$]", sheet1); using (OleDbDataAdapter adapter = new OleDbDataAdapter(query, conn)){DataTable dataTable = new DataTable();adapter.Fill(dataTable);int rows, cols;// 处理获取到的数据foreach (DataRow row in dataTable.Rows){rows = row.Table.Rows.IndexOf(row) +1;foreach (DataColumn column in dataTable.Columns){string value = row[column].ToString() ?? string.Empty; cols = column.Ordinal +1;Console.WriteLine("Cell({0:d},{1:d}): {2}", rows,cols,value);}}}} Console.ReadKey();}}}

SET PATH=C:\WINDOWS\Microsoft.NET\Framework\v4.0.30319;%PATH%

编译：csc.exe /t:exe read_excel.cs

环境：win10 64位系统 运行 \your\path\read_excel.exe test1.xlsx

错误信息：未在本地计算机上注册“Microsoft.ACE.OLEDB.12.0”提供程序。

搜索 Microsoft Access Database Engine 2016

我先下载了accessdatabaseengine.exe安装好后，还是运行出错。

卸载了32位版本，又下载了AccessDatabaseEngine_X64.exe 安装好后，能运行了。