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()); }
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"); sheet.OpenCellByDefinedName("testA1").Value = "Tom"; sheet.OpenCellByDefinedName("testB1").Value = "John"; // 注意不要忘记此代码,如果缺少此句代码,不会赋值成功。 pageofficeCtrl.SetWriter(workBook); pageofficeCtrl.Caption = "给Excel文档中定义名称的单元格赋值"; pageofficeCtrl.AddCustomToolButton("保存", "Save()", 1); //设置保存页面 pageofficeCtrl.SaveDataPage = "SaveData"; //打开Word文档 pageofficeCtrl.WebOpen("doc/test.xls", PageOfficeNetCore.OpenModeType.xlsSubmitForm, "tom"); ViewBag.POCtrl = pageofficeCtrl.GetHtmlCode("PageOfficeCtrl1"); return(View()); }