VB.NET 讀取 Excel 文件（不使用 Interop）| IronXL

相关文章推荐

聪明的小狗 · 荣格认知功能测试【标准版】· 2 月前 ·

踢足球的茄子 · 11/02/21：大连理工大学陆文琪副教授学 ...· 3 月前 ·

旅途中的小熊猫 · 2023北京动物园旅游攻略之大熊猫馆-大熊猫 ...· 1 年前 ·

帅气的鸵鸟 · 天津｜2023年卫生管理研究职称考试报名的通 ...· 1 年前 ·

卖萌的小马驹 · 武汉部分高中高考喜报出炉，中考志愿你填对了吗 ...· 1 年前 ·

</noscript><nav id="desktop_nav" class="sticky-top d-none d-md-block" data-page-lockedmenu="false"><div class="titleBar dark"><div class="titleLogo"><a href="/zh-hant/"><svg width="17" height="15" viewbox="0 0 17 15" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M16.28 3.25317L15.5902 5.65762H9.93359L10.5774 3.25317H16.28Z" fill="#FDA509"/><path d="M6.30046 8.53589L5.65661 10.9875H0L0.597848 8.53589H6.30046Z" fill="#63C1A0"/><path d="M7.67937 3.25317L7.03552 5.65762H1.37891L2.02275 3.25317H7.67937Z" fill="#FDA509"/><path d="M7.03701 5.65919H4.59961L6.07125 0H8.50865L7.03701 5.65919Z" fill="#E01A59"/><path d="M14.8551 8.53589L14.2113 10.9875H8.55469L9.19853 8.53589H14.8551Z" fill="#63C1A0"/><path d="M10.164 14.2422H7.72656L9.19821 8.53589H11.6356L10.164 14.2422Z" fill="#89D3DF"/><path d="M12.417 5.65919H9.93359L11.4512 0H13.8886L12.417 5.65919Z" fill="#89D3DF"/><path d="M4.82909 14.2422H2.3457L3.81733 8.53589H6.30074L4.82909 14.2422Z" fill="#E01A59"/></svg> <span class="iron_name"><strong>IRON</strong>SOFTWARE</span></a></div><ul class="titleMenu"><li><a href="" class="collapseHover" data-bs-target="#collapseMenuProducts">產品<i class="fas fa-caret-down"/></a></li><li><a href="/zh-hant/enterprise/" class="collapseHover" data-bs-target="#collapseMenuEnterprise">企業<i class="fas fa-caret-down"/></a></li><li><a href="" class="collapseHover" data-bs-target="#collapseMenuOpenSource">開源<i class="fas fa-caret-down"/></a></li><li><a href="" class="collapseHover" data-bs-target="#collapseMenuAboutUs">關於我們<i class="fas fa-caret-down"/></a></li><li><a href="/zh-hant/contact-us/" target="_blank" class="">聯絡我們</a></li></ul><div class="titleRight"><div class="d-none d-xl-block iron_address overflow-hidden">205 N. Michigan Ave. Chicago, IL 60601, USA</div><div class="d-block" style="flex:0 1 15px;"/><div class="d-none d-xl-block iron_phone">+1 (312) 500-3060</div><div class="d-block" style="flex:0 1 32px;"/><div class="iron_slack d-none d-lg-block"><a class="d-flex align-items-center" href="/zh-hant/company/iron-slack-community/"><span class="iron_slack_logo d-block"><svg width="14" height="14" viewbox="0 0 14 14" fill="none" xmlns="http://www.w3.org/2000/svg" class=""><path d="M2.95147 8.85032C2.95147 9.66401 2.29435 10.3217 1.4813 10.3217C0.668258 10.3217 0.0111376 9.66401 0.0111376 8.85032C0.0111376 8.03662 0.668258 7.37898 1.4813 7.37898H2.95147V8.85032ZM3.68655 8.85032C3.68655 8.03662 4.34368 7.37898 5.15672 7.37898C5.96977 7.37898 6.62689 8.03662 6.62689 8.85032V12.5287C6.62689 13.3424 5.96977 14 5.15672 14C4.34368 14 3.68655 13.3424 3.68655 12.5287V8.85032Z" fill="#E01E5A"/><path d="M5.15672 2.94268C4.34368 2.94268 3.68655 2.28503 3.68655 1.47134C3.68655 0.657643 4.34368 0 5.15672 0C5.96977 0 6.62689 0.657643 6.62689 1.47134V2.94268H5.15672ZM5.15672 3.68949C5.96977 3.68949 6.62689 4.34713 6.62689 5.16083C6.62689 5.97452 5.96977 6.63217 5.15672 6.63217H1.47017C0.65712 6.63217 0 5.97452 0 5.16083C0 4.34713 0.65712 3.68949 1.47017 3.68949H5.15672Z" fill="#36C5F0"/><path d="M11.0485 5.16083C11.0485 4.34713 11.7056 3.68949 12.5187 3.68949C13.3317 3.68949 13.9889 4.34713 13.9889 5.16083C13.9889 5.97452 13.3317 6.63217 12.5187 6.63217H11.0485V5.16083ZM10.3134 5.16083C10.3134 5.97452 9.65632 6.63217 8.84328 6.63217C8.03023 6.63217 7.37311 5.97452 7.37311 5.16083V1.47134C7.37311 0.657643 8.03023 0 8.84328 0C9.65632 0 10.3134 0.657643 10.3134 1.47134V5.16083Z" fill="#2EB67D"/><path d="M8.84328 11.0573C9.65632 11.0573 10.3134 11.715 10.3134 12.5287C10.3134 13.3424 9.65632 14 8.84328 14C8.03023 14 7.37311 13.3424 7.37311 12.5287V11.0573H8.84328ZM8.84328 10.3217C8.03023 10.3217 7.37311 9.66401 7.37311 8.85032C7.37311 8.03662 8.03023 7.37898 8.84328 7.37898H12.5298C13.3429 7.37898 14 8.03662 14 8.85032C14 9.66401 13.3429 10.3217 12.5298 10.3217H8.84328Z" fill="#ECB22E"/></svg></span>加入 Iron Slack</a></div><div class="d-block" style="flex:0 1 32px;"/><li class="iron_lang-menu dropdown" data-bs-target="#headerLangNameMenuDropdown"><span type="button" class="dropdown-toggle" id="iron_lang-menu__language-name_dropdown__current-language" data-bs-toggle="dropdown" aria-haspopup="true" aria-expanded="false">繁體中文</span><ul id="headerLangNameMenuDropdown" class="dropdown-menu" aria-labelledby="headerLangNameMenuDropdown"><li class="dropdown-item"><a class="i18n__distrans" data-language-code="en" data-language-alias="zh-hant" data-href="/csharp/excel/how-to/vb-net-excel-files/" onclick="window.location='/csharp/excel/how-to/vb-net-excel-files/'">English</a></li><li class="dropdown-item"><a class="i18n__distrans" data-language-code="es" data-href="/es/csharp/excel/how-to/vb-net-excel-files/" onclick="window.location='/es/csharp/excel/how-to/vb-net-excel-files/'">Español</a></li><li class="dropdown-item"><a class="i18n__distrans" data-language-code="de" data-href="/de/csharp/excel/how-to/vb-net-excel-files/" onclick="window.location='/de/csharp/excel/how-to/vb-net-excel-files/'">Deutsch</a></li><li class="dropdown-item"><a class="i18n__distrans" data-language-code="fr" data-href="/fr/csharp/excel/how-to/vb-net-excel-files/" onclick="window.location='/fr/csharp/excel/how-to/vb-net-excel-files/'">Français</a></li><li class="dropdown-item"><a class="i18n__distrans" data-language-code="ja" data-href="/ja/csharp/excel/how-to/vb-net-excel-files/" onclick="window.location='/ja/csharp/excel/how-to/vb-net-excel-files/'">日本語</a></li><li class="dropdown-item"><a class="i18n__distrans" data-language-code="zh" data-href="/zh/csharp/excel/how-to/vb-net-excel-files/" onclick="window.location='/zh/csharp/excel/how-to/vb-net-excel-files/'">简体中文</a></li></ul></li></div></div><section id="collapseMenuAboutUs" class="collapse menuCollapse"><div class="wrapper mx-auto justify-content-center" style=""><section class="menu_block"><h2>我們的公司</h2><ul class="listing"><li><a href="/zh-hant/about-us/">關於我們 <i class="fa fa-caret-right"/></a></li><li><a href="/zh-hant/trust-center/">信任中心 <i class="fa fa-caret-right"/></a></li><li><a href="/zh-hant/news/company-news/">公司新聞 <i class="fa fa-caret-right"/></a></li><li><a href="/zh-hant/customers/">顧客 <i class="fa fa-caret-right"/></a></li><li><a href="/zh-hant/about-us/ecogrant/">環境承諾 <i class="fa fa-caret-right"/></a></li><li><a href="/zh-hant/beta/">Beta 計劃 <i class="fa fa-caret-right"/></a></li><li><a href="/zh-hant/news/company-news/2023-wrap-up/">2023年回顧 <i class="fa fa-caret-right"/></a></li></ul></section><section class="menu_block"><h2>銷售夥伴</h2><ul class="listing"><li><a href="/zh-hant/resellers/">全球經銷商 <i class="fa fa-caret-right"/></a></li><li><a href="/zh-hant/merchant-of-record/">商業合作夥伴 <i class="fa fa-caret-right"/></a></li><li><a href="/zh-hant/partners/itconsultancy/">諮詢夥伴 <i class="fa fa-caret-right"/></a></li><li><a href="/zh-hant/partners/technology/">技術合作夥伴 <i class="fa fa-caret-right"/></a></li><li><a href="/zh-hant/partners/microsoftmvp/">微軟 MVPs <i class="fa fa-caret-right"/></a></li><li><a href="/zh-hant/partners/affiliate/">加入聯盟 <i class="fa fa-caret-right"/></a></li></ul></section><section class="menu_block"><h2>聯絡我們</h2><ul class="listing"><li><a href="#live-chat-support" onclick="return window.HubSpotConversations.widget.open()"><div class="flex_wrapper"><i class="far fa-comment-alt leading_icon"/><span>線上聊天 <i class="fa fa-caret-right"/></span></div></a></li><li><a href="mailto:sales@ironsoftware.com"><div class="flex_wrapper"><i class="far fa-envelope leading_icon"/><span>發送電子郵件 <i class="fa fa-caret-right"/></span></div></a></li></ul><div class="hr"/><div class="address_info"><div class="flex_wrapper"><i class="fa fa-phone-volume leading_icon"/><span>+1 (312) 500-3060</span></div><div class="flex_wrapper"><i class="fa fa-location-dot leading_icon"/><span>205 N. Michigan Ave.<br/>美國伊利諾伊州芝加哥 60601</span></div></div></section><section class="menu_block"><h2>在 Iron 的職業發展</h2><div style=" left:0; right:0; height:204px; bottom:0px;"><div class="careers_image_layer"><img loading="lazy" src="/img/company/about/who_we_are.webp" alt="加入我們的團隊" class="img-fluid"/><a href="/zh-hant/careers/" class="button" target="_blank">加入我們的團隊</a><div class="highlight">我們正在招聘</div></div></div></section></div></section><section id="collapseMenuProducts" class="collapse menuCollapse"><div class="wrapper mx-auto justify-content-center" style=""><div class="ironproduct-wrapper"><section class="menu_outer"><a class="menubox" href="https://ironpdf.com/zh-hant/" title="點擊查看IronPDF首頁"><div class="productLogo"><img loading="lazy" src="/img/svgs/navbar/ironpdf-logo.svg" class="productSymbol" width="130" height="130" alt="ironpdf_logo"/><div class="shadow_overlay"/></div><div class="productLogoText d-flex flex-row align-items-end"><img loading="lazy" src="/img/products/ironpdf-text.svg" height="15" alt="ironpdf_logo"/><div class="mainProLn">for <label class="progItem openWebsiteWithDataURL" data-url="https://ironpdf.com">.NET</label></div><div class="break add_margin_top"/><div class="menuProgLn"><label class="progItem openWebsiteWithDataURL" data-url="https://ironpdf.com/java/">Java</label><label class="progItem openWebsiteWithDataURL" data-url="https://ironpdf.com/python/">Python</label><label class="progItem openWebsiteWithDataURL" data-url="https://ironpdf.com/nodejs/">Node.js</label></div></div><div class="textDesc">建立、閱讀及編輯PDFs</div></a></section><section class="menu_outer"><a class="menubox" href="/zh-hant/csharp/word/" title="點擊以查看IronWord首頁"><div class="productLogo"><img loading="lazy" src="/img/svgs/navbar/ironword-logo.svg" class="productSymbol" width="130" height="130" alt="IronWord標誌"/><div class="shadow_overlay"/></div><div class="productLogoText d-flex flex-row align-items-end"><img loading="lazy" src="/img/products/ironword-text-without-icon-white.svg" height="15" alt="IronWord標誌"/><div class="break_top"/><div class="mainProLn">for <label class="progItem openWebsiteWithDataURL" data-url="/csharp/word/">.NET</label></div></div><div class="textDesc">編輯 DOCX Word 檔案<br/>不需要 Office 互操作性</div></a></section><section class="menu_outer"><a class="menubox" href="/zh-hant/csharp/excel/" title="點擊查看IronXL主頁"><div class="productLogo"><img loading="lazy" src="/img/svgs/navbar/ironxl-logo.svg" class="productSymbol" width="130" height="130" alt="ironxl_logo"/><div class="shadow_overlay"/></div><div class="productLogoText d-flex flex-row align-items-end"><img loading="lazy" src="/img/products/ironxl-text.svg" height="15" alt="ironxl_logo"/><div class="mainProLn">for <label class="progItem openWebsiteWithDataURL" data-url="/csharp/excel/">.NET</label></div><div class="break add_margin_top"/><div class="menuProgLn"><label class="progItem openWebsiteWithDataURL" data-url="/python/excel/">Python</label></div></div><div class="textDesc">編輯 Excel 及 CSV 文件。<br/>不需要 Office 互操作性</div></a></section><section class="menu_outer"><a class="menubox" href="/zh-hant/csharp/ocr/" title="點擊查看 IronOCR 主頁"><div class="productLogo"><img loading="lazy" src="/img/svgs/navbar/ironocr-logo.svg" class="productSymbol" width="130" height="130" alt="ironocr_logo"/><div class="shadow_overlay"/></div><div class="productLogoText d-flex flex-row align-items-end"><img loading="lazy" src="/img/products/ironocr-text.svg" height="15" alt="ironocr_logo"/><div class="mainProLn">for <label class="progItem openWebsiteWithDataURL" data-url="/csharp/ocr/">.NET</label></div></div><div class="textDesc">127種語言的圖像轉文字</div></a></section><section class="menu_outer"><a class="menubox" href="/zh-hant/csharp/barcode/" title="點擊查看IronBarcode主頁"><div class="productLogo"><img loading="lazy" src="/img/svgs/navbar/ironbarcode-logo.svg" class="productSymbol" width="130" height="130" alt="ironbarcode_logo"/><div class="shadow_overlay"/></div><div class="productLogoText d-flex flex-row align-items-end"><img loading="lazy" src="/img/products/ironbarcode-text.svg" height="15" alt="ironbarcode_logo"/><div class="break_top"/><div class="mainProLn">for <label class="progItem openWebsiteWithDataURL" data-url="/csharp/barcode/">.NET</label></div></div><div class="textDesc">讀取和寫入條碼</div></a></section><section class="menu_outer"><a class="menubox" href="/zh-hant/csharp/qr/" title="點擊查看 IronQR 首頁"><div class="productLogo"><img loading="lazy" src="/img/svgs/navbar/ironqr-logo.svg" class="productSymbol" width="130" height="130" alt="ironqr_logo"/><div class="shadow_overlay"/></div><div class="productLogoText d-flex flex-row align-items-end"><img loading="lazy" src="/img/products/ironqr-text.svg" height="15" alt="ironqr_logo"/><div class="mainProLn">for <label class="progItem openWebsiteWithDataURL" data-url="/csharp/qr/">.NET</label></div></div><div class="textDesc">使用機器學習檢測讀取和寫入 QR 碼</div></a></section><section class="menu_outer"><a class="menubox" href="/zh-hant/csharp/zip/" title="點擊查看IronZIP主頁"><div class="productLogo"><img loading="lazy" src="/img/svgs/navbar/ironzip-logo.svg" class="productSymbol" width="130" height="130" alt="ironzip_logo"/><div class="shadow_overlay"/></div><div class="productLogoText d-flex flex-row align-items-end"><img loading="lazy" src="/img/products/ironzip-text.svg" height="15" alt="ironzip_logo"/><div class="mainProLn">for <label class="progItem openWebsiteWithDataURL" data-url="/csharp/zip/">.NET</label></div></div><div class="textDesc">壓縮和解壓檔案</div></a></section><section class="menu_outer"><a class="menubox" href="/zh-hant/csharp/print/" title="點擊查看 IronPrint 主頁"><div class="productLogo"><img loading="lazy" src="/img/svgs/navbar/ironprint-logo.svg" class="productSymbol" width="130" height="130" alt="ironprint_logo"/><div class="shadow_overlay"/></div><div class="productLogoText d-flex flex-row align-items-end"><img loading="lazy" src="/img/products/ironprint-text.svg" height="15" alt="ironprint_logo"/><div class="break_top"/><div class="mainProLn">for <label class="progItem openWebsiteWithDataURL" data-url="/csharp/print/">.NET</label></div></div><div class="textDesc">自訂檔案列印</div></a></section><section class="menu_outer"><a class="menubox" href="/zh-hant/csharp/webscraper/" title="點擊查看IronWebScraper主頁"><div class="productLogo"><img loading="lazy" src="/img/svgs/navbar/ironwebscraper-logo.svg" class="productSymbol" width="130" height="130" alt="ironwebscraper標誌"/><div class="shadow_overlay"/></div><div class="productLogoText d-flex flex-row align-items-end"><img loading="lazy" src="/img/products/ironwebscraper-text.svg" height="15" alt="ironwebscraper標誌"/><div class="break_top"/><div class="mainProLn">for <label class="progItem openWebsiteWithDataURL" data-url="/csharp/webscraper/">.NET</label></div></div><div class="textDesc">從網站提取結構化數據</div></a></section></div><div class="suite-offer-wrapper"><section class="menu_outer"><a class="menubox promotionBox" href="/zh-hant/suite/" title="點擊查看 Iron Suite 許可證條款"><img loading="lazy" class="ironsuite-logo-white" src="/img/products/suite-logo-text-dotnet-large-white-v2__zh_TW.svg" width="154" height="136"/> <img loading="lazy" class="ironsuite-logo-white mobile-view" src="/img/products/suite-logo-text-dotnet-large-white-v3.svg" width="215" height="116"/> <span class="title">所有 9 用於<br/>價格2 </span><span class="action"><span class="promotionButton">使用 Iron Suite 節省 75%</span></span><div class="position-absolute" style="right:25px; bottom:8px;"><img loading="lazy" src="/img/svgs/teamseas-logo-for-dropdown.svg" alt="Iron Suite - 捐款50美元" class="img-fluid" width="94" height="36"/></div></a></section></div></div></section><section id="collapseMenuEnterprise" class="collapse menuCollapse"><div class="wrapper mx-auto" style=""><section class="menu_outer"><a class="menubox" href="/zh-hant/enterprise/" title="點擊查看企業頁面"><div class="productLogo"><img loading="lazy" src="/img/svgs/navbar/ironsuite-enterprise-icon.svg" class="productSymbol" width="130" height="130" alt="ironsuite-enterprise_logo"/><div class="shadow_overlay"/></div><div class="productLogoText d-flex flex-row align-items-end"><img loading="lazy" src="/img/products/ironsuite-enterprise-text-without-icon-white.svg" height="27" alt="ironsuite-enterprise_logo"/></div><div class="textDesc">企業授權</div></a></section><section class="menu_outer"><a class="menubox" href="/zh-hant/enterprise/securedoc/" title="點擊查看IronSecureDoc首頁"><div class="productLogo"><img loading="lazy" src="/img/svgs/navbar/ironsecuredoc-logo.svg" class="productSymbol" width="130" height="130" alt="ironsecuredoc_logo"/><div class="shadow_overlay"/></div><div class="productLogoText d-flex flex-row align-items-end"><img loading="lazy" src="/img/products/ironsecuredoc-text-without-icon-white.svg" height="15" alt="ironsecuredoc_logo"/></div><div class="textDesc">PDF 安全與合規性</div></a></section></div></section><section id="collapseMenuOpenSource" class="collapse menuCollapse"><div class="wrapper mx-auto" style=""><section class="menu_outer"><a class="menubox" href="/zh-hant/open-source/csharp/drawing/" title="點擊查看IronDrawing主頁"><div class="productLogo"><img loading="lazy" src="/img/svgs/navbar/irondrawing-logo.svg" class="productSymbol" width="130" height="130" alt="irondrawing_logo"/><div class="shadow_overlay"/></div><div class="productLogoText d-flex flex-row align-items-end"><img loading="lazy" src="/img/products/irondrawing-text-without-icon-white_2.svg" height="15" alt="irondrawing_logo"/><div class="mainProLn">for <label class="progItem openWebsiteWithDataURL" data-url="/open-source/csharp/drawing/">.NET</label></div></div><div class="textDesc">System.Drawing.Common 替代品</div></a></section><section class="menu_outer"><a class="menubox" href="/zh-hant/open-source/csharp/free-tools/json-to-csharp-converter/" title="點擊查看IronFreeTools主頁"><div class="productLogo"><img loading="lazy" src="/img/svgs/navbar/ironfreetools-logo.svg" class="productSymbol" width="130" height="130" alt="ironfreetools_logo"/><div class="shadow_overlay"/></div><div class="productLogoText d-flex flex-row align-items-end"><img loading="lazy" src="/img/products/ironfreetools-text-without-icon-white-text.svg" height="15" alt="ironfreetools_logo"/></div><div class="textDesc">免費軟體開發工具</div></a></section></div></section><section id="devMenuDesktop"><div class="d-flex mx-auto" style="max-width:1470px; padding:2px; align-items:center; padding-left:18px; padding-right:18px;"><div class="d-flex dropdown-center programselect"><div class="productLogoWrapper"><a href="/zh-hant/csharp/excel/" title="點擊查看 IronXL for .NET 主頁"><img loading="lazy" src="/img/products/ironxl-logo-text.svg" alt="IronXL - Excel資料庫，用於C# .NET" width="auto" height="34"/></a></div><div class="d-flex proglang_selector"><div class="textFor">for</div><div class="program-select align-self-center"><div class="dropdown-toggle-by-hover position-relative" data-bs-target="#devProgLangSelector" aria-expanded="false"><div class="dropdown-program-selected">.NET</div><ul id="devProgLangSelector" class="dropdown-menu"><li><a href="/zh-hant/csharp/excel/" title="點擊查看IronXL for .NET">.NET</a></li><li><a href="/zh-hant/python/excel/" title="點擊查看IronXL for Python">Python</a></li></ul></div></div></div></div><div class="flex-grow-1"/><div><ul class="devMenu"><li id="header-navbar-white-item-home"><a href="/zh-hant/csharp/excel/" title="首頁" class="item">首頁</a></li><li id="header-navbar-white-item-licensing"><div class="menuGroup"><a href="/zh-hant/csharp/excel/licensing/" title="授權" class="item text-nowrap">授權<i class="fas fa-angle-down arrow"/></a><ul class="menuDropDown"><li id="header-navbar-white-item-buy-license"><a class="" href="/zh-hant/csharp/excel/licensing/"><span class="iwrap"><i class="fa-kit fa-licensing"/></span>授權</a></li><li id="header-navbar-white-item-eula"><a class="" href="/zh-hant/csharp/excel/licensing/#license-terms-modal-tabs-eula" data-modal-licensing-tab-id="license-terms-modal-tabs-eula"><span class="iwrap"><i class="fa-kit fa-eula"/></span>最終用戶許可協議</a></li><li id="header-navbar-white-item-support-n-update"><a class="" href="/zh-hant/csharp/excel/licensing/extensions/"><span class="iwrap"><i class="fa-kit fa-support"/></span>支援與更新延伸模組</a></li><li id="header-navbar-white-item-license-upgrade"><a class="" href="/zh-hant/csharp/excel/licensing/upgrades/"><span class="iwrap"><i class="fa-kit fa-upgrades"/></span>許可證升級</a></li><li id="header-navbar-white-item-how-to-use-license"><a class="" href="/zh-hant/csharp/excel/how-to/license-keys/"><span class="iwrap"><i class="fa-regular fa-circle-question"/></span>如何使用授權金鑰</a></li><li class="free-trial" id="header-navbar-white-item-license-trial"><a class="js-modal-open" href="/zh-hant/csharp/excel/#trial-license" data-modal-id="trial-license" data-bs-toggle="modal" data-bs-target="#trial-license"><span class="iwrap"><i class="fa-regular fa-key"/></span>開始免費試用</a></li></ul></div></li><li id="header-navbar-white-item-features-in-main-nav"><a href="/zh-hant/csharp/excel/features/" title="功能" class="item">功能</a></li><li id="header-navbar-white-item-docs"><div class="menuGroup"><a href="/zh-hant/csharp/excel/docs/" title="文件" class="item text-nowrap">文件<i class="fas fa-angle-down arrow"/></a><ul class="menuDropDown"><li id="header-navbar-white-item-get-started"><a class="" href="/zh-hant/csharp/excel/docs/"><span class="iwrap"><i class="fa-regular fa-rocket-launch"/></span>開始使用</a></li><li id="header-navbar-white-item-code-examples"><a class="" href="/zh-hant/csharp/excel/examples/read-excel/"><span class="iwrap"><i class="fa-regular fa-code"/></span>程式碼範例</a></li><li id="header-navbar-white-item-tutorials"><a class="" href="/zh-hant/csharp/excel/tutorials/how-to-read-excel-file-csharp/"><span class="iwrap"><i class="fa-regular fa-graduation-cap fa-flip-horizontal"/></span>教程</a></li><li id="header-navbar-white-item-faq"><a class="" href="/zh-hant/csharp/excel/how-to/create-xlsx-file-c-sharp/"><span class="iwrap"><i class="fa-regular fa-circle-question"/></span>操作指南</a></li><li id="header-navbar-white-item-troubleshooting"><a class="" href="/zh-hant/csharp/excel/troubleshooting/apply-a-license-key-in-ironxl/"><span class="iwrap"><i class="fa-regular fa-wrench"/></span>故障排除</a></li><li id="header-navbar-white-item-changelog"><a class="" href="/zh-hant/csharp/excel/product-updates/changelog/"><span class="iwrap"><i class="fa-regular fa-arrows-rotate"/></span>產品更新</a></li><li class="api-ref" id="header-navbar-white-item-api-reference"><a class="" href="/zh-hant/csharp/excel/object-reference/api/" target="_blank"><span class="iwrap"><i class="fa-kit fa-plugconnect"/></span>API 參考<i class="fa-solid fa-square-arrow-up-right"/></a></li></ul></div></li></ul></div><div class="js-search js-search__button searchBoxTop d-none d-xl-flex"><div class="searchBox search-button__link"><div class="iwrap"><i class="fa-solid fa-magnifying-glass"/></div><div class="searchText">搜索</div><div><div class="search-shortcut_btn">Ctrl</div><div class="search-shortcut_btn">K</div></div></div></div><div class="searchBoxTop d-flex d-xl-none"><div class="js-search js-search__button searchBoxRound search-button__link d-flex d-xl-none"><i class="fa-solid fa-magnifying-glass"/></div></div><div class="downloadButtonTop"><a id="header-navbar-white-cta-button" class="js-modal-open btn btn-red btn--twolines text-nowrap w-100 vwo-homepage-start-trial-cta-button--control" href="https://www.nuget.org/packages/IronXL.Excel/" target="_blank" data-modal-id="trial-license-after-download" title="點擊查看 IronXL 在 NuGet 網站上的詳情"><i class="nuget-icon-white2"/> <span>免費 NuGet 下載</span><span class="header-navbar-white-cta-button--total-download"><span class="vwo-cta-total-downloads-wording">總下載次數： </span>1,023,839</span></a><div class="download_button_2407__wrapper"><a class="download_button_2407__button js-modal-open" href="https://www.nuget.org/packages/IronXL.Excel/" data-modal-id="trial-license-after-download" target="_blank"><span class="download_button_2407__main_icon_wrapper"><i class="fa-kit fa-nuget"/></span> 免費開始<i class="fa-solid fa-caret-down ms-2 download_button_2407__button__arrow"/></a><div class="download_button_2407__content"><div class="download_button_2407__menu"><a aria-label="" class="js-modal-open" target="_blank" href="https://www.nuget.org/packages/IronXL.Excel/" data-modal-id="trial-license-after-download"><span class="download_button_2407__icon_wrapper"><i class="fa-kit fa-nuget"/></span> NuGet 下載 </a><a aria-label="" class="openWebsiteWithDataURL" data-url="https://ironsoftware.com/csharp/excel/packages/IronXL.zip"><span class="download_button_2407__icon_wrapper"><i class="fa fa-download"/></span> DLL 下載 </a><a href="#trial-license" class="the_trial" aria-label="" data-bs-toggle="modal" data-bs-target="#trial-license"><span class="download_button_2407__icon_wrapper"><i class="fa-solid fa-key"/></span>開始免費試用</a></div></div></div></div></div><div id="reading-progressbar"><div class="progress-bar"/></div></section></nav><nav id="mobile_nav" class="sticky-top d-block d-md-none"><div class="devTitleBar d-flex align-items-center shadow"><a href="#" data-bs-toggle="offcanvas" data-bs-target="#offCanvasProducts" aria-controls="menuoffcanvas" class="d-flex"><div style="background-color:#141414; height:40px; padding:0 10px;" class="d-flex align-items-center"><img loading="lazy" src="https://ironsoftware.com/img/svgs/logo-icon.svg" width="24" height="24"/><div style="font-size:10px; color:#fff;" class="align-self-end"><i class="fas fa-caret-down"/></div></div><div style="width:12px; height:40px;" class="theshard"><i class="fa-kit fa-shard"/></div></a><div class="d-flex flex-grow-1 align-items-end overflow-x-hidden"><div class="product_for"><a href="/zh-hant/csharp/excel/" title="IronXL"><img loading="lazy" src="/img/products/ironxl-text-without-icon-black.svg" alt="IronXL - Excel資料庫，用於C# .NET" height="16"/><div class="textFor">為</div></a></div><div id="plang_dropdown" class="xx_dropdown-center"><button type="button" data-bs-toggle="dropdown" class="btn btn-secondary dropdown-toggle" aria-expanded="false">.NET</button><ul class="dropdown-menu shadow"><li><a href="/zh-hant/csharp/excel/" title="點擊查看IronXL for .NET">.NET</a></li><li><a href="/zh-hant/python/excel/" title="點擊查看IronXL for Python">Python</a></li></ul></div></div><div data-bs-toggle="x_collapse" data-bs-target="#collapseSearchBox" class="icon_magnify cursorPointer"><i class="fa-regular fa-magnifying-glass js-search js-search__button"/></div><div data-bs-toggle="offcanvas" data-bs-target="#offCanvasDev" aria-controls="menuoffcanvas" class="icon_bars cursorPointer"><i class="fas fa-bars"/></div></div><div id="offCanvasProducts" class="offcanvas devmode offcanvas-start" tabindex="-1" aria-labelledby="IronSoftwareProductsMenu"><div class="body transparent-scrollbar"><div class="accordion" id="accordionProductGroup"><ul class="layer1"><li class="home"><a href="/zh-hant/" title="點擊查看Iron Software主頁">IRONSOFTWARE <em>首頁</em></a></li><li><div class="accordion-button collapsed" data-bs-toggle="collapse" data-bs-target="#collapseProducts" aria-expanded="false" aria-controls="collapseProducts">產品</div><ul id="collapseProducts" class="collapse layer2" data-bs-parent="#accordionProductGroup"><li><a href="/zh-hant/suite/" class="productname" title="Click to view Iron Suite licensing"><div>IRON<span style="color:#e01a59;">SUITE</span></div></a></li><li><hr/></li><li><a href="https://ironpdf.com/zh-hant/" class="productname" title="Click to view the IronPDF homepage"><div>IRON<span style="color:#e01a59;">PDF</span></div><div class="badge update">更新</div></a></li><li><a href="/zh-hant/csharp/word/" class="productname" title="Click to view the IronWord homepage"><div>IRON<span style="color:#89D3DF;">WORD</span></div></a></li><li><a href="/zh-hant/csharp/excel/" class="productname" title="Click to view the IronXL homepage"><div>IRON<span style="color:#63c1a0;">XL</span></div></a></li><li><a href="/zh-hant/csharp/ocr/" class="productname" title="Click to view the IronOCR homepage"><div>IRON<span style="color:#89d3df;">OCR</span></div></a></li><li><a href="/zh-hant/csharp/barcode/" class="productname" title="Click to view the IronBarcode homepage"><div>IRON<span style="color:#63c1a0;">BARCODE</span></div></a></li><li><a href="/zh-hant/csharp/qr/" class="productname" title="Click to view the IronQR homepage"><div>IRON<span style="color:#63c1a0;">QR</span></div></a></li><li><a href="/zh-hant/csharp/zip/" class="productname" title="Click to view the IronZIP homepage"><div>IRON<span style="color:#FDA509;">ZIP</span></div></a></li><li><a href="/zh-hant/csharp/print/" class="productname" title="Click to view the IronPRINT homepage"><div>IRON<span style="color:#FDA509;">PRINT</span></div></a></li><li><a href="/zh-hant/csharp/webscraper/" class="productname" title="Click to view the IronWebScraper homepage"><div>IRON<span style="color:#fda509;">WEBSCRAPER</span></div></a></li></ul></li><li><div class="accordion-button collapsed" data-bs-toggle="collapse" data-bs-target="#collapseEnterprise" aria-expanded="false" aria-controls="collapseEnterprise">企業</div><ul id="collapseEnterprise" class="layer2 collapse" data-bs-parent="#accordionProductGroup"><li><a href="/zh-hant/enterprise/securedoc/" class="productname" title="點擊查看 IronSECUREDOC 主頁"><div>鉄<span style="color:#ef5214;">SECUREDOC</span></div></a></li></ul></li><li><div class="accordion-button collapsed" data-bs-toggle="collapse" data-bs-target="#collapseOpenSource" aria-expanded="false" aria-controls="collapseOpenSource">開源</div><ul id="collapseOpenSource" class="layer2 collapse" data-bs-parent="#accordionProductGroup"><li><a href="/zh-hant/open-source/csharp/drawing/docs/" class="productname" title="點擊查看 IronDRAWING 主頁"><div>鉄<span style="color:#63C1A0;">繪圖</span></div></a></li><li><a href="/zh-hant/open-source/csharp/free-tools/json-to-csharp-converter/" class="productname" title="點擊查看IronFREETOOLS首頁"><div>鉄<span style="color:#fda509;">免費工具</span></div></a></li></ul></li><li><div class="accordion-button collapsed" data-bs-toggle="collapse" data-bs-target="#collapseAboutUs" aria-expanded="false" aria-controls="collapseOpenSource">關於我們</div><ul id="collapseAboutUs" class="layer2 collapse" data-bs-parent="#accordionProductGroup"><li><a href="/zh-hant/about-us/" title="點擊查看關於我們頁面"><div>關於我們</div></a></li><li><a href="/zh-hant/news/company-news/" title="點擊查看公司新聞頁面"><div>公司新聞</div></a></li><li><a href="/zh-hant/customers/" title="點擊查看客戶頁面"><div>顧客</div></a></li><li><a href="/zh-hant/about-us/ecogrant/" title="點擊查看環保承諾頁面"><div>環境承諾</div></a></li><li><a href="/zh-hant/beta/" title="點擊查看測試計畫頁面"><div>Beta 計劃</div></a></li><li><a href="/zh-hant/news/company-news/2023-wrap-up/" title="點擊查看 2023 年回顧頁面"><div>2023年回顧</div></a></li><li><a href="/zh-hant/#live-chat-support" title="與我們的團隊交談" onclick="return window.HubSpotConversations.widget.open()"><div>線上聊天</div></a></li><li><a href="/zh-hant/resellers/" title="點擊查看全球經銷商頁面"><div>全球經銷商</div></a></li><li><a href="/zh-hant/careers/" title="點擊以查看職業頁面"><div>加入我們的團隊</div></a></li></ul></li><li><a href="/zh-hant/contact-us/" title="點擊查看聯絡我們頁面">聯絡我們</a></li></ul></div></div><div class="/h-100" data-bs-dismiss="offcanvas"/></div><div id="offCanvasDev" class="offcanvas offcanvas-end" tabindex="-1" aria-labelledby="IronSoftwareDeveloperMenu"><div class="body transparent-scrollbar /h-100"><div class="accordion" id="accordionDevGroup"><ul class="layer1"><li><a href="/zh-hant/csharp/excel/" class="item"><span class="iwrap"><i class="fa-regular fa-home"/></span>首頁</a></li><li><div class="accordion-button collapsed" data-bs-toggle="collapse" data-bs-target="#collapse-1" aria-expanded="false" aria-controls="collapseProducts"><span class="iwrap"><i class="fa-kit fa-licensing"/></span>授權</div><ul id="collapse-1" class="collapse layer2" data-bs-parent="#accordionDevGroup"><li><a class="" href="/zh-hant/csharp/excel/licensing/"><span class="iwrap"><i class="fa-kit fa-licensing"/></span>授權</a></li><li><a class="" href="/zh-hant/csharp/excel/licensing/" data-modal-licensing-tab-id="license-terms-modal-tabs-eula"><span class="iwrap"><i class="fa-kit fa-eula"/></span>最終用戶許可協議</a></li><li><a class="" href="/zh-hant/csharp/excel/licensing/extensions/"><span class="iwrap"><i class="fa-kit fa-support"/></span>支援與更新延伸模組</a></li><li><a class="" href="/zh-hant/csharp/excel/licensing/upgrades/"><span class="iwrap"><i class="fa-kit fa-upgrades"/></span>許可證升級</a></li><li><a class="" href="/zh-hant/csharp/excel/how-to/license-keys/"><span class="iwrap"><i class="fa-regular fa-circle-question"/></span>如何使用授權金鑰</a></li><li><hr/></li><li><a class="js-modal-open" href="/zh-hant/csharp/excel/" data-modal-id="trial-license" data-bs-toggle="modal" data-bs-target="#trial-license"><span class="iwrap"><i class="fa-regular fa-key"/></span>開始免費試用</a></li></ul></li><li><a href="/zh-hant/csharp/excel/features/" class="item"><span class="iwrap"><i class="fa-regular fa-clipboard-check"/></span>功能</a></li><li><div class="accordion-button collapsed" data-bs-toggle="collapse" data-bs-target="#collapse-3" aria-expanded="false" aria-controls="collapseProducts"><span class="iwrap"><i class="fa-regular fa-book"/></span>文件</div><ul id="collapse-3" class="collapse layer2" data-bs-parent="#accordionDevGroup"><li><a class="" href="/zh-hant/csharp/excel/docs/"><span class="iwrap"><i class="fa-regular fa-rocket-launch"/></span>開始使用</a></li><li><a class="" href="/zh-hant/csharp/excel/examples/read-excel/"><span class="iwrap"><i class="fa-regular fa-code"/></span>程式碼範例</a></li><li><a class="" href="/zh-hant/csharp/excel/tutorials/how-to-read-excel-file-csharp/"><span class="iwrap"><i class="fa-regular fa-graduation-cap fa-flip-horizontal"/></span>教程</a></li><li><a class="" href="/zh-hant/csharp/excel/how-to/create-xlsx-file-c-sharp/"><span class="iwrap"><i class="fa-regular fa-circle-question"/></span>操作指南</a></li><li><a class="" href="/zh-hant/csharp/excel/troubleshooting/apply-a-license-key-in-ironxl/"><span class="iwrap"><i class="fa-regular fa-wrench"/></span>故障排除</a></li><li><a class="" href="/zh-hant/csharp/excel/product-updates/changelog/"><span class="iwrap"><i class="fa-regular fa-arrows-rotate"/></span>產品更新</a></li><li><hr/></li><li><a class="" href="/zh-hant/csharp/excel/object-reference/api/" target="_blank"><span class="iwrap"><i class="fa-kit fa-plugconnect"/></span>API 參考<i class="fa-solid fa-square-arrow-up-right"/></a></li></ul></li></ul></div><div class="/h-100" data-bs-dismiss="offcanvas"/></div></div></nav><div id="header-navbar-search" class="js-search search-box shadow" data-visible-class="search-box_visible"><div class="js-search__close search-box__backdrop"><div class="js-search__close-exception search-box__container"><div class="js-search-offset-block search-box__field"><label class="search-box__label"><span class="search-box__label-icon"><i class="fa-solid fa-magnifying-glass"/> </span><input id="header-navbar-search-input" class="js-search__input search-box__label-input" type="search" autocomplete="off" placeholder="搜索 API、代碼範例和教程"/></label> <button class="js-search__close search-box__close"/></div><div class="js-search__results search-box__results search-box__results_horizontal" data-visible-class="search-box__results_visible"><div class="search-box__list-wrapper"><div class="js-search__list-overflow search-box__list"><div id="header-navbar-search-results-list" class="js-search__list search-box__list-inner" data-insights-index="ironxl__zh_TW"/></div></div><div id="header-navbar-search-results-preview" class="search-box__preview-wrapper"><div class="js-search__preview-overflow search-box__preview"><div class="js-search__preview search-box__preview-inner"><div class="js-search__preview-icon-wrapper search-box__preview-icon-wrapper" data-visible-class="search-box__preview-icon-wrapper_visible"><i class="js-search__preview-icon search-box__preview-icon" data-added-class-before=""/></div><div class="js-search__preview-title search-box__preview-title" data-visible-class="search-box__preview-title_visible"/><div class="js-search__preview-breadcrumbs search-box__preview-breadcrumbs" data-visible-class="search-box__preview-breadcrumbs_visible"/><div class="js-search__preview-content search-box__preview-content" data-visible-class="search-box__preview-content_visible"/></div></div></div></div><div id="header-navbar-search-message" class="js-search__message search-box__results search-box__results_padding-bottom" data-visible-class="search-box__results_visible"><div class="search-box__results-icon"><img loading="lazy" class="js-search__message-icon search-box__results-icon-img" src="/img/svgs/search-no-results.svg" alt="訊息圖示"/></div><div class="js-search__message-text search-box__results-text"/></div></div></div></div><header id="header" class="products-header products-header_margin-top-desktop"><div id="section-banner" class="banner banner-inner banner-inner--remove-minheight-bgcolor banner-iron-xl-styles docs-version-two-layout"><img loading="lazy" class="illustration1 add-shadow d-none d-lg-block" src="/img/products/iron-xl-illustration-2-1.svg" alt="IronXL" width="207" height="197"/><div class="container-fluid container-fluid_wide"><div class="banner__illustration2-wrapper banner__illustration2-wrapper--ironxl d-lg-block"><img loading="lazy" class="illustration2 add-shadow banner__small-illustration2--right-ironxl" src="/img/products/iron-xl-illustration-2-2.svg" alt="IronXL" width="164" height="278"/></div></div></div></header><main class="main-inverse three-columns-section docs-version-two-layout" id="main"><div class="container-fluid container-fluid_wide"><div class="row equal-height-columns"><div class="col-md-3 col-lg-3 three-columns-left order-last order-md-first"><aside class="sidebar" id="sidebar"><div id="pages-leftmenu-nav-wrapper"><div class="pages-leftmenu-nav-wrapper__docs-explorer-menu relative-with-navbar"><div class="leftmenu-nav-wrapper__img-header"><img loading="lazy" class="product-text-img" src="/img/products/ironxl-text-without-icon-black.svg" alt="Iron Software Product" width="100" height="20"/> <img loading="lazy" class="section-icon" src="/img/svgs/docs.svg" alt="Iron Software Documents" width="46" height="20"/></div><div class="leftmenu-nav__copy-cmd vwo-variant-2"><div class="nuget-sidebar-cli copy-cmd--ironxl"><div class="nuget-sidebar-cli__command" data-copy-text="點擊複製" data-copied-text="已複製到剪貼板"><p class="nuget-sidebar-cli__command__text"><a class="nuget-icon-continaer__link js-modal-open" href="https://www.nuget.org/packages/IronXL.Excel" target="_blank" title="Visit IronXL NuGet Page" data-modal-id="trial-license-after-download"><i class="nuget-icon-blue"/></a> <span class="js-nuget-sidebar-cli__command__text__prefix">PM &gt;</span><span class="js-nuget-sidebar-cli__command__text">Install-Package IronXL.Excel</span></p></div><div class="nuget-sidebar-cli__copy-block"><span class="fas copy-icon-white"/></div></div></div><div class="well-v2 aside-well"><ul class="nav nav-list aside-list"><li class=""><div class="first-level"><a href="/zh-hant/csharp/excel/docs/"><span class="navmenu-icon img-icon navmenu-icon__sidemenu-icon left-sidemenu-icon"><i class="fa-regular fa-rocket-launch"/></span><div class="flex-grow-1">開始使用</div><i class="fa fa-caret-down hidden"/></a></div></li><li class=""><div class="first-level"><a href="/zh-hant/csharp/excel/examples/read-excel/"><span class="navmenu-icon img-icon navmenu-icon__sidemenu-icon left-sidemenu-icon"><i class="fa-regular fa-code"/></span><div class="flex-grow-1">程式碼範例</div><i class="fa fa-caret-down hidden"/></a></div></li><li class=""><label class="tree-toggle nav-header first-level"><span class="nested-content-menuitem"><span class="navmenu-icon img-icon navmenu-icon__sidemenu-icon left-sidemenu-icon"><i class="fa-regular fa-graduation-cap fa-flip-horizontal"/></span><span class="nested-content-menuitem__text">教程</span> </span><i class="fa fa-caret-down visible"/></label><ul class="nav nav-list tree"><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/tutorials/how-to-read-excel-file-csharp/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">如何在 C#中读取 Excel 文件</a></li><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/tutorials/create-excel-file-net/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">使用 C# 在 .NET 中創建 Excel 文件</a></li><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/tutorials/csharp-open-write-excel-file/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">使用 C# 開啟並寫入 Excel 文件</a></li></ul></li><li class="active current-menuitem"><label class="tree-toggle nav-header first-level"><span class="nested-content-menuitem"><span class="navmenu-icon img-icon navmenu-icon__sidemenu-icon left-sidemenu-icon"><i class="fa-regular fa-circle-question"/></span><span class="nested-content-menuitem__text">操作指南</span> </span><i class="fa fa-caret-down visible"/></label><ul class="nav nav-list tree v2-expandable-menu-group" style="display: block"><li class="v2-expandable-menuitem active"><i class="fa fa-solid fa-square-minus"/> <span>相容性</span><ul class="nav nav-list tree v2-expandable-menu-group" style="display: block"><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/how-to/license-keys/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">使用序號密鑰</a></li><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/how-to/macos/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">在macOS上設置</a></li><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/how-to/aws-lambda-support/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">在 AWS 上設置</a></li><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/how-to/azure-support/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">在 Azure 上設定</a></li><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/how-to/docker-support/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">在 Docker 上設置</a></li><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/how-to/linux/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">在 Linux 上安裝</a></li><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/how-to/blazor-read-excel-file-tutorial/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">在 Blazor 中讀取 Excel 文件</a></li><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/how-to/c-sharp-excel-interop/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">在C#中使用Excel而不需要Interop</a></li><li class="active"><div class="active">使用 VB.NET Excel 檔案</div></li><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/how-to/read-create-excel-net-maui/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">在 .NET MAUI 上使用 Excel</a></li></ul></li><li class="v2-expandable-menuitem"><i class="fa fa-solid fa-square-plus"/> <span>工作簿</span><ul class="nav nav-list tree v2-expandable-menu-group"><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/how-to/create-spreadsheet/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">創建試算表</a></li><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/how-to/load-spreadsheet/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">載入試算表</a></li><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/how-to/export-spreadsheet/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">儲存或匯出格式</a></li><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/how-to/csharp-create-excel/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">在 C# 中建立 Excel 文件</a></li><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/how-to/create-xlsx-file-c-sharp/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">建立 XLSX 檔案</a></li><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/how-to/c-sharp-parse-excel-file/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">在C#中解析Excel文件</a></li><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/how-to/c-sharp-export-to-excel/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">在 C# 中導出到 Excel</a></li><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/how-to/c-sharp-read-xlsx-file/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">讀取 XLSX 檔案 C#</a></li><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/how-to/csharp-read-csv-file/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">在 C# 中讀取 CSV</a></li><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/how-to/asp-net-mvc-read-excel-file/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">在 ASP.NET 網頁應用程式中讀取 Excel 檔案</a></li><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/how-to/csharp-write-to-csv-file/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">在.NET中寫入CSV</a></li><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/how-to/c-sharp-open-excel-worksheet/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">在C#中打開Excel工作表</a></li><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/how-to/csharp-datatable-to-csv/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">將資料表轉換為CSV</a></li><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/how-to/csharp-convert-xlsx-to-csv/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">將 XLSX 轉換為 CSV、JSON、XML</a></li><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/how-to/convert-spreadsheet-file-types/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">轉換試算表文件類型</a></li><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/how-to/export-dataset-datatable/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">導入和導出為DataSet</a></li><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/how-to/edit-workbook-metadata/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">編輯工作簿元數據</a></li><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/how-to/set-password-workbook/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">使用密碼加密工作簿</a></li><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/how-to/manage-worksheet/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">管理工作表</a></li></ul></li><li class="v2-expandable-menuitem"><i class="fa fa-solid fa-square-plus"/> <span>工作表</span><ul class="nav nav-list tree v2-expandable-menu-group"><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/how-to/edit-formulas/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">編輯公式</a></li><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/how-to/select-range/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">選擇範圍</a></li><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/how-to/named-range/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">命名範圍</a></li><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/how-to/named-table/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">命名表格</a></li><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/how-to/csharp-excel-chart-create-edit-tutorial/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">建立和編輯圖表</a></li><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/how-to/add-freeze-panes/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">凍結窗格</a></li><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/how-to/add-rows-columns/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">新增行和列</a></li><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/how-to/autosize-rows-columns/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">自動調整行和列</a></li><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/how-to/set-password-worksheet/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">加密工作表並設定密碼</a></li><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/how-to/group-and-ungroup-rows-columns/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">群組和取消群組</a></li><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/how-to/add-extract-remove-worksheet-images/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">添加、提取和刪除圖像</a></li><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/how-to/csharp-create-excel-chart-programmatically/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">在 C# 中創建 Excel 圖表</a></li></ul></li><li class="v2-expandable-menuitem"><i class="fa fa-solid fa-square-plus"/> <span>儲存格範圍</span><ul class="nav nav-list tree v2-expandable-menu-group"><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/how-to/write-excel-net/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">在 .NET 中寫入 Excel 值</a></li><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/how-to/csharp-import-excel/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">在 C# 中匯入 Excel 數據</a></li><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/how-to/sort-cells/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">排序儲存格範圍</a></li><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/how-to/trim-cell-range/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">修剪單元範圍</a></li><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/how-to/clear-cells/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">清除儲存格</a></li><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/how-to/copy-cells/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">複製單元格</a></li><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/how-to/hyperlinks/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">設置超連結</a></li><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/how-to/csharp-excel-merge-cells/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">合併和拆分儲存格</a></li><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/how-to/cell-font-size/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">單元格字體和大小</a></li><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/how-to/border-alignment/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">儲存格邊框和對齊</a></li><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/how-to/background-pattern-color/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">背景圖案及顏色</a></li><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/how-to/conditional-formatting/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">條件格式化</a></li><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/how-to/math-functions/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">數學函數</a></li><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/how-to/add-comment/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">添加評論</a></li><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/how-to/set-cell-data-format/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">設置單元格數據格式</a></li><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/how-to/csharp-edit-excel-file/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">在 C# 中編輯 Excel 文件</a></li></ul></li></ul></li><li class=""><label class="tree-toggle nav-header first-level"><span class="nested-content-menuitem"><span class="navmenu-icon img-icon navmenu-icon__sidemenu-icon left-sidemenu-icon"><i class="fa-regular fa-wrench"/></span><span class="nested-content-menuitem__text">故障排除</span> </span><i class="fa fa-caret-down visible"/></label><ul class="nav nav-list tree v2-expandable-menu-group"><li class="v2-expandable-menuitem"><i class="fa fa-solid fa-square-plus"/> <span>故障排除指南</span><ul class="nav nav-list tree v2-expandable-menu-group"><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/troubleshooting/apply-a-license-key-in-ironxl/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">在 IronXL 中應用授權金鑰</a></li><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/troubleshooting/file-size-limits/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">檔案大小限制</a></li></ul></li><li class="v2-expandable-menuitem"><i class="fa fa-solid fa-square-plus"/> <span>常見問題</span><ul class="nav nav-list tree v2-expandable-menu-group"><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/troubleshooting/ironxl-security-cve/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">IronXL - 安全性CVE</a></li></ul></li><li class="v2-expandable-menuitem"><i class="fa fa-solid fa-square-plus"/> <span>例外訊息</span><ul class="nav nav-list tree v2-expandable-menu-group"><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/troubleshooting/license-key-web.config/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">在 Web.config 中設定授權金鑰</a></li></ul></li></ul></li><li class=""><label class="tree-toggle nav-header first-level"><span class="nested-content-menuitem"><span class="navmenu-icon img-icon navmenu-icon__sidemenu-icon left-sidemenu-icon"><i class="fa-regular fa-arrows-rotate"/></span><span class="nested-content-menuitem__text">產品更新</span> </span><i class="fa fa-caret-down visible"/></label><ul class="nav nav-list tree"><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/product-updates/changelog/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">變更日誌</a></li><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/product-updates/milestones/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">里程碑</a></li><li class=""><a class="js-code-explorer-item-another" href="/zh-hant/csharp/excel/product-updates/milestones-performance/" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title" data-code-explorer-item-class="active">里程碑：性能</a></li></ul></li><li class=""><div class="first-level"><a href="/zh-hant/csharp/excel/object-reference/api/" target="__blank"><span class="navmenu-icon img-icon navmenu-icon__sidemenu-icon left-sidemenu-icon"><i class="fa-kit fa-plugconnect"/></span><div class="flex-grow-1">API 參考文獻</div><i class="fa fas fas fa-external-link-square-alt visible"/></a></div></li></ul></div></div></div></aside></div><div class="col-12 col-md-9 col-lg-6 three-columns-content"><article class="main-article main-content"><ol class="breadcrumb"><li class="breadcrumb-item"><a href="/zh-hant/csharp/excel/">IronXL</a></li><li class="breadcrumb-item"><a href="/zh-hant/csharp/excel/how-to/create-xlsx-file-c-sharp/">操作指南</a></li><li class="breadcrumb-item">VB.NET Excel 文件</li></ol><h1 id="anchor-vb-net-36-49-excel-36-49-36-49">VB .NET 讀取和創建 Excel 文件 (代碼範例教學)</h1><div class="translated-article-note-block"><div class="translated-article-note-block__label"><div class="translated-article-note-block__tooltip link-with-tooltip__standard_tooltip1">This article was translated from English: <a href="#anchor-improve-the-article">Does it need improvement?</a> <i class="fas fa-sort-down"/></div>Translated</div><div class="translated-article-note-block__link">View the article in <a class="i18n__distrans" href="/csharp/excel/how-to/vb-net-excel-files/" target="_blank" rel="nofollow noopener noreferrer">English</a></div></div><p>開發人員需要一種順暢且簡單的方法來存取 VB .NET Excel 檔案。在這個操作指南中，我們將使用 IronXL 來讀取 VB dotnet Excel 檔案並存取我們專案使用的所有數據。我們將學習如何以所有格式創建試算表。 ( <code>.xls</code>、<code>.xlsx</code>、<code>.csv</code> 和 <code>.tsv</code> )，以及使用 VB.NET Excel 程式設計設定儲存格樣式和插入資料。</p><div class="hsg-featured-snippet"><h2>如何在 VB.NET 中讀取 Excel 文件</h2><ol><li><a class="js-modal-open" data-modal-id="trial-license-after-download" href="https://nuget.org/packages/IronXL.Excel/" target="_blank" rel="nofollow noopener noreferrer">下載 VB.NET 讀取 Excel C# 庫</a></li><li>在 VB.NET 中建立 Excel 檔案</li><li>插入資料到工作表</li><li>在 VB.NET 中讀取 Excel 檔案</li><li>從工作表中存取數據</li><li>執行資料功能</li></ol></div><p/><div class="main-article__video-wrapper js-article-video-modal-wrapper"><iframe class="" loading="lazy" src="https://www.youtube.com/embed/5KBH0YqvKl4?start=0" title="YouTube Video Player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" allowfullscreen=""/></div><p/><hr class="separator"/><h4 class="tutorial-segment-title">第一步</h4><h2 id="anchor-1-excel-for-vb-net-36-49">1. Excel for VB.NET 函式庫</h2><p>獲取 IronXL Excel for VB.NET 函式庫使用 <a href="/zh-hant/csharp/excel/packages/IronXL.Package.For.vb.net.excel.files.zip" target="_blank" rel="nofollow noopener noreferrer">DLL 下載</a> 或 <a href="https://www.nuget.org/packages/IronXL.Excel" target="_blank" rel="nofollow noopener noreferrer">NuGet</a>. IronXL 是我們在 VB.NET 專案中快速存取 Excel 數據的第一步，這是我們在本教程中將使用的工具。 (開發免費使用).</p><div class="copy-nuget-section md-body net" data-toggle="tooltip" data-placement="top" title="點擊複製" data-copy-text="點擊複製" data-copied-text="已複製到剪貼板"><pre class="install-script">Install-Package IronXL.Excel</pre></div><hr class="separator"/><h4 class="tutorial-segment-title">教學指南</h4><h2 id="anchor-2-36-49vb-net36-49excel36-49">2. 在VB.NET中創建Excel文件</h2><p>IronXL 提供了最簡單的方法來創建 Excel 文件。 (<code>.xlsx</code> 格式) 在 VB.NET 項目中檔案之後，我們可以插入數據並設置單元格屬性，如字體樣式或邊框。</p><h3 id="anchor-2-1-36-49-excel-36-49">2.1. 建立 Excel 檔案</h3><p>讓我們首先建立一個 WorkBook：</p><pre class="naked-code"><code class="language-vb">Dim wb As New WorkBook</code></pre><div class="code-content code-content-inner"><div class="code_window"><div class="code_window_content"><div class="code-window__action-buttons-wrapper code-window__action-buttons-wrapper--content-page"><button title="點擊複製" class="code-window__action-button code-window__action-button--copy copy-clipboard" data-copy-text="點擊複製" data-copied-text="已複製到剪貼板" data-clipboard-id="code-explorer" data-placement="bottom"><i class="fa-kit fa-copy-example"/></button> <button title="全螢幕模式" class="code-window__action-button code-window__action-button--full-screen js-full-screen-code-example-modal"><i class="fas fa-expand"/></button> <button title="退出全螢幕" class="code-window__action-button code-window__action-button--exit-full-screen js-exit-full-screen-code-example-modal"><i class="fas fa-compress"/></button></div><pre class="prettyprint linenums lang-vb"><code>Dim wb As New WorkBook</code></pre></div><div class="code_window_bottom"><span class="pull-right"><span class="ls-span" style="font-weight: 600">VB.NET</span></span></div></div></div><p>上面的程式碼是用來建立一個新的 Excel 檔案。預設情況下，檔案的擴展名是 <code>.xlsx</code>。</p><h3 id="anchor-2-2-36-49-xls-36-49">2.2. 建立 XLS 檔案</h3><p>如果您想建立一個 <code>.xls</code> 擴展名的檔案，您可以使用這個程式碼。</p><pre class="naked-code"><code class="language-vb">Dim wb As New WorkBook(ExcelFileFormat.XLS)</code></pre><div class="code-content code-content-inner"><div class="code_window"><div class="code_window_content"><div class="code-window__action-buttons-wrapper code-window__action-buttons-wrapper--content-page"><button title="點擊複製" class="code-window__action-button code-window__action-button--copy copy-clipboard" data-copy-text="點擊複製" data-copied-text="已複製到剪貼板" data-clipboard-id="code-explorer" data-placement="bottom"><i class="fa-kit fa-copy-example"/></button> <button title="全螢幕模式" class="code-window__action-button code-window__action-button--full-screen js-full-screen-code-example-modal"><i class="fas fa-expand"/></button> <button title="退出全螢幕" class="code-window__action-button code-window__action-button--exit-full-screen js-exit-full-screen-code-example-modal"><i class="fas fa-compress"/></button></div><pre class="prettyprint linenums lang-vb"><code>Dim wb As New WorkBook(ExcelFileFormat.XLS)</code></pre></div><div class="code_window_bottom"><span class="pull-right"><span class="ls-span" style="font-weight: 600">VB.NET</span></span></div></div></div><h3 id="anchor-2-3-36-49">2.3. 創建工作表</h3><p>創建工作簿後，可以如下創建 Excel 工作表：</p><pre class="naked-code"><code class="language-vb">Dim ws1 As WorkSheet = wb.CreateWorkSheet("Sheet1")</code></pre><div class="code-content code-content-inner"><div class="code_window"><div class="code_window_content"><div class="code-window__action-buttons-wrapper code-window__action-buttons-wrapper--content-page"><button title="點擊複製" class="code-window__action-button code-window__action-button--copy copy-clipboard" data-copy-text="點擊複製" data-copied-text="已複製到剪貼板" data-clipboard-id="code-explorer" data-placement="bottom"><i class="fa-kit fa-copy-example"/></button> <button title="全螢幕模式" class="code-window__action-button code-window__action-button--full-screen js-full-screen-code-example-modal"><i class="fas fa-expand"/></button> <button title="退出全螢幕" class="code-window__action-button code-window__action-button--exit-full-screen js-exit-full-screen-code-example-modal"><i class="fas fa-compress"/></button></div><pre class="prettyprint linenums lang-vb"><code>Dim ws1 As WorkSheet = wb.CreateWorkSheet("Sheet1")</code></pre></div><div class="code_window_bottom"><span class="pull-right"><span class="ls-span" style="font-weight: 600">VB.NET</span></span></div></div></div><p>上面的程式碼將在 WorkBook <code>wb</code> 中創建名為 <code>sheet1</code> 的新工作表 <code>ws1</code>。</p><h3 id="anchor-2-4-36-49">2.4. 建立多個工作表</h3><p>可以使用相同的方法創建任意數量的工作表：</p><pre class="naked-code"><code class="language-vb">Dim ws2 As WorkSheet = wb.CreateWorkSheet("Sheet2") Dim ws3 As WorkSheet = wb.CreateWorkSheet("Sheet3")</code></pre><div class="code-content code-content-inner"><div class="code_window"><div class="code_window_content"><div class="code-window__action-buttons-wrapper code-window__action-buttons-wrapper--content-page"><button title="點擊複製" class="code-window__action-button code-window__action-button--copy copy-clipboard" data-copy-text="點擊複製" data-copied-text="已複製到剪貼板" data-clipboard-id="code-explorer" data-placement="bottom"><i class="fa-kit fa-copy-example"/></button> <button title="全螢幕模式" class="code-window__action-button code-window__action-button--full-screen js-full-screen-code-example-modal"><i class="fas fa-expand"/></button> <button title="退出全螢幕" class="code-window__action-button code-window__action-button--exit-full-screen js-exit-full-screen-code-example-modal"><i class="fas fa-compress"/></button></div><pre class="prettyprint linenums lang-vb"><code>Dim ws2 As WorkSheet = wb.CreateWorkSheet("Sheet2") Dim ws3 As WorkSheet = wb.CreateWorkSheet("Sheet3")</code></pre></div><div class="code_window_bottom"><span class="pull-right"><span class="ls-span" style="font-weight: 600">VB.NET</span></span></div></div></div><hr class="separator"/><h2 id="anchor-3-36-49">3. 將資料插入工作表</h2><h3 id="anchor-3-1-36-49">3.1. 插入資料到儲存格</h3><p>現在我們可以輕鬆地將資料插入到工作表的儲存格，如下所示：</p><pre class="naked-code"><code class="language-vb"> worksheet("CellAddress").Value = "MyValue"</code></pre><div class="code-content code-content-inner"><div class="code_window"><div class="code_window_content"><div class="code-window__action-buttons-wrapper code-window__action-buttons-wrapper--content-page"><button title="點擊複製" class="code-window__action-button code-window__action-button--copy copy-clipboard" data-copy-text="點擊複製" data-copied-text="已複製到剪貼板" data-clipboard-id="code-explorer" data-placement="bottom"><i class="fa-kit fa-copy-example"/></button> <button title="全螢幕模式" class="code-window__action-button code-window__action-button--full-screen js-full-screen-code-example-modal"><i class="fas fa-expand"/></button> <button title="退出全螢幕" class="code-window__action-button code-window__action-button--exit-full-screen js-exit-full-screen-code-example-modal"><i class="fas fa-compress"/></button></div><pre class="prettyprint linenums lang-vb"><code> worksheet("CellAddress").Value = "MyValue"</code></pre></div><div class="code_window_bottom"><span class="pull-right"><span class="ls-span" style="font-weight: 600">VB.NET</span></span></div></div></div><p>例如，工作表 <code>ws1</code> 中的資料可以插入為：</p><pre class="naked-code"><code class="language-vb">ws1("A1").Value = "Hello World"</code></pre><div class="code-content code-content-inner"><div class="code_window"><div class="code_window_content"><div class="code-window__action-buttons-wrapper code-window__action-buttons-wrapper--content-page"><button title="點擊複製" class="code-window__action-button code-window__action-button--copy copy-clipboard" data-copy-text="點擊複製" data-copied-text="已複製到剪貼板" data-clipboard-id="code-explorer" data-placement="bottom"><i class="fa-kit fa-copy-example"/></button> <button title="全螢幕模式" class="code-window__action-button code-window__action-button--full-screen js-full-screen-code-example-modal"><i class="fas fa-expand"/></button> <button title="退出全螢幕" class="code-window__action-button code-window__action-button--exit-full-screen js-exit-full-screen-code-example-modal"><i class="fas fa-compress"/></button></div><pre class="prettyprint linenums lang-vb"><code>ws1("A1").Value = "Hello World"</code></pre></div><div class="code_window_bottom"><span class="pull-right"><span class="ls-span" style="font-weight: 600">VB.NET</span></span></div></div></div><p>上述程式碼將在工作表 <code>ws1</code> 的 <code>A1</code> 單元格中寫入 <code>Hello World</code>。</p><h3 id="anchor-3-2-36-49">3.2. 插入資料至範圍</h3><p>也可以使用範圍函數將資料寫入多個儲存格，如下所示：</p><pre class="naked-code"><code class="language-vb">ws1("A3:A8").Value = "NewValue"</code></pre><div class="code-content code-content-inner"><div class="code_window"><div class="code_window_content"><div class="code-window__action-buttons-wrapper code-window__action-buttons-wrapper--content-page"><button title="點擊複製" class="code-window__action-button code-window__action-button--copy copy-clipboard" data-copy-text="點擊複製" data-copied-text="已複製到剪貼板" data-clipboard-id="code-explorer" data-placement="bottom"><i class="fa-kit fa-copy-example"/></button> <button title="全螢幕模式" class="code-window__action-button code-window__action-button--full-screen js-full-screen-code-example-modal"><i class="fas fa-expand"/></button> <button title="退出全螢幕" class="code-window__action-button code-window__action-button--exit-full-screen js-exit-full-screen-code-example-modal"><i class="fas fa-compress"/></button></div><pre class="prettyprint linenums lang-vb"><code>ws1("A3:A8").Value = "NewValue"</code></pre></div><div class="code_window_bottom"><span class="pull-right"><span class="ls-span" style="font-weight: 600">VB.NET</span></span></div></div></div><p>上述代碼會將 <code>NewValue</code> 從工作表 <code>ws1</code> 的單元格 <code>A3</code> 寫到 <code>A8</code>。</p><h3 id="anchor-3-3-36-49">3.3. 建立和編輯工作表範例</h3><p>我們將建立一個新的 Excel 文件 <code>Sample.xlsx</code> 並插入一些數據，以展示我們上面學到的代碼。</p><pre class="naked-code"><code class="language-vb">/** Create and Edit Excel anchor-create-and-edit-worksheets-example Imports IronXL Sub Main() Dim wb As New WorkBook(ExcelFileFormat.XLSX) Dim ws1 As WorkSheet = wb.CreateWorkSheet("Sheet1") ws1("A1").Value = "Hello" ws1("A2").Value = "World" ws1("B1:B8").Value = "RangeValue" wb.SaveAs("Sample.xlsx") End Sub</code></pre><div class="code-content code-content-inner"><div class="code_window"><div class="code_window_content"><div class="code-window__action-buttons-wrapper code-window__action-buttons-wrapper--content-page"><button title="點擊複製" class="code-window__action-button code-window__action-button--copy copy-clipboard" data-copy-text="點擊複製" data-copied-text="已複製到剪貼板" data-clipboard-id="code-explorer" data-placement="bottom"><i class="fa-kit fa-copy-example"/></button> <button title="全螢幕模式" class="code-window__action-button code-window__action-button--full-screen js-full-screen-code-example-modal"><i class="fas fa-expand"/></button> <button title="退出全螢幕" class="code-window__action-button code-window__action-button--exit-full-screen js-exit-full-screen-code-example-modal"><i class="fas fa-compress"/></button></div><pre class="prettyprint linenums lang-vb"><code>/** Create and Edit Excel anchor-create-and-edit-worksheets-example Imports IronXL Sub Main() Dim wb As New WorkBook(ExcelFileFormat.XLSX) Dim ws1 As WorkSheet = wb.CreateWorkSheet("Sheet1") ws1("A1").Value = "Hello" ws1("A2").Value = "World" ws1("B1:B8").Value = "RangeValue" wb.SaveAs("Sample.xlsx") End Sub</code></pre></div><div class="code_window_bottom"><span class="pull-right"><span class="ls-span" style="font-weight: 600">VB.NET</span></span></div></div></div><p><b>注意：預設情況下，新Excel文件將在專案的<code>bin&gt;Debug</code>資料夾中創建。如果我們想在自定義路徑中創建新文件，則：</b></p><p><code>wb.SaveAs(@"E:\IronXL\Sample.xlsx")</code></p><p>Here is the screenshot of our newly created Excel file <code>sample.xlsx</code>:</p><center><div class="center-image-wrapper"><a rel="nofollow noopener noreferrer" href="/zh-hant/img/faq/excel/vb-net-excel-files/doc5-1.png" target="_blank"><img src="/img/faq/excel/vb-net-excel-files/doc5-1.png" alt="" class="img-responsive add-shadow img-responsive img-popup" loading="lazy" width="347" height="222"/></a></div></center><p>很明顯，在VB.NET應用程式中使用 <code>IronXL</code> 創建Excel文件是多麼簡單。</p><hr class="separator"/><h2 id="anchor-4-36-49-vb-net-36-49-excel-36-49">4. 使用 VB.NET 讀取 Excel 文件</h2><p>IronXL 也提供了一種簡單的方法來讀取 Excel (<code>.xlsx</code>) 在您的VB dotnet項目中處理檔案。為此，只需獲取Excel文件，將其加載到您的項目中，讀取其數據，並根據您的需求使用它。</p><p>請按照以下步驟操作：</p><h3 id="anchor-4-1-36-49-excel-36-49">4.1. 在專案中存取 Excel 檔案</h3><p><code>WorkBook</code> 是 IronXL 的類別，其對象提供對 Excel 檔案及其功能的全面訪問。例如，如果我們想要存取 Excel 檔案，我們只需使用：</p><pre class="naked-code"><code class="language-vb">WorkBook wb = WorkBook.Load("sample.xlsx") 'Excel file path</code></pre><div class="code-content code-content-inner"><div class="code_window"><div class="code_window_content"><div class="code-window__action-buttons-wrapper code-window__action-buttons-wrapper--content-page"><button title="點擊複製" class="code-window__action-button code-window__action-button--copy copy-clipboard" data-copy-text="點擊複製" data-copied-text="已複製到剪貼板" data-clipboard-id="code-explorer" data-placement="bottom"><i class="fa-kit fa-copy-example"/></button> <button title="全螢幕模式" class="code-window__action-button code-window__action-button--full-screen js-full-screen-code-example-modal"><i class="fas fa-expand"/></button> <button title="退出全螢幕" class="code-window__action-button code-window__action-button--exit-full-screen js-exit-full-screen-code-example-modal"><i class="fas fa-compress"/></button></div><pre class="prettyprint linenums lang-vb"><code>WorkBook wb = WorkBook.Load("sample.xlsx") 'Excel file path</code></pre></div><div class="code_window_bottom"><span class="pull-right"><span class="ls-span" style="font-weight: 600">VB.NET</span></span></div></div></div><p>在上面的程式碼中，<code>WorkBook.Load()將</code>sample.xlsx<code>載入到</code>wb<code>中。可以通過存取 Excel 文件的特定工作表對</code>wb` 執行任何類型的函式。</p><h3 id="anchor-4-2-36-49">4.2. 訪問特定工作表</h3><p>要訪問 Excel 中的特定工作表，可以使用 <code>WorkSheet</code> 類，這個類可以通過以下不同方式使用：</p><h4 id="anchor-4-2-1-36-49">4.2.1. 按工作表名稱</h4><pre class="naked-code"><code class="language-vb">Dim ws As WorkSheet = WorkBook.GetWorkSheet("sheet1") 'by sheet name</code></pre><div class="code-content code-content-inner"><div class="code_window"><div class="code_window_content"><div class="code-window__action-buttons-wrapper code-window__action-buttons-wrapper--content-page"><button title="點擊複製" class="code-window__action-button code-window__action-button--copy copy-clipboard" data-copy-text="點擊複製" data-copied-text="已複製到剪貼板" data-clipboard-id="code-explorer" data-placement="bottom"><i class="fa-kit fa-copy-example"/></button> <button title="全螢幕模式" class="code-window__action-button code-window__action-button--full-screen js-full-screen-code-example-modal"><i class="fas fa-expand"/></button> <button title="退出全螢幕" class="code-window__action-button code-window__action-button--exit-full-screen js-exit-full-screen-code-example-modal"><i class="fas fa-compress"/></button></div><pre class="prettyprint linenums lang-vb"><code>Dim ws As WorkSheet = WorkBook.GetWorkSheet("sheet1") 'by sheet name</code></pre></div><div class="code_window_bottom"><span class="pull-right"><span class="ls-span" style="font-weight: 600">VB.NET</span></span></div></div></div><p><code>wb</code> 是在上述部分聲明的 WorkBook。</p><h4 id="anchor-4-2-2-36-49">4.2.2. 按工作表索引</h4><pre class="naked-code"><code class="language-vb"> Dim ws As WorkSheet = WorkBook.WorkSheets(0) 'by sheet index</code></pre><div class="code-content code-content-inner"><div class="code_window"><div class="code_window_content"><div class="code-window__action-buttons-wrapper code-window__action-buttons-wrapper--content-page"><button title="點擊複製" class="code-window__action-button code-window__action-button--copy copy-clipboard" data-copy-text="點擊複製" data-copied-text="已複製到剪貼板" data-clipboard-id="code-explorer" data-placement="bottom"><i class="fa-kit fa-copy-example"/></button> <button title="全螢幕模式" class="code-window__action-button code-window__action-button--full-screen js-full-screen-code-example-modal"><i class="fas fa-expand"/></button> <button title="退出全螢幕" class="code-window__action-button code-window__action-button--exit-full-screen js-exit-full-screen-code-example-modal"><i class="fas fa-compress"/></button></div><pre class="prettyprint linenums lang-vb"><code> Dim ws As WorkSheet = WorkBook.WorkSheets(0) 'by sheet index</code></pre></div><div class="code_window_bottom"><span class="pull-right"><span class="ls-span" style="font-weight: 600">VB.NET</span></span></div></div></div><h4 id="anchor-4-2-3-36-49">4.2.3. 預設工作表</h4><pre class="naked-code"><code class="language-vb">Dim ws As WorkSheet = workbook.DefaultWorkSheet() 'for the default sheet: </code></pre><div class="code-content code-content-inner"><div class="code_window"><div class="code_window_content"><div class="code-window__action-buttons-wrapper code-window__action-buttons-wrapper--content-page"><button title="點擊複製" class="code-window__action-button code-window__action-button--copy copy-clipboard" data-copy-text="點擊複製" data-copied-text="已複製到剪貼板" data-clipboard-id="code-explorer" data-placement="bottom"><i class="fa-kit fa-copy-example"/></button> <button title="全螢幕模式" class="code-window__action-button code-window__action-button--full-screen js-full-screen-code-example-modal"><i class="fas fa-expand"/></button> <button title="退出全螢幕" class="code-window__action-button code-window__action-button--exit-full-screen js-exit-full-screen-code-example-modal"><i class="fas fa-compress"/></button></div><pre class="prettyprint linenums lang-vb"><code>Dim ws As WorkSheet = workbook.DefaultWorkSheet() 'for the default sheet: </code></pre></div><div class="code_window_bottom"><span class="pull-right"><span class="ls-span" style="font-weight: 600">VB.NET</span></span></div></div></div><h4 id="anchor-4-2-4-36-49">4.2.4. 第一張表單</h4><pre class="naked-code"><code class="language-vb">Dim sheet As WorkSheet = workbook.WorkSheets.FirstOrDefault() 'for the first sheet:</code></pre><div class="code-content code-content-inner"><div class="code_window"><div class="code_window_content"><div class="code-window__action-buttons-wrapper code-window__action-buttons-wrapper--content-page"><button title="點擊複製" class="code-window__action-button code-window__action-button--copy copy-clipboard" data-copy-text="點擊複製" data-copied-text="已複製到剪貼板" data-clipboard-id="code-explorer" data-placement="bottom"><i class="fa-kit fa-copy-example"/></button> <button title="全螢幕模式" class="code-window__action-button code-window__action-button--full-screen js-full-screen-code-example-modal"><i class="fas fa-expand"/></button> <button title="退出全螢幕" class="code-window__action-button code-window__action-button--exit-full-screen js-exit-full-screen-code-example-modal"><i class="fas fa-compress"/></button></div><pre class="prettyprint linenums lang-vb"><code>Dim sheet As WorkSheet = workbook.WorkSheets.FirstOrDefault() 'for the first sheet:</code></pre></div><div class="code_window_bottom"><span class="pull-right"><span class="ls-span" style="font-weight: 600">VB.NET</span></span></div></div></div><h4 id="anchor-4-2-1-36-49">4.2.1. 第一或預設工作表</h4><pre class="naked-code"><code class="language-vb">Dim sheet As WorkSheet = workbook.WorkSheets.FirstOrDefault() 'for the first or default sheet:</code></pre><div class="code-content code-content-inner"><div class="code_window"><div class="code_window_content"><div class="code-window__action-buttons-wrapper code-window__action-buttons-wrapper--content-page"><button title="點擊複製" class="code-window__action-button code-window__action-button--copy copy-clipboard" data-copy-text="點擊複製" data-copied-text="已複製到剪貼板" data-clipboard-id="code-explorer" data-placement="bottom"><i class="fa-kit fa-copy-example"/></button> <button title="全螢幕模式" class="code-window__action-button code-window__action-button--full-screen js-full-screen-code-example-modal"><i class="fas fa-expand"/></button> <button title="退出全螢幕" class="code-window__action-button code-window__action-button--exit-full-screen js-exit-full-screen-code-example-modal"><i class="fas fa-compress"/></button></div><pre class="prettyprint linenums lang-vb"><code>Dim sheet As WorkSheet = workbook.WorkSheets.FirstOrDefault() 'for the first or default sheet:</code></pre></div><div class="code_window_bottom"><span class="pull-right"><span class="ls-span" style="font-weight: 600">VB.NET</span></span></div></div></div><p>在獲取 Excel 工作表 <code>ws</code> 之後，您可以從對應的工作表中獲取任何類型的數據，並執行所有 Excel 功能。</p><hr class="separator"/><h2 id="anchor-5-36-49">5. 從工作表存取資料</h2><p>可以這樣從 ExcelSheet <code>ws</code> 存取資料：</p><pre class="naked-code"><code class="language-vb">Dim int_Value As Integer = sheet("A2").IntValue 'for integer Dim str_value As String = sheet("A2").ToString() 'for string</code></pre><div class="code-content code-content-inner"><div class="code_window"><div class="code_window_content"><div class="code-window__action-buttons-wrapper code-window__action-buttons-wrapper--content-page"><button title="點擊複製" class="code-window__action-button code-window__action-button--copy copy-clipboard" data-copy-text="點擊複製" data-copied-text="已複製到剪貼板" data-clipboard-id="code-explorer" data-placement="bottom"><i class="fa-kit fa-copy-example"/></button> <button title="全螢幕模式" class="code-window__action-button code-window__action-button--full-screen js-full-screen-code-example-modal"><i class="fas fa-expand"/></button> <button title="退出全螢幕" class="code-window__action-button code-window__action-button--exit-full-screen js-exit-full-screen-code-example-modal"><i class="fas fa-compress"/></button></div><pre class="prettyprint linenums lang-vb"><code>Dim int_Value As Integer = sheet("A2").IntValue 'for integer Dim str_value As String = sheet("A2").ToString() 'for string</code></pre></div><div class="code_window_bottom"><span class="pull-right"><span class="ls-span" style="font-weight: 600">VB.NET</span></span></div></div></div><h3 id="anchor-5-1-36-49">5.1. 從指定欄位獲取資料</h3><p>這樣做也可以從指定欄位的多個單元格獲取資料：</p><pre class="naked-code"><code class="language-vb">For Each cell In sheet("A2:A10") Console.WriteLine("value is: {0}", cell.Text) Next cell</code></pre><div class="code-content code-content-inner"><div class="code_window"><div class="code_window_content"><div class="code-window__action-buttons-wrapper code-window__action-buttons-wrapper--content-page"><button title="點擊複製" class="code-window__action-button code-window__action-button--copy copy-clipboard" data-copy-text="點擊複製" data-copied-text="已複製到剪貼板" data-clipboard-id="code-explorer" data-placement="bottom"><i class="fa-kit fa-copy-example"/></button> <button title="全螢幕模式" class="code-window__action-button code-window__action-button--full-screen js-full-screen-code-example-modal"><i class="fas fa-expand"/></button> <button title="退出全螢幕" class="code-window__action-button code-window__action-button--exit-full-screen js-exit-full-screen-code-example-modal"><i class="fas fa-compress"/></button></div><pre class="prettyprint linenums lang-vb"><code>For Each cell In sheet("A2:A10") Console.WriteLine("value is: {0}", cell.Text) Next cell</code></pre></div><div class="code_window_bottom"><span class="pull-right"><span class="ls-span" style="font-weight: 600">VB.NET</span></span></div></div></div><p>它將顯示從單元格 <code>A2</code> 到 <code>A10</code> 的值。以下是上述整個討論的代碼示例。</p><pre class="naked-code"><code class="language-vb">/** Load and Edit Values anchor-data-from-specific-column Imports IronXL Sub Main() Dim wb As WorkBook = WorkBook.Load("sample.xlsx") Dim ws As WorkSheet = wb.WorkSheets.FirstOrDefault() For Each cell In ws("A2:A10") Console.WriteLine("value is: {0}", cell.Text) Console.ReadKey() End Sub</code></pre><div class="code-content code-content-inner"><div class="code_window"><div class="code_window_content"><div class="code-window__action-buttons-wrapper code-window__action-buttons-wrapper--content-page"><button title="點擊複製" class="code-window__action-button code-window__action-button--copy copy-clipboard" data-copy-text="點擊複製" data-copied-text="已複製到剪貼板" data-clipboard-id="code-explorer" data-placement="bottom"><i class="fa-kit fa-copy-example"/></button> <button title="全螢幕模式" class="code-window__action-button code-window__action-button--full-screen js-full-screen-code-example-modal"><i class="fas fa-expand"/></button> <button title="退出全螢幕" class="code-window__action-button code-window__action-button--exit-full-screen js-exit-full-screen-code-example-modal"><i class="fas fa-compress"/></button></div><pre class="prettyprint linenums lang-vb"><code>/** Load and Edit Values anchor-data-from-specific-column Imports IronXL Sub Main() Dim wb As WorkBook = WorkBook.Load("sample.xlsx") Dim ws As WorkSheet = wb.WorkSheets.FirstOrDefault() For Each cell In ws("A2:A10") Console.WriteLine("value is: {0}", cell.Text) Console.ReadKey() End Sub</code></pre></div><div class="code_window_bottom"><span class="pull-right"><span class="ls-span" style="font-weight: 600">VB.NET</span></span></div></div></div><p>這將顯示以下輸出：</p><center><div class="center-image-wrapper"><a rel="nofollow noopener noreferrer" href="/zh-hant/img/faq/excel/vb-net-excel-files/doc3-input1.png" target="_blank"><img src="/img/faq/excel/vb-net-excel-files/doc3-input1.png" alt="" class="img-responsive add-shadow img-responsive img-popup" loading="lazy" width="359" height="160"/></a></div></center><p>我們可以看到 Excel 文件 <code>Sample.xlsx</code> 的截圖：</p><center><div class="center-image-wrapper"><a rel="nofollow noopener noreferrer" href="/zh-hant/img/faq/excel/vb-net-excel-files/doc3-1.png" target="_blank"><img src="/img/faq/excel/vb-net-excel-files/doc3-1.png" alt="" class="img-responsive add-shadow img-responsive img-popup" loading="lazy" width="545" height="340"/></a></div></center><hr class="separator"/><h2 id="anchor-6-36-49">6. 在數據上執行函數</h2><p>通過以下方式使用匯總函數（如Sum、Min或Max）來訪問Excel工作表中的篩選數據是非常簡單的：</p><pre class="naked-code"><code class="language-vb">Dim sum As Decimal = ws("From:To").Sum() Dim min As Decimal = ws("From:To").Min() Dim max As Decimal = ws("From:To").Max()</code></pre><div class="code-content code-content-inner"><div class="code_window"><div class="code_window_content"><div class="code-window__action-buttons-wrapper code-window__action-buttons-wrapper--content-page"><button title="點擊複製" class="code-window__action-button code-window__action-button--copy copy-clipboard" data-copy-text="點擊複製" data-copied-text="已複製到剪貼板" data-clipboard-id="code-explorer" data-placement="bottom"><i class="fa-kit fa-copy-example"/></button> <button title="全螢幕模式" class="code-window__action-button code-window__action-button--full-screen js-full-screen-code-example-modal"><i class="fas fa-expand"/></button> <button title="退出全螢幕" class="code-window__action-button code-window__action-button--exit-full-screen js-exit-full-screen-code-example-modal"><i class="fas fa-compress"/></button></div><pre class="prettyprint linenums lang-vb"><code>Dim sum As Decimal = ws("From:To").Sum() Dim min As Decimal = ws("From:To").Min() Dim max As Decimal = ws("From:To").Max()</code></pre></div><div class="code_window_bottom"><span class="pull-right"><span class="ls-span" style="font-weight: 600">VB.NET</span></span></div></div></div><p>您可以閱讀更多有關 <a href="/zh-hant/csharp/excel/tutorials/csharp-open-write-excel-file/" target="__blank">Excel 聚合函数</a> 這裡。</p><pre class="naked-code"><code class="language-vb">/** Apply Functions to Data anchor-perform-functions-on-data Imports IronXL Sub Main() Dim wb As WorkBook = WorkBook.Load("sample.xlsx") Dim ws As WorkSheet = wb.WorkSheets.FirstOrDefault() Dim sum As Decimal = ws("G2:G10").Sum() Dim min As Decimal = ws("G2:G10").Min() Dim max As Decimal = ws("G2:G10").Max() Console.WriteLine("Sum is: {0}", sum) Console.WriteLine("Min is: {0}", min) Console.WriteLine("Max is: {0}", max) Console.ReadKey() End Sub</code></pre><div class="code-content code-content-inner"><div class="code_window"><div class="code_window_content"><div class="code-window__action-buttons-wrapper code-window__action-buttons-wrapper--content-page"><button title="點擊複製" class="code-window__action-button code-window__action-button--copy copy-clipboard" data-copy-text="點擊複製" data-copied-text="已複製到剪貼板" data-clipboard-id="code-explorer" data-placement="bottom"><i class="fa-kit fa-copy-example"/></button> <button title="全螢幕模式" class="code-window__action-button code-window__action-button--full-screen js-full-screen-code-example-modal"><i class="fas fa-expand"/></button> <button title="退出全螢幕" class="code-window__action-button code-window__action-button--exit-full-screen js-exit-full-screen-code-example-modal"><i class="fas fa-compress"/></button></div><pre class="prettyprint linenums lang-vb"><code>/** Apply Functions to Data anchor-perform-functions-on-data Imports IronXL Sub Main() Dim wb As WorkBook = WorkBook.Load("sample.xlsx") Dim ws As WorkSheet = wb.WorkSheets.FirstOrDefault() Dim sum As Decimal = ws("G2:G10").Sum() Dim min As Decimal = ws("G2:G10").Min() Dim max As Decimal = ws("G2:G10").Max()