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 指令或程序集引用?)这是怎么回事啊,该如何解决阿?
解决方案 »
- winForm中怎么获取服务器时间
- 在.Net里实现多条件查询,时间的按月份或者几号来查询,显示在一个GridView里
- Devpress gridControl 棘手问题,求大家相助,跪谢了!!!
- C#执行存储过程非常慢
- 怎么解决在WinForm下拉列表ComboBox显示System.Data.DataRowview的问题啊?
- 【脚本】WinForm做的Web服务器如何支持ASP之类的混合脚本解析
- SOS---我的MessageBox的YES要点两次,才消失。
- 用C#作个类似千千静听的播放器
- 注册了一个Com组件,怎样在注册表中删除它
- C#中怎么在两个应用程序之间传递数据(少量或大量)?
- 大家好,我是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);
}
} }
}