protected void Page_Load(object sender, EventArgs e) { PageOffice.ExcelReader.Workbook workBook = new PageOffice.ExcelReader.Workbook(); PageOffice.ExcelReader.Sheet sheet = workBook.OpenSheet("Sheet1"); PageOffice.ExcelReader.Table table = sheet.OpenTable("B4:D8"); while (!table.EOF) { //获取提交的数值 //DataFields.Count标识的是table的列数 if (!table.DataFields.IsEmpty) { content += "<br/>月份名称:" + table.DataFields[0].Text; content += "<br/>计划完成量:" + table.DataFields[1].Text; content += "<br/>实际完成量:" + table.DataFields[2].Text; content += "<br/>*********************************************"; } //循环进入下一行 table.NextRow(); } table.Close(); workBook.ShowPage(500, 400); workBook.Close(); }
protected void Page_Load(object sender, EventArgs e) { PageOffice.ExcelReader.Workbook workBook = new PageOffice.ExcelReader.Workbook(); PageOffice.ExcelReader.Sheet sheet = workBook.OpenSheet("Sheet1"); content += "testA1:" + sheet.OpenCellByDefinedName("testA1").Value + "<br/>"; content += "testB1:" + sheet.OpenCellByDefinedName("testB1").Value + "<br/>"; workBook.ShowPage(500, 400); workBook.Close(); }
protected void Page_Load(object sender, EventArgs e) { PageOffice.ExcelReader.Workbook workBook = new PageOffice.ExcelReader.Workbook(); PageOffice.ExcelReader.Sheet sheet = workBook.OpenSheet("Sheet1"); PageOffice.ExcelReader.Table table = sheet.OpenTable("Info"); int result = 0; while (!table.EOF) { //获取提交的数值 //DataFields.Count标识的是提交过来的table的列数 if (!table.DataFields.IsEmpty) { content += "<br/>月份名称:" + table.DataFields[0].Text; content += "<br/>计划完成量:" + table.DataFields[1].Text; content += "<br/>实际完成量:" + table.DataFields[2].Text; content += "<br/>累计完成量:" + table.DataFields[3].Text; if (string.IsNullOrEmpty(table.DataFields[2].Text) || !int.TryParse(table.DataFields[2].Text, out result) || !int.TryParse(table.DataFields[1].Text, out result)) { content += "<br/>完成率:0"; } else { float f = int.Parse(table.DataFields[2].Text); f = f / int.Parse(table.DataFields[1].Text); content += "<br/>完成率:" + string.Format("{0:P}", f); } content += "<br/>*********************************************"; } //循环进入下一行 table.NextRow(); } table.Close(); workBook.ShowPage(500, 400); workBook.Close(); }
protected void Page_Load(object sender, EventArgs e) { if (Session["UserName"] == null || Session["UserName"].ToString().Length <= 0) { Response.Redirect("Login.aspx"); } string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|demo_excelorder.mdb"; OleDbConnection conn = new OleDbConnection(connectionString); conn.Open(); OleDbCommand cmd = new OleDbCommand(); cmd.Connection = conn; cmd.CommandType = CommandType.Text; PageOffice.ExcelReader.Workbook workBook = new PageOffice.ExcelReader.Workbook();; PageOffice.ExcelReader.Sheet sheet = workBook.OpenSheet("销售订单"); string sql = ""; if (Request.QueryString["ID"] != null && Request.QueryString["ID"].Length > 0) { #region 修改保存 string id = ""; id = Request.QueryString["ID"]; int num; //保存客户信息 num = UpdateOrInsertCustInfo(cmd, id, workBook, sheet, 0); if (num > 0) //保存成功 { int resDelete = 0; //要删除的记录条数 //删除当前orderID下的产品数据 sql = "delete from OrderDetail where OrderId = " + id; try { cmd.CommandText = sql; cmd.ExecuteNonQuery(); } catch (Exception ex) { strErrHtml += "删除客户ID为" + id + "的产品订单信息失败,失败原因为:" + ex.Message + "\n"; resDelete = -1; } //删除成功或无数据可删除时 if (resDelete >= 0) { //插入产品信息 InsertProductInfo(cmd, workBook, sheet, id); } } else { strErrHtml += "<br>客户信息保存失败!"; } #endregion } else { #region 新建保存 int maxId = 0;//OrderMaster表中最大ID号 sql = "select max(ID) from OrderMaster "; cmd.CommandText = sql; try { object obj = cmd.ExecuteScalar(); if (obj != null) { maxId = int.Parse(obj.ToString()); //保存客户信息 if (UpdateOrInsertCustInfo(cmd, "", workBook, sheet, maxId) > 0) { //插入产品信息 InsertProductInfo(cmd, workBook, sheet, (maxId + 1).ToString()); } } } catch (Exception ex) { strErrHtml += "新建订单失败,失败原因为:" + ex.Message; } #endregion } //保存失败,弹出提示框 if (strErrHtml.Length > 0) { strErrHtml = "\n" + strErrHtml; workBook.ShowPage(410, 260); workBook.CustomSaveResult = "error"; } workBook.Close(); conn.Close(); string mScriptName = "updateorder.aspx"; string mHttpUrl = "http://" + Request.ServerVariables["HTTP_HOST"] + Request.ServerVariables["SCRIPT_NAME"]; BaseUrl = mHttpUrl.Substring(0, mHttpUrl.Length - mScriptName.Length); }