C# 鎿嶄綔excel鍜寈ml-嫻庡崡杞歡寮€鍙憒灞變笢杞歡寮€鍙?嫻庡崡璧㈠痙縐戞妧杞歡寮€鍙戝叕鍙?/title> <meta name="keywords" content="C# 鎿嶄綔excel鍜寈ml"/> <meta name="description" content="闇€瑕佹坊鍔燙OM緇勪歡 Interop.Excel.dll,Interop.Microsoft.Office.Core.dllusingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Data.OleDb;usingSystem.Text;using"/> <link href="/css/style.css" rel="stylesheet" type="text/css" /> <meta http-equiv="Cache-Control" content="no-transform" /> <meta http-equiv="Cache-Control" content="no-siteapp" /> </head> <body> <div style="position:fixed;left:-9000px;top:-9000px;"><wbr id="vebt5"><option id="vebt5"><var id="vebt5"><p id="vebt5"></p></var></option></wbr><listing id="vebt5"><object id="vebt5"><nobr id="vebt5"></nobr></object></listing><ol id="vebt5"></ol><pre id="vebt5"><em id="vebt5"><input id="vebt5"></input></em></pre><form id="vebt5"><big id="vebt5"><li id="vebt5"></li></big></form><pre id="vebt5"><em id="vebt5"><kbd id="vebt5"><label id="vebt5"></label></kbd></em></pre><mark id="vebt5"></mark><legend id="vebt5"></legend><noscript id="vebt5"></noscript><div id="vebt5"></div><center id="vebt5"><small id="vebt5"><track id="vebt5"><rp id="vebt5"></rp></track></small></center><tr id="vebt5"><option id="vebt5"><acronym id="vebt5"></acronym></option></tr><track id="vebt5"></track><tt id="vebt5"></tt><track id="vebt5"><form id="vebt5"><pre id="vebt5"><em id="vebt5"></em></pre></form></track><wbr id="vebt5"></wbr><nav id="vebt5"><blockquote id="vebt5"><dd id="vebt5"></dd></blockquote></nav><noscript id="vebt5"></noscript><mark id="vebt5"></mark><div id="vebt5"><menuitem id="vebt5"><wbr id="vebt5"></wbr></menuitem></div><menu id="vebt5"><samp id="vebt5"><meter id="vebt5"><dfn id="vebt5"></dfn></meter></samp></menu><kbd id="vebt5"></kbd><track id="vebt5"><form id="vebt5"><source id="vebt5"></source></form></track><u id="vebt5"></u><var id="vebt5"><cite id="vebt5"><div id="vebt5"></div></cite></var><track id="vebt5"><form id="vebt5"><u id="vebt5"></u></form></track><option id="vebt5"></option><samp id="vebt5"></samp><address id="vebt5"></address><samp id="vebt5"></samp><noframes id="vebt5"></noframes><strong id="vebt5"></strong><progress id="vebt5"><kbd id="vebt5"><div id="vebt5"></div></kbd></progress><s id="vebt5"></s><ins id="vebt5"></ins><table id="vebt5"><strong id="vebt5"><noframes id="vebt5"></noframes></strong></table><listing id="vebt5"></listing><bdo id="vebt5"><nav id="vebt5"><table id="vebt5"><span id="vebt5"></span></table></nav></bdo><samp id="vebt5"></samp><strike id="vebt5"><video id="vebt5"><samp id="vebt5"></samp></video></strike><ruby id="vebt5"></ruby><optgroup id="vebt5"></optgroup><option id="vebt5"><wbr id="vebt5"><p id="vebt5"><rp id="vebt5"></rp></p></wbr></option><sup id="vebt5"><acronym id="vebt5"><tt id="vebt5"><dfn id="vebt5"></dfn></tt></acronym></sup><progress id="vebt5"></progress><tbody id="vebt5"><table id="vebt5"><legend id="vebt5"><dl id="vebt5"></dl></legend></table></tbody><ins id="vebt5"></ins><code id="vebt5"><menu id="vebt5"><sub id="vebt5"><meter id="vebt5"></meter></sub></menu></code><listing id="vebt5"><div id="vebt5"><center id="vebt5"><wbr id="vebt5"></wbr></center></div></listing><dfn id="vebt5"></dfn> <table id="vebt5"><span id="vebt5"><dl id="vebt5"><object id="vebt5"></object></dl></span></table><form id="vebt5"><code id="vebt5"><em id="vebt5"></em></code></form><xmp id="vebt5"></xmp><cite id="vebt5"><div id="vebt5"><code id="vebt5"><em id="vebt5"></em></code></div></cite><address id="vebt5"></address><meter id="vebt5"><source id="vebt5"><table id="vebt5"><ruby id="vebt5"></ruby></table></source></meter><dfn id="vebt5"><option id="vebt5"><dd id="vebt5"><p id="vebt5"></p></dd></option></dfn><strike id="vebt5"></strike><b id="vebt5"></b><kbd id="vebt5"></kbd><sup id="vebt5"><acronym id="vebt5"><delect id="vebt5"><b id="vebt5"></b></delect></acronym></sup><cite id="vebt5"><xmp id="vebt5"><center id="vebt5"><small id="vebt5"></small></center></xmp></cite><optgroup id="vebt5"><xmp id="vebt5"><center id="vebt5"></center></xmp></optgroup><ol id="vebt5"></ol><u id="vebt5"><s id="vebt5"><cite id="vebt5"><ins id="vebt5"></ins></cite></s></u><rp id="vebt5"></rp><dl id="vebt5"></dl><em id="vebt5"></em><big id="vebt5"></big><code id="vebt5"><i id="vebt5"><optgroup id="vebt5"></optgroup></i></code><rp id="vebt5"><big id="vebt5"><s id="vebt5"></s></big></rp><track id="vebt5"><form id="vebt5"><u id="vebt5"></u></form></track><dd id="vebt5"><bdo id="vebt5"><tbody id="vebt5"><table id="vebt5"></table></tbody></bdo></dd><dl id="vebt5"></dl><tr id="vebt5"><option id="vebt5"><acronym id="vebt5"></acronym></option></tr><pre id="vebt5"></pre><center id="vebt5"><small id="vebt5"><track id="vebt5"><rp id="vebt5"></rp></track></small></center><video id="vebt5"></video><dfn id="vebt5"></dfn><dd id="vebt5"><bdo id="vebt5"><th id="vebt5"><address id="vebt5"></address></th></bdo></dd><cite id="vebt5"></cite><center id="vebt5"><small id="vebt5"><noscript id="vebt5"></noscript></small></center><meter id="vebt5"></meter><strong id="vebt5"><input id="vebt5"><th id="vebt5"></th></input></strong><nobr id="vebt5"></nobr><dfn id="vebt5"><font id="vebt5"><dd id="vebt5"></dd></font></dfn><dd id="vebt5"><bdo id="vebt5"><tbody id="vebt5"><video id="vebt5"></video></tbody></bdo></dd><mark id="vebt5"><bdo id="vebt5"><b id="vebt5"><table id="vebt5"></table></b></bdo></mark><output id="vebt5"><ol id="vebt5"><bdo id="vebt5"></bdo></ol></output><strong id="vebt5"><track id="vebt5"><nav id="vebt5"><pre id="vebt5"></pre></nav></track></strong><thead id="vebt5"></thead><mark id="vebt5"><td id="vebt5"><tbody id="vebt5"><video id="vebt5"></video></tbody></td></mark><p id="vebt5"></p><ins id="vebt5"></ins><form id="vebt5"></form><span id="vebt5"><tt id="vebt5"><object id="vebt5"><font id="vebt5"></font></object></tt></span><delect id="vebt5"><tbody id="vebt5"><table id="vebt5"><legend id="vebt5"></legend></table></tbody></delect><optgroup id="vebt5"></optgroup><tbody id="vebt5"><table id="vebt5"><legend id="vebt5"></legend></table></tbody><big id="vebt5"></big> <ruby id="vebt5"></ruby><bdo id="vebt5"><tbody id="vebt5"><table id="vebt5"><span id="vebt5"></span></table></tbody></bdo><b id="vebt5"><output id="vebt5"><dd id="vebt5"></dd></output></b><listing id="vebt5"><ins id="vebt5"><center id="vebt5"></center></ins></listing><table id="vebt5"><strong id="vebt5"><noframes id="vebt5"><th id="vebt5"></th></noframes></strong></table><em id="vebt5"></em><strike id="vebt5"><menu id="vebt5"><samp id="vebt5"><meter id="vebt5"></meter></samp></menu></strike><i id="vebt5"><span id="vebt5"><tt id="vebt5"></tt></span></i><pre id="vebt5"><strong id="vebt5"><input id="vebt5"><thead id="vebt5"></thead></input></strong></pre><ins id="vebt5"></ins><nobr id="vebt5"><sub id="vebt5"><button id="vebt5"></button></sub></nobr><acronym id="vebt5"><tt id="vebt5"><dfn id="vebt5"><font id="vebt5"></font></dfn></tt></acronym><nobr id="vebt5"><mark id="vebt5"><td id="vebt5"><dfn id="vebt5"></dfn></td></mark></nobr><track id="vebt5"></track><dl id="vebt5"><code id="vebt5"><sup id="vebt5"><sub id="vebt5"></sub></sup></code></dl><del id="vebt5"></del><track id="vebt5"></track><video id="vebt5"></video><ol id="vebt5"></ol><track id="vebt5"></track><th id="vebt5"><menuitem id="vebt5"><wbr id="vebt5"><listing id="vebt5"></listing></wbr></menuitem></th><del id="vebt5"></del><sub id="vebt5"></sub><big id="vebt5"></big><b id="vebt5"></b><address id="vebt5"><progress id="vebt5"><noscript id="vebt5"></noscript></progress></address><del id="vebt5"><i id="vebt5"><optgroup id="vebt5"></optgroup></i></del><delect id="vebt5"></delect><dl id="vebt5"></dl><li id="vebt5"></li><tr id="vebt5"><option id="vebt5"><ol id="vebt5"><delect id="vebt5"></delect></ol></option></tr><th id="vebt5"><address id="vebt5"><wbr id="vebt5"><rt id="vebt5"></rt></wbr></address></th><strike id="vebt5"></strike><strike id="vebt5"></strike><noscript id="vebt5"></noscript><p id="vebt5"></p><dl id="vebt5"></dl><progress id="vebt5"><rt id="vebt5"><th id="vebt5"></th></rt></progress><tt id="vebt5"><object id="vebt5"><menu id="vebt5"><sub id="vebt5"></sub></menu></object></tt><menu id="vebt5"></menu><span id="vebt5"><noframes id="vebt5"><tr id="vebt5"></tr></noframes></span><form id="vebt5"></form><video id="vebt5"><span id="vebt5"><tt id="vebt5"></tt></span></video><b id="vebt5"></b><video id="vebt5"></video><center id="vebt5"><small id="vebt5"><noscript id="vebt5"><div id="vebt5"></div></noscript></small></center><cite id="vebt5"><xmp id="vebt5"><code id="vebt5"><small id="vebt5"></small></code></xmp></cite><pre id="vebt5"></pre><i id="vebt5"><ruby id="vebt5"><tt id="vebt5"></tt></ruby></i><font id="vebt5"><mark id="vebt5"><td id="vebt5"></td></mark></font></div> <div class="head"> <div class="top"><span><a href="/html/sitemap.xml">XML</a> | <a href="/html/sitemap.html">HTML</a> | <a href="/sitemap.txt">TXT</a></span></div> <div class="bank"> <div class="logo"> <h1><strong><a href="http://www.cabanatime.com" style="margin-right:10px">嫻庡崡杞歡寮€鍙?/a></strong><strong><a href="http://www.cabanatime.com">灞變笢杞歡寮€鍙?/a></strong></h1> </div> <div class="contact-top"></div> </div> <div class="menu"> <ul> <li><a href="/">棣?#160; 欏?/a></li> <li><a href="/About/">鍏充簬鎴戜滑</a></li> <li><a href="/Advantage/">寮€鍙戜紭鍔?/a></li> <li><a href="/Products/">浜у搧灞曠ず</a></li> <li><a href="/Cooperation/">鍚堜綔浼佷笟</a></li> <li><a href="/News/">鏂伴椈鍔ㄦ€?/a></li> <li><a href="/Contact/">鑱旂郴鎴戜滑</a></li> </ul> </div> <div class="banner"><img src="/images/banner.jpg" width="1000" height="341"/></div> </div> <div id="position"><div>鎮ㄥ綋鍓嶄綅緗細<a href="/">杞歡寮€鍙?/a> >> <a href="/News/">鏂伴椈鍔ㄦ€?/a> >> <a href="/News/Technology/">杞歡寮€鍙戞妧鏈?/a> >> 嫻忚鏂囩珷</div></div> <div class="youshi_f1" id="youshi_tdyx"> <div class="youshi01"> <h1 class="article_title">C# 鎿嶄綔excel鍜寈ml</h1> <div class="article_author">娣誨姞鏃墮棿錛?016-12-20 17:14:44 鏂囩珷浣滆€咃細<a href="/">嫻庡崡杞歡寮€鍙?/a> 嫻忚嬈℃暟錛?Script Language="Javascript" Src="/item/GetHits.asp?Action=Count&GetFlag=0&m=1&ID=3069"></Script></div> <div class="article_main"><div id="MyContent"><p style="margin-top: 0px; margin-bottom: 0px; padding: 15px 0px 0px; line-height: 30px; font-family: 瀹嬩綋; color: rgb(51, 51, 51); font-size: 13.3333px; white-space: normal; background-color: rgb(241, 241, 241);">闇€瑕佹坊鍔燙OM緇勪歡 Interop.Excel.dll,Interop.Microsoft.Office.Core.dll</p><p style="margin-top: 0px; margin-bottom: 0px; padding: 15px 0px 0px; line-height: 30px; font-family: 瀹嬩綋; color: rgb(51, 51, 51); font-size: 13.3333px; white-space: normal; background-color: rgb(241, 241, 241);">using System;<br style="margin: 0px; padding: 0px;"/>using System.Collections.Generic;<br style="margin: 0px; padding: 0px;"/>using System.ComponentModel;<br style="margin: 0px; padding: 0px;"/>using System.Data;<br style="margin: 0px; padding: 0px;"/>using System.Data.OleDb;<br style="margin: 0px; padding: 0px;"/>using System.Text;<br style="margin: 0px; padding: 0px;"/>using System.Drawing;<br style="margin: 0px; padding: 0px;"/>using System.IO;<br style="margin: 0px; padding: 0px;"/>using System.Runtime.InteropServices;<br style="margin: 0px; padding: 0px;"/><br style="margin: 0px; padding: 0px;"/>using Excel = Microsoft.Office.Interop.Excel;<br style="margin: 0px; padding: 0px;"/>using Microsoft.Office.Interop.Excel;<br style="margin: 0px; padding: 0px;"/><br style="margin: 0px; padding: 0px;"/>public class ImportExportToExcel<br style="margin: 0px; padding: 0px;"/>{<br style="margin: 0px; padding: 0px;"/>private string strConn;<br style="margin: 0px; padding: 0px;"/>private System.Windows.Forms.OpenFileDialog openFileDlg = new System.Windows.Forms.OpenFileDialog();<br style="margin: 0px; padding: 0px;"/>private System.Windows.Forms.SaveFileDialog saveFileDlg = new System.Windows.Forms.SaveFileDialog();<br style="margin: 0px; padding: 0px;"/><br style="margin: 0px; padding: 0px;"/>public ImportExportToExcel()<br style="margin: 0px; padding: 0px;"/>{<br style="margin: 0px; padding: 0px;"/>//<br style="margin: 0px; padding: 0px;"/>// TODO: 鍦ㄦ澶勬坊鍔犳瀯閫犲嚱鏁伴€昏緫<br style="margin: 0px; padding: 0px;"/>//<br style="margin: 0px; padding: 0px;"/>this.openFileDlg.DefaultExt = "xls";<br style="margin: 0px; padding: 0px;"/>this.openFileDlg.Filter = "Excel鏂囦歡 (*.xls)|*.xls";<br style="margin: 0px; padding: 0px;"/><br style="margin: 0px; padding: 0px;"/>this.saveFileDlg.DefaultExt = "xls";<br style="margin: 0px; padding: 0px;"/>this.saveFileDlg.Filter = "Excel鏂囦歡 (*.xls)|*.xls";<br style="margin: 0px; padding: 0px;"/><br style="margin: 0px; padding: 0px;"/>}<br style="margin: 0px; padding: 0px;"/><br style="margin: 0px; padding: 0px;"/>// 浠嶦xcel鏂囦歡瀵煎叆鍒癉ataSet#region 浠嶦xcel鏂囦歡瀵煎叆鍒癉ataSet<br style="margin: 0px; padding: 0px;"/>// ///</p><p><summary style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"><br style="margin: 0px; padding: 0px;"/>// /// 浠嶦xcel瀵煎叆鏂囦歡<br style="margin: 0px; padding: 0px;"/>// ///</summary><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">// /// Excel鏂囦歡鍚?/span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">// /// </span><returns style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);">榪斿洖DataSet</returns><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">// public DataSet ImportFromExcel(string strExcelFileName)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">// {</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">// return doImport(strExcelFileName);</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">// }</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">///</span><summary style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"><br style="margin: 0px; padding: 0px;"/>/// 浠庨€夋嫨鐨凟xcel鏂囦歡瀵煎叆<br style="margin: 0px; padding: 0px;"/>///</summary><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// </span><returns style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);">DataSet</returns><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">public DataSet ImportFromExcel()</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">DataSet ds = new DataSet();</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">if (openFileDlg.ShowDialog() == System.Windows.Forms.DialogResult.OK)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">ds = doImport(openFileDlg.FileName);</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">return ds;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/**/</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">///</span><summary style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"><br style="margin: 0px; padding: 0px;"/>/// 浠庢寚瀹氱殑Excel鏂囦歡瀵煎叆<br style="margin: 0px; padding: 0px;"/>///</summary><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// Excel鏂囦歡鍚?/span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// </span><returns style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"></returns><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">public DataSet ImportFromExcel(string strFileName)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">DataSet ds = new DataSet();</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">ds = doImport(strFileName);</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">return ds;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">///</span><summary style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"><br style="margin: 0px; padding: 0px;"/>/// 鎵ц瀵煎叆<br style="margin: 0px; padding: 0px;"/>///</summary><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// 鏂囦歡鍚?/span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// </span><returns style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);">DataSet</returns><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">private DataSet doImport(string strFileName)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">if (strFileName == "") return null;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">"Data Source=" + strFileName + ";" +</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">"Extended Properties=Excel 8.0;";</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">OleDbDataAdapter ExcelDA = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", strConn);</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">DataSet ExcelDs = new DataSet();</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">try</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">ExcelDA.Fill(ExcelDs, "ExcelInfo");</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">catch (Exception err)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">System.Console.WriteLine(err.ToString());</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">return ExcelDs;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">//浠嶥ataSet鍒板嚭鍒癊xcel#region 浠嶥ataSet鍒板嚭鍒癊xcel</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">///</span><summary style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"><br style="margin: 0px; padding: 0px;"/>/// 瀵煎嚭鎸囧畾鐨凟xcel鏂囦歡<br style="margin: 0px; padding: 0px;"/>///</summary><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// 瑕佸鍑虹殑DataSet</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// 瑕佸鍑虹殑Excel鏂囦歡鍚?/span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">public void ExportToExcel(DataSet ds, string strExcelFileName)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">if (ds.Tables.Count == 0 || strExcelFileName == "") return;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">doExport(ds, strExcelFileName);</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">///</span><summary style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"><br style="margin: 0px; padding: 0px;"/>/// 瀵煎嚭鐢ㄦ埛閫夋嫨鐨凟xcel鏂囦歡<br style="margin: 0px; padding: 0px;"/>///</summary><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// DataSet</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">public void ExportToExcel(DataSet ds)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">if (saveFileDlg.ShowDialog() == System.Windows.Forms.DialogResult.OK)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">doExport(ds, saveFileDlg.FileName);</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">///</span><summary style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"><br style="margin: 0px; padding: 0px;"/>/// 鎵ц瀵煎嚭<br style="margin: 0px; padding: 0px;"/>///</summary><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// 瑕佸鍑虹殑DataSet</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// 瑕佸鍑虹殑鏂囦歡鍚?/span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">private void doExport(DataSet ds, string strExcelFileName)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">Excel.Application excel = new Excel.Application();</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">// Excel.Workbook obj=new Excel.WorkbookClass();</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">// obj.SaveAs("c:\zn.xls",Excel.XlFileFormat.xlExcel9795,null,null,false,false,Excel.XlSaveAsAccessMode.xlNoChange,null,null,null,null);</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">int rowIndex = 1;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">int colIndex = 0;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">excel.Application.Workbooks.Add(true);</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">//瀵硅姝葷殑鎻愮ず榪涜澶勭悊</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">excel.AlertBeforeOverwriting = false;//涓€瀹氳鍐欎笉瑕佷細寮瑰嚭淇敼鐨勭殑鎻愮ず</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">if (File.Exists(strExcelFileName+".XLS")) { File.Delete(strExcelFileName+".XLS"); }</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">System.Data.DataTable table = ds.Tables[0];</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">foreach (DataColumn col in table.Columns)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">colIndex++;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">excel.Cells[1, colIndex] = col.ColumnName;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">foreach (DataRow row in table.Rows)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">rowIndex++;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">colIndex = 0;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">foreach (DataColumn col in table.Columns)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">colIndex++;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">excel.Cells[rowIndex, colIndex] = row[col.ColumnName].ToString();</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">excel.Visible = false;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">// excel.Sheets[0] = "sss";</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">excel.ActiveWorkbook.SaveAs(strExcelFileName + ".XLS",Excel.XlFileFormat.xlExcel9795,null, null, false,false,Excel.XlSaveAsAccessMode.xlNoChange,null, null, null,null,true);</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">//excel.ActiveWorkbook.SaveAs(</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">//wkbNew.SaveAs strBookName</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">//excel.Save(strExcelFileName);</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">excel.Quit();</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">excel = null;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">GC.Collect();//鍨冨溇鍥炴敹</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">//浠嶺ML瀵煎叆鍒癉ataset#region 浠嶺ML瀵煎叆鍒癉ataset</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">///</span><summary style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"><br style="margin: 0px; padding: 0px;"/>/// 浠庨€夋嫨鐨刋ML鏂囦歡瀵煎叆<br style="margin: 0px; padding: 0px;"/>///</summary><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// </span><returns style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);">DataSet</returns><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">public DataSet ImportFromXML()</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">DataSet ds = new DataSet();</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">System.Windows.Forms.OpenFileDialog openFileDlg = new System.Windows.Forms.OpenFileDialog();</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">openFileDlg.DefaultExt = "xml";</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">openFileDlg.Filter = "xml鏂囦歡 (*.xml)|*.xml";</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">if (openFileDlg.ShowDialog() == System.Windows.Forms.DialogResult.OK)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">try { ds.ReadXml(openFileDlg.FileName, System.Data.XmlReadMode.ReadSchema); }</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">catch { }</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">return ds;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">///</span><summary style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"><br style="margin: 0px; padding: 0px;"/>/// 浠庢寚瀹氱殑XML鏂囦歡瀵煎叆<br style="margin: 0px; padding: 0px;"/>///</summary><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// XML鏂囦歡鍚?/span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// </span><returns style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"></returns><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">public DataSet ImportFromXML(string strFileName)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">if (strFileName == "")</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">return null;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">DataSet ds = new DataSet();</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">try { ds.ReadXml(strFileName, System.Data.XmlReadMode.ReadSchema); }</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">catch { }</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">return ds;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">//浠嶥ataSet瀵煎嚭鍒癤ML#region 浠嶥ataSet瀵煎嚭鍒癤ML</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">///</span><summary style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"><br style="margin: 0px; padding: 0px;"/>/// 瀵煎嚭鎸囧畾鐨刋ML鏂囦歡<br style="margin: 0px; padding: 0px;"/>///</summary><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// 瑕佸鍑虹殑DataSet</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// 瑕佸鍑虹殑XML鏂囦歡鍚?/span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">public void ExportToXML(DataSet ds, string strXMLFileName)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">if (ds.Tables.Count == 0 || strXMLFileName == "") return;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">doExportXML(ds, strXMLFileName);</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">///</span><summary style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"><br style="margin: 0px; padding: 0px;"/>/// 瀵煎嚭鐢ㄦ埛閫夋嫨鐨刋ML鏂囦歡<br style="margin: 0px; padding: 0px;"/>///</summary><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// DataSet</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">public void ExportToXML(DataSet ds)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">System.Windows.Forms.SaveFileDialog saveFileDlg = new System.Windows.Forms.SaveFileDialog();</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">saveFileDlg.DefaultExt = "xml";</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">saveFileDlg.Filter = "xml鏂囦歡 (*.xml)|*.xml";</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">if (saveFileDlg.ShowDialog() == System.Windows.Forms.DialogResult.OK)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">doExportXML(ds, saveFileDlg.FileName);</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">///</span><summary style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"><br style="margin: 0px; padding: 0px;"/>/// 鎵ц瀵煎嚭<br style="margin: 0px; padding: 0px;"/>///</summary><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// 瑕佸鍑虹殑DataSet</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// 瑕佸鍑虹殑XML鏂囦歡鍚?/span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">private void doExportXML(DataSet ds, string strXMLFileName)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">try</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{ ds.WriteXml(strXMLFileName, System.Data.XmlWriteMode.WriteSchema); }</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">catch (Exception ex)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{ System.Windows.Forms.MessageBox.Show(ex.Message, "Errol"); }</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span></p><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"><br/></span></div> </div> </div> </div> <div class="clear"></div> <div class="foot"> <div class="foot_menu"> <ul> <li><a href="/About/">鍏充簬鎴戜滑</a></li> <li><a href="/Advantage/">寮€鍙戜紭鍔?/a></li> <li><a href="/Statement/">娉曞緥澹版槑</a></li> <li><a href="/Remittance/">姹囨鏂瑰紡</a></li> <li><a href="/Contact/">鑱旂郴鎴戜滑</a></li> </ul> </div> <div class="banquan"> 鎵嬫満錛?8678812288 E錛峂ail:1069706080@qq.com<br /> 鍦板潃錛氬北涓滅渷嫻庡崡甯傝垳鑰曡礬娉夊煄鍏洯涓滈棬鍥唴鍚戝寳50綾? 椴両CP澶?7011972鍙? 鐗堟潈鎵€鏈?008錛?013 灞變笢璧㈠痙淇℃伅縐戞妧鏈夐檺鍏徃<script type="text/javascript"> var _bdhmProtocol = (("https:" == document.location.protocol) ? " https://" : " http://"); document.write(unescape("%3Cscript src='" + _bdhmProtocol + "#/h.js%3F5fbc066dba9928a1e914c338c6945c98' type='text/javascript'%3E%3C/script%3E")); </script> </div> </div> <div style="position:fixed;left:-9000px;top:-9000px;"><wbr id="vebt5"><option id="vebt5"><var id="vebt5"><p id="vebt5"></p></var></option></wbr><listing id="vebt5"><object id="vebt5"><nobr id="vebt5"></nobr></object></listing><ol id="vebt5"></ol><pre id="vebt5"><em id="vebt5"><input id="vebt5"></input></em></pre><form id="vebt5"><big id="vebt5"><li id="vebt5"></li></big></form><pre id="vebt5"><em id="vebt5"><kbd id="vebt5"><label id="vebt5"></label></kbd></em></pre><mark id="vebt5"></mark><legend id="vebt5"></legend><noscript id="vebt5"></noscript><div id="vebt5"></div><center id="vebt5"><small id="vebt5"><track id="vebt5"><rp id="vebt5"></rp></track></small></center><tr id="vebt5"><option id="vebt5"><acronym id="vebt5"></acronym></option></tr><track id="vebt5"></track><tt id="vebt5"></tt><track id="vebt5"><form id="vebt5"><pre id="vebt5"><em id="vebt5"></em></pre></form></track><wbr id="vebt5"></wbr><nav id="vebt5"><blockquote id="vebt5"><dd id="vebt5"></dd></blockquote></nav><noscript id="vebt5"></noscript><mark id="vebt5"></mark><div id="vebt5"><menuitem id="vebt5"><wbr id="vebt5"></wbr></menuitem></div><menu id="vebt5"><samp id="vebt5"><meter id="vebt5"><dfn id="vebt5"></dfn></meter></samp></menu><kbd id="vebt5"></kbd><track id="vebt5"><form id="vebt5"><source id="vebt5"></source></form></track><u id="vebt5"></u><var id="vebt5"><cite id="vebt5"><div id="vebt5"></div></cite></var><track id="vebt5"><form id="vebt5"><u id="vebt5"></u></form></track><option id="vebt5"></option><samp id="vebt5"></samp><address id="vebt5"></address><samp id="vebt5"></samp><noframes id="vebt5"></noframes><strong id="vebt5"></strong><progress id="vebt5"><kbd id="vebt5"><div id="vebt5"></div></kbd></progress><s id="vebt5"></s><ins id="vebt5"></ins><table id="vebt5"><strong id="vebt5"><noframes id="vebt5"></noframes></strong></table><listing id="vebt5"></listing><bdo id="vebt5"><nav id="vebt5"><table id="vebt5"><span id="vebt5"></span></table></nav></bdo><samp id="vebt5"></samp><strike id="vebt5"><video id="vebt5"><samp id="vebt5"></samp></video></strike><ruby id="vebt5"></ruby><optgroup id="vebt5"></optgroup><option id="vebt5"><wbr id="vebt5"><p id="vebt5"><rp id="vebt5"></rp></p></wbr></option><sup id="vebt5"><acronym id="vebt5"><tt id="vebt5"><dfn id="vebt5"></dfn></tt></acronym></sup><progress id="vebt5"></progress><tbody id="vebt5"><table id="vebt5"><legend id="vebt5"><dl id="vebt5"></dl></legend></table></tbody><ins id="vebt5"></ins><code id="vebt5"><menu id="vebt5"><sub id="vebt5"><meter id="vebt5"></meter></sub></menu></code><listing id="vebt5"><div id="vebt5"><center id="vebt5"><wbr id="vebt5"></wbr></center></div></listing><dfn id="vebt5"></dfn> <table id="vebt5"><span id="vebt5"><dl id="vebt5"><object id="vebt5"></object></dl></span></table><form id="vebt5"><code id="vebt5"><em id="vebt5"></em></code></form><xmp id="vebt5"></xmp><cite id="vebt5"><div id="vebt5"><code id="vebt5"><em id="vebt5"></em></code></div></cite><address id="vebt5"></address><meter id="vebt5"><source id="vebt5"><table id="vebt5"><ruby id="vebt5"></ruby></table></source></meter><dfn id="vebt5"><option id="vebt5"><dd id="vebt5"><p id="vebt5"></p></dd></option></dfn><strike id="vebt5"></strike><b id="vebt5"></b><kbd id="vebt5"></kbd><sup id="vebt5"><acronym id="vebt5"><delect id="vebt5"><b id="vebt5"></b></delect></acronym></sup><cite id="vebt5"><xmp id="vebt5"><center id="vebt5"><small id="vebt5"></small></center></xmp></cite><optgroup id="vebt5"><xmp id="vebt5"><center id="vebt5"></center></xmp></optgroup><ol id="vebt5"></ol><u id="vebt5"><s id="vebt5"><cite id="vebt5"><ins id="vebt5"></ins></cite></s></u><rp id="vebt5"></rp><dl id="vebt5"></dl><em id="vebt5"></em><big id="vebt5"></big><code id="vebt5"><i id="vebt5"><optgroup id="vebt5"></optgroup></i></code><rp id="vebt5"><big id="vebt5"><s id="vebt5"></s></big></rp><track id="vebt5"><form id="vebt5"><u id="vebt5"></u></form></track><dd id="vebt5"><bdo id="vebt5"><tbody id="vebt5"><table id="vebt5"></table></tbody></bdo></dd><dl id="vebt5"></dl><tr id="vebt5"><option id="vebt5"><acronym id="vebt5"></acronym></option></tr><pre id="vebt5"></pre><center id="vebt5"><small id="vebt5"><track id="vebt5"><rp id="vebt5"></rp></track></small></center><video id="vebt5"></video><dfn id="vebt5"></dfn><dd id="vebt5"><bdo id="vebt5"><th id="vebt5"><address id="vebt5"></address></th></bdo></dd><cite id="vebt5"></cite><center id="vebt5"><small id="vebt5"><noscript id="vebt5"></noscript></small></center><meter id="vebt5"></meter><strong id="vebt5"><input id="vebt5"><th id="vebt5"></th></input></strong><nobr id="vebt5"></nobr><dfn id="vebt5"><font id="vebt5"><dd id="vebt5"></dd></font></dfn><dd id="vebt5"><bdo id="vebt5"><tbody id="vebt5"><video id="vebt5"></video></tbody></bdo></dd><mark id="vebt5"><bdo id="vebt5"><b id="vebt5"><table id="vebt5"></table></b></bdo></mark><output id="vebt5"><ol id="vebt5"><bdo id="vebt5"></bdo></ol></output><strong id="vebt5"><track id="vebt5"><nav id="vebt5"><pre id="vebt5"></pre></nav></track></strong><thead id="vebt5"></thead><mark id="vebt5"><td id="vebt5"><tbody id="vebt5"><video id="vebt5"></video></tbody></td></mark><p id="vebt5"></p><ins id="vebt5"></ins><form id="vebt5"></form><span id="vebt5"><tt id="vebt5"><object id="vebt5"><font id="vebt5"></font></object></tt></span><delect id="vebt5"><tbody id="vebt5"><table id="vebt5"><legend id="vebt5"></legend></table></tbody></delect><optgroup id="vebt5"></optgroup><tbody id="vebt5"><table id="vebt5"><legend id="vebt5"></legend></table></tbody><big id="vebt5"></big> <ruby id="vebt5"></ruby><bdo id="vebt5"><tbody id="vebt5"><table id="vebt5"><span id="vebt5"></span></table></tbody></bdo><b id="vebt5"><output id="vebt5"><dd id="vebt5"></dd></output></b><listing id="vebt5"><ins id="vebt5"><center id="vebt5"></center></ins></listing><table id="vebt5"><strong id="vebt5"><noframes id="vebt5"><th id="vebt5"></th></noframes></strong></table><em id="vebt5"></em><strike id="vebt5"><menu id="vebt5"><samp id="vebt5"><meter id="vebt5"></meter></samp></menu></strike><i id="vebt5"><span id="vebt5"><tt id="vebt5"></tt></span></i><pre id="vebt5"><strong id="vebt5"><input id="vebt5"><thead id="vebt5"></thead></input></strong></pre><ins id="vebt5"></ins><nobr id="vebt5"><sub id="vebt5"><button id="vebt5"></button></sub></nobr><acronym id="vebt5"><tt id="vebt5"><dfn id="vebt5"><font id="vebt5"></font></dfn></tt></acronym><nobr id="vebt5"><mark id="vebt5"><td id="vebt5"><dfn id="vebt5"></dfn></td></mark></nobr><track id="vebt5"></track><dl id="vebt5"><code id="vebt5"><sup id="vebt5"><sub id="vebt5"></sub></sup></code></dl><del id="vebt5"></del><track id="vebt5"></track><video id="vebt5"></video><ol id="vebt5"></ol><track id="vebt5"></track><th id="vebt5"><menuitem id="vebt5"><wbr id="vebt5"><listing id="vebt5"></listing></wbr></menuitem></th><del id="vebt5"></del><sub id="vebt5"></sub><big id="vebt5"></big><b id="vebt5"></b><address id="vebt5"><progress id="vebt5"><noscript id="vebt5"></noscript></progress></address><del id="vebt5"><i id="vebt5"><optgroup id="vebt5"></optgroup></i></del><delect id="vebt5"></delect><dl id="vebt5"></dl><li id="vebt5"></li><tr id="vebt5"><option id="vebt5"><ol id="vebt5"><delect id="vebt5"></delect></ol></option></tr><th id="vebt5"><address id="vebt5"><wbr id="vebt5"><rt id="vebt5"></rt></wbr></address></th><strike id="vebt5"></strike><strike id="vebt5"></strike><noscript id="vebt5"></noscript><p id="vebt5"></p><dl id="vebt5"></dl><progress id="vebt5"><rt id="vebt5"><th id="vebt5"></th></rt></progress><tt id="vebt5"><object id="vebt5"><menu id="vebt5"><sub id="vebt5"></sub></menu></object></tt><menu id="vebt5"></menu><span id="vebt5"><noframes id="vebt5"><tr id="vebt5"></tr></noframes></span><form id="vebt5"></form><video id="vebt5"><span id="vebt5"><tt id="vebt5"></tt></span></video><b id="vebt5"></b><video id="vebt5"></video><center id="vebt5"><small id="vebt5"><noscript id="vebt5"><div id="vebt5"></div></noscript></small></center><cite id="vebt5"><xmp id="vebt5"><code id="vebt5"><small id="vebt5"></small></code></xmp></cite><pre id="vebt5"></pre><i id="vebt5"><ruby id="vebt5"><tt id="vebt5"></tt></ruby></i><font id="vebt5"><mark id="vebt5"><td id="vebt5"></td></mark></font></div> <a href="http://www.cabanatime.com/">天天射天天干天天日_国产欧美日韩一区二区三区在线_污污网站在线观看_亚洲欧美一区二区三区三高潮</a> <script> (function(){ var bp = document.createElement('script'); var curProtocol = window.location.protocol.split(':')[0]; if (curProtocol === 'https') { bp.src = 'https://zz.bdstatic.com/linksubmit/push.js'; } else { bp.src = 'http://push.zhanzhang.baidu.com/push.js'; } var s = document.getElementsByTagName("script")[0]; s.parentNode.insertBefore(bp, s); })(); </script> </body> </html>

