public IActionResult Excel() { PageOfficeNetCore.PageOfficeCtrl pageofficeCtrl = new PageOfficeNetCore.PageOfficeCtrl(Request); pageofficeCtrl.ServerPage = "/PageOffice/POServer"; //定义Workbook对象 PageOfficeNetCore.ExcelWriter.Workbook workBook = new PageOfficeNetCore.ExcelWriter.Workbook(); //定义Sheet对象,"Sheet1"是打开的Excel表单的名称 PageOfficeNetCore.ExcelWriter.Sheet sheet = workBook.OpenSheet("Sheet1"); //定义Table对象 PageOfficeNetCore.ExcelWriter.Table table = sheet.OpenTable("B4:F13"); for (int i = 0; i < 50; i++) { table.DataFields[0].Value = "产品 " + i.ToString(); table.DataFields[1].Value = "100"; table.DataFields[2].Value = (100 + i).ToString(); table.NextRow(); } table.Close(); pageofficeCtrl.SetWriter(workBook);// 注意不要忘记此代码,如果缺少此句代码,不会赋值成功。 pageofficeCtrl.Caption = "使用OpenTable给Excel赋值"; //打开Word文档 pageofficeCtrl.WebOpen("doc/test.xls", PageOfficeNetCore.OpenModeType.xlsNormalEdit, "tom"); ViewBag.POCtrl = pageofficeCtrl.GetHtmlCode("PageOfficeCtrl1"); return(View()); }
public IActionResult ExcelFill() { PageOfficeNetCore.PageOfficeCtrl pageofficeCtrl = new PageOfficeNetCore.PageOfficeCtrl(Request); pageofficeCtrl.ServerPage = "/PageOffice/POServer"; PageOfficeNetCore.ExcelWriter.Workbook wk = new PageOfficeNetCore.ExcelWriter.Workbook(); PageOfficeNetCore.ExcelWriter.Sheet sheet = wk.OpenSheet("Sheet1"); PageOfficeNetCore.ExcelWriter.Table table = sheet.OpenTableByDefinedName("report", 10, 5, false); table.DataFields[0].Value = "轮胎"; table.DataFields[1].Value = "100"; table.DataFields[2].Value = "120"; table.DataFields[3].Value = "500"; table.DataFields[4].Value = "120%"; table.NextRow(); table.Close(); pageofficeCtrl.SetWriter(wk);// 注意不要忘记此代码,如果缺少此句代码,不会赋值成功。 pageofficeCtrl.Caption = "给Excel文档中定义名称的单元格赋值"; pageofficeCtrl.SaveDataPage = "SaveData"; pageofficeCtrl.AddCustomToolButton("保存", "Save()", 1); //打开Word文档 pageofficeCtrl.WebOpen("doc/test.xls", PageOfficeNetCore.OpenModeType.xlsSubmitForm, "tom"); ViewBag.POCtrl = pageofficeCtrl.GetHtmlCode("PageOfficeCtrl1"); return(View()); }
public IActionResult ExcelFill4() { PageOfficeNetCore.PageOfficeCtrl pageofficeCtrl = new PageOfficeNetCore.PageOfficeCtrl(Request); pageofficeCtrl.ServerPage = "/PageOffice/POServer"; PageOfficeNetCore.ExcelWriter.Workbook wk = new PageOfficeNetCore.ExcelWriter.Workbook(); PageOfficeNetCore.ExcelWriter.Sheet sheet = wk.OpenSheet("Sheet1"); PageOfficeNetCore.ExcelWriter.Table table = sheet.OpenTable("B4:F11"); int rowCount = 12;//假设将要自动填充数据的实际记录条数为12 for (int i = 1; i <= rowCount; i++) { table.DataFields[0].Value = i + "月"; table.DataFields[1].Value = "100"; table.DataFields[2].Value = "120"; table.DataFields[3].Value = "500"; table.DataFields[4].Value = "120%"; table.NextRow(); } table.Close(); //定义另一个table PageOfficeNetCore.ExcelWriter.Table table2 = sheet.OpenTable("B13:F16"); int rowCount2 = 4;//假设将要自动填充数据的实际记录条数为12 for (int i = 1; i <= rowCount2; i++) { table2.DataFields[0].Value = i + "季度"; table2.DataFields[1].Value = "300"; table2.DataFields[2].Value = "300"; table2.DataFields[3].Value = "300"; table2.DataFields[4].Value = "100%"; table2.NextRow(); } table2.Close(); pageofficeCtrl.SetWriter(wk);// 注意不要忘记此代码,如果缺少此句代码,不会赋值成功。 //隐藏菜单栏 pageofficeCtrl.Menubar = false; pageofficeCtrl.Caption = "给Excel文档中定义名称的单元格赋值"; pageofficeCtrl.SaveDataPage = "SaveData"; //打开Word文档 pageofficeCtrl.WebOpen("doc/test4.xls", PageOfficeNetCore.OpenModeType.xlsSubmitForm, "tom"); ViewBag.POCtrl = pageofficeCtrl.GetHtmlCode("PageOfficeCtrl1"); return(View()); }
public IActionResult ExcelFill2() { string tempFileName = Request.Query["temp"]; PageOfficeNetCore.PageOfficeCtrl pageofficeCtrl = new PageOfficeNetCore.PageOfficeCtrl(Request); pageofficeCtrl.ServerPage = "/PageOffice/POServer"; PageOfficeNetCore.ExcelWriter.Workbook wk = new PageOfficeNetCore.ExcelWriter.Workbook(); PageOfficeNetCore.ExcelWriter.Sheet sheet = wk.OpenSheet("Sheet1"); PageOfficeNetCore.ExcelWriter.Table table = sheet.OpenTableByDefinedName("report", 10, 5, false); table.DataFields[0].Value = "轮胎"; table.DataFields[1].Value = "100"; table.DataFields[2].Value = "120"; table.DataFields[3].Value = "500"; table.DataFields[4].Value = "120%"; table.NextRow(); table.Close(); // 注意不要忘记此代码,如果缺少此句代码,不会赋值成功。 //定义单元格对象,参数“year”就是Excel模板中定义的单元格的名称 PageOfficeNetCore.ExcelWriter.Cell cellYear = sheet.OpenCellByDefinedName("year"); // 给单元格赋值 cellYear.Value = "2015年"; PageOfficeNetCore.ExcelWriter.Cell cellName = sheet.OpenCellByDefinedName("name"); cellName.Value = "张三"; pageofficeCtrl.SetWriter(wk); //隐藏菜单栏 pageofficeCtrl.Menubar = false; pageofficeCtrl.Caption = "给Excel文档中定义名称的单元格赋值"; pageofficeCtrl.SaveDataPage = "SaveData"; pageofficeCtrl.AddCustomToolButton("保存", "Save()", 1); //打开Word文档 pageofficeCtrl.WebOpen("doc/" + tempFileName, PageOfficeNetCore.OpenModeType.xlsSubmitForm, "tom"); ViewBag.POCtrl = pageofficeCtrl.GetHtmlCode("PageOfficeCtrl1"); return(View()); }