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());
}
