如何将已做好的Excel模板嵌入到网页中

发布时间：2012-09-13

方法一：如何将已做好的Excel模板嵌入到网页中,再从数据库中读取数据填充到Excel模板中

打开excel模板，通过数据集赋值给excel单元格。 Excel.Application app=new Application(; Excel._Workbook book; Excel._Worksheet sheet;
book=(Excel._Workbookapp.Workbooks.Open(strPath,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,
Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value;
sheet=(Excel._Worksheetbook.Sheets[1]; int j=dvs.Count;
Excel.Range ran1=app.ActiveCell;
ran1=sheet.get_Range(sheet.Cells[1,1],sheet.Cells[1,9]; ran1.Value2=Name;
for(int i=0;i { try {
s=Convert.ToString(i;
sheet.Cells[i+4,"A"]=dvs[i]["BH"].ToString(.Trim(; }
catch(Exception ex {
HttpContext.Current.Response.Write(""; book.Close(null,null,null; app.Workbooks.Close(; app.Quit(;
System.Runtime.InteropServices.Marshal.ReleaseComObject(app; System.Runtime.InteropServices.Marshal.ReleaseComObject(book; System.Runtime.InteropServices.Marshal.ReleaseComObject(sheet; sheet=null; book=null; app=null; GC.Collect(;
HttpContext.Current.Response.Write(""; return; } }
book.Save(;

book.Close(null,null,null; app.Workbooks.Close(; app.Quit(;
System.Runtime.InteropServices.Marshal.ReleaseComObject(app; System.Runtime.InteropServices.Marshal.ReleaseComObject(book; System.Runtime.InteropServices.Marshal.ReleaseComObject(sheet; sheet=null; book=null; app=null; GC.Collect(; GC.Collect(; GC.Collect(;
HttpContext.Current.Response.Write("";
HttpContext.Current.Response.Write("";

方法二、关于网页中嵌入excel表格

从Excel中取得数据 string ConnStr =

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " + file + ";Extended Properties=Excel
8.0; "; OleDbConnection con = new
OleDbConnection(ConnStr; OleDbCommand com = new OleDbCommand( "SELECT * FROM [sheet1$] where "+StrSql,
con; OleDbDataAdapter ada = new OleDbDataAdapter(com; DataSet ds=new
DataSet(; DataTable dt = new DataTable(;


如何将已做好的Excel模板嵌入到网页中

推荐内容

相关推荐