ASP. NET Word ecxel type file online preview

ASP. NET Word ecxel type file online preview

First you have to refer to com:

Microsoft Excel Object Library

Microsoft Word Ten Object Library

or a class library of more than 10.

What I'm using now: Resources download: http://download.csdn.net/detail/panfuy/3247641 or accessories

Microsoft Excel Object Library

Microsoft Word Ten Object Library

The code is as follows:

C # code

2. Using System;
4. Using System.Data;
6. Using System.Configuration;
8. Using System.Collections;
10. Using System.Web;
12. Using System.Web.Security;
14. Using System.Web.UI;
16. Using System.Web.UI.WebControls;
18. Using System.Web.UI.WebControls.WebParts;
20. Using System.Web.UI.HtmlControls;
22. Using System.IO;
24. Using System.Diagnostics;
26. Using Word = Microsoft.Office.Interop.Word;
28. Using Excel = Microsoft.Office.Interop.Excel;
30. Using System.Reflection;
32. Using Microsoft.Office.Interop.Excel;
38. Public partial class Upload_preview:System.Web.UI.Page
40. {
42. protected void Page_Load (object sender, EventArgs e)
44. {
48. Generationwordhtml ("E://20110502.doc", "e://20110502.html");
50. Generationexcelhtml ("E://20110502.xls", "e://20110502.html");
52. }
56. // <summary>
58. /// Ecxel file generates HTML and saves
60. // </summary>
62. /// <param name= "FilePath" > Path of ecxel file to be generated </param>
64. /// <param name= "Savefilepath" > The path to save HTML files after generation </param>
66. // <returns> Whether the build succeeds, the success is true, and vice versa is false</returns>
68. protected bool Generationexcelhtml (string FilePath, string savefilepath)
70. {
72. Try
74. {
76. Excel.Application app = new Excel.Application ();
78. App.    Visible = false;
80. Object o = Missing.Value;
84. /// Open File
86. /* The following is the wording of the Microsoft Excel 9 Object Library: */
88. /*_workbook xls = App. Workbooks.Open (FilePath, O , O, O, O, O, O, O, O, O, O, O, O); */
92. /* The following is the wording of the Microsoft Excel Object Library: */
94. _workbook xls = App. Workbooks.Open (FilePath, O, O, O, O, O, O, O, O, O, O, O, O, O, O);
98. /// convert format, save as HTML
100. /* The following is the wording of the Microsoft Excel 9 Object Library: */
102. /*xls. SaveAs (Savefilepath, Excel.XlFileFormat.xlHtml, O, O, O, O, xlsaveasaccessmode.xlexclusive, O, O, O, O); */
106. /* The following is the wording of the Microsoft Excel Object Library: */
108. Xls. SaveAs (Savefilepath, Excel.XlFileFormat.xlHtml, O, O, O, O, xlsaveasaccessmode.xlexclusive, O, O, O, O, O);
112. /// exit Excel
114. App. Quit ();
116. return true;
118. }
120. Catch
122. {
124. return false;
126. }
128. finally
130. {
132. //Close open Excel process last
134. process[] myprocesses = Process.getprocessesbyname ("EXCEL");
136. foreach (Process myprocess in myprocesses)
138. {
140. Myprocess.kill ();
142. }
144. }
146. }
150. // <summary>
152. /// Winword file generates HTML and saves
154. // </summary>
156. /// <param name= "FilePath" > The path to the word file that needs to be generated </param>
158. /// <param name= "Savefilepath" > The path to save HTML files after generation </param>
160. // <returns> Whether the build succeeds, the success is true, and vice versa is false</returns>
162. Private bool Generationwordhtml (string FilePath, string savefilepath)
164. {
166. Try
168. {
170. Word.applicationclass Word = new Word.applicationclass ();
172. Type Wordtype = Word. GetType ();
174. word.documents docs = Word. Documents;
178. /// Open File
180. Type Docstype = Docs. GetType ();
182. Word.Document doc = (word.document) docstype.invokemember ("Open", System.Reflection.BindingFlags.InvokeMethod,    null, Docs, new object[] {FilePath, True, true});
186. /// convert format, save as HTML
188. Type DocType = doc. GetType ();
192. /* The following is the wording of the Microsoft Word 9 Object Library: */
194. /*doctype.invokemember ("SaveAs", System.Reflection.BindingFlags.InvokeMethod, NULL, doc, new object[] { Savefilepath, Word.WdSaveFormat.wdFormatHTML}); * *
198. /* The following is the wording of the Microsoft Word Object Library: */
200. Doctype.invokemember ("SaveAs", System.Reflection.BindingFlags.InvokeMethod,
202. null, doc, new object[] {savefilepath, Word.WdSaveFormat.wdFormatFilteredHTML});
206. /// quit Word
208. Wordtype.invokemember ("Quit", System.Reflection.BindingFlags.InvokeMethod, null, Word, null);
210. return true;
212. }
214. Catch
216. {
218. return false;
220. }
222. finally
224. {
226. //Finally close open Winword process
228. process[] myprocesses = Process.getprocessesbyname ("Winword");
230. foreach (Process myprocess in myprocesses)
232. {
234. Myprocess.kill ();
236. }
238. }
240. }
242. }

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