protected void Page_Load(object sender, EventArgs e)
{
AceoffixCtrl1.ServerPage = "../aceoffix-runtime/server.aspx";
Aceoffix.ExcelWriter.Workbook wb = new Aceoffix.ExcelWriter.Workbook();
Aceoffix.ExcelWriter.Sheet sheet = wb.OpenSheet("Sheet1");
sheet.OpenTable("B2:F2").Merge();
Aceoffix.ExcelWriter.Cell cellB2 = sheet.OpenCell("B2");
cellB2.Value = "Products for Sale";
cellB2.HorizontalAlignment = Aceoffix.ExcelWriter.XlHAlign.xlHAlignCenter;
cellB2.ForeColor = Color.Red;
cellB2.Font.Size = 16;
sheet.OpenTable("B4:B6").Merge();
Aceoffix.ExcelWriter.Cell cellB4 = sheet.OpenCell("B4");
cellB4.Value = "Product A:";
cellB4.HorizontalAlignment = Aceoffix.ExcelWriter.XlHAlign.xlHAlignCenter;
cellB4.VerticalAlignment = Aceoffix.ExcelWriter.XlVAlign.xlVAlignCenter;
cellB4.ForeColor = Color.Red;
sheet.OpenTable("B7:B9").Merge();
Aceoffix.ExcelWriter.Cell cellB7 = sheet.OpenCell("B7");
cellB7.Value = "Product B:";
cellB7.HorizontalAlignment = Aceoffix.ExcelWriter.XlHAlign.xlHAlignCenter;
cellB7.VerticalAlignment = Aceoffix.ExcelWriter.XlVAlign.xlVAlignCenter;
cellB7.ForeColor = Color.Red;
AceoffixCtrl1.Bind(wb);
AceoffixCtrl1.Menubar = false;
AceoffixCtrl1.CustomToolbar = false;
AceoffixCtrl1.OpenDocument("doc/test.xls", Aceoffix.OpenModeType.xlsNormalEdit, "John Scott");
}
protected void Page_Load(object sender, EventArgs e)
{
AceoffixCtrl1.ServerPage = "../aceoffix-runtime/server.aspx";
Aceoffix.ExcelWriter.Workbook wb = new Aceoffix.ExcelWriter.Workbook();
Aceoffix.ExcelWriter.Sheet sheet = wb.OpenSheet("Sheet1");
Aceoffix.ExcelWriter.Cell cellB4 = sheet.OpenCell("B4");
cellB4.Value = "Jan";
Aceoffix.ExcelWriter.Cell cellD2 = sheet.OpenCell("D2");
cellD2.Value = "Sales Report (2015)";
Aceoffix.ExcelWriter.Cell cellF14 = sheet.OpenCell("F14");
cellF14.Value = "100%";
AceoffixCtrl1.Bind(wb);
AceoffixCtrl1.Menubar = false;
AceoffixCtrl1.CustomToolbar = false;
AceoffixCtrl1.OpenDocument("doc/test.xls", Aceoffix.OpenModeType.xlsNormalEdit, "John Scott");
}
protected void AceoffixCtrl1_Load(object sender, EventArgs e)
{
Aceoffix.ExcelWriter.Workbook wb = new Aceoffix.ExcelWriter.Workbook();
Aceoffix.ExcelWriter.Sheet sheet1 = wb.OpenSheet("Purchase Order");
System.Random rd = new Random(System.DateTime.Now.Millisecond);
sheet1.OpenCell("D8").Value = "XYZ-11-" + (10001 + rd.Next(10000)).ToString();
sheet1.OpenCell("D8").ReadOnly = true;
Aceoffix.ExcelWriter.Cell cellDate = sheet1.OpenCell("I6");
string dt = DateTime.Now.ToString();
cellDate.Value = dt;
sheet1.OpenCell("J31").Value = dt;
sheet1.OpenCell("D15").ReadOnly = false; // Enabled edit
Aceoffix.ExcelWriter.Table table1 = sheet1.OpenTable("B18:J23");
table1.ReadOnly = false; // Enabled edit
sheet1.OpenCell("J24").ReadOnly = true;
sheet1.OpenCell("J26").ReadOnly = true;
sheet1.OpenCell("J28").ReadOnly = true;
sheet1.OpenCell("G31").Value = "John Scott";
AceoffixCtrl1.Caption = "Excel spreadsheet used as an input form.";
AceoffixCtrl1.ServerPage = "../aceoffix-runtime/server.aspx";
// Create custom toolbar
AceoffixCtrl1.AddCustomToolButton("Save", "SaveDocument()", 1);
AceoffixCtrl1.AddCustomToolButton("-", "", 0);
AceoffixCtrl1.AddCustomToolButton("Print", "ShowPrintDlg()", 6);
AceoffixCtrl1.AddCustomToolButton("-", "", 0);
AceoffixCtrl1.AddCustomToolButton("Full-screen Switch", "SwitchFullScreen()", 4);
AceoffixCtrl1.Bind(wb);
AceoffixCtrl1.SaveDataPage = "saveexceldata.aspx";
AceoffixCtrl1.OpenDocument("../doc/xls-submit.xls", Aceoffix.OpenModeType.xlsSubmitForm, "John Scott");
}
