将Excel转化为html显示代码,Asp.Net代码库,德仔网

代码语言

代码分类

【Asp.Net】将Excel转化为html显示

作者:dezai / 发布于2014/7/23/ 790

转换成功后会在文件夹下会生对应的图片文件夹，和样式文件，和html文件。其中如果Excel中包含多个sheet时，转化后的html会包含多个tab,如果想每个sheet转化为一个页面,则需要修改代码


	//========================================================================
	 // 函数名: ExcelToHtml
	 /// <summary>
	 /// Excel转成Html
	 /// </summary>
	 /// <param name="excelFileName">Excel文件名</param>
	 /*=======================================================================
	 变更记录
	 序号　　　更新日期　　开发者　　　变更内容
	 0001　　　2008/07/22 张 新建
	 =======================================================================*/
	 public string ExcelToHtml(string excelFileName)
	 {
	 //实例化Excel
	 Microsoft.Office.Interop.Excel.Application repExcel = new Microsoft.Office.Interop.Excel.Application();
	 Microsoft.Office.Interop.Excel.Workbook workbook = null;
	 Microsoft.Office.Interop.Excel.Worksheet worksheet = null;
	 //打开文件，n.FullPath是文件路径
	 workbook = repExcel.Application.Workbooks.Open(excelFileName, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
	 worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.Worksheets[1];
	 string filesavefilename = excelFileName.ToString();
	 string strsavefilename = filesavefilename.Substring(0, filesavefilename.Length - 3) + "html";
	 object savefilename = (object)strsavefilename;
	 object ofmt = Microsoft.Office.Interop.Excel.XlFileFormat.xlHtml;
	 //进行另存为操作
	 workbook.SaveAs(savefilename, ofmt, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
	 object osave = false;
	 //逐步关闭所有使用的对象
	 workbook.Close(osave, Type.Missing, Type.Missing);
	 repExcel.Quit();
	 System.Runtime.InteropServices.Marshal.ReleaseComObject(worksheet);
	 worksheet = null;
	 //垃圾回收
	 GC.Collect();
	 System.Runtime.InteropServices.Marshal.ReleaseComObject(workbook);
	 workbook = null;
	 GC.Collect();
	 System.Runtime.InteropServices.Marshal.ReleaseComObject(repExcel.Application.Workbooks);
	 GC.Collect();
	 System.Runtime.InteropServices.Marshal.ReleaseComObject(repExcel);
	 repExcel = null;
	 GC.Collect();
	 //依据时间杀灭进程
	 System.Diagnostics.Process[] process = System.Diagnostics.Process.GetProcessesByName("EXCEL");
	 foreach (System.Diagnostics.Process p in process)
	 {
	 if (DateTime.Now.Second - p.StartTime.Second > 0 && DateTime.Now.Second - p.StartTime.Second < 5)
	 {
	 p.Kill();
	 }
	 }
	
	 return savefilename.ToString();
	 }

评论列表

本站所提供的代码，版权归原作者所有，若有侵犯作者版权，请与我们联系，我们将立即删除或修改。谢谢!
本站所有代码发布及提供者。

试试其它关键字

　Excel转化为html　

同语言下

可能有用的

dezai贡献的其它代码(1065)