{"id":155,"date":"2010-05-25T11:32:06","date_gmt":"2010-05-25T03:32:06","guid":{"rendered":"http:\/\/nick.workao.org\/?p=155"},"modified":"2010-05-25T11:32:06","modified_gmt":"2010-05-25T03:32:06","slug":"%e9%80%9a%e8%bf%87excel%e8%87%aa%e5%b8%a6%e7%9a%84%e6%9f%a5%e8%af%a2%e5%88%86%e6%9e%90%e5%99%a8%e5%bf%ab%e9%80%9f%e5%ae%8c%e6%88%90%e4%bb%8esql-server%e4%b8%ad%e5%af%bc%e5%87%ba%e6%95%b0%e6%8d%ae","status":"publish","type":"post","link":"https:\/\/nick.txtcc.com\/index.php\/win\/155","title":{"rendered":"\u901a\u8fc7Excel\u81ea\u5e26\u7684\u67e5\u8be2\u5206\u6790\u5668\u5feb\u901f\u5b8c\u6210\u4eceSQL Server\u4e2d\u5bfc\u51fa\u6570\u636e\u7684\u4f8b\u5b50(\u901a\u7528\u7c7b)"},"content":{"rendered":"<p dir=\"ltr\">\u8fd9\u662f\u4e00\u4e2a\u4f7f\u7528Excel\u4e2d\u67e5\u8be2\u5206\u6790\u5668(Ms\u901a\u7528\u67e5\u8be2\u5206\u6790\u5668)\u5b8c\u6210\u4ece  SQL Server  7.0\u4ee5\u4e0a\u7248\u672c(\u5df2\u901a\u8fc7\u6d4b\u8bd5)\u7684\u6570\u636e\u5feb\u901f\u5bfc\u51fa\u5230Excel\u4e2d\u7684\u793a\u4f8b\u3002\u5b83\u7531\u4e24\u4e2a\u53c2\u6570\u5b8c\u6210\uff0c\u5176\u4e2d\u7684\u7b2c\u4e00\u4e2a\u662f\u4f60\u6240\u8981\u8fdb\u884c\u67e5\u8be2\u5206\u6790\u65f6\u4f7f\u7528\u7684Select\u67e5\u8be2\u8bed\u53e5\u3002  \u4e3a\u4e86\u597d\u770b\uff0c\u6211\u4eec\u7ed9\u6211\u4eec\u5bfc\u51fa\u7684\u6570\u636e\u52a0\u4e0a\u4e00\u4e2a\u540d\u79f0\u3002\u540d\u79f0\uff0c\u7531\u7b2c\u4e8c\u4e2a\u53c2\u6570\u4f20\u9012\u8fdb\u6765\uff1a\uff09\u597d\u4e86\uff0c\u4e0d\u8bf4\u4ec0\u4e48\u5e9f\u8bdd\u4e86\u3002\u5927\u5bb6\u770b\u4ee3\u7801\u5427\u3002<\/p>\n<p dir=\"ltr\">using System;\nusing Excel;\nnamespace \u7c7b\u5e93\n{\npublic class Excel\u5bfc\u51fa\n{\npublic Excel\u5bfc\u51fa(string \u67e5\u8be2\u8bed\u53e5,string \u6807\u9898)\n{\nExcel.Application excel;\nExcel._Workbook xBk;\nExcel._Worksheet xSt;\nExcel._QueryTable xQt;\nstring Conn = &#8220;ODBC;DRIVER=SQL  Server;SERVER=[\u670d\u52a1\u5668\u5730\u5740\u6216\u8005\u540d\u79f0];UID=sa;PWD=[\u5bc6\u7801];APP=[\u5e94\u7528\u7a0b\u5e8f\u540d\u79f0(\u4e00\u822c\u4e3a\u64cd\u4f5c\u7cfb\u7edf\u540d)];WSID=[\u5de5  \u4f5c\u7ad9\u540d\u79f0(\u5ba2\u6237\u7aef)];DATABASE=[\u6570\u636e\u5e93\u540d\u79f0]&#8221;;\nstring Select = \u67e5\u8be2\u8bed\u53e5;\nexcel = new Excel.ApplicationClass();\nxBk = excel.Workbooks.Add(true);\nxSt = (Excel._Worksheet)xBk.ActiveSheet;\nexcel.Cells[2,2] = \u6807\u9898;\nxSt.get_Range(excel.Cells[2,2],excel.Cells[2,2]).Font.Bold =  true;\nxSt.get_Range(excel.Cells[2,2],excel.Cells[2,2]).Font.Name =  &#8220;\u9ed1\u4f53&#8221;;\nxSt.get_Range(excel.Cells[2,2],excel.Cells[2,2]).Font.Size =  22;\nxQt =  xSt.QueryTables.Add(Conn,xSt.get_Range(excel.Cells[4,2],excel.Cells[4,2]),Select);\nxQt.Name = &#8220;\u5bfc\u51fa\u793a\u4f8b&#8221;;\nxQt.FieldNames = true;\nxQt.RowNumbers = false;\nxQt.FillAdjacentFormulas = false;\nxQt.PreserveFormatting = false;\nxQt.BackgroundQuery = true;\nxQt.RefreshStyle =  Excel.XlCellInsertionMode.xlInsertDeleteCells;\nxQt.AdjustColumnWidth = true;\nxQt.RefreshPeriod = 0;\nxQt.PreserveColumnInfo = true;\nxQt.Refresh(xQt.BackgroundQuery);\nexcel.Visible = true;\n}\n}\n}<\/p>\n<p dir=\"ltr\">\u5168\u4e2d\u6587\u7684\uff0c\u4e0d\u7528\u8fdb\u884c\u89e3\u91ca\u4e86\u5427\uff1f<\/p>\n<p dir=\"ltr\">\u539f\u6765\u8fdb\u884c\u6570\u636e\u5bfc\u51fa\u64cd\u4f5c(\u76f8\u5173\u8fde\u63a5<a href=\"http:\/\/www.csdn.net\/Develop\/Read_Article.asp?Id=21391\">http:\/\/www.csdn.net\/Develop\/Read_Article.asp?Id=21391<\/a>)\uff0c \u4e09\u767e\u6761\u8bb0\u5f55\uff0c\u7528\u65f6\u5341\u5206\u949f\u4ee5\u4e0a\u3002\u5982\u679c\u4f7f\u7528Excel\u81ea\u5e26\u7684\u8fd9\u4e00\u4e2a\u67e5\u8be2\u5de5\u5177\uff0c\u5bfc\u51fa\u4e00\u4e07\u6761\u8bb0\u5f55\uff0c\u53ea\u9700\u5341\u79d2\u949f\u4ee5\u5185\u7684\u65f6\u95f4\uff0c\u800c\u4e14\uff0c\u53ef\u4ee5\u5b8c\u6210\u683c\u5f0f\u81ea\u52a8\u6392\u7248\u7684\u529f\u80fd\u3002<\/p>\n<p dir=\"ltr\">\u53ef\u80fd\u6709\u4eba\u4f1a\u95ee\uff1aExcel\u91cc\u9762\u7684\u67e5\u8be2\u8bed\u53e5\u4e0eSQL  Server\u91cc\u9762\u7684\u67e5\u8be2\u8bed\u53e5\u662f\u4e0d\u662f\u4e00\u6837\u7684\uff1f\u8fd9\u91cc\u8bf4\u660e\u4e00\u70b9\u3002\u4f7f\u7528\u8fd9\u4e2a\u7c7b\uff0c\u53ef\u4ee5\u76f4\u63a5\u4f7f\u7528SQL Server\u91cc\u9762\u7684\u67e5\u8be2\u8bed\u53e5\uff0c\u5305\u62ec\u76f4\u63a5\u4f20\u9012SQL  Server\u7684\u5b58\u50a8\u8fc7\u7a0b\u3002<\/p>","protected":false},"excerpt":{"rendered":"<p>\u8fd9\u662f\u4e00\u4e2a\u4f7f\u7528Excel\u4e2d\u67e5\u8be2\u5206\u6790\u5668(Ms\u901a\u7528\u67e5\u8be2\u5206\u6790\u5668)\u5b8c\u6210\u4ece SQL Server 7.0\u4ee5\u4e0a\u7248\u672c(\u5df2\u901a\u8fc7\u6d4b\u8bd5)\u7684\u6570\u636e\u5feb\u901f\u5bfc\u51fa\u5230Excel\u4e2d\u7684\u793a\u4f8b\u3002\u5b83\u7531\u4e24\u4e2a\u53c2\u6570\u5b8c\u6210\uff0c\u5176\u4e2d\u7684\u7b2c\u4e00\u4e2a\u662f\u4f60\u6240\u8981\u8fdb\u884c\u67e5\u8be2\u5206\u6790&#46;&#46;&#46;<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[102,103,104],"class_list":["post-155","post","type-post","status-publish","format-standard","hentry","category-win","tag-excel","tag-sql-server","tag-104"],"_links":{"self":[{"href":"https:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/posts\/155","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/comments?post=155"}],"version-history":[{"count":1,"href":"https:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/posts\/155\/revisions"}],"predecessor-version":[{"id":156,"href":"https:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/posts\/155\/revisions\/156"}],"wp:attachment":[{"href":"https:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/media?parent=155"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/categories?post=155"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nick.txtcc.com\/index.php\/wp-json\/wp\/v2\/tags?post=155"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}