protected void Page_Load(object sender, EventArgs e)
{
Workbook wb = new Workbook();
Sheet sheet = wb.OpenSheet("Sheet1");
// 设置背景
PageOffice.ExcelWriter.Table backGroundTable = sheet.OpenTable("A1:P200");
//设置表格边框样式
backGroundTable.Border.LineColor = Color.White;
// 设置单元格边框样式
PageOffice.ExcelWriter.Border C4Border = sheet.OpenTable("C4:C4").Border;
C4Border.Weight = PageOffice.ExcelWriter.XlBorderWeight.xlThick;
C4Border.LineColor = Color.Yellow;
C4Border.BorderType = XlBorderType.xlAllEdges;
// 设置单元格边框样式
PageOffice.ExcelWriter.Border B6Border = sheet.OpenTable("B6:B6").Border;
B6Border.Weight = PageOffice.ExcelWriter.XlBorderWeight.xlHairline;
B6Border.LineColor = Color.Purple;
B6Border.LineStyle = XlBorderLineStyle.xlSlantDashDot;
B6Border.BorderType = XlBorderType.xlAllEdges;
//设置表格边框样式
PageOffice.ExcelWriter.Table titleTable = sheet.OpenTable("B4:F5");
titleTable.Border.Weight = PageOffice.ExcelWriter.XlBorderWeight.xlThick;
titleTable.Border.LineColor = Color.FromArgb(0, 128, 128);
titleTable.Border.BorderType = PageOffice.ExcelWriter.XlBorderType.xlAllEdges;
//设置表格边框样式
PageOffice.ExcelWriter.Table bodyTable2 = sheet.OpenTable("B6:F15");
bodyTable2.Border.Weight = PageOffice.ExcelWriter.XlBorderWeight.xlThick;
bodyTable2.Border.LineColor = Color.FromArgb(0, 128, 128);
bodyTable2.Border.BorderType = PageOffice.ExcelWriter.XlBorderType.xlAllEdges;
PageOfficeCtrl1.SetWriter(wb);// 不要忘记此句代码
PageOfficeCtrl1.AddCustomToolButton("全屏/还原", "IsFullScreen", 4);
PageOfficeCtrl1.ServerPage = Request.ApplicationPath + "/pageoffice/server.aspx"; //此行必须
PageOfficeCtrl1.WebOpen("doc/test.xls", PageOffice.OpenModeType.xlsNormalEdit, "张三");
}
protected void Page_Load(object sender, EventArgs e)
{
string userName = Request.Form["userName"];
//***************************卓正PageOffice组件的使用********************************
Workbook wb = new Workbook();
Sheet sheet = wb.OpenSheet("Sheet1");
PageOffice.ExcelWriter.Table tableA = sheet.OpenTable("C4:D6");
PageOffice.ExcelWriter.Table tableB = sheet.OpenTable("C7:D9");
tableA.SubmitName = "tableA";
tableB.SubmitName = "tableB";
//根据登录用户名设置数据区域可编辑性
//A部门经理登录后
if (userName.Equals("zhangsan"))
{
Literal1.Text = "A部门经理，所以只能编辑A部门的产品数据";
tableA.ReadOnly = false;
tableB.ReadOnly = true;
}
//B部门经理登录后
else
{
Literal1.Text = "B部门经理，所以只能编辑B部门的产品数据";
tableA.ReadOnly = true;
tableB.ReadOnly = false;
}
PageOfficeCtrl1.SetWriter(wb);
PageOfficeCtrl1.AddCustomToolButton("保存", "Save", 1);
PageOfficeCtrl1.ServerPage = Request.ApplicationPath + "/pageoffice/server.aspx"; //此行必须
PageOfficeCtrl1.SaveDataPage = "SaveData.aspx"; //保存数据
PageOfficeCtrl1.SaveFilePage = "SaveFile.aspx"; //如果需要保存文档，添加此句代码
PageOfficeCtrl1.WebOpen("doc/test.xls", PageOffice.OpenModeType.xlsSubmitForm, userName);
}
protected void Page_Load(object sender, EventArgs e)
{
PageOffice.ExcelWriter.Workbook wb = new PageOffice.ExcelWriter.Workbook();
Sheet sheet = wb.OpenSheet("Sheet1");
Cell cC3 = sheet.OpenCell("C3");
//设置单元格背景样式
cC3.BackColor = Color.AntiqueWhite;
cC3.Value = "一月";
cC3.ForeColor = Color.Green;
cC3.HorizontalAlignment = XlHAlign.xlHAlignCenter;
Cell cD3 = sheet.OpenCell("D3");
//设置单元格背景样式
cD3.BackColor = Color.AntiqueWhite;
cD3.Value = "二月";
cD3.ForeColor = Color.Green;
cD3.HorizontalAlignment = XlHAlign.xlHAlignCenter;
Cell cE3 = sheet.OpenCell("E3");
//设置单元格背景样式
cE3.BackColor = Color.AntiqueWhite;
cE3.Value = "三月";
cE3.ForeColor = Color.Green;
cE3.HorizontalAlignment = XlHAlign.xlHAlignCenter;
Cell cB4 = sheet.OpenCell("B4");
//设置单元格背景样式
cB4.BackColor = Color.SkyBlue;
cB4.Value = "住房";
cB4.ForeColor = Color.Wheat;
cB4.HorizontalAlignment = XlHAlign.xlHAlignCenter;
Cell cB5 = sheet.OpenCell("B5");
//设置单元格背景样式
cB5.BackColor = Color.Teal;
cB5.Value = "三餐";
cB5.ForeColor = Color.Wheat;
cB5.HorizontalAlignment = XlHAlign.xlHAlignCenter;
Cell cB6 = sheet.OpenCell("B6");
//设置单元格背景样式
cB6.BackColor = Color.MediumPurple;
cB6.Value = "车费";
cB6.ForeColor = Color.Wheat;
cB6.HorizontalAlignment = XlHAlign.xlHAlignCenter;
Cell cB7 = sheet.OpenCell("B7");
//设置单元格背景样式
cB7.BackColor = Color.SteelBlue;
cB7.Value = "通讯";
cB7.ForeColor = Color.Wheat;
cB7.HorizontalAlignment = XlHAlign.xlHAlignCenter;
//绘制表格线
PageOffice.ExcelWriter.Table titleTable = sheet.OpenTable("B3:E10");
titleTable.Border.Weight = PageOffice.ExcelWriter.XlBorderWeight.xlThick;
titleTable.Border.LineColor = Color.FromArgb(0, 128, 128);
titleTable.Border.BorderType = PageOffice.ExcelWriter.XlBorderType.xlAllEdges;
//合并单元格后赋值
sheet.OpenTable("B1:E2").Merge();
sheet.OpenTable("B1:E2").RowHeight = 30;//设置行高
PageOffice.ExcelWriter.Cell B1 = sheet.OpenCell("B1");
//设置单元格文本样式
B1.HorizontalAlignment = PageOffice.ExcelWriter.XlHAlign.xlHAlignCenter;
B1.VerticalAlignment = PageOffice.ExcelWriter.XlVAlign.xlVAlignCenter;
B1.ForeColor = Color.FromArgb(0, 128, 128);
B1.Value = "出差开支预算";
B1.Font.Bold = true;
B1.Font.Size = 25;
PageOfficeCtrl1.SetWriter(wb); // 不要忘记此句代码
PageOfficeCtrl1.ServerPage = Request.ApplicationPath + "/pageoffice/server.aspx"; //此行必须
PageOfficeCtrl1.WebOpen("doc/test.xls", PageOffice.OpenModeType.xlsNormalEdit, "张三");
}