public ActionResult Show(string id)
{
//定义Workbook对象
PageOffice.ExcelWriter.Workbook workBook = new PageOffice.ExcelWriter.Workbook();
System.Web.UI.Page page = new System.Web.UI.Page();
string controlOutput = string.Empty;
PageOffice.PageOfficeCtrl pc = new PageOffice.PageOfficeCtrl();
pc.ID = "PageOfficeCtrl1";
pc.ServerPage = "/pageoffice/server.aspx";
pc.AddCustomToolButton("保存", "Save()", 1);
string filePath = Server.MapPath(id.Replace("..", "~"));
pc.SaveFilePage = "/PREPARE_SCHEME/SaveFile/?id=" + id.Replace("..", "~");
pc.Caption = "------------------------------------^o^------------------双击我，最大化------------------^o^------------------------------------";
pc.SetWriter(workBook);
pc.WebOpen(filePath, PageOffice.OpenModeType.xlsNormalEdit, "Tom");
page.Controls.Add(pc);
StringBuilder sb = new StringBuilder();
using (StringWriter sw = new StringWriter(sb))
{
using (HtmlTextWriter htw = new HtmlTextWriter(sw))
{
Server.Execute(page, htw, false); controlOutput = sb.ToString();
}
}
ViewBag.EditorHtml22 = controlOutput;
return(View());
}
public ActionResult BaoGao(string id)
{ //定义Workbook对象
PageOffice.ExcelWriter.Workbook workBook = new PageOffice.ExcelWriter.Workbook();
System.Web.UI.Page page = new System.Web.UI.Page();
string controlOutput = string.Empty;
PageOffice.PageOfficeCtrl pc = new PageOffice.PageOfficeCtrl();
pc.ID = "PageOfficeCtrl1";
pc.ServerPage = "/pageoffice/server.aspx";
string filePath = Server.MapPath(id.Replace("..", "~"));
pc.Caption = "------------------------------------^o^------------------双击我，报告最大化------------------^o^------------------------------------";
pc.SetWriter(workBook);
pc.WebOpen(filePath, PageOffice.OpenModeType.xlsReadOnly, "13718511828");
page.Controls.Add(pc);
StringBuilder sb = new StringBuilder();
using (StringWriter sw = new StringWriter(sb))
{
using (HtmlTextWriter htw = new HtmlTextWriter(sw))
{
Server.Execute(page, htw, false); controlOutput = sb.ToString();
}
}
ViewBag.EditorHtml22 = controlOutput;
return(View());
}
/// <summary>
/// 文件预览
/// </summary>
/// <returns></returns>
public ActionResult FileView(string filename, string SaveFilePage, string SaveDataPage, string DataRange)
{
if (!string.IsNullOrEmpty(filename))
{
while (SaveFilePage.IndexOf('|') > -1)
{
SaveFilePage = SaveFilePage.Replace('|', '&');
}
while (SaveDataPage.IndexOf('|') > -1)
{
SaveDataPage = SaveDataPage.Replace('|', '&');
}
Page page = new Page();
string controlOutput = string.Empty;
PageOffice.PageOfficeCtrl pc = new PageOffice.PageOfficeCtrl();
pc.SaveFilePage = SaveFilePage;
pc.ServerPage = "/pageoffice/server.aspx";
if (!string.IsNullOrEmpty(SaveDataPage) && !string.IsNullOrEmpty(DataRange))
{
PageOffice.ExcelWriter.Workbook wb = new PageOffice.ExcelWriter.Workbook();
PageOffice.ExcelWriter.Sheet sheetOrder = wb.OpenSheet("Sheet1");
PageOffice.ExcelWriter.Table table = sheetOrder.OpenTable(DataRange);
pc.SetWriter(wb);
pc.SaveDataPage = SaveDataPage;
}
var openmodeltype = PageOffice.OpenModeType.docAdmin;
try
{
var filenames = filename.Split('.');
switch (filenames[1])
{
case "doc":
openmodeltype = PageOffice.OpenModeType.docNormalEdit;
break;
case "docx":
openmodeltype = PageOffice.OpenModeType.docNormalEdit;
break;
case "xlsx":
openmodeltype = PageOffice.OpenModeType.xlsNormalEdit;
break;
case "xls":
openmodeltype = PageOffice.OpenModeType.xlsNormalEdit;
break;
case "pptx":
openmodeltype = PageOffice.OpenModeType.pptNormalEdit;
break;
case "ppt":
openmodeltype = PageOffice.OpenModeType.pptNormalEdit;
break;
}
}
catch
{
}
pc.WebOpen("/UpFile/" + filename, openmodeltype, "s");
page.Controls.Add(pc);
StringBuilder sb = new StringBuilder();
using (StringWriter sw = new StringWriter(sb))
{
using (HtmlTextWriter htw = new HtmlTextWriter(sw))
{
Server.Execute(page, htw, false); controlOutput = sb.ToString();
}
}
ViewBag.EditorHtml = controlOutput;
}
return(View());
}
