protected void Page_Load(object sender, EventArgs e) { Workbook workBook = new Workbook(); Sheet sheet = workBook.OpenSheet("Sheet1"); Aceoffix.ExcelReader.Table table = sheet.OpenTable("B4:D8"); while (!table.EOF) { if (!table.DataFields.IsEmpty) { content += "<br/>Month:" + table.DataFields[0].Text; content += "<br/>Plan:" + table.DataFields[1].Text; content += "<br/>Reality:" + table.DataFields[2].Text; content += "<br/>*********************************************"; } table.NextRow(); } table.Close(); workBook.ShowPage(500, 400); workBook.Close(); }
protected void Page_Load(object sender, EventArgs e) { Workbook workBook = new Workbook(); Sheet sheet = workBook.OpenSheet("Sheet1"); Aceoffix.ExcelReader.Table table = sheet.OpenTableByDefinedName("report"); int result = 0; while (!table.EOF) { if (!table.DataFields.IsEmpty) { content += "<br/>Month:" + table.DataFields[0].Text; content += "<br/>Plan:" + table.DataFields[1].Text; content += "<br/>Reality:" + table.DataFields[2].Text; content += "<br/>Accumulative:" + 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/>Order Fill Rate:0%"; } else { float f = int.Parse(table.DataFields[2].Text); f = f / int.Parse(table.DataFields[1].Text); content += "<br/>Order Fill Rate:" + string.Format("{0:P}", f); } content += "<br/>*********************************************"; } table.NextRow(); } table.Close(); workBook.ShowPage(500, 400); workBook.Close(); }