关于C# 读取excel的问题

来源:百度知道 编辑:UC知道 时间:2024/06/21 18:48:38
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;

namespace _11
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

private void Form1_Load(object sender, EventArgs e)
{
DataTable myT = ExcelToDataTable("D:\\1.xlsx", "sheet1 ");
String mystr = myT.Rows[0][0].ToString();
this.textBox1.Text = mystr;

}
public static DataTable ExcelToDataTable(string strExcelFileName, string strSheetName)
{
//源的定义
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0; " + "Data Source= " + strExcelFileName + &qu

连接串改下,再试下:
string strConn = @"Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + strExcelFileName + ";" + "User ID=admin;Password=;Jet OLEDB:Database Password=1;Jet OLEDB:System database=c:\\system.mdw";

DataTable myT = ExcelToDataTable("D:\\1.xlsx", "sheet1 ");
是不是这一句的文件名写错了。D:\\1.xls

DataTable myT = ExcelToDataTable("D:\\1.xlsx", "sheet1 ");
是不是这一句的文件名写错了。D:\\1.xls

路径有嘛?还有就是加个try 就看到是什么异常了

加个try 就看到是什么异常了