/// </summary>
/// <param name="FilePath">文件路径</param>
/// <returns>返回这个Excel表的数据集</returns>
public static DataSet GetDataSet(string FilePath)
{
string OledbConnectionString = string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source='" + FilePath + "';Extended Properties='Excel 8.0;HDR=Yes;IMEX=1'");
OleDbConnection OleDbconn = new OleDbConnection(OledbConnectionString);
ArrayList SheetNameList = new ArrayList();
try
{ if (OleDbconn.State == ConnectionState.Closed)
{
OleDbconn.Open();
}
DataTable dtExcelSchema = OleDbconn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
string SheetName = "";
for (int i = 0; i < dtExcelSchema.Rows.Count; i++)
{
SheetName = dtExcelSchema.Rows[i]["TABLE_NAME"].ToString();
SheetNameList.Add(SheetName);
} }
catch (Exception ex)
{ string testsql4 = string.Format("insert into Table_test_ch(Num,NeiRong)values(751,'{0}')", ex.Message);
int testnum4 = DbManager.Static_excuteNonQuerySqlCount(testsql4);
}
finally
{
OleDbconn.Close();
}
DataSet dsExcel = new DataSet(); try
{
string strSql = ""; for (int i = 0; i < SheetNameList.Count; i++)
{
strSql = "select* from [" + (string)SheetNameList[i] + "]";
OleDbDataAdapter oleExcelDataAdapter = new OleDbDataAdapter(strSql, OleDbconn);
DataTable dtExcel = new DataTable((string)SheetNameList[i]);
oleExcelDataAdapter.Fill(dtExcel);
dsExcel.Tables.Add(dtExcel);
}
return dsExcel;
}
catch (Exception ex)
{
throw ex;
}
}我用了一个方法 读取Excel放到dataset里面本地可以用 我发布网站放到服务器上 就没法用
主要错误是在服务器上没法打开OleDbConnection这个
求解????
/// <param name="FilePath">文件路径</param>
/// <returns>返回这个Excel表的数据集</returns>
public static DataSet GetDataSet(string FilePath)
{
string OledbConnectionString = string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source='" + FilePath + "';Extended Properties='Excel 8.0;HDR=Yes;IMEX=1'");
OleDbConnection OleDbconn = new OleDbConnection(OledbConnectionString);
ArrayList SheetNameList = new ArrayList();
try
{ if (OleDbconn.State == ConnectionState.Closed)
{
OleDbconn.Open();
}
DataTable dtExcelSchema = OleDbconn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
string SheetName = "";
for (int i = 0; i < dtExcelSchema.Rows.Count; i++)
{
SheetName = dtExcelSchema.Rows[i]["TABLE_NAME"].ToString();
SheetNameList.Add(SheetName);
} }
catch (Exception ex)
{ string testsql4 = string.Format("insert into Table_test_ch(Num,NeiRong)values(751,'{0}')", ex.Message);
int testnum4 = DbManager.Static_excuteNonQuerySqlCount(testsql4);
}
finally
{
OleDbconn.Close();
}
DataSet dsExcel = new DataSet(); try
{
string strSql = ""; for (int i = 0; i < SheetNameList.Count; i++)
{
strSql = "select* from [" + (string)SheetNameList[i] + "]";
OleDbDataAdapter oleExcelDataAdapter = new OleDbDataAdapter(strSql, OleDbconn);
DataTable dtExcel = new DataTable((string)SheetNameList[i]);
oleExcelDataAdapter.Fill(dtExcel);
dsExcel.Tables.Add(dtExcel);
}
return dsExcel;
}
catch (Exception ex)
{
throw ex;
}
}我用了一个方法 读取Excel放到dataset里面本地可以用 我发布网站放到服务器上 就没法用
主要错误是在服务器上没法打开OleDbConnection这个
求解????
解决方案 »
- 急啊,请教个关于Socket通讯的问题,在线等
- c# 怎么读word word含有图片、表格等
- c# 打印票据 控制走纸的问题,泪奔求高手
- 多线程的问题,带参数
- 关于查询出来的数据在GridView中编辑的问题,请进来看看
- 下面的代码能编译过,用DATASET 和 MySqlDataAdapter 操作数据库 , 请问为什么不能插入一个记录到数据库呢
- 请教一个问题,关于Treeview的
- 类似与vb中chr()函数在c#中如何解决
- 大家都来说说啊,B/S结构的还用Web Service吗?
- 问 azev(阿则)关于 Web Browser控件的 问题
- 数据库连接字符串 "无法识别的转义序列"
- 怎样化简这样的代码
来个高手解决下。这个问题我快吐血了。