You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
36 lines
1.0 KiB
36 lines
1.0 KiB
using System;
|
|
using System.Collections.Generic;
|
|
using System.Text;
|
|
using System.Data;
|
|
using System.Data.OleDb;
|
|
|
|
namespace Stone.Common
|
|
{
|
|
public class MyExcelDatabase : MyOleDbDatabase
|
|
{
|
|
public static void OpenDatabase(string DbPath, bool IsHead)
|
|
{
|
|
string HDR = "";
|
|
if (IsHead)
|
|
{
|
|
HDR = "HDR=YES;";
|
|
}
|
|
else
|
|
{
|
|
HDR = "HDR=NO;";
|
|
}
|
|
|
|
if (DbPath.ToLower().Substring(DbPath.Length - 3) == "xls") //excel 2003格式
|
|
{
|
|
m_oleconn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + DbPath + ";Extended Properties='Excel 8.0;" + HDR + "'");
|
|
}
|
|
else //excel 2007 格式
|
|
{
|
|
m_oleconn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + DbPath + ";Extended Properties='Excel 12.0 Xml;" + HDR + "'");
|
|
}
|
|
m_oleconn.Open();
|
|
|
|
m_olecmd = m_oleconn.CreateCommand();
|
|
}
|
|
}
|
|
}
|
|
|