using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Linq;
using?System.Text;
using?System.Windows.Forms;
using?System.Data.OleDb;
using?System.IO;



namespace?Excel根據Word模板批量生成Word文件
{
????public?partial?class?Form1?:?Form
????{


????????public??string?ExcelName?=?null;
????????public??string?ModelName?=?null;
????????public??bool?state_Excel?=?false;
????????public??bool?state_Model?=?false;
????????public??bool?state_Check?=?false;
????????public??string[]?columns?=?null;
????????public??DataSet?ds?=?null;

????????public?Form1（）
????????{
????????????InitializeComponent（）;
????????}

????????private?void?btn_selectfile_Click（object?sender?EventArgs?e）
????????{
????????????OpenFileDialog?ofg?=?new?OpenFileDialog（）;
????????????ofg.Filter?=?“Excel文件（*.xls）|*.xls“;
????????????ofg.Multiselect?=?false;
????????????if?（ofg.ShowDialog（）?==?DialogResult.OK）
????????????{
????????????????this.txt_filename.Text?=?ofg.FileName;
????????????????ExcelName?=?ofg.FileName;
????????????????state_Excel?=?true;
????????????}
????????????else
????????????{
????????????????state_Excel?=?false;
????????????????return;
????????????}

????????}

????????private?void?btn_selectmodel_Click（object?sender?EventArgs?e）
????????{
????????????OpenFileDialog?ofg?=?new?OpenFileDialog（）;
????????????ofg.Filter?=?“Word文件（*.doc）|*.doc“;
????????????ofg.Multiselect?=?false;
????????????if?（ofg.ShowDialog（）?==?DialogResult.OK）
????????????{
????????????????this.txt_model.Text?=?ofg.FileName;
????????????????ModelName?=?ofg.FileName;
????????????????state_Model?=?true;
????????????}
????????????else
????????????{
????????????????state_Model?=?false;
????????????????return;
????????????}
????????}

????????public?static?DataSet?ExcelToDataSet（string?filename）??//函數用來讀取一個excel文件到DataSet集中??
????????{

????????????string?strCon?=?“Provider=Microsoft.Jet.OLEDB.4.0;“?+
????????????????????????????“Extended?Properties=‘Excel?8.0;HDR=YES;‘;“?+
????????????????????????????“data?source=“?+?filename;
????????????string?sheetname?=?GetExcelFirstTableName（filename）;
????????????OleDbConnection?myConn?=?new?OleDbConnection（strCon）;
????????????string?strCom?=?“?SELECT?*?FROM?[“?+?sheetname?+?“]“;?????//“Sheet1“為表單標簽頁名??
????????????myConn.Open（）;
????????????OleDbDataAdapter?myCommand?=?new?OleDbDataAdapter（strCom?myConn）;
????????????DataSet?ds;
????????????ds?=?new?DataSet（）;
????????????myCommand.Fill（ds）;
????????????myConn.Close（）;
????????????return?ds;
????????}


????????public?void?DataSetToDoc（DataSet?dataset?string[]?columsstring?savepath）
????????{
????????????DataTable?dt?=?dataset.Tables[0];
????????????this.list_prolist.Items.Clear（）;
????????????for?（int?i?=?0;?i?????????????{
????????????????Aspose.Words.Document?doc?=?new?Aspose.Words.Document（ModelName）;
????????????????Asp

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-12-13?18:39??Excel根據Word模板批量生成Word文件\
?????文件????????5824??2018-12-13?18:39??Excel根據Word模板批量生成Word文件\Excel根據Word模板批量生成Word文件.csproj
?????文件?????????478??2018-12-13?13:32??Excel根據Word模板批量生成Word文件\Excel根據Word模板批量生成Word文件.csproj.user
?????文件???????10128??2018-12-13?18:39??Excel根據Word模板批量生成Word文件\Form1.Designer.cs
?????文件????????6064??2018-12-13?18:39??Excel根據Word模板批量生成Word文件\Form1.cs
?????文件??????107589??2018-12-13?18:39??Excel根據Word模板批量生成Word文件\Form1.resx
?????文件???????67646??2018-12-13?18:39??Excel根據Word模板批量生成Word文件\Microsoft_Excel_128px_561799_easyicon.net.ico
?????文件?????????524??2018-12-13?12:59??Excel根據Word模板批量生成Word文件\Program.cs
?????目錄???????????0??2018-12-13?12:59??Excel根據Word模板批量生成Word文件\Properties\
?????文件????????1436??2018-12-13?12:59??Excel根據Word模板批量生成Word文件\Properties\AssemblyInfo.cs
?????文件????????2926??2018-12-13?13:32??Excel根據Word模板批量生成Word文件\Properties\Resources.Designer.cs
?????文件????????5612??2018-12-13?12:59??Excel根據Word模板批量生成Word文件\Properties\Resources.resx
?????文件????????1143??2018-12-13?13:32??Excel根據Word模板批量生成Word文件\Properties\Settings.Designer.cs
?????文件?????????249??2018-12-13?12:59??Excel根據Word模板批量生成Word文件\Properties\Settings.settings
?????文件?????????144??2018-12-13?13:32??Excel根據Word模板批量生成Word文件\app.config
?????目錄???????????0??2018-12-13?12:59??Excel根據Word模板批量生成Word文件\bin\
?????目錄???????????0??2018-12-13?18:44??Excel根據Word模板批量生成Word文件\bin\Debug\
?????文件?????8143360??2012-09-10?13:56??Excel根據Word模板批量生成Word文件\bin\Debug\Aspose.Words.dll
?????文件??????151040??2018-12-13?18:39??Excel根據Word模板批量生成Word文件\bin\Debug\Excel2Word.exe
?????文件?????????144??2018-12-13?13:32??Excel根據Word模板批量生成Word文件\bin\Debug\Excel根據Word模板批量生成Word文件.exe.config
?????文件???????30208??2018-12-13?18:39??Excel根據Word模板批量生成Word文件\bin\Debug\Excel根據Word模板批量生成Word文件.pdb
?????文件???????11600??2018-12-13?18:39??Excel根據Word模板批量生成Word文件\bin\Debug\Excel根據Word模板批量生成Word文件.vshost.exe
?????文件?????????144??2018-12-13?13:32??Excel根據Word模板批量生成Word文件\bin\Debug\Excel根據Word模板批量生成Word文件.vshost.exe.config
?????文件?????????490??2010-03-17?22:39??Excel根據Word模板批量生成Word文件\bin\Debug\Excel根據Word模板批量生成Word文件.vshost.exe.manifest
?????目錄???????????0??2018-12-13?12:59??Excel根據Word模板批量生成Word文件\obj\
?????目錄???????????0??2018-12-13?12:59??Excel根據Word模板批量生成Word文件\obj\x86\
?????目錄???????????0??2018-12-13?18:39??Excel根據Word模板批量生成Word文件\obj\x86\Debug\
?????文件????????3744??2018-12-13?18:12??Excel根據Word模板批量生成Word文件\obj\x86\Debug\DesignTimeResolveAssemblyReferences.cache
?????文件????????6644??2018-12-13?18:39??Excel根據Word模板批量生成Word文件\obj\x86\Debug\DesignTimeResolveAssemblyReferencesInput.cache
?????文件???????68212??2018-12-13?18:39??Excel根據Word模板批量生成Word文件\obj\x86\Debug\Excel根據Word模板批量生成Word文件.Form1.resources
?????文件?????????180??2018-12-13?18:39??Excel根據Word模板批量生成Word文件\obj\x86\Debug\Excel根據Word模板批量生成Word文件.Properties.Resources.resources
............此處省略7個文件信息