快捷導(dǎo)航

比較簡單的將數(shù)據(jù)信息導(dǎo)入wrod文檔方案(C# for word)

更新時間：2010年01月15日 17:17:26 作者：

史上最簡單將數(shù)據(jù)信息導(dǎo)入wrod文檔方案(C# for word)

 
/// <summary> 
/// 設(shè)置Word模板，word表格樣式在此設(shè)置 
/// </summary> 
/// <param name="dsTr"></param> 
/// <returns></returns> 
protected string SetWordTemplate(string dsTr) 
{ 
StringBuilder html = new StringBuilder(); 
html.Append("<!DOCTYPE html PUBLIC '-//W3C//DTD XHTML 1.0 Transitional//EN' 'http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd'>"); 
html.Append("<html xmlns='http://www.w3.org/1999/xhtml'>"); 
html.Append("<html><head><title>測試word</title></head>"); 
html.Append("<body>"); 
//html.Append("<table cellpadding='0' cellspacing='0' border='1'>"); 
html.Append(dsTr); 
//html.Append("</table>"); 
html.Append("</body>"); 
html.Append("</html>"); 
return html.ToString(); 
} 
/// <summary> 
/// 保存Word 
/// </summary> 
/// <param name="savePath"></param> 
/// <param name="data"></param> 
/// <returns></returns> 
protected bool SaveWord(string savePath,string data) 
{ 
try 
{ 
using (StreamWriter sw = new StreamWriter(savePath,true, Encoding.Default)) 
{ 
sw.WriteLine(data); 
sw.Close(); 
sw.Dispose(); 
} 
return true; 
} 
catch 
{ 
return false; 
} 
return false; 
} 
/// <summary> 
/// 導(dǎo)入 
/// </summary> 
/// <param name="sender"></param> 
/// <param name="e"></param> 
private void button1_Click(object sender, EventArgs e) 
{ 
//保存路徑 
string path = string.Format("{0}{1}", Application.StartupPath, "保存物理路徑"); 
//多個表 這里的dataset需要換成從數(shù)據(jù)庫查詢出來的dataset 
foreach(DataTable dt in new DataSet().Tables) 
{ 
StringBuilder _tables = new StringBuilder(); 
for (int i = 0; i < dt.Rows.Count; i++ ) 
{ 
if (i == 0) 
{ 
_tables.Append("<table cellpadding='0' cellspacing='0' border='1'>"); 
_tables.Append("<tr><td>表名字</td></tr>"); 
} 
_tables.Append("<tr><td>" + i + "</td><td>" + i + "</td><td>" + i + "</td></tr>"); 
if (i == (dt.Rows.Count - 1)) 
_tables.Append("</table>"); 
} 
SaveWord(path, this.SetWordTemplate(_tables.ToString())); 
} 
MessageBox.Show("生成成功!"); 
} 