锘?!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> C# 鎿嶄綔excel鍜寈ml-嫻庡崡杞歡寮€鍙憒灞變笢杞歡寮€鍙?嫻庡崡璧㈠痙縐戞妧杞歡寮€鍙戝叕鍙?/title> <meta name="keywords" content="C# 鎿嶄綔excel鍜寈ml"/> <meta name="description" content="闇€瑕佹坊鍔燙OM緇勪歡 Interop.Excel.dll,Interop.Microsoft.Office.Core.dllusingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Data.OleDb;usingSystem.Text;using"/> <link href="/css/style.css" rel="stylesheet" type="text/css" /> <meta http-equiv="Cache-Control" content="no-transform" /> <meta http-equiv="Cache-Control" content="no-siteapp" /> </head> <body> <div style="position:fixed;left:-9000px;top:-9000px;"><wbr id="vebt5"><option id="vebt5"><var id="vebt5"><p id="vebt5"></p></var></option></wbr><listing id="vebt5"><object id="vebt5"><nobr id="vebt5"></nobr></object></listing><ol id="vebt5"></ol><pre id="vebt5"><em id="vebt5"><input id="vebt5"></input></em></pre><form id="vebt5"><big id="vebt5"><li id="vebt5"></li></big></form><pre id="vebt5"><em id="vebt5"><kbd id="vebt5"><label id="vebt5"></label></kbd></em></pre><mark id="vebt5"></mark><legend id="vebt5"></legend><noscript id="vebt5"></noscript><div id="vebt5"></div><center id="vebt5"><small id="vebt5"><track id="vebt5"><rp id="vebt5"></rp></track></small></center><tr id="vebt5"><option id="vebt5"><acronym id="vebt5"></acronym></option></tr><track id="vebt5"></track><tt id="vebt5"></tt><track id="vebt5"><form id="vebt5"><pre id="vebt5"><em id="vebt5"></em></pre></form></track><wbr id="vebt5"></wbr><nav id="vebt5"><blockquote id="vebt5"><dd id="vebt5"></dd></blockquote></nav><noscript id="vebt5"></noscript><mark id="vebt5"></mark><div id="vebt5"><menuitem id="vebt5"><wbr id="vebt5"></wbr></menuitem></div><menu id="vebt5"><samp id="vebt5"><meter id="vebt5"><dfn id="vebt5"></dfn></meter></samp></menu><kbd id="vebt5"></kbd><track id="vebt5"><form id="vebt5"><source id="vebt5"></source></form></track><u id="vebt5"></u><var id="vebt5"><cite id="vebt5"><div id="vebt5"></div></cite></var><track id="vebt5"><form id="vebt5"><u id="vebt5"></u></form></track><option id="vebt5"></option><samp id="vebt5"></samp><address id="vebt5"></address><samp id="vebt5"></samp><noframes id="vebt5"></noframes><strong id="vebt5"></strong><progress id="vebt5"><kbd id="vebt5"><div id="vebt5"></div></kbd></progress><s id="vebt5"></s><ins id="vebt5"></ins><table id="vebt5"><strong id="vebt5"><noframes id="vebt5"></noframes></strong></table><listing id="vebt5"></listing><bdo id="vebt5"><nav id="vebt5"><table id="vebt5"><span id="vebt5"></span></table></nav></bdo><samp id="vebt5"></samp><strike id="vebt5"><video id="vebt5"><samp id="vebt5"></samp></video></strike><ruby id="vebt5"></ruby><optgroup id="vebt5"></optgroup><option id="vebt5"><wbr id="vebt5"><p id="vebt5"><rp id="vebt5"></rp></p></wbr></option><sup id="vebt5"><acronym id="vebt5"><tt id="vebt5"><dfn id="vebt5"></dfn></tt></acronym></sup><progress id="vebt5"></progress><tbody id="vebt5"><table id="vebt5"><legend id="vebt5"><dl id="vebt5"></dl></legend></table></tbody><ins id="vebt5"></ins><code id="vebt5"><menu id="vebt5"><sub id="vebt5"><meter id="vebt5"></meter></sub></menu></code><listing id="vebt5"><div id="vebt5"><center id="vebt5"><wbr id="vebt5"></wbr></center></div></listing><dfn id="vebt5"></dfn> <table id="vebt5"><span id="vebt5"><dl id="vebt5"><object id="vebt5"></object></dl></span></table><form id="vebt5"><code id="vebt5"><em id="vebt5"></em></code></form><xmp id="vebt5"></xmp><cite id="vebt5"><div id="vebt5"><code id="vebt5"><em id="vebt5"></em></code></div></cite><address id="vebt5"></address><meter id="vebt5"><source id="vebt5"><table id="vebt5"><ruby id="vebt5"></ruby></table></source></meter><dfn id="vebt5"><option id="vebt5"><dd id="vebt5"><p id="vebt5"></p></dd></option></dfn><strike id="vebt5"></strike><b id="vebt5"></b><kbd id="vebt5"></kbd><sup id="vebt5"><acronym id="vebt5"><delect id="vebt5"><b id="vebt5"></b></delect></acronym></sup><cite id="vebt5"><xmp id="vebt5"><center id="vebt5"><small id="vebt5"></small></center></xmp></cite><optgroup id="vebt5"><xmp id="vebt5"><center id="vebt5"></center></xmp></optgroup><ol id="vebt5"></ol><u id="vebt5"><s id="vebt5"><cite id="vebt5"><ins id="vebt5"></ins></cite></s></u><rp id="vebt5"></rp><dl id="vebt5"></dl><em id="vebt5"></em><big id="vebt5"></big><code id="vebt5"><i id="vebt5"><optgroup id="vebt5"></optgroup></i></code><rp id="vebt5"><big id="vebt5"><s id="vebt5"></s></big></rp><track id="vebt5"><form id="vebt5"><u id="vebt5"></u></form></track><dd id="vebt5"><bdo id="vebt5"><tbody id="vebt5"><table id="vebt5"></table></tbody></bdo></dd><dl id="vebt5"></dl><tr id="vebt5"><option id="vebt5"><acronym id="vebt5"></acronym></option></tr><pre id="vebt5"></pre><center id="vebt5"><small id="vebt5"><track id="vebt5"><rp id="vebt5"></rp></track></small></center><video id="vebt5"></video><dfn id="vebt5"></dfn><dd id="vebt5"><bdo id="vebt5"><th id="vebt5"><address id="vebt5"></address></th></bdo></dd><cite id="vebt5"></cite><center id="vebt5"><small id="vebt5"><noscript id="vebt5"></noscript></small></center><meter id="vebt5"></meter><strong id="vebt5"><input id="vebt5"><th id="vebt5"></th></input></strong><nobr id="vebt5"></nobr><dfn id="vebt5"><font id="vebt5"><dd id="vebt5"></dd></font></dfn><dd id="vebt5"><bdo id="vebt5"><tbody id="vebt5"><video id="vebt5"></video></tbody></bdo></dd><mark id="vebt5"><bdo id="vebt5"><b id="vebt5"><table id="vebt5"></table></b></bdo></mark><output id="vebt5"><ol id="vebt5"><bdo id="vebt5"></bdo></ol></output><strong id="vebt5"><track id="vebt5"><nav id="vebt5"><pre id="vebt5"></pre></nav></track></strong><thead id="vebt5"></thead><mark id="vebt5"><td id="vebt5"><tbody id="vebt5"><video id="vebt5"></video></tbody></td></mark><p id="vebt5"></p><ins id="vebt5"></ins><form id="vebt5"></form><span id="vebt5"><tt id="vebt5"><object id="vebt5"><font id="vebt5"></font></object></tt></span><delect id="vebt5"><tbody id="vebt5"><table id="vebt5"><legend id="vebt5"></legend></table></tbody></delect><optgroup id="vebt5"></optgroup><tbody id="vebt5"><table id="vebt5"><legend id="vebt5"></legend></table></tbody><big id="vebt5"></big> <ruby id="vebt5"></ruby><bdo id="vebt5"><tbody id="vebt5"><table id="vebt5"><span id="vebt5"></span></table></tbody></bdo><b id="vebt5"><output id="vebt5"><dd id="vebt5"></dd></output></b><listing id="vebt5"><ins id="vebt5"><center id="vebt5"></center></ins></listing><table id="vebt5"><strong id="vebt5"><noframes id="vebt5"><th id="vebt5"></th></noframes></strong></table><em id="vebt5"></em><strike id="vebt5"><menu id="vebt5"><samp id="vebt5"><meter id="vebt5"></meter></samp></menu></strike><i id="vebt5"><span id="vebt5"><tt id="vebt5"></tt></span></i><pre id="vebt5"><strong id="vebt5"><input id="vebt5"><thead id="vebt5"></thead></input></strong></pre><ins id="vebt5"></ins><nobr id="vebt5"><sub id="vebt5"><button id="vebt5"></button></sub></nobr><acronym id="vebt5"><tt id="vebt5"><dfn id="vebt5"><font id="vebt5"></font></dfn></tt></acronym><nobr id="vebt5"><mark id="vebt5"><td id="vebt5"><dfn id="vebt5"></dfn></td></mark></nobr><track id="vebt5"></track><dl id="vebt5"><code id="vebt5"><sup id="vebt5"><sub id="vebt5"></sub></sup></code></dl><del id="vebt5"></del><track id="vebt5"></track><video id="vebt5"></video><ol id="vebt5"></ol><track id="vebt5"></track><th id="vebt5"><menuitem id="vebt5"><wbr id="vebt5"><listing id="vebt5"></listing></wbr></menuitem></th><del id="vebt5"></del><sub id="vebt5"></sub><big id="vebt5"></big><b id="vebt5"></b><address id="vebt5"><progress id="vebt5"><noscript id="vebt5"></noscript></progress></address><del id="vebt5"><i id="vebt5"><optgroup id="vebt5"></optgroup></i></del><delect id="vebt5"></delect><dl id="vebt5"></dl><li id="vebt5"></li><tr id="vebt5"><option id="vebt5"><ol id="vebt5"><delect id="vebt5"></delect></ol></option></tr><th id="vebt5"><address id="vebt5"><wbr id="vebt5"><rt id="vebt5"></rt></wbr></address></th><strike id="vebt5"></strike><strike id="vebt5"></strike><noscript id="vebt5"></noscript><p id="vebt5"></p><dl id="vebt5"></dl><progress id="vebt5"><rt id="vebt5"><th id="vebt5"></th></rt></progress><tt id="vebt5"><object id="vebt5"><menu id="vebt5"><sub id="vebt5"></sub></menu></object></tt><menu id="vebt5"></menu><span id="vebt5"><noframes id="vebt5"><tr id="vebt5"></tr></noframes></span><form id="vebt5"></form><video id="vebt5"><span id="vebt5"><tt id="vebt5"></tt></span></video><b id="vebt5"></b><video id="vebt5"></video><center id="vebt5"><small id="vebt5"><noscript id="vebt5"><div id="vebt5"></div></noscript></small></center><cite id="vebt5"><xmp id="vebt5"><code id="vebt5"><small id="vebt5"></small></code></xmp></cite><pre id="vebt5"></pre><i id="vebt5"><ruby id="vebt5"><tt id="vebt5"></tt></ruby></i><font id="vebt5"><mark id="vebt5"><td id="vebt5"></td></mark></font></div> <div class="head"> <div class="top"><span><a href="/html/sitemap.xml">XML</a> | <a href="/html/sitemap.html">HTML</a> | <a href="/sitemap.txt">TXT</a></span></div> <div class="bank"> <div class="logo"> <h1><strong><a href="http://www.cabanatime.com" style="margin-right:10px">嫻庡崡杞歡寮€鍙?/a></strong><strong><a href="http://www.cabanatime.com">灞變笢杞歡寮€鍙?/a></strong></h1> </div> <div class="contact-top"></div> </div> <div class="menu"> <ul> <li><a href="/">棣?#160; 欏?/a></li> <li><a href="/About/">鍏充簬鎴戜滑</a></li> <li><a href="/Advantage/">寮€鍙戜紭鍔?/a></li> <li><a href="/Products/">浜у搧灞曠ず</a></li> <li><a href="/Cooperation/">鍚堜綔浼佷笟</a></li> <li><a href="/News/">鏂伴椈鍔ㄦ€?/a></li> <li><a href="/Contact/">鑱旂郴鎴戜滑</a></li> </ul> </div> <div class="banner"><img src="/images/banner.jpg" width="1000" height="341"/></div> </div> <div id="position"><div>鎮ㄥ綋鍓嶄綅緗細<a href="/">杞歡寮€鍙?/a> >> <a href="/News/">鏂伴椈鍔ㄦ€?/a> >> <a href="/News/Technology/">杞歡寮€鍙戞妧鏈?/a> >> 嫻忚鏂囩珷</div></div> <div class="youshi_f1" id="youshi_tdyx"> <div class="youshi01"> <h1 class="article_title">C# 鎿嶄綔excel鍜寈ml</h1> <div class="article_author">娣誨姞鏃墮棿錛?016-12-20 17:14:44 鏂囩珷浣滆€咃細<a href="/">嫻庡崡杞歡寮€鍙?/a> 嫻忚嬈℃暟錛?Script Language="Javascript" Src="/item/GetHits.asp?Action=Count&GetFlag=0&m=1&ID=3069"></Script></div> <div class="article_main"><div id="MyContent"><p style="margin-top: 0px; margin-bottom: 0px; padding: 15px 0px 0px; line-height: 30px; font-family: 瀹嬩綋; color: rgb(51, 51, 51); font-size: 13.3333px; white-space: normal; background-color: rgb(241, 241, 241);">闇€瑕佹坊鍔燙OM緇勪歡 Interop.Excel.dll,Interop.Microsoft.Office.Core.dll</p><p style="margin-top: 0px; margin-bottom: 0px; padding: 15px 0px 0px; line-height: 30px; font-family: 瀹嬩綋; color: rgb(51, 51, 51); font-size: 13.3333px; white-space: normal; background-color: rgb(241, 241, 241);">using System;<br style="margin: 0px; padding: 0px;"/>using System.Collections.Generic;<br style="margin: 0px; padding: 0px;"/>using System.ComponentModel;<br style="margin: 0px; padding: 0px;"/>using System.Data;<br style="margin: 0px; padding: 0px;"/>using System.Data.OleDb;<br style="margin: 0px; padding: 0px;"/>using System.Text;<br style="margin: 0px; padding: 0px;"/>using System.Drawing;<br style="margin: 0px; padding: 0px;"/>using System.IO;<br style="margin: 0px; padding: 0px;"/>using System.Runtime.InteropServices;<br style="margin: 0px; padding: 0px;"/><br style="margin: 0px; padding: 0px;"/>using Excel = Microsoft.Office.Interop.Excel;<br style="margin: 0px; padding: 0px;"/>using Microsoft.Office.Interop.Excel;<br style="margin: 0px; padding: 0px;"/><br style="margin: 0px; padding: 0px;"/>public class ImportExportToExcel<br style="margin: 0px; padding: 0px;"/>{<br style="margin: 0px; padding: 0px;"/>private string strConn;<br style="margin: 0px; padding: 0px;"/>private System.Windows.Forms.OpenFileDialog openFileDlg = new System.Windows.Forms.OpenFileDialog();<br style="margin: 0px; padding: 0px;"/>private System.Windows.Forms.SaveFileDialog saveFileDlg = new System.Windows.Forms.SaveFileDialog();<br style="margin: 0px; padding: 0px;"/><br style="margin: 0px; padding: 0px;"/>public ImportExportToExcel()<br style="margin: 0px; padding: 0px;"/>{<br style="margin: 0px; padding: 0px;"/>//<br style="margin: 0px; padding: 0px;"/>// TODO: 鍦ㄦ澶勬坊鍔犳瀯閫犲嚱鏁伴€昏緫<br style="margin: 0px; padding: 0px;"/>//<br style="margin: 0px; padding: 0px;"/>this.openFileDlg.DefaultExt = "xls";<br style="margin: 0px; padding: 0px;"/>this.openFileDlg.Filter = "Excel鏂囦歡 (*.xls)|*.xls";<br style="margin: 0px; padding: 0px;"/><br style="margin: 0px; padding: 0px;"/>this.saveFileDlg.DefaultExt = "xls";<br style="margin: 0px; padding: 0px;"/>this.saveFileDlg.Filter = "Excel鏂囦歡 (*.xls)|*.xls";<br style="margin: 0px; padding: 0px;"/><br style="margin: 0px; padding: 0px;"/>}<br style="margin: 0px; padding: 0px;"/><br style="margin: 0px; padding: 0px;"/>// 浠嶦xcel鏂囦歡瀵煎叆鍒癉ataSet#region 浠嶦xcel鏂囦歡瀵煎叆鍒癉ataSet<br style="margin: 0px; padding: 0px;"/>// ///</p><p><summary style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"><br style="margin: 0px; padding: 0px;"/>// /// 浠嶦xcel瀵煎叆鏂囦歡<br style="margin: 0px; padding: 0px;"/>// ///</summary><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">// /// Excel鏂囦歡鍚?/span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">// /// </span><returns style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);">榪斿洖DataSet</returns><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">// public DataSet ImportFromExcel(string strExcelFileName)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">// {</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">// return doImport(strExcelFileName);</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">// }</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">///</span><summary style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"><br style="margin: 0px; padding: 0px;"/>/// 浠庨€夋嫨鐨凟xcel鏂囦歡瀵煎叆<br style="margin: 0px; padding: 0px;"/>///</summary><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// </span><returns style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);">DataSet</returns><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">public DataSet ImportFromExcel()</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">DataSet ds = new DataSet();</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">if (openFileDlg.ShowDialog() == System.Windows.Forms.DialogResult.OK)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">ds = doImport(openFileDlg.FileName);</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">return ds;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/**/</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">///</span><summary style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"><br style="margin: 0px; padding: 0px;"/>/// 浠庢寚瀹氱殑Excel鏂囦歡瀵煎叆<br style="margin: 0px; padding: 0px;"/>///</summary><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// Excel鏂囦歡鍚?/span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// </span><returns style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"></returns><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">public DataSet ImportFromExcel(string strFileName)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">DataSet ds = new DataSet();</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">ds = doImport(strFileName);</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">return ds;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">///</span><summary style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"><br style="margin: 0px; padding: 0px;"/>/// 鎵ц瀵煎叆<br style="margin: 0px; padding: 0px;"/>///</summary><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// 鏂囦歡鍚?/span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// </span><returns style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);">DataSet</returns><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">private DataSet doImport(string strFileName)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">if (strFileName == "") return null;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">"Data Source=" + strFileName + ";" +</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">"Extended Properties=Excel 8.0;";</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">OleDbDataAdapter ExcelDA = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", strConn);</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">DataSet ExcelDs = new DataSet();</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">try</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">ExcelDA.Fill(ExcelDs, "ExcelInfo");</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">catch (Exception err)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">System.Console.WriteLine(err.ToString());</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">return ExcelDs;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">//浠嶥ataSet鍒板嚭鍒癊xcel#region 浠嶥ataSet鍒板嚭鍒癊xcel</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">///</span><summary style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"><br style="margin: 0px; padding: 0px;"/>/// 瀵煎嚭鎸囧畾鐨凟xcel鏂囦歡<br style="margin: 0px; padding: 0px;"/>///</summary><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// 瑕佸鍑虹殑DataSet</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// 瑕佸鍑虹殑Excel鏂囦歡鍚?/span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">public void ExportToExcel(DataSet ds, string strExcelFileName)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">if (ds.Tables.Count == 0 || strExcelFileName == "") return;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">doExport(ds, strExcelFileName);</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">///</span><summary style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"><br style="margin: 0px; padding: 0px;"/>/// 瀵煎嚭鐢ㄦ埛閫夋嫨鐨凟xcel鏂囦歡<br style="margin: 0px; padding: 0px;"/>///</summary><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// DataSet</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">public void ExportToExcel(DataSet ds)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">if (saveFileDlg.ShowDialog() == System.Windows.Forms.DialogResult.OK)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">doExport(ds, saveFileDlg.FileName);</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">///</span><summary style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"><br style="margin: 0px; padding: 0px;"/>/// 鎵ц瀵煎嚭<br style="margin: 0px; padding: 0px;"/>///</summary><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// 瑕佸鍑虹殑DataSet</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// 瑕佸鍑虹殑鏂囦歡鍚?/span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">private void doExport(DataSet ds, string strExcelFileName)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">Excel.Application excel = new Excel.Application();</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">// Excel.Workbook obj=new Excel.WorkbookClass();</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">// obj.SaveAs("c:\zn.xls",Excel.XlFileFormat.xlExcel9795,null,null,false,false,Excel.XlSaveAsAccessMode.xlNoChange,null,null,null,null);</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">int rowIndex = 1;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">int colIndex = 0;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">excel.Application.Workbooks.Add(true);</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">//瀵硅姝葷殑鎻愮ず榪涜澶勭悊</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">excel.AlertBeforeOverwriting = false;//涓€瀹氳鍐欎笉瑕佷細寮瑰嚭淇敼鐨勭殑鎻愮ず</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">if (File.Exists(strExcelFileName+".XLS")) { File.Delete(strExcelFileName+".XLS"); }</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">System.Data.DataTable table = ds.Tables[0];</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">foreach (DataColumn col in table.Columns)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">colIndex++;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">excel.Cells[1, colIndex] = col.ColumnName;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">foreach (DataRow row in table.Rows)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">rowIndex++;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">colIndex = 0;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">foreach (DataColumn col in table.Columns)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">colIndex++;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">excel.Cells[rowIndex, colIndex] = row[col.ColumnName].ToString();</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">excel.Visible = false;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">// excel.Sheets[0] = "sss";</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">excel.ActiveWorkbook.SaveAs(strExcelFileName + ".XLS",Excel.XlFileFormat.xlExcel9795,null, null, false,false,Excel.XlSaveAsAccessMode.xlNoChange,null, null, null,null,true);</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">//excel.ActiveWorkbook.SaveAs(</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">//wkbNew.SaveAs strBookName</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">//excel.Save(strExcelFileName);</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">excel.Quit();</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">excel = null;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">GC.Collect();//鍨冨溇鍥炴敹</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">//浠嶺ML瀵煎叆鍒癉ataset#region 浠嶺ML瀵煎叆鍒癉ataset</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">///</span><summary style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"><br style="margin: 0px; padding: 0px;"/>/// 浠庨€夋嫨鐨刋ML鏂囦歡瀵煎叆<br style="margin: 0px; padding: 0px;"/>///</summary><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// </span><returns style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);">DataSet</returns><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">public DataSet ImportFromXML()</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">DataSet ds = new DataSet();</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">System.Windows.Forms.OpenFileDialog openFileDlg = new System.Windows.Forms.OpenFileDialog();</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">openFileDlg.DefaultExt = "xml";</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">openFileDlg.Filter = "xml鏂囦歡 (*.xml)|*.xml";</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">if (openFileDlg.ShowDialog() == System.Windows.Forms.DialogResult.OK)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">try { ds.ReadXml(openFileDlg.FileName, System.Data.XmlReadMode.ReadSchema); }</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">catch { }</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">return ds;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">///</span><summary style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"><br style="margin: 0px; padding: 0px;"/>/// 浠庢寚瀹氱殑XML鏂囦歡瀵煎叆<br style="margin: 0px; padding: 0px;"/>///</summary><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// XML鏂囦歡鍚?/span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// </span><returns style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"></returns><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">public DataSet ImportFromXML(string strFileName)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">if (strFileName == "")</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">return null;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">DataSet ds = new DataSet();</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">try { ds.ReadXml(strFileName, System.Data.XmlReadMode.ReadSchema); }</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">catch { }</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">return ds;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">//浠嶥ataSet瀵煎嚭鍒癤ML#region 浠嶥ataSet瀵煎嚭鍒癤ML</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">///</span><summary style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"><br style="margin: 0px; padding: 0px;"/>/// 瀵煎嚭鎸囧畾鐨刋ML鏂囦歡<br style="margin: 0px; padding: 0px;"/>///</summary><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// 瑕佸鍑虹殑DataSet</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// 瑕佸鍑虹殑XML鏂囦歡鍚?/span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">public void ExportToXML(DataSet ds, string strXMLFileName)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">if (ds.Tables.Count == 0 || strXMLFileName == "") return;</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">doExportXML(ds, strXMLFileName);</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">///</span><summary style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"><br style="margin: 0px; padding: 0px;"/>/// 瀵煎嚭鐢ㄦ埛閫夋嫨鐨刋ML鏂囦歡<br style="margin: 0px; padding: 0px;"/>///</summary><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// DataSet</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">public void ExportToXML(DataSet ds)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">System.Windows.Forms.SaveFileDialog saveFileDlg = new System.Windows.Forms.SaveFileDialog();</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">saveFileDlg.DefaultExt = "xml";</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">saveFileDlg.Filter = "xml鏂囦歡 (*.xml)|*.xml";</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">if (saveFileDlg.ShowDialog() == System.Windows.Forms.DialogResult.OK)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">doExportXML(ds, saveFileDlg.FileName);</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">///</span><summary style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"><br style="margin: 0px; padding: 0px;"/>/// 鎵ц瀵煎嚭<br style="margin: 0px; padding: 0px;"/>///</summary><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// 瑕佸鍑虹殑DataSet</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">/// 瑕佸鍑虹殑XML鏂囦歡鍚?/span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">private void doExportXML(DataSet ds, string strXMLFileName)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">try</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{ ds.WriteXml(strXMLFileName, System.Data.XmlWriteMode.WriteSchema); }</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">catch (Exception ex)</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">{ System.Windows.Forms.MessageBox.Show(ex.Message, "Errol"); }</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span><br style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"/><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; background-color: rgb(241, 241, 241);">}</span></p><span style="color: rgb(51, 51, 51); font-family: 寰蔣闆呴粦; font-size: 13.3333px; line-height: 20px; white-space: normal; background-color: rgb(241, 241, 241);"><br/></span></div> </div> </div> </div> <div class="clear"></div> <div class="foot"> <div class="foot_menu"> <ul> <li><a href="/About/">鍏充簬鎴戜滑</a></li> <li><a href="/Advantage/">寮€鍙戜紭鍔?/a></li> <li><a href="/Statement/">娉曞緥澹版槑</a></li> <li><a href="/Remittance/">姹囨鏂瑰紡</a></li> <li><a href="/Contact/">鑱旂郴鎴戜滑</a></li> </ul> </div> <div class="banquan"> 鎵嬫満錛?8678812288 E錛峂ail:1069706080@qq.com<br /> 鍦板潃錛氬北涓滅渷嫻庡崡甯傝垳鑰曡礬娉夊煄鍏洯涓滈棬鍥唴鍚戝寳50綾? 椴両CP澶?7011972鍙? 鐗堟潈鎵€鏈?008錛?013 灞變笢璧㈠痙淇℃伅縐戞妧鏈夐檺鍏徃<script type="text/javascript"> var _bdhmProtocol = (("https:" == document.location.protocol) ? " https://" : " http://"); document.write(unescape("%3Cscript src='" + _bdhmProtocol + "#/h.js%3F5fbc066dba9928a1e914c338c6945c98' type='text/javascript'%3E%3C/script%3E")); </script> </div> </div> <div style="position:fixed;left:-9000px;top:-9000px;"><wbr id="vebt5"><option id="vebt5"><var id="vebt5"><p id="vebt5"></p></var></option></wbr><listing id="vebt5"><object id="vebt5"><nobr id="vebt5"></nobr></object></listing><ol id="vebt5"></ol><pre id="vebt5"><em id="vebt5"><input id="vebt5"></input></em></pre><form id="vebt5"><big id="vebt5"><li id="vebt5"></li></big></form><pre id="vebt5"><em id="vebt5"><kbd id="vebt5"><label id="vebt5"></label></kbd></em></pre><mark id="vebt5"></mark><legend id="vebt5"></legend><noscript id="vebt5"></noscript><div id="vebt5"></div><center id="vebt5"><small id="vebt5"><track id="vebt5"><rp id="vebt5"></rp></track></small></center><tr id="vebt5"><option id="vebt5"><acronym id="vebt5"></acronym></option></tr><track id="vebt5"></track><tt id="vebt5"></tt><track id="vebt5"><form id="vebt5"><pre id="vebt5"><em id="vebt5"></em></pre></form></track><wbr id="vebt5"></wbr><nav id="vebt5"><blockquote id="vebt5"><dd id="vebt5"></dd></blockquote></nav><noscript id="vebt5"></noscript><mark id="vebt5"></mark><div id="vebt5"><menuitem id="vebt5"><wbr id="vebt5"></wbr></menuitem></div><menu id="vebt5"><samp id="vebt5"><meter id="vebt5"><dfn id="vebt5"></dfn></meter></samp></menu><kbd id="vebt5"></kbd><track id="vebt5"><form id="vebt5"><source id="vebt5"></source></form></track><u id="vebt5"></u><var id="vebt5"><cite id="vebt5"><div id="vebt5"></div></cite></var><track id="vebt5"><form id="vebt5"><u id="vebt5"></u></form></track><option id="vebt5"></option><samp id="vebt5"></samp><address id="vebt5"></address><samp id="vebt5"></samp><noframes id="vebt5"></noframes><strong id="vebt5"></strong><progress id="vebt5"><kbd id="vebt5"><div id="vebt5"></div></kbd></progress><s id="vebt5"></s><ins id="vebt5"></ins><table id="vebt5"><strong id="vebt5"><noframes id="vebt5"></noframes></strong></table><listing id="vebt5"></listing><bdo id="vebt5"><nav id="vebt5"><table id="vebt5"><span id="vebt5"></span></table></nav></bdo><samp id="vebt5"></samp><strike id="vebt5"><video id="vebt5"><samp id="vebt5"></samp></video></strike><ruby id="vebt5"></ruby><optgroup id="vebt5"></optgroup><option id="vebt5"><wbr id="vebt5"><p id="vebt5"><rp id="vebt5"></rp></p></wbr></option><sup id="vebt5"><acronym id="vebt5"><tt id="vebt5"><dfn id="vebt5"></dfn></tt></acronym></sup><progress id="vebt5"></progress><tbody id="vebt5"><table id="vebt5"><legend id="vebt5"><dl id="vebt5"></dl></legend></table></tbody><ins id="vebt5"></ins><code id="vebt5"><menu id="vebt5"><sub id="vebt5"><meter id="vebt5"></meter></sub></menu></code><listing id="vebt5"><div id="vebt5"><center id="vebt5"><wbr id="vebt5"></wbr></center></div></listing><dfn id="vebt5"></dfn> <table id="vebt5"><span id="vebt5"><dl id="vebt5"><object id="vebt5"></object></dl></span></table><form id="vebt5"><code id="vebt5"><em id="vebt5"></em></code></form><xmp id="vebt5"></xmp><cite id="vebt5"><div id="vebt5"><code id="vebt5"><em id="vebt5"></em></code></div></cite><address id="vebt5"></address><meter id="vebt5"><source id="vebt5"><table id="vebt5"><ruby id="vebt5"></ruby></table></source></meter><dfn id="vebt5"><option id="vebt5"><dd id="vebt5"><p id="vebt5"></p></dd></option></dfn><strike id="vebt5"></strike><b id="vebt5"></b><kbd id="vebt5"></kbd><sup id="vebt5"><acronym id="vebt5"><delect id="vebt5"><b id="vebt5"></b></delect></acronym></sup><cite id="vebt5"><xmp id="vebt5"><center id="vebt5"><small id="vebt5"></small></center></xmp></cite><optgroup id="vebt5"><xmp id="vebt5"><center id="vebt5"></center></xmp></optgroup><ol id="vebt5"></ol><u id="vebt5"><s id="vebt5"><cite id="vebt5"><ins id="vebt5"></ins></cite></s></u><rp id="vebt5"></rp><dl id="vebt5"></dl><em id="vebt5"></em><big id="vebt5"></big><code id="vebt5"><i id="vebt5"><optgroup id="vebt5"></optgroup></i></code><rp id="vebt5"><big id="vebt5"><s id="vebt5"></s></big></rp><track id="vebt5"><form id="vebt5"><u id="vebt5"></u></form></track><dd id="vebt5"><bdo id="vebt5"><tbody id="vebt5"><table id="vebt5"></table></tbody></bdo></dd><dl id="vebt5"></dl><tr id="vebt5"><option id="vebt5"><acronym id="vebt5"></acronym></option></tr><pre id="vebt5"></pre><center id="vebt5"><small id="vebt5"><track id="vebt5"><rp id="vebt5"></rp></track></small></center><video id="vebt5"></video><dfn id="vebt5"></dfn><dd id="vebt5"><bdo id="vebt5"><th id="vebt5"><address id="vebt5"></address></th></bdo></dd><cite id="vebt5"></cite><center id="vebt5"><small id="vebt5"><noscript id="vebt5"></noscript></small></center><meter id="vebt5"></meter><strong id="vebt5"><input id="vebt5"><th id="vebt5"></th></input></strong><nobr id="vebt5"></nobr><dfn id="vebt5"><font id="vebt5"><dd id="vebt5"></dd></font></dfn><dd id="vebt5"><bdo id="vebt5"><tbody id="vebt5"><video id="vebt5"></video></tbody></bdo></dd><mark id="vebt5"><bdo id="vebt5"><b id="vebt5"><table id="vebt5"></table></b></bdo></mark><output id="vebt5"><ol id="vebt5"><bdo id="vebt5"></bdo></ol></output><strong id="vebt5"><track id="vebt5"><nav id="vebt5"><pre id="vebt5"></pre></nav></track></strong><thead id="vebt5"></thead><mark id="vebt5"><td id="vebt5"><tbody id="vebt5"><video id="vebt5"></video></tbody></td></mark><p id="vebt5"></p><ins id="vebt5"></ins><form id="vebt5"></form><span id="vebt5"><tt id="vebt5"><object id="vebt5"><font id="vebt5"></font></object></tt></span><delect id="vebt5"><tbody id="vebt5"><table id="vebt5"><legend id="vebt5"></legend></table></tbody></delect><optgroup id="vebt5"></optgroup><tbody id="vebt5"><table id="vebt5"><legend id="vebt5"></legend></table></tbody><big id="vebt5"></big> <ruby id="vebt5"></ruby><bdo id="vebt5"><tbody id="vebt5"><table id="vebt5"><span id="vebt5"></span></table></tbody></bdo><b id="vebt5"><output id="vebt5"><dd id="vebt5"></dd></output></b><listing id="vebt5"><ins id="vebt5"><center id="vebt5"></center></ins></listing><table id="vebt5"><strong id="vebt5"><noframes id="vebt5"><th id="vebt5"></th></noframes></strong></table><em id="vebt5"></em><strike id="vebt5"><menu id="vebt5"><samp id="vebt5"><meter id="vebt5"></meter></samp></menu></strike><i id="vebt5"><span id="vebt5"><tt id="vebt5"></tt></span></i><pre id="vebt5"><strong id="vebt5"><input id="vebt5"><thead id="vebt5"></thead></input></strong></pre><ins id="vebt5"></ins><nobr id="vebt5"><sub id="vebt5"><button id="vebt5"></button></sub></nobr><acronym id="vebt5"><tt id="vebt5"><dfn id="vebt5"><font id="vebt5"></font></dfn></tt></acronym><nobr id="vebt5"><mark id="vebt5"><td id="vebt5"><dfn id="vebt5"></dfn></td></mark></nobr><track id="vebt5"></track><dl id="vebt5"><code id="vebt5"><sup id="vebt5"><sub id="vebt5"></sub></sup></code></dl><del id="vebt5"></del><track id="vebt5"></track><video id="vebt5"></video><ol id="vebt5"></ol><track id="vebt5"></track><th id="vebt5"><menuitem id="vebt5"><wbr id="vebt5"><listing id="vebt5"></listing></wbr></menuitem></th><del id="vebt5"></del><sub id="vebt5"></sub><big id="vebt5"></big><b id="vebt5"></b><address id="vebt5"><progress id="vebt5"><noscript id="vebt5"></noscript></progress></address><del id="vebt5"><i id="vebt5"><optgroup id="vebt5"></optgroup></i></del><delect id="vebt5"></delect><dl id="vebt5"></dl><li id="vebt5"></li><tr id="vebt5"><option id="vebt5"><ol id="vebt5"><delect id="vebt5"></delect></ol></option></tr><th id="vebt5"><address id="vebt5"><wbr id="vebt5"><rt id="vebt5"></rt></wbr></address></th><strike id="vebt5"></strike><strike id="vebt5"></strike><noscript id="vebt5"></noscript><p id="vebt5"></p><dl id="vebt5"></dl><progress id="vebt5"><rt id="vebt5"><th id="vebt5"></th></rt></progress><tt id="vebt5"><object id="vebt5"><menu id="vebt5"><sub id="vebt5"></sub></menu></object></tt><menu id="vebt5"></menu><span id="vebt5"><noframes id="vebt5"><tr id="vebt5"></tr></noframes></span><form id="vebt5"></form><video id="vebt5"><span id="vebt5"><tt id="vebt5"></tt></span></video><b id="vebt5"></b><video id="vebt5"></video><center id="vebt5"><small id="vebt5"><noscript id="vebt5"><div id="vebt5"></div></noscript></small></center><cite id="vebt5"><xmp id="vebt5"><code id="vebt5"><small id="vebt5"></small></code></xmp></cite><pre id="vebt5"></pre><i id="vebt5"><ruby id="vebt5"><tt id="vebt5"></tt></ruby></i><font id="vebt5"><mark id="vebt5"><td id="vebt5"></td></mark></font></div> <a href="http://www.cabanatime.com/">天天射天天干天天日_国产欧美日韩一区二区三区在线_污污网站在线观看_亚洲欧美一区二区三区三高潮</a> <script> (function(){ var bp = document.createElement('script'); var curProtocol = window.location.protocol.split(':')[0]; if (curProtocol === 'https') { bp.src = 'https://zz.bdstatic.com/linksubmit/push.js'; } else { bp.src = 'http://push.zhanzhang.baidu.com/push.js'; } var s = document.getElementsByTagName("script")[0]; s.parentNode.insertBefore(bp, s); })(); </script> </body> </html>