1.该程序是一个win32控制台程序
2.开发工具是VS2010,office是2013版的
3.需要添加以下引用
4 在C盘保存.dot模板,样式如下
6.excel中的数据格式,最好都设置为常规。
具体的代码如下:
using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Data; using System.Data.SqlClient; using System.Data.OleDb; using System.Drawing; using Microsoft.Office.Interop.Word; using Microsoft.Office.Interop.Excel; namespace ReadANDWrite { class Program { //读取EXCEL数据 public System.Data.DataTable LoadDataFromExcel(string Path) { string strConn = "Provider=Microsoft.Ace.OleDb.12.0;" + "data source=" + Path + ";Extended Properties='Excel 12.0; HDR=Yes; IMEX=1'"; OleDbConnection conn = new OleDbConnection(strConn); conn.Open(); string strExcel = ""; OleDbDataAdapter myCommand = null; System.Data.DataTable dt = null; strExcel = "select * from [sheet1$]"; myCommand = new OleDbDataAdapter(strExcel, strConn); dt = new System.Data.DataTable(); myCommand.Fill(dt); return dt; } // 写入word 模板 public void WriteDataTOword(System.Data.DataTable dt, System.Data.DataTable dt1, System.Data.DataTable dt2, System.Data.DataTable dt3,string [] sstr) { object oMissing = System.Reflection.Missing.Value; //创建一个Word应用程序实例 Microsoft.Office.Interop.Word._Application oWord = new Microsoft.Office.Interop.Word.Application(); //设置为不可见 oWord.Visible = false; //模板文件地址,这里假设在X盘根目录 object oTemplate = "C://template11.dot"; //以模板为基础生成文档 Microsoft.Office.Interop.Word._Document oDoc = oWord.Documents.Add(ref oTemplate, ref oMissing, ref oMissing, ref oMissing); //声明书签数组 object[] oBookMark = new object[20]; <