asp.net Word ecxel類型文件在線預覽

asp.net word ecxel類型文件在線預覽

首先得引用COM：

Microsoft Excel 10 Object Library

Microsoft Word 10 Object Library

或者是 10以上的類庫

我現在用的是：資源下載：http://download.csdn.net/detail/panfuy/3247641或者附件

Microsoft Excel 10 Object Library

Microsoft Word 10 Object Library

代碼如下：

1. usingSystem;
2. usingSystem.Data;
3. usingSystem.Configuration;
4. usingSystem.Collections;
5. usingSystem.Web;
6. usingSystem.Web.Security;
7. usingSystem.Web.UI;
8. usingSystem.Web.UI.WebControls;
9. usingSystem.Web.UI.WebControls.WebParts;
10. usingSystem.Web.UI.HtmlControls;
11. usingSystem.IO;
12. usingSystem.Diagnostics;
13. usingWord=Microsoft.Office.Interop.Word;
14. usingExcel=Microsoft.Office.Interop.Excel;
15. usingSystem.Reflection;
16. usingMicrosoft.Office.Interop.Excel;
19. publicpartialclassupload_PReview:System.Web.UI.Page
20. {
21. protectedvoidPage_Load(objectsender,EventArgse)
22. {
24. GenerationWorDHTML("E://20110502.doc","E://20110502.html");
25. GenerationExcelHTML("E://20110502.xls","E://20110502.html");
26. }
28. ///<summary>
29. ///Ecxel文件生成HTML并保存
30. ///</summary>
31. ///<paramname="FilePath">需要生成的ecxel文件的路徑</param>
32. ///<paramname="saveFilePath">生成以后保存HTML文件的路徑</param>
33. ///<returns>是否生成成功，成功為true，反之為false</returns>
34. protectedboolGenerationExcelHTML(stringFilePath,stringsaveFilePath)
35. {
36. try
37. {
38. Excel.applicationapp=newExcel.Application();
39. app.Visible=false;
40. Objecto=Missing.Value;
42. ///打開文件
43. /*下面是MicrosoftExcel9ObjectLibrary的寫法：*/
44. /*_Workbookxls=app.Workbooks.Open(FilePath,o,o,o,o,o,o,o,o,o,o,o,o);*/
46. /*下面是MicrosoftExcel10ObjectLibrary的寫法：*/
47. _Workbookxls=app.Workbooks.Open(FilePath,o,o,o,o,o,o,o,o,o,o,o,o,o,o);
49. ///轉換格式，另存為HTML
50. /*下面是MicrosoftExcel9ObjectLibrary的寫法：*/
51. /*xls.SaveAs(saveFilePath,Excel.XlFileFormat.xlHtml,o,o,o,o,XlSaveAsaccessMode.xlExclusive,o,o,o,o);*/
53. /*下面是MicrosoftExcel10ObjectLibrary的寫法：*/
54. xls.SaveAs(saveFilePath,Excel.XlFileFormat.xlHtml,o,o,o,o,XlSaveAsAccessMode.xlExclusive,o,o,o,o,o);
56. ///退出Excel
57. app.Quit();
58. returntrue;
59. }
60. catch
61. {
62. returnfalse;
63. }
64. finally
65. {
66. //最后關閉打開的excel進程
67. Process[]myProcesses=Process.GetProcessesByName("EXCEL");
68. foreach(ProcessmyProcessinmyProcesses)
69. {
70. myProcess.Kill();
71. }
72. }
73. }
75. ///<summary>
76. ///WinWord文件生成HTML并保存
77. ///</summary>
78. ///<paramname="FilePath">需要生成的word文件的路徑</param>
79. ///<paramname="saveFilePath">生成以后保存HTML文件的路徑</param>
80. ///<returns>是否生成成功，成功為true，反之為false</returns>
81. privateboolGenerationWordHTML(stringFilePath,stringsaveFilePath)
82. {
83. try
84. {
85. Word.ApplicationClassword=newWord.ApplicationClass();
86. TypewordType=word.GetType();
87. Word.Documentsdocs=word.Documents;
89. ///打開文件
90. TypedocsType=docs.GetType();
91. Word.Documentdoc=(Word.Document)docsType.InvokeMember("Open",System.Reflection.BindingFlags.InvokeMethod,null,docs,newObject[]{FilePath,true,true});
93. ///轉換格式，另存為HTML
94. TypedocType=doc.GetType();
96. /*下面是MicrosoftWord9ObjectLibrary的寫法：*/
97. /*docType.InvokeMember("SaveAs",System.Reflection.BindingFlags.InvokeMethod,null,doc,newobject[]{saveFilePath,Word.WdSaveFormat.wdFormatHTML});*/
99. /*下面是MicrosoftWord10ObjectLibrary的寫法：*/
100. docType.InvokeMember("SaveAs",System.Reflection.BindingFlags.InvokeMethod,
101. null,doc,newobject[]{saveFilePath,Word.WdSaveFormat.wdFormatFilteredHTML});
103. ///退出Word
104. wordType.InvokeMember("Quit",System.Reflection.BindingFlags.InvokeMethod,null,word,null);
105. returntrue;
106. }
107. catch
108. {
109. returnfalse;
110. }
111. finally
112. {
113. //最后關閉打開的winword進程
114. Process[]myProcesses=Process.GetProcessesByName("WINWORD");
115. foreach(ProcessmyProcessinmyProcesses)
116. {
117. myProcess.Kill();
118. }
119. }
120. }
121. }

• Microsoft.Office.Interop.Excel_Word.dll.zip(589.3 KB)