Excel.ApplicationClass excelApp = new Microsoft.Office.Interop.Excel.ApplicationClass();
Excel.Workbooks wbs = excelApp.Workbooks;
Excel.Workbook wb = wbs.Open( Server.MapPath("D:\IPconv.xls"),Type.Missing,Type.Missing,Type.Missing,Type.Missing,
Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,
Type.Missing,Type.Missing,Type.Missing,Type.Missing);for ( int i = 1; i <= wb.Worksheets.Count; i++ )
{
Response.Write(((Excel.Worksheet)wb.Worksheets[i]).Name);
}--------------------------------------------------
错误提示:D:\TraData\ImpData\Form1.cs(507): 找不到类型或命名空间名称“Excel”(是否缺少 using 指令或程序集引用?)这是怎么回事啊,该如何解决阿?
Excel.Workbooks wbs = excelApp.Workbooks;
Excel.Workbook wb = wbs.Open( Server.MapPath("D:\IPconv.xls"),Type.Missing,Type.Missing,Type.Missing,Type.Missing,
Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,
Type.Missing,Type.Missing,Type.Missing,Type.Missing);for ( int i = 1; i <= wb.Worksheets.Count; i++ )
{
Response.Write(((Excel.Worksheet)wb.Worksheets[i]).Name);
}--------------------------------------------------
错误提示:D:\TraData\ImpData\Form1.cs(507): 找不到类型或命名空间名称“Excel”(是否缺少 using 指令或程序集引用?)这是怎么回事啊,该如何解决阿?
解决方案 »
- treeview动态添加节点
- DataGridView里的行,可以编辑,怎么让他不能修改怎么看?
- cs中如何把改变Label中指定位置的文本的颜色其它的不变
- C# 的C/S客户端报 }应用程序试图执行安全策略不允许的操作..."
- 数据库 查询问题 重复数据
- 高难度问题请高手帮忙:将word文档中每一行读出并写入数据库中,有什么办法能实现(c#)?
- 关于 Windows Form 用户控件自定义属性的问题,求助,谢谢!
- 为啥不通过哦
- 怎么用c#编宽带拨号软件?????????
- 求大神们帮忙:An 'System.ArithmeticException' occurred in WindowsBase.dll
- 大家好,我是c#新手,请给点意见,谢谢大家,顺便散分。
- 哪种学习方法更好,请各位指点
程序里添加using Excel;
DataSet ds=new DataSet();
string strConn= "Provider=Microsoft.Jet.OleDb.4.0;" + "data source="+fName+ ";Extended Properties=Excel 8.0;";
objConn=new OleDbConnection(strConn);
objConn.Open();
DataTable schemaTable = objConn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables,null);
string tableName=schemaTable.Rows[0][2].ToString().Trim();
string strSql= "Select * From ["+tableName+"]";
OleDbCommand objCmd=new OleDbCommand(strSql, objConn);
OleDbDataAdapter sqlada=new OleDbDataAdapter();
sqlada.SelectCommand=objCmd;
sqlada.Fill(ds,"BG");DataTable dt=ds.Tables["BG"];
-------------------
怎么回事?
using System.Data;
using System.Data.OleDb;namespace Common
{
/// <summary>
/// OleDbTransfer 的摘要说明。
/// </summary>
public class OleDbTransfer
{
public OleDbTransfer(){} public static OleDbDataReader ExecuteReader(string connString, CommandType cmdType, string cmdText, params OleDbParameter[] cmdParms)
{
OleDbCommand cmd = new OleDbCommand();
OleDbConnection conn = new OleDbConnection(connString); try
{
PrepareCommand(cmd, conn, null, cmdType, cmdText, cmdParms);
OleDbDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
cmd.Parameters.Clear();
return rdr;
}
catch
{
conn.Close();
throw;
}
} public static int ExecuteNonQuery(string connString, CommandType cmdType, string cmdText, params OleDbParameter[] cmdParms)
{
OleDbCommand cmd = new OleDbCommand();
using (OleDbConnection conn = new OleDbConnection(connString))
{
PrepareCommand(cmd, conn, null, cmdType, cmdText, cmdParms);
int val = cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
return val;
}
} public static object ExecuteScalar(string connString, CommandType cmdType, string cmdText, params OleDbParameter[] cmdParms)
{
OleDbCommand cmd = new OleDbCommand(); using (OleDbConnection conn = new OleDbConnection(connString))
{
PrepareCommand(cmd, conn, null, cmdType, cmdText, cmdParms);
object val = cmd.ExecuteScalar();
cmd.Parameters.Clear();
return val;
}
}
private static void PrepareCommand(OleDbCommand cmd, OleDbConnection conn, OleDbTransaction trans, CommandType cmdType,
string cmdText, OleDbParameter[] cmdParms)
{ if (conn.State != ConnectionState.Open)
conn.Open(); cmd.Connection = conn;
cmd.CommandText = cmdText; if (trans != null)
cmd.Transaction = trans; cmd.CommandType = cmdType; if (cmdParms != null)
{
foreach (OleDbParameter parm in cmdParms)
cmd.Parameters.Add(parm);
}
} }
}