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.Table table = sheet.OpenTable("B4:F13"); for (int i = 0; i < 50; i++) { table.DataFields[0].Value = "Product:" + i.ToString(); table.DataFields[1].Value = "100"; table.DataFields[2].Value = (100 + i).ToString(); table.NextRow(); } table.Close(); sheet.OpenCell("F4").Value = string.Format("{0:P}", 270.0 / 300); 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"); 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"); }
protected void AceoffixCtrl1_Load(object sender, EventArgs e) { Aceoffix.ExcelWriter.Workbook wb = new Aceoffix.ExcelWriter.Workbook(); Aceoffix.ExcelWriter.Sheet sheet1 = wb.OpenSheet("Sheet1"); Aceoffix.ExcelWriter.Table table1 = sheet1.OpenTable("C5:E16"); //Output data into the table. System.Random rd = new Random(System.DateTime.Now.Millisecond); for (int j = 0; j < 12; j++) { for (int i = 0; i < table1.DataFields.Count; i++) { int iValue = (rd.Next(25) + 10) * 1000; table1.DataFields[i].Value = iValue.ToString(); // You can set the data from the database. if (iValue > 30 * 1000) // If the value is greater than 30*1000, then the cell will display alert style to warn the user. { table1.DataFields[i].BackColor = System.Drawing.Color.Red; table1.DataFields[i].ForeColor = System.Drawing.Color.Yellow; } } table1.NextRow(); } table1.Close(); AceoffixCtrl1.ServerPage = "../aceoffix-runtime/server.aspx"; AceoffixCtrl1.Caption = "Subject: Usage of Excel Table [Double click the title bar to enter/exit full screen]"; AceoffixCtrl1.Bind(wb); // Create custom toolbar AceoffixCtrl1.AddCustomToolButton("Save As", "SaveAsDocument()", 1); AceoffixCtrl1.AddCustomToolButton("-", "", 0); AceoffixCtrl1.AddCustomToolButton("Page Setup", "ShowPageSetupDlg()", 0); AceoffixCtrl1.AddCustomToolButton("Print", "ShowPrintDlg()", 6); AceoffixCtrl1.AddCustomToolButton("-", "", 0); AceoffixCtrl1.AddCustomToolButton("Full-screen Switch", "SwitchFullScreen()", 4); AceoffixCtrl1.FileTitle = "Report1"; AceoffixCtrl1.OpenDocument("../doc/xls-report.xls", Aceoffix.OpenModeType.xlsReadOnly, "John Scott"); }