//实例化excelApp对象
excelApp = new Excel.Application();
//打开目标文件strFilePath
excelWk = (Excel.Workbook)excelApp.Workbooks.Open(strFilePath, missing, missing, missing, missing, missing,
missing, missing, missing, missing, missing, missing, missing, missing, missing);
excelApp = new Excel.Application();
//打开目标文件strFilePath
excelWk = (Excel.Workbook)excelApp.Workbooks.Open(strFilePath, missing, missing, missing, missing, missing,
missing, missing, missing, missing, missing, missing, missing, missing, missing);
OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();
string strExcel = "";
OleDbDataAdapter myCommand = null;
this.dsTransVouchData1.Clear();
strExcel="select [调出仓库编号] as cOWhCode,[调出仓库名称] as cOWhName,[入库类别编码] as cIRdCode,[出库类别编码] as cORdCode, "+"[调入仓库编号] as cIWhCode,[调入仓库名称] as cIWhName,[规格型号] as cInvStd, "+
"[存货编号] as cInvCode,[存货名称] as cInvName, [数量] as iTVQuantity,[批号] as cTVBatch "+
" from [Sheet1$] "+
" where [数量]<>0 ";
myCommand = new OleDbDataAdapter(strExcel, strConn);
myCommand.Fill(dsTransVouchData1,"ExcelData");
conn.Close();
OleDbConnection 来操作Excel原则上大多数情况都是行不通的..服务端不能装Excel也很正常,装了个Excel服务器的注册表都得太很多.脱离Excel IDE操作Excel文件还是有点难度的,
建议楼主将Excel转换为Excel Xml格式再进行操作就会比较好处理了....