110,539
社区成员
发帖
与我相关
我的任务
分享
读取excel中sheet(工作簿)名称
private void btnsheet_Click(object sender, EventArgs e)
{
try
{
if (dialog.ShowDialog() == DialogResult.OK)
{
textBox1.Text = dialog.FileName;
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + textBox1.Text + ";Extended Properties=Excel 8.0;";
OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();
System.Data.DataTable schemaTable = conn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
cbboxsheet.Items.Clear();
for (int i = 0; i < schemaTable.Rows.Count; i++)
{
cbboxsheet.Items.Add(schemaTable.Rows[i]["TABLE_NAME"].ToString());
}
conn.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "Sanertable", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
using System;
using System.Data;
using System.Data.OleDb;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
test();
}
public void test()
{
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\test.xls;Extended Properties=\"Excel 8.0\"";
System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection(strConn);
conn.Open();
DataTable dt = conn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, null);
conn.Close();
}
}