ASP.NET MVC在线预览Excel、Word、TXT、PDF文件


话不多说直接上代码:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using Microsoft.Office.Interop.Excel;
using System.Diagnostics;
using System.IO;
using Microsoft.Office.Interop.Word;

namespace Suya.Web.Apps.Areas.PMP.Controllers
{
    /// <summary>
    /// 在线预览Office文件
    /// </summary>
    public class OfficeViewController : Controller
    {
        #region Index页面
        /// <summary>
        /// Index页面
        /// </summary>
        /// <paramname="url">例:/uploads/......XXX.xls</param>
        public ActionResult Index(stringurl)
        {
            stringphysicalPath = Server.MapPath(Server.UrlDecode(url));
            stringextension = Path.GetExtension(physicalPath);

            stringhtmlUrl = "";
            switch(extension.ToLower())
            {
               case ".xls":
               case ".xlsx":
                   htmlUrl = PreviewExcel(physicalPath, url);
                   break;
               case ".doc":
               case ".docx":
                   htmlUrl = PreviewWord(physicalPath, url);
                   break;
               case ".txt":
                   htmlUrl = PreviewTxt(physicalPath, url);
                   break;
               case ".pdf":
                   htmlUrl = PreviewPdf(physicalPath, url);
                   break;
               case ".jpg":
               case ".jpeg":
               case ".bmp":
               case ".gif":
               case ".png":
                   htmlUrl = PreviewImg(physicalPath, url);
                   break;
               default:
                   htmlUrl = PreviewOther(physicalPath, url);
                   break;
            }

            returnRedirect(Url.Content(htmlUrl));
        }
        #endregion

        #region 预览Excel
        /// <summary>
        /// 预览Excel
        /// </summary>
        public string PreviewExcel(stringphysicalPath, string url)
        {
           Microsoft.Office.Interop.Excel.Application application = null;
           Microsoft.Office.Interop.Excel.Workbook workbook = null;
            application= new Microsoft.Office.Interop.Excel.Application();
            objectmissing = Type.Missing;
            objecttrueObject = true;
           application.Visible = false;
           application.DisplayAlerts = false;
            workbook =application.Workbooks.Open(physicalPath, missing, trueObject, missing, missing,missing,
               missing, missing, missing, missing, missing, missing, missing, missing,missing);
            //Save Excelto Html
            objectformat = Microsoft.Office.Interop.Excel.XlFileFormat.xlHtml;
            stringhtmlName = Path.GetFileNameWithoutExtension(physicalPath) + ".html";
            StringoutputFile = Path.GetDirectoryName(physicalPath) + "\\" + htmlName;
           workbook.SaveAs(outputFile, format, missing, missing, missing,
                             missing, XlSaveAsAccessMode.xlNoChange, missing,
                             missing, missing, missing, missing);
           workbook.Close();
           application.Quit();
            returnPath.GetDirectoryName(Server.UrlDecode(url)) + "\\" + htmlName;
        }
        #endregion

        #region 预览Word
        /// <summary>
        /// 预览Word
        /// </summary>
        public string PreviewWord(stringphysicalPath, string url)
        {
           Microsoft.Office.Interop.Word._Application application = null;
           Microsoft.Office.Interop.Word._Document doc = null;
            application= new Microsoft.Office.Interop.Word.Application();
            objectmissing = Type.Missing;
            objecttrueObject = true;
            application.Visible= false;
           application.DisplayAlerts = WdAlertLevel.wdAlertsNone;
            doc =application.Documents.Open(physicalPath, missing, trueObject, missing, missing,missing,
               missing, missing, missing, missing, missing, missing, missing, missing,missing, missing);
            //Save Excelto Html
            objectformat = Microsoft.Office.Interop.Word.WdSaveFormat.wdFormatHTML;
            stringhtmlName = Path.GetFileNameWithoutExtension(physicalPath) + ".html";
            StringoutputFile = Path.GetDirectoryName(physicalPath) + "\\" + htmlName;
           doc.SaveAs(outputFile, format, missing, missing, missing,
                             missing, XlSaveAsAccessMode.xlNoChange, missing,
                             missing, missing, missing, missing);
            doc.Close();
           application.Quit();
            returnPath.GetDirectoryName(Server.UrlDecode(url)) + "\\" + htmlName;
        }
        #endregion

        #region 预览Txt
        /// <summary>
        /// 预览Txt
        /// </summary>
        public string PreviewTxt(stringphysicalPath, string url)
        {
            returnServer.UrlDecode(url);
        }
        #endregion

        #region 预览Pdf
        /// <summary>
        /// 预览Pdf
        /// </summary>
        public string PreviewPdf(stringphysicalPath, string url)
        {
            returnServer.UrlDecode(url);
        }
        #endregion

        #region 预览图片
        /// <summary>
        /// 预览图片
        /// </summary>
        public string PreviewImg(stringphysicalPath, string url)
        {
            returnServer.UrlDecode(url);
        }
        #endregion

        #region 预览其他文件
        /// <summary>
        /// 预览其他文件
        /// </summary>
        public string PreviewOther(stringphysicalPath, string url)
        {
            returnServer.UrlDecode(url);
        }
        #endregion
    }
}



  • 0
    点赞
  • 16
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 8
    评论
【核心代码】 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 using Aspose.Cells; using Aspose.Slides.Pptx; using System; using System.Collections.Generic; using System.Data; using System.IO; using System.Linq; using System.Net; using System.Net.Http; using System.Text; using System.Web.Http; namespace DocOnlineView.UI.Controllers.MVCAPI { public class HomeController : ApiController { [HttpGet] public DataTable CourseViewOnLine(string fileName) { DataTable dtlist = new DataTable(); dtlist.Columns.Add("TempDocHtml", typeof(string)); string fileDire = "/Files"; string sourceDoc = Path.Combine(fileDire, fileName); string saveDoc = ""; string docExtendName = System.IO.Path.GetExtension(sourceDoc).ToLower(); bool result = false; if (docExtendName == ".pdf") { //pdf模板文件 string tempFile = Path.Combine(fileDire, "temppdf.html"); saveDoc = Path.Combine(fileDire, "viewFiles/onlinepdf.html"); result = PdfToHtml( sourceDoc, System.Web.HttpContext.Current.Server.MapPath(tempFile), System.Web.HttpContext.Current.Server.MapPath(saveDoc)); } else { saveDoc = Path.Combine(fileDire, "viewFiles/onlineview.html"); result = OfficeDocumentToHtml( System.Web.HttpContext.Current.Server.MapPath(sourceDoc), System.Web.HttpContext.Current.Server.MapPath(saveDoc)); }

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 8
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

三天不学习

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值