protected void Page_Load(object sender, EventArgs e)
{
string tempFileName = Request.QueryString["temp"];
AceoffixCtrl1.ServerPage = "../aceoffix-runtime/server.aspx";
Workbook wb = new Workbook();
Sheet sheet = wb.OpenSheet("Sheet1");
Aceoffix.ExcelWriter.Table table = sheet.OpenTableByDefinedName("report", 10, 5, false);
table.DataFields[0].Value = "Jan";
table.DataFields[1].Value = "100";
table.DataFields[2].Value = "120";
table.DataFields[3].Value = "500";
table.DataFields[4].Value = "120%";
table.NextRow();
table.Close();
Cell cellName = sheet.OpenCellByDefinedName("Name");
cellName.Value = "Tom";
AceoffixCtrl1.Bind(wb);
AceoffixCtrl1.Menubar = false;
AceoffixCtrl1.OpenDocument("doc/" + tempFileName, Aceoffix.OpenModeType.xlsNormalEdit, "John Scott");
}
protected void Page_Load(object sender, EventArgs e)
{
AceoffixCtrl1.ServerPage = "../aceoffix-runtime/server.aspx";
Workbook wb = new Workbook();
Sheet sheet = wb.OpenSheet("Sheet1");
Aceoffix.ExcelWriter.Table table = sheet.OpenTable("B4:F11");
int rowCount = 12;
for (int i = 1; i <= rowCount; i++)
{
table.DataFields[0].Value = i + "Month";
table.DataFields[1].Value = "100";
table.DataFields[2].Value = "120";
table.DataFields[3].Value = "500";
table.DataFields[4].Value = "120%";
table.NextRow();
}
table.Close();
Aceoffix.ExcelWriter.Table table2 = sheet.OpenTable("B13:F16");
int rowCount2 = 12;
for (int i = 1; i <= rowCount2; i++)
{
table2.DataFields[0].Value = i + "Quarter";
table2.DataFields[1].Value = "300";
table2.DataFields[2].Value = "300";
table2.DataFields[3].Value = "300";
table2.DataFields[4].Value = "100%";
table2.NextRow();
}
table2.Close();
AceoffixCtrl1.Bind(wb);
AceoffixCtrl1.Menubar = false;
AceoffixCtrl1.OpenDocument("doc/test4.xls", Aceoffix.OpenModeType.xlsNormalEdit, "John Scott");
}
protected void Page_Load(object sender, EventArgs e)
{
AceoffixCtrl1.ServerPage = "../aceoffix-runtime/server.aspx";
Workbook wb = new Workbook();
Sheet sheet = wb.OpenSheet("Sheet1");
Aceoffix.ExcelWriter.Table table = sheet.OpenTableByDefinedName("report", 10, 5, false);
table.DataFields[0].Value = "Jan";
table.DataFields[1].Value = "100";
table.DataFields[2].Value = "120";
table.DataFields[3].Value = "500";
table.DataFields[4].Value = "120%";
table.NextRow();
table.Close();
AceoffixCtrl1.Bind(wb);
AceoffixCtrl1.AddCustomToolButton("Save", "Save()", 1);
AceoffixCtrl1.Menubar = false;
AceoffixCtrl1.SaveDataPage = "SaveData.aspx";
AceoffixCtrl1.OpenDocument("doc/test.xls", Aceoffix.OpenModeType.xlsSubmitForm, "John Scott");
}
