ASP.NET VB\u8bfb\u53d6EXCEL\u8868\u683c<\/p>\n
\/\/\u5b9a\u4e49\u8981\u4e0a\u4f20\u7684\u6587\u4ef6\u540d<\/span> ASP.NET VB\u8bfb\u53d6EXCEL\u8868\u683c \/\/\u5b9a\u4e49\u8981\u4e0a\u4f20\u7684\u6587\u4ef6\u540d Dim filename As String […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[44],"tags":[],"class_list":["post-4573","post","type-post","status-publish","format-standard","hentry","category-sql"],"_links":{"self":[{"href":"https:\/\/itoau.com\/index.php?rest_route=\/wp\/v2\/posts\/4573","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/itoau.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/itoau.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/itoau.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/itoau.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4573"}],"version-history":[{"count":3,"href":"https:\/\/itoau.com\/index.php?rest_route=\/wp\/v2\/posts\/4573\/revisions"}],"predecessor-version":[{"id":4576,"href":"https:\/\/itoau.com\/index.php?rest_route=\/wp\/v2\/posts\/4573\/revisions\/4576"}],"wp:attachment":[{"href":"https:\/\/itoau.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4573"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/itoau.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4573"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/itoau.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4573"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nDim filename As String = xlsupload.FileName<\/span>
\n\/\/\u5b9a\u4e49\u4e0a\u4f20\u8def\u5f84\uff08\u9879\u76ee\u6839\u76ee\u5f55\uff09
\nDim savePath = Server.MapPath(“~\/”) + filename<\/span>
\n\/\/\u4e0a\u4f20\u6587\u4ef6
\nxlsupload.PostedFile.SaveAs(Trim(savePath))<\/span>
\n\/\/\u5b9a\u4e49\u5185\u5b58\u8868
\nDim xlstable = New DataTable<\/span>
\n\/\/\u5b9a\u4e49\u8fde\u63a5\u5b57\u7b26\u4e32
\nDim MyConnectionString As String = “Provider=Microsoft.ACE.OLEDB.12.0;Data Source=” + savePath + “;Extended Properties=’Excel 12.0 Xml;HDR=YES’;”<\/span>
\n\/\/\u8bfb\u53d6\u8fc7\u7a0b
\nUsing xlscon As New OleDb.OleDbConnection(MyConnectionString)<\/span>
\nxlscon.Open()<\/span>
\n\/\/\u5b9a\u4e49Sheet\u8868\u540d\u5217\u8868
\nDim excelsheetlist As New DataTable<\/span>
\n\/\/\u53d6\u5f97Sheet\u8868\u540d
\nexcelsheetlist = xlscon.GetSchema(“Tables”)<\/span>
\n\/\/\u5c06Sheet\u8868\u540d\u6dfb\u52a0\u5230DropListDown\u63a7\u4ef6
\nSheetList.Items.Clear()<\/span>
\nFor i As Integer = 0 To excelsheetlist.Rows.Count – 1<\/span>
\n‘ \u83b7\u53d6sheet\u7684\u540d\u79f0
\nDim sheetName As String = Replace(excelsheetlist.Rows(i).Item(“TABLE_NAME”), “$”, “”)<\/span>
\nSheetList.Items.Add(sheetName)<\/span>
\nNext<\/span>
\n\/\/\u67e5\u8be2\u6307\u5b9aSheet\u8868\u5185\u7684\u6570\u636e
\ndim xlssqlstr as String = “select * from [” + SheetList.Text + “$]”<\/span>
\nDim XlsAda As New OleDb.OleDbDataAdapter(xlssqlstr, xlscon)<\/span>
\nDim xlstable = New DataTable<\/span>
\nXlsAda.Fill(xlstable)<\/span>
\nxlshelp.DataSource = xlstable<\/span>
\nxlshelp.DataBind()<\/span>
\nEnd Using<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"