protected void btnImport_Click(object sender, EventArgs e) { if (Request.Files.Count > 0) { HttpPostedFile postedFile = Request.Files[0]; if (postedFile.FileName.Trim() != "") { string filePath = Server.MapPath("/Content/DataImport/") + postedFile.FileName.Trim(); postedFile.SaveAs(filePath); string destinationString = "Data Source=.;Initial Catalog=JXT;uid=sa;pwd=123456"; Utility.DataTransferTookits.ExcelItem sourceItem = new Utility.DataTransferTookits.ExcelItem(filePath); Utility.DataTransferTookits.ExcelItem outputItem = new Utility.DataTransferTookits.ExcelItem(@"C:\导入错误信息提示.xls"); JXT.Core.Business.User.ImportDataFromExcel(sourceItem, destinationString, JXT.Core.Business.User.JXT_USER_TABLE_COLUME_MAPPING, outputItem); File.Delete(filePath); } else { Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "", "<script>alert('请选择导入的EXCEL文件')</script>"); } } else { Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "", "<script>alert('请选择导入的EXCEL文件')</script>"); } }
public void TestMethod1() { Utility.DataTransferTookits.ExcelItem sourceItem = new Utility.DataTransferTookits.ExcelItem(@"D:\家校通\统计表.xls"); Utility.DataTransferTookits.ExcelItem outputItem = new Utility.DataTransferTookits.ExcelItem(@"D:\家校通\2.xls"); string connection = "Data Source=.;Initial Catalog=JXT;uid=sa;pwd=123456"; JXT.Core.Business.User.ImportDataFromExcel(sourceItem, connection, JXT.Core.Business.User.JXT_USER_TABLE_COLUME_MAPPING, outputItem); }