Aspose Cells Example C# Alternatives (No Interop)

link管理

链接快照平台

输入网页链接，自动生成快照
标签化管理网页链接

相关文章推荐

才高八斗的西瓜 · 聊城2020年高中招生计划公布！聊城一中30 ...· 9 月前 ·

追风的茶壶 · 老正聊史｜华约的诞生与夭折|北约|波兰|东德 ...· 9 月前 ·

帅呆的匕首 · 汪峰家世背景曝光，来头大的吓人，难怪章子怡4 ...· 9 月前 ·

至今单身的韭菜 · 关闭Clash后Chrome或者Edge浏览 ...· 10 月前 ·

侠义非凡的炒饭 · 【原神】史莱姆大战莹_哔哩哔哩bilibili· 1 年前 ·

</noscript><header id="header" class="products-header products-header_margin-top-desktop"><div id="header-navbars" class="js-toggle-class-on-scroll nav-bars" data-toggle-class="nav-bars_translate-up"><div id="header-navbar-black" class="js-search-offset-block top-bar"><nav id="top-navbar" class="navbar navbar_bg-lighter navbar-inverse navbar-static-top marginBottom-0" role="navigation"><div class="navbar-header"><button class="navbar-toggle collapsed" data-target="#navbar-collapse-1" data-toggle="collapse" type="button"><span class="sr-only">Toggle navigation</span> <i class="fa fa-bars"/> <i class="fas fa-times"/></button> <a id="header-navbar-black-logo" class="navbar-brand navbar-brand_small" href="/"><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><strong>Iron</strong>Software</span></a></div><div class="collapse navbar-collapse" id="navbar-collapse-1"><ul class="nav navbar-nav"><li class="js-dropdown-open-hover dropdown"><a id="header-navbar-black-item-products" class="navbar__item-link dropdown-toggle" data-toggle="dropdown" href="#">Products <b class="caret"/></a><div class="dropdown-menu"><div class="nav-products__wrapper"><div id="header-navbar-black-dropdown-products" class="nav-products"><a id="header-navbar-black-dropdown-product-ironpdf" class="nav-product" href="http://ironpdf.com" title="Click to view the IronPDF homepage"><span class="nav-product__image" style="background-image: url('/img/products/ironpdf-logo.svg');"/> <span class="nav-product__content"><div class="nav-product__title"><span class="nav-product__title__text-logo" style="background-image: url('/img/products/ironpdf-text-dotnet.svg'); width:103px; height:19px;"/><div class="nav-product__product-languages"><span class="nav-product__language-selector__prefix">for</span> <span class="nav-product__language-selector__language-list IronPDF"><span class="nav-product__language-selector__language-item dotnet" data-url="http://ironpdf.com">.NET</span> <span class="nav-product__language-selector__language-separator"/> <span class="nav-product__language-selector__language-item java" data-url="http://ironpdf.com/java/">Java</span></span></div></div><span class="nav-product__description">Create, read, and edit PDFs </span></span></a><a id="header-navbar-black-dropdown-product-ironocr" class="nav-product" href="/csharp/ocr/" title="Click to view the IronOCR homepage"><span class="nav-product__image" style="background-image: url('/img/products/ironocr-logo.svg');"/> <span class="nav-product__content"><div class="nav-product__title"><span class="nav-product__title__text-logo" style="background-image: url('/img/products/ironocr-text-dotnet.svg'); width:107px; height:19px;"/><div class="nav-product__product-languages"><span class="nav-product__language-selector__prefix">for</span> <span class="nav-product__language-selector__language-list IronOCR"><span class="nav-product__language-selector__language-item dotnet" data-url="/csharp/ocr/">.NET</span></span></div></div><span class="nav-product__description">Image to text in 127 languages </span></span></a><a id="header-navbar-black-dropdown-product-ironbarcode" class="nav-product" href="/csharp/barcode/" title="Click to view the IronBarcode homepage"><span class="nav-product__image" style="background-image: url('/img/products/ironbarcode-logo.svg');"/> <span class="nav-product__content"><div class="nav-product__title"><span class="nav-product__title__text-logo" style="background-image: url('/img/products/ironbarcode-text-dotnet.svg'); width:168px; height:19px;"/><div class="nav-product__product-languages"><span class="nav-product__language-selector__prefix">for</span> <span class="nav-product__language-selector__language-list IronBarcode"><span class="nav-product__language-selector__language-item dotnet" data-url="/csharp/barcode/">.NET</span></span></div></div><span class="nav-product__description">Read and write QR &amp; Barcodes </span></span></a><a id="header-navbar-black-dropdown-product-ironxl" class="nav-product" href="/csharp/excel/" title="Click to view the IronXL homepage"><span class="nav-product__image" style="background-image: url('/img/products/ironxl-logo.svg');"/> <span class="nav-product__content"><div class="nav-product__title"><span class="nav-product__title__text-logo" style="background-image: url('/img/products/ironxl-text-dotnet.svg'); width:88px; height:19px;"/><div class="nav-product__product-languages"><span class="nav-product__language-selector__prefix">for</span> <span class="nav-product__language-selector__language-list IronXL"><span class="nav-product__language-selector__language-item dotnet" data-url="/csharp/excel/">.NET</span></span></div></div><span class="nav-product__description">Edit Excel &amp; CSV Files.<br/>No Office Interop required </span></span></a><a id="header-navbar-black-dropdown-product-ironwebscraper" class="nav-product" href="/csharp/webscraper/" title="Click to view the IronWebscraper homepage"><span class="nav-product__image" style="background-image: url('/img/products/ironwebscraper-logo.svg');"/> <span class="nav-product__content"><div class="nav-product__title"><span class="nav-product__title__text-logo" style="background-image: url('/img/products/ironwebscraper-text-dotnet.svg'); width:197px; height:19px;"/><div class="nav-product__product-languages"><span class="nav-product__language-selector__prefix">for</span> <span class="nav-product__language-selector__language-list IronWebScraper"><span class="nav-product__language-selector__language-item dotnet" data-url="/csharp/webscraper/">.NET</span></span></div></div><span class="nav-product__description">Extract structured data from websites </span></span></a><a id="header-navbar-black-dropdown-product-ironsuite" class="nav-product-special" href="/suite/" title="Click to view IronSuite licensing" style="background-image: url('/img/products/special-offer-bg.svg');"><span class="nav-product-special__title">5 for the Price of 2 </span><span class="nav-product-special__description">All 5 .NET product licenses from <strong>$1498</strong> </span><span class="nav-product-special__button"><span>Save 60% with Iron Suite </span></span><img class="nav-product-special__teamseas" src="/img/svgs/teamseas-logo-for-dropdown.svg" alt="Iron Suites - Donate $50"/></a></div></div></div></li><li class="js-dropdown-open-hover dropdown"><a id="link-opensource-list" class="navbar__item-link dropdown-toggle" href="#" data-toggle="dropdown">Open Source <b class="caret"/></a><div class="dropdown-menu"><div class="nav-products__wrapper"><div class="nav-products"><a class="nav-product" href="/open-source/csharp/drawing/" title="Click to view the IronDrawing homepage"><span class="nav-product__image" style="background-image: url('/img/products/irondrawing-icon.svg');"/> <span class="nav-product__content"><div class="nav-product__title"><span class="nav-product__title__text-logo" style="background-image: url('/img/products/irondrawing-text-without-icon-white-text.svg'); width:162px; height:19px;"/><div class="nav-product__product-languages"><span class="nav-product__language-selector__prefix">for</span> <span class="nav-product__language-selector__language-list IronDrawing"><span class="nav-product__language-selector__language-item dotnet" data-url="/open-source/csharp/drawing/">.NET</span></span></div></div><span class="nav-product__description">System.Drawing.Common Replacement</span></span></a></div></div></div></li><li><a class="navbar__item-link" href="https://ironsoftware.com/about-us/" target="_blank">About Us</a></li><li><a class="navbar__item-link" href="https://ironsoftware.com/contact-us/" target="_blank">Contact Us</a></li></ul><div class="navbar__address-wrapper"><p class="navbar__address-text"><span class="navbar__address-visability">205 N. Michigan Ave. Chicago, IL 60611, USA </span><span class="navbar__phone-number">+1 (312) 500-3060</span></p><p class="nav-bar__slack-link-wrapper"><a class="nav-bar__slack-link" href="/company/iron-slack-community/"><svg width="14" height="14" viewbox="0 0 14 14" fill="none" xmlns="http://www.w3.org/2000/svg" class="navbar__slack-icon"><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>Join Iron Slack</a></p></div><div class="mobile-only-nav"><ul class="nav navbar-nav"><li><a class="mobile-only-nav__item-link" href="/csharp/excel/"><span class="mobile-only-nav__item-link-text">Home</span></a></li><li><a class="mobile-only-nav__item-link" href="/csharp/excel/licensing/"><span class="mobile-only-nav__item-link-text">Licensing</span></a></li><li><a class="mobile-only-nav__item-link" href="/csharp/excel/licensing/#license-terms-modal-tabs-eula"><span class="mobile-only-nav__item-link-text">EULA</span></a></li><li><a class="mobile-only-nav__item-link" href="/csharp/excel/licensing/extensions/"><span class="mobile-only-nav__item-link-text">Support &amp; Update Extensions</span></a></li><li><a class="mobile-only-nav__item-link" href="/csharp/excel/licensing/upgrades/"><span class="mobile-only-nav__item-link-text">License Upgrades</span></a></li><li><a class="mobile-only-nav__item-link" href="#trial-license"><span class="mobile-only-nav__item-link-text">Start 30-Day Trial</span></a></li><li><a class="mobile-only-nav__item-link" href="/csharp/excel/features/"><span class="mobile-only-nav__item-link-text">Features</span></a></li><li><a class="mobile-only-nav__item-link" href="/csharp/excel/docs/"><span class="mobile-only-nav__item-link-text">Get Started</span></a></li><li><a class="mobile-only-nav__item-link" href="/csharp/excel/examples/read-excel/"><span class="mobile-only-nav__item-link-text">Code Examples</span></a></li><li><a class="mobile-only-nav__item-link" href="/csharp/excel/tutorials/how-to-read-excel-file-csharp/"><span class="mobile-only-nav__item-link-text">Tutorials</span></a></li><li><a class="mobile-only-nav__item-link" href="/csharp/excel/how-to/create-xlsx-file-c-sharp/"><span class="mobile-only-nav__item-link-text">How-Tos</span></a></li><li><a class="mobile-only-nav__item-link" href="/csharp/excel/troubleshooting/apply-a-license-key-in-ironxl/"><span class="mobile-only-nav__item-link-text">Troubleshooting</span></a></li><li><a class="mobile-only-nav__item-link" href="/csharp/excel/product-updates/changelog/"><span class="mobile-only-nav__item-link-text">Product Updates</span></a></li><li><a class="mobile-only-nav__item-link" href="/csharp/excel/object-reference/api/" target="_blank"><span class="mobile-only-nav__item-link-text">API Reference </span><i class="mobile-only-nav__item-link-icon fas fa-external-link-square-alt"/></a></li><li class="js-search__button search-button search-button_visible" data-active-class="search-button_active"><a class="search-button__link"><span class="search-button__link-icon"><svg width="18" height="18" viewbox="0 0 18 18" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M7.69724 15.3945C9.40504 15.3941 11.0636 14.8224 12.4089 13.7704L16.6385 18L17.999 16.6395L13.7694 12.4099C14.822 11.0645 15.3941 9.40549 15.3945 7.69724C15.3945 3.45318 11.9413 0 7.69724 0C3.45318 0 0 3.45318 0 7.69724C0 11.9413 3.45318 15.3945 7.69724 15.3945ZM7.69724 1.92431C10.881 1.92431 13.4702 4.51347 13.4702 7.69724C13.4702 10.881 10.881 13.4702 7.69724 13.4702C4.51347 13.4702 1.92431 10.881 1.92431 7.69724C1.92431 4.51347 4.51347 1.92431 7.69724 1.92431Z" fill="#181818"/></svg> </span><span class="search-button__link-text">Search</span></a></li><li><a class="js-modal-open btn" href="https://www.nuget.org/packages/IronXL.Excel/" target="_blank" data-modal-id="trial-license-after-download"><i class="nuget-icon-white2"/> <span>Free NuGet Download</span></a></li></ul></div></div></nav></div><div id="header-navbar-white" class="js-search-offset-block navbar-container"><nav id="navbar" class="navbar navbar_no-fixed navbar-default" role="navigation"><div class="container-fluid container-fluid_wide" style="position: relative;"><div class="navbar-header"><button class="navbar-toggle" data-target="#navbar-collapse-2" data-toggle="collapse" type="button"><span class="sr-only">Toggle navigation</span> <span class="icon-bar"/> <span class="icon-bar"/> <span class="icon-bar"/></button></div><div class="header-navbar-logo-wrapper"><div id="header-navbar-white-logo" class="logo-product logo-product_out-content"><a href="/csharp/excel/" class="logo-product-img-link" title="Click to view the IronXL homepage"><img class="logo-product__black-font-logo" src="/img/products/ironxl-logo-text-dotnet.svg" alt="IronXL - Excel Library for C# .NET" width="191" height="34"/> <img class="logo-product__white-font-logo" src="/img/products/ironxl-logo-text-dotnet_white-font.svg" alt="IronXL - Excel Library for C# .NET"/></a></div><a href="/csharp/excel/"><div class="header-navbar-logo-wrapper__home-icon"/></a></div><div class="product-collapse collapse navbar-collapse" id="navbar-collapse-2"><ul id="header-navbar-white-items" class="nav navbar-nav"><li><a class="navbar__item" href="/csharp/excel/"><span class="navbar__item-text"><div class="navbar__item__home-link-icon"/><span class="navbar__item__home-link-anchor">Home</span></span></a></li><li id="header-navbar-white-item-licensing" class="sub-menu"><a class="navbar__item" href="/csharp/excel/licensing/"><span class="navbar__item-text">Licensing </span><i class="navbar__item-icon fas fa-chevron-down"/></a><ul class="dropdown-menu"><li id="header-navbar-white-item-buy-license"><a class="sub-menu__item-link" href="/csharp/excel/licensing/"><span class="navmenu-icon img-icon navmenu-icon__topmenu-icon"><svg width="20" height="20" viewbox="0 0 20 20" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M13.3242 13.42V18.6024L9.97999 17.2852L6.67578 18.6024V13.4199" stroke="#181818" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"/><path d="M10.0722 1.17975C9.20556 1.17975 8.33889 1.61308 7.90556 2.40753C7.47309 2.29681 7.0194 2.2993 6.58818 2.41477C6.15696 2.53024 5.76274 2.75479 5.44347 3.0668C5.1242 3.37881 4.89065 3.76777 4.7653 4.19623C4.63995 4.62468 4.62703 5.07819 4.72778 5.51308C4.00556 5.94642 3.5 6.81308 3.5 7.67975C3.5 8.54642 4.00556 9.41308 4.72778 9.84642C4.51111 10.7131 4.72778 11.652 5.45 12.302C6.02778 12.8797 6.96667 13.1686 7.83333 13.0242C8.26667 13.7464 9.13333 14.1797 10 14.1797C10.8667 14.1797 11.7333 13.7464 12.1667 12.952C13.0333 13.1686 13.9722 12.952 14.6222 12.2297C15.2 11.652 15.4889 10.7853 15.3444 9.84642C16.0667 9.41308 16.5 8.54642 16.5 7.67975C16.5 6.81308 16.0667 5.94642 15.2722 5.51308C15.4889 4.64642 15.2722 3.70753 14.55 3.05753C14.2412 2.75269 13.8629 2.52764 13.4476 2.4018C13.0324 2.27597 12.5927 2.25315 12.1667 2.3353C11.7333 1.61308 10.8667 1.17975 10 1.17975H10.0722Z" stroke="#181818" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"/><path d="M7.88086 8.10679L9.29362 9.51955L12.1191 6.69403" stroke="#181818" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"/></svg></span><span class="sub-menu__item-link-text">Licensing</span></a></li><li id="header-navbar-white-item-eula"><a class="sub-menu__item-link" href="/csharp/excel/licensing/#license-terms-modal-tabs-eula" data-modal-licensing-tab-id="license-terms-modal-tabs-eula"><span class="navmenu-icon img-icon navmenu-icon__topmenu-icon"><svg width="20" height="20" viewbox="0 0 20 20" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M8.33464 14.1667V15.8333C8.33464 16.2754 8.15904 16.6993 7.84648 17.0118C7.53392 17.3244 7.11 17.5 6.66797 17.5C6.22594 17.5 5.80202 17.3244 5.48946 17.0118C5.1769 16.6993 5.0013 16.2754 5.0013 15.8333V4.16667C5.0013 3.72464 4.82571 3.30072 4.51315 2.98816C4.20059 2.67559 3.77666 2.5 3.33464 2.5C2.89261 2.5 2.46868 2.67559 2.15612 2.98816C1.84356 3.30072 1.66797 3.72464 1.66797 4.16667V6.66667H4.16797" stroke="#000000" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"/><path d="M18.3346 14.1666V15.8333C18.3346 16.2753 18.159 16.6992 17.8465 17.0118C17.5339 17.3244 17.11 17.5 16.668 17.5H6.66797" stroke="#000000" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"/><path d="M15.832 14.1667V4.16667C15.832 3.72464 15.6564 3.30072 15.3439 2.98816C15.0313 2.67559 14.6074 2.5 14.1654 2.5H3.33203" stroke="#000000" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"/><path d="M18.332 14.1666H8.33203" stroke="#000000" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"/><path d="M12.5 10.4504H8.33203" stroke="#000000" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"/><path d="M12.5 6.71455H8.33203" stroke="#000000" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"/></svg></span><span class="sub-menu__item-link-text">EULA</span></a></li><li id="header-navbar-white-item-support-n-update"><a class="sub-menu__item-link" href="/csharp/excel/licensing/extensions/"><span class="navmenu-icon img-icon navmenu-icon__topmenu-icon"><svg width="20" height="20" viewbox="0 0 20 20" fill="none" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" clip-rule="evenodd" d="M17.5013 1.83331C17.9615 1.83331 18.3346 2.20641 18.3346 2.66665V6.66665C18.3346 7.12688 17.9615 7.49998 17.5013 7.49998C17.0411 7.49998 16.668 7.12688 16.668 6.66665C16.668 6.20641 17.0411 5.83331 17.5013 5.83331H16.668V2.66665C16.668 2.20641 17.0411 1.83331 17.5013 1.83331Z" fill="#181818"/><path fill-rule="evenodd" clip-rule="evenodd" d="M11.0293 3.41994C9.7583 3.22156 8.45701 3.39517 7.28242 3.91982C6.10783 4.44446 5.11013 5.29775 4.40964 6.37674C3.70915 7.45573 3.33581 8.71435 3.33464 10.0008C3.33422 10.461 2.96078 10.8338 2.50054 10.8334C2.04031 10.8329 1.66755 10.4595 1.66797 9.99927C1.66943 8.39123 2.13612 6.81795 3.01172 5.46921C3.88733 4.12047 5.13447 3.05386 6.6027 2.39805C8.07093 1.74224 9.69755 1.52524 11.2864 1.77321C12.8752 2.02118 14.3583 2.72354 15.5569 3.79556L15.5588 3.79728L18.0588 6.04728C18.4009 6.35517 18.4286 6.88207 18.1207 7.22416C17.8128 7.56626 17.2859 7.59399 16.9438 7.28611L14.4457 5.03782C14.4454 5.03755 14.4451 5.03728 14.4448 5.03701C13.4861 4.17984 12.3 3.61825 11.0293 3.41994Z" fill="#181818"/><path fill-rule="evenodd" clip-rule="evenodd" d="M1.66797 13.3333C1.66797 12.8731 2.04106 12.5 2.5013 12.5C2.96154 12.5 3.33464 12.8731 3.33464 13.3333C3.33464 13.7936 2.96154 14.1667 2.5013 14.1667H3.33464V17.3333C3.33464 17.7936 2.96154 18.1667 2.5013 18.1667C2.04106 18.1667 1.66797 17.7936 1.66797 17.3333V13.3333Z" fill="#181818"/><path fill-rule="evenodd" clip-rule="evenodd" d="M17.5021 9.16669C17.9623 9.16711 18.3351 9.54054 18.3346 10.0008C18.3332 11.6088 17.8665 13.1821 16.9909 14.5308C16.1153 15.8796 14.8681 16.9462 13.3999 17.602C11.9317 18.2578 10.3051 18.4748 8.71625 18.2268C7.12745 17.9789 5.64432 17.2765 4.44575 16.2045L4.44384 16.2028L1.94384 13.9528C1.60175 13.6449 1.57401 13.118 1.8819 12.7759C2.18978 12.4338 2.71669 12.4061 3.05878 12.7139L5.55687 14.9622L5.55781 14.9631C6.51649 15.8202 7.70264 16.3818 8.97326 16.5801C10.2443 16.7785 11.5456 16.6049 12.7202 16.0802C13.8948 15.5556 14.8925 14.7023 15.593 13.6233C16.2935 12.5443 16.6668 11.2857 16.668 9.99926C16.6684 9.53902 17.0418 9.16627 17.5021 9.16669Z" fill="#181818"/><path d="M10.6464 12.415C11.9801 12.0576 12.7715 10.6868 12.4142 9.35314C12.0568 8.01948 10.686 7.22802 9.35231 7.58537C8.01865 7.94273 7.22719 9.31357 7.58455 10.6472C7.9419 11.9809 9.31274 12.7724 10.6464 12.415Z" stroke="#181818" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"/><path d="M9.13672 6.7804L9.3524 7.58533" stroke="#181818" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"/><path d="M10.6445 12.415L10.8602 13.2199" stroke="#181818" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"/><path d="M13.219 9.13741L12.4141 9.35309" stroke="#181818" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"/><path d="M7.58619 10.6469L6.78125 10.8625" stroke="#181818" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"/><path d="M11.7669 6.93856L11.2484 7.8367" stroke="#181818" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"/><path d="M8.75131 12.1639L8.23277 13.062" stroke="#181818" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"/><path d="M13.0583 11.7682L12.1602 11.2496" stroke="#181818" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"/><path d="M7.83565 8.75097L6.9375 8.23242" stroke="#181818" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"/></svg></span><span class="sub-menu__item-link-text">Support &amp; Update Extensions</span></a></li><li id="header-navbar-white-item-license-upgrade"><a class="sub-menu__item-link" href="/csharp/excel/licensing/upgrades/"><span class="navmenu-icon img-icon navmenu-icon__topmenu-icon"><svg width="20" height="20" viewbox="0 0 20 20" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M10.0889 2C9.02222 2 7.95556 2.53333 7.42222 3.51111C6.88996 3.37484 6.33158 3.37791 5.80084 3.52002C5.27011 3.66214 4.78491 3.93851 4.39196 4.32253C3.99902 4.70654 3.71157 5.18526 3.55729 5.71259C3.40301 6.23991 3.38711 6.79808 3.51111 7.33333C2.62222 7.86667 2 8.93333 2 10C2 11.0667 2.62222 12.1333 3.51111 12.6667C3.24444 13.7333 3.51111 14.8889 4.4 15.6889C5.11111 16.4 6.26667 16.7556 7.33333 16.5778C7.86667 17.4667 8.93333 18 10 18C11.0667 18 12.1333 17.4667 12.6667 16.4889C13.7333 16.7556 14.8889 16.4889 15.6889 15.6C16.4 14.8889 16.7556 13.8222 16.5778 12.6667C17.4667 12.1333 18 11.0667 18 10C18 8.93333 17.4667 7.86667 16.4889 7.33333C16.7556 6.26667 16.4889 5.11111 15.6 4.31111C15.22 3.93593 14.7543 3.65894 14.2432 3.50407C13.7321 3.3492 13.191 3.32111 12.6667 3.42222C12.1333 2.53333 11.0667 2 10 2H10.0889Z" stroke="#181818" stroke-width="1.7" stroke-linecap="round"/><path d="M13 10L10 7L7 10" stroke="#181818" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"/><path d="M9.99902 13V7" stroke="#181818" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"/></svg></span><span class="sub-menu__item-link-text">License Upgrades</span></a></li><li id="header-navbar-white-item-license-trial"><a class="sub-menu__item-link" href="#trial-license"><span class="navmenu-icon img-icon navmenu-icon__topmenu-icon"><svg width="20" height="20" viewbox="0 0 20 20" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M17.1289 7.77224C17.1289 10.4791 14.9346 12.6733 12.2278 12.6733C11.9153 12.6733 11.6099 12.6438 11.3136 12.5879L10.645 13.3401C10.5823 13.4107 10.5053 13.4671 10.4192 13.5058C10.3331 13.5445 10.2398 13.5645 10.1454 13.5645H9.10889V14.6783C9.10889 15.0475 8.80967 15.3467 8.44055 15.3467H7.32666V16.4606C7.32666 16.8297 7.02744 17.1289 6.65832 17.1289H3.53943C3.17031 17.1289 2.87109 16.8297 2.87109 16.4606V14.2868C2.87109 14.1096 2.94152 13.9396 3.06683 13.8142L7.57258 9.3085C7.41321 8.82523 7.32666 8.30886 7.32666 7.77222C7.32666 5.0654 9.52094 2.87112 12.2278 2.87109C14.9426 2.87107 17.1289 5.05741 17.1289 7.77224Z" stroke="#181818" stroke-width="1.7" stroke-linecap="round" stroke-linejoin="round"/><circle class="svg-fill" cx="12.0887" cy="7.8407" r="1.47547" fill="#181818"/></svg></span><span class="sub-menu__item-link-text js-modal-open trial-license-menu-item" data-modal-id="trial-license">Start 30-Day Trial</span></a></li></ul></li><li id="header-navbar-white-item-features-in-main-nav"><a class="navbar__item" href="/csharp/excel/features/"><span class="navbar__item-text">Features</span></a></li><li class="sub-menu"><a class="navbar__item" href="/csharp/excel/docs/"><span class="navbar__item-text">Docs </span><i class="navbar__item-icon fas fa-chevron-down"/></a><ul class="dropdown-menu"><li id="header-navbar-white-search-button-docs-top" class="js-search__button search-button search-button_position-top" data-active-class="search-button_active"><a class="search-button__link search-button__link--in-docs"><span class="search-button__link-icon"><svg width="18" height="18" viewbox="0 0 18 18" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M7.69724 15.3945C9.40504 15.3941 11.0636 14.8224 12.4089 13.7704L16.6385 18L17.999 16.6395L13.7694 12.4099C14.822 11.0645 15.3941 9.40549 15.3945 7.69724C15.3945 3.45318 11.9413 0 7.69724 0C3.45318 0 0 3.45318 0 7.69724C0 11.9413 3.45318 15.3945 7.69724 15.3945ZM7.69724 1.92431C10.881 1.92431 13.4702 4.51347 13.4702 7.69724C13.4702 10.881 10.881 13.4702 7.69724 13.4702C4.51347 13.4702 1.92431 10.881 1.92431 7.69724C1.92431 4.51347 4.51347 1.92431 7.69724 1.92431Z" fill="#181818"/></svg> </span><span class="search-button__link-text">Search</span></a></li><li><a class="sub-menu__item-link" href="/csharp/excel/docs/"><span class="navmenu-icon img-icon navmenu-icon__topmenu-icon"><svg width="20" height="20" viewbox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" clip-rule="evenodd" d="M14.0642 0C11.7437 9.77746e-05 9.51841 0.922015 7.87768 2.56295L7.41871 3.02094C7.10474 3.33493 6.80276 3.66192 6.51479 3.99992H3.31106C3.01227 4 2.71847 4.0766 2.45767 4.22241C2.19687 4.36823 1.97775 4.5784 1.82118 4.8329L0.111324 7.60684C0.0513023 7.70434 0.014399 7.81429 0.00344232 7.92826C-0.00751434 8.04222 0.00776654 8.15719 0.0481137 8.26434C0.0884609 8.37149 0.152803 8.46797 0.236209 8.54641C0.319614 8.62484 0.419869 8.68313 0.529289 8.71682L3.63103 9.6708C3.66803 9.7218 3.71002 9.7708 3.75502 9.8158L6.18382 12.2437C6.22981 12.2897 6.27781 12.3317 6.3288 12.3687L7.28273 15.4707C7.31641 15.5801 7.3747 15.6804 7.45313 15.7638C7.53155 15.8472 7.62804 15.9115 7.73518 15.9519C7.84232 15.9922 7.95728 16.0075 8.07124 15.9966C8.1852 15.9856 8.29514 15.9487 8.39263 15.8887L11.1664 14.1817C11.4209 14.0251 11.631 13.806 11.7768 13.5452C11.9227 13.2844 11.9992 12.9905 11.9993 12.6917V9.4848C12.3373 9.19681 12.6643 8.89481 12.9783 8.58082L13.4362 8.12183C15.0772 6.48141 15.9994 4.25632 16 1.93596V1.74996C16 1.28584 15.8156 0.840734 15.4875 0.512552C15.1593 0.184371 14.7142 0 14.2501 0H14.0642ZM10.5005 10.6248C10.4125 10.6848 10.3235 10.7428 10.2345 10.7998L7.88468 12.3207L8.43263 14.1037L10.3815 12.9037C10.4178 12.8814 10.4479 12.85 10.4687 12.8127C10.4895 12.7754 10.5005 12.7334 10.5005 12.6907V10.6248ZM3.67903 8.11583L5.2009 5.76588C5.25889 5.67588 5.31789 5.58788 5.37688 5.49989H3.31006C3.26735 5.49987 3.22535 5.5108 3.18806 5.53164C3.15078 5.55247 3.11945 5.58251 3.09707 5.61888L1.89717 7.56884L3.67903 8.11583ZM8.93859 3.62292C10.2978 2.26386 12.1411 1.50025 14.0632 1.49997H14.2491C14.3154 1.49997 14.379 1.52631 14.4259 1.57319C14.4728 1.62007 14.4991 1.68366 14.4991 1.74996V1.93596C14.4992 2.88807 14.3118 3.83088 13.9476 4.71056C13.5834 5.59023 13.0494 6.38955 12.3763 7.06285L11.9173 7.52084C11.1581 8.28051 10.3205 8.95761 9.41855 9.5408L7.10174 11.0408L4.95892 8.89781L6.45879 6.58086C7.04214 5.67872 7.71917 4.84075 8.47863 4.08091L8.93659 3.62292H8.93859ZM12.0003 4.9999C12.0003 5.26511 11.895 5.51946 11.7075 5.70699C11.5199 5.89452 11.2656 5.99988 11.0004 5.99988C10.7352 5.99988 10.4809 5.89452 10.2934 5.70699C10.1058 5.51946 10.0005 5.26511 10.0005 4.9999C10.0005 4.73468 10.1058 4.48034 10.2934 4.2928C10.4809 4.10527 10.7352 3.99992 11.0004 3.99992C11.2656 3.99992 11.5199 4.10527 11.7075 4.2928C11.895 4.48034 12.0003 4.73468 12.0003 4.9999ZM3.56104 14.5597C3.7084 14.4224 3.82659 14.2568 3.90857 14.0728C3.99055 13.8888 4.03463 13.6902 4.03818 13.4888C4.04173 13.2874 4.00469 13.0873 3.92925 12.9005C3.85381 12.7138 3.74154 12.5441 3.59911 12.4017C3.45668 12.2592 3.28703 12.1469 3.10027 12.0715C2.91351 11.9961 2.71347 11.959 2.51208 11.9626C2.31069 11.9661 2.11208 12.0102 1.9281 12.0922C1.74411 12.1742 1.57853 12.2924 1.44121 12.4397C0.707274 13.1697 0.3943 14.7717 0.291309 15.4427C0.285219 15.4788 0.287865 15.5159 0.299028 15.5509C0.31019 15.5858 0.329544 15.6176 0.355475 15.6435C0.381407 15.6694 0.413163 15.6888 0.448096 15.7C0.483028 15.7111 0.520123 15.7138 0.556286 15.7077C1.22723 15.6047 2.8291 15.2917 3.56104 14.5597Z" fill="#181818"/></svg></span><span class="sub-menu__item-link-text">Get Started</span></a></li><li><a class="sub-menu__item-link" href="/csharp/excel/examples/read-excel/"><span class="navmenu-icon img-icon navmenu-icon__topmenu-icon"><svg width="20" height="20" viewbox="0 0 20 20" fill="none" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" clip-rule="evenodd" d="M14.412 6.07757C14.7375 5.75214 15.2651 5.75214 15.5906 6.07757L18.9239 9.41091C19.2493 9.73634 19.2493 10.264 18.9239 10.5894L15.5906 13.9228C15.2651 14.2482 14.7375 14.2482 14.412 13.9228C14.0866 13.5973 14.0866 13.0697 14.412 12.7442L17.1561 10.0002L14.412 7.25609C14.0866 6.93065 14.0866 6.40301 14.412 6.07757Z" fill="#181818"/><path fill-rule="evenodd" clip-rule="evenodd" d="M5.58795 6.07757C5.91339 6.40301 5.91339 6.93065 5.58795 7.25609L2.84388 10.0002L5.58795 12.7442C5.91339 13.0697 5.91339 13.5973 5.58795 13.9228C5.26252 14.2482 4.73488 14.2482 4.40944 13.9228L1.07611 10.5894C0.750672 10.264 0.750672 9.73634 1.07611 9.41091L4.40944 6.07757C4.73488 5.75214 5.26252 5.75214 5.58795 6.07757Z" fill="#181818"/><path fill-rule="evenodd" clip-rule="evenodd" d="M12.3308 2.53816C12.7701 2.67543 13.0149 3.14283 12.8777 3.58212L8.71099 16.9155C8.57371 17.3547 8.10631 17.5996 7.66702 17.4623C7.22774 17.325 6.98291 16.8576 7.12019 16.4183L11.2869 3.08499C11.4241 2.64571 11.8915 2.40088 12.3308 2.53816Z" fill="#181818"/></svg></span><span class="sub-menu__item-link-text">Code Examples</span></a></li><li><a class="sub-menu__item-link" href="/csharp/excel/tutorials/how-to-read-excel-file-csharp/"><span class="navmenu-icon img-icon navmenu-icon__topmenu-icon"><svg width="20" height="20" viewbox="0 0 20 20" fill="none" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" clip-rule="evenodd" d="M9.62602 3.42147C9.86063 3.30417 10.1368 3.30417 10.3714 3.42147L18.6886 7.58007C18.7945 7.63028 18.8881 7.70217 18.9638 7.78999C19.0894 7.93591 19.1654 8.12583 19.1654 8.3335V13.3335C19.1654 13.7937 18.7923 14.1668 18.332 14.1668C17.8718 14.1668 17.4987 13.7937 17.4987 13.3335V9.68186L10.3714 13.2455C10.1368 13.3628 9.86063 13.3628 9.62602 13.2455L1.29269 9.07885C1.01037 8.93769 0.832031 8.64914 0.832031 8.3335C0.832031 8.01785 1.01037 7.7293 1.29269 7.58814L9.62602 3.42147ZM16.4686 8.3335L9.9987 5.09852L3.52875 8.3335L9.9987 11.5685L16.4686 8.3335Z" fill="#181818"/><path fill-rule="evenodd" clip-rule="evenodd" d="M5.0013 9.1665C5.46154 9.1665 5.83464 9.5396 5.83464 9.99984V13.804C6.89215 14.7171 8.41808 15.2082 10.0013 15.2082C11.5845 15.2082 13.1104 14.7171 14.168 13.804V9.99984C14.168 9.5396 14.5411 9.1665 15.0013 9.1665C15.4615 9.1665 15.8346 9.5396 15.8346 9.99984V14.1665C15.8346 14.3875 15.7468 14.5995 15.5906 14.7558C14.1489 16.1974 12.0417 16.8748 10.0013 16.8748C7.9609 16.8748 5.85369 16.1974 4.41205 14.7558C4.25577 14.5995 4.16797 14.3875 4.16797 14.1665V9.99984C4.16797 9.5396 4.54106 9.1665 5.0013 9.1665Z" fill="#181818"/></svg></span><span class="sub-menu__item-link-text">Tutorials</span></a></li><li><a class="sub-menu__item-link" href="/csharp/excel/how-to/create-xlsx-file-c-sharp/"><span class="navmenu-icon img-icon navmenu-icon__topmenu-icon"><svg width="20" height="20" viewbox="0 0 20 20" fill="none" xmlns="http://www.w3.org/2000/svg"><g clip-path="url(#clip0_7761_29772)"><path fill-rule="evenodd" clip-rule="evenodd" d="M9.9987 2.50016C5.85656 2.50016 2.4987 5.85803 2.4987 10.0002C2.4987 14.1423 5.85656 17.5002 9.9987 17.5002C14.1408 17.5002 17.4987 14.1423 17.4987 10.0002C17.4987 5.85803 14.1408 2.50016 9.9987 2.50016ZM0.832031 10.0002C0.832031 4.93755 4.93609 0.833496 9.9987 0.833496C15.0613 0.833496 19.1654 4.93755 19.1654 10.0002C19.1654 15.0628 15.0613 19.1668 9.9987 19.1668C4.93609 19.1668 0.832031 15.0628 0.832031 10.0002Z" fill="#181818"/><path fill-rule="evenodd" clip-rule="evenodd" d="M10.2158 6.68676C9.82791 6.62022 9.42895 6.69312 9.08961 6.89255C8.75028 7.09198 8.49247 7.40507 8.36186 7.77636C8.20913 8.21052 7.73337 8.43866 7.29921 8.28594C6.86505 8.13321 6.63691 7.65745 6.78964 7.22329C7.05086 6.4807 7.56647 5.85452 8.24514 5.45566C8.92381 5.0568 9.72174 4.911 10.4976 5.04408C11.2735 5.17716 11.9772 5.58054 12.4842 6.18276C12.991 6.78487 13.2685 7.54689 13.2674 8.33392C13.267 9.60921 12.3215 10.4514 11.6463 10.9015C11.2833 11.1436 10.9262 11.3215 10.6632 11.4384C10.5304 11.4974 10.4187 11.5422 10.3382 11.5728C10.2978 11.5882 10.2651 11.6001 10.2413 11.6086L10.2124 11.6187L10.2032 11.6219L10.1999 11.623L10.1986 11.6234C10.1984 11.6235 10.1976 11.6237 9.93408 10.8332L10.1976 11.6237C9.76098 11.7693 9.28905 11.5333 9.14351 11.0967C8.99807 10.6604 9.23362 10.1888 9.66969 10.0429L9.66862 10.0432C9.66871 10.0432 9.66878 10.0432 9.66969 10.0429L9.68298 10.0382C9.6958 10.0337 9.71681 10.026 9.74484 10.0154C9.80103 9.99395 9.88459 9.96058 9.98626 9.9154C10.192 9.82398 10.4599 9.68943 10.7218 9.51478C11.2965 9.13167 11.6007 8.7241 11.6007 8.33316L11.6007 8.33192C11.6013 7.93832 11.4626 7.55721 11.2091 7.2561C10.9556 6.95499 10.6038 6.7533 10.2158 6.68676Z" fill="#181818"/><path fill-rule="evenodd" clip-rule="evenodd" d="M9.16797 14.1668C9.16797 13.7066 9.54106 13.3335 10.0013 13.3335H10.0096C10.4699 13.3335 10.843 13.7066 10.843 14.1668C10.843 14.6271 10.4699 15.0002 10.0096 15.0002H10.0013C9.54106 15.0002 9.16797 14.6271 9.16797 14.1668Z" fill="#181818"/></g><defs><clippath id="clip0_7761_29772"><rect width="20" height="20" fill="white"/></clippath></defs></svg></span><span class="sub-menu__item-link-text">How-Tos</span></a></li><li id="header-navbar-white-item-troubleshooting"><a class="sub-menu__item-link" href="/csharp/excel/troubleshooting/apply-a-license-key-in-ironxl/"><span class="navmenu-icon img-icon navmenu-icon__topmenu-icon"><svg width="20" height="20" viewbox="0 0 20 20" fill="none" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" clip-rule="evenodd" d="M13.7967 2.5231C13.3942 2.47762 12.985 2.4908 12.5819 2.56423C11.7486 2.71606 10.9814 3.11822 10.3825 3.71714C9.78361 4.31605 9.38144 5.08326 9.22962 5.91654C9.07779 6.74981 9.18352 7.60956 9.53271 8.38122C9.67571 8.69723 9.60802 9.06877 9.36275 9.31404L3.60442 15.0724C3.42918 15.2476 3.33073 15.4853 3.33073 15.7331C3.33073 15.9809 3.42918 16.2186 3.60442 16.3939C3.77966 16.5691 4.01734 16.6675 4.26516 16.6675C4.51299 16.6675 4.75067 16.5691 4.92591 16.3939L10.6842 10.6355C10.9295 10.3903 11.301 10.3226 11.6171 10.4656C12.3887 10.8148 13.2485 10.9205 14.0817 10.7687C14.915 10.6168 15.6822 10.2147 16.2811 9.61576C16.8801 9.01685 17.2822 8.24963 17.434 7.41636C17.5075 7.01332 17.5207 6.60408 17.4752 6.20161L15.3319 8.34493C15.0203 8.65031 14.6014 8.82133 14.1652 8.82133C13.7289 8.82133 13.31 8.65028 12.9985 8.3449L12.9925 8.33907L11.6533 6.99981C11.348 6.68826 11.1769 6.26937 11.1769 5.83311C11.1769 5.39686 11.348 4.97799 11.6534 4.66645L11.6592 4.6605L13.7967 2.5231ZM12.2832 0.924563C13.4497 0.712009 14.6534 0.860029 15.7337 1.3489C15.983 1.46168 16.161 1.6896 16.21 1.95874C16.259 2.22787 16.1729 2.50393 15.9794 2.69737L12.8437 5.83311L14.1652 7.1546L17.3009 4.01886C17.4943 3.82542 17.7704 3.73924 18.0395 3.78828C18.3087 3.83731 18.5366 4.01532 18.6494 4.26455C19.1382 5.34488 19.2863 6.54853 19.0737 7.71511C18.8612 8.88169 18.2981 9.95579 17.4597 10.7943C16.6212 11.6327 15.5471 12.1958 14.3805 12.4083C13.4076 12.5856 12.409 12.5121 11.4776 12.1992L6.10442 17.5724C5.61662 18.0602 4.95502 18.3342 4.26516 18.3342C3.57531 18.3342 2.91371 18.0602 2.42591 17.5724C1.93811 17.0846 1.66406 16.423 1.66406 15.7331C1.66406 15.0433 1.93811 14.3817 2.42591 13.8939L7.79904 8.52073C7.4862 7.58932 7.41269 6.59066 7.58995 5.61778C7.8025 4.4512 8.36553 3.3771 9.20401 2.53863C10.0425 1.70015 11.1166 1.13712 12.2832 0.924563Z" fill="#181818"/></svg></span><span class="sub-menu__item-link-text">Troubleshooting</span></a></li><li id="header-navbar-white-item-changelog"><a class="sub-menu__item-link" href="/csharp/excel/product-updates/changelog/"><span class="navmenu-icon img-icon navmenu-icon__topmenu-icon"><svg width="20" height="20" viewbox="0 0 19 18" fill="none" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" clip-rule="evenodd" d="M15.9531 0.75C16.3673 0.75 16.7031 1.08579 16.7031 1.5V6C16.7031 6.41421 16.3673 6.75 15.9531 6.75H11.4531C11.0389 6.75 10.7031 6.41421 10.7031 6C10.7031 5.58579 11.0389 5.25 11.4531 5.25H15.2031V1.5C15.2031 1.08579 15.5389 0.75 15.9531 0.75Z" fill="#181818"/><path fill-rule="evenodd" clip-rule="evenodd" d="M10.1284 3.07788C8.98442 2.89934 7.81326 3.05558 6.75613 3.52777C5.699 3.99995 4.80107 4.7679 4.17063 5.739C3.54019 6.71009 3.20418 7.84285 3.20312 9.00064C3.20275 9.41486 2.86665 9.75033 2.45244 9.74996C2.03823 9.74958 1.70275 9.41349 1.70313 8.99928C1.70444 7.55204 2.12446 6.13609 2.9125 4.92222C3.70055 3.70835 4.82297 2.74841 6.14438 2.15818C7.46579 1.56795 8.92975 1.37264 10.3597 1.59582C11.7896 1.81899 13.1244 2.45112 14.2031 3.41594L14.2049 3.41748L16.4548 5.44249C16.7627 5.71958 16.7877 6.1938 16.5106 6.50168C16.2335 6.80956 15.7593 6.83452 15.4514 6.55743L13.2031 4.53397C13.2029 4.53373 13.2026 4.53348 13.2023 4.53324C12.3395 3.76179 11.2719 3.25636 10.1284 3.07788Z" fill="#181818"/><path fill-rule="evenodd" clip-rule="evenodd" d="M1.70312 12C1.70312 11.5858 2.03891 11.25 2.45312 11.25H6.95312C7.36734 11.25 7.70312 11.5858 7.70312 12C7.70312 12.4142 7.36734 12.75 6.95312 12.75H3.20312V16.5C3.20312 16.9142 2.86734 17.25 2.45312 17.25C2.03891 17.25 1.70312 16.9142 1.70312 16.5V12Z" fill="#181818"/><path fill-rule="evenodd" clip-rule="evenodd" d="M15.9538 8.25C16.368 8.25038 16.7035 8.58647 16.7031 9.00068C16.7018 10.4479 16.2818 11.8639 15.4938 13.0777C14.7057 14.2916 13.5833 15.2515 12.2619 15.8418C10.9405 16.432 9.47651 16.6273 8.04658 16.4041C6.61666 16.181 5.28184 15.5488 4.20313 14.584L4.20141 14.5825L4.20141 14.5825L1.95141 12.5575C1.64353 12.2804 1.61857 11.8062 1.89566 11.4983C2.17276 11.1904 2.64697 11.1654 2.95486 11.4425L5.20313 13.466C5.20342 13.4662 5.2037 13.4665 5.20398 13.4667C6.0668 14.2382 7.13433 14.7436 8.27789 14.9221C9.42183 15.1006 10.593 14.9444 11.6501 14.4722C12.7073 14 13.6052 13.2321 14.2356 12.261C14.8661 11.2899 15.2021 10.1571 15.2031 8.99932C15.2035 8.5851 15.5396 8.24962 15.9538 8.25Z" fill="#181818"/></svg></span><span class="sub-menu__item-link-text">Product Updates</span></a></li><li id="header-navbar-white-item-api-reference"><a class="sub-menu__item-link" href="/csharp/excel/object-reference/api/" target="_blank"><span class="navmenu-icon img-icon navmenu-icon__topmenu-icon"><svg width="18" height="18" viewbox="0 0 18 18" fill="none" xmlns="http://www.w3.org/2000/svg"><g clip-path="url(#clip0_7977_32209)"><path fill-rule="evenodd" clip-rule="evenodd" d="M4.79602 7.90003C5.08895 8.19296 5.08891 8.66793 4.79594 8.9609L3.13622 10.6206C2.58634 11.1928 2.28512 11.9594 2.29853 12.7529C2.31197 13.5483 2.6404 14.3058 3.21173 14.8593C3.77174 15.3991 4.5193 15.7007 5.2972 15.7006C6.0732 15.7005 6.81905 15.4003 7.3787 14.8629L9.03831 13.2033C9.33129 12.9103 9.80626 12.9103 10.0992 13.2032C10.3921 13.4961 10.3921 13.9711 10.0991 14.2641L8.4344 15.9288L8.4247 15.9383C7.58488 16.7482 6.4637 17.2008 5.29708 17.2009C4.13046 17.201 3.00935 16.7486 2.16967 15.9388L2.1686 15.9378C1.31138 15.1078 0.818592 13.9716 0.798435 12.7785C0.778279 11.5854 1.2324 10.433 2.0611 9.57432L2.07044 9.56481L3.73514 7.90011C4.02812 7.60713 4.50309 7.6071 4.79602 7.90003Z" fill="#181818"/><path fill-rule="evenodd" clip-rule="evenodd" d="M13.1884 10.1102C12.8954 9.8173 12.8955 9.34233 13.1884 9.04935L14.8482 7.38963C15.398 6.81746 15.6993 6.05089 15.6858 5.25734C15.6724 4.46194 15.344 3.70442 14.7726 3.15098C14.2126 2.61118 13.4651 2.30959 12.6872 2.30965C11.9112 2.30971 11.1653 2.60995 10.6057 3.14736L8.94606 4.80698C8.65309 5.09995 8.17812 5.09999 7.88519 4.80706C7.59226 4.51413 7.59229 4.03916 7.88527 3.74618L9.54997 2.08148L9.55968 2.07195C10.3995 1.26205 11.5207 0.809437 12.6873 0.809345C13.8539 0.809254 14.975 1.26169 15.8147 2.07146L15.8158 2.07248C16.673 2.90243 17.1658 4.03868 17.1859 5.23176C17.2061 6.42484 16.752 7.57724 15.9233 8.43593L15.9139 8.44544L14.2492 10.1101C13.9563 10.4031 13.4813 10.4032 13.1884 10.1102Z" fill="#181818"/><path fill-rule="evenodd" clip-rule="evenodd" d="M14.8077 3.18219C14.5148 2.88929 14.5148 2.41442 14.8077 2.12153L16.3987 0.530535C16.6916 0.237642 17.1664 0.237642 17.4593 0.530535C17.7522 0.823428 17.7522 1.2983 17.4593 1.5912L15.8683 3.18219C15.5754 3.47508 15.1006 3.47508 14.8077 3.18219Z" fill="#181818"/><path fill-rule="evenodd" clip-rule="evenodd" d="M0.514705 17.4756C0.221812 17.1827 0.221812 16.7079 0.514705 16.415L2.10569 14.824C2.39859 14.5311 2.87346 14.5311 3.16636 14.824C3.45925 15.1169 3.45925 15.5918 3.16636 15.8847L1.57537 17.4756C1.28247 17.7685 0.807598 17.7685 0.514705 17.4756Z" fill="#181818"/><path fill-rule="evenodd" clip-rule="evenodd" d="M8.10455 7.77447C8.39744 8.06736 8.39744 8.54224 8.10455 8.83513L6.51356 10.4261C6.22067 10.719 5.74579 10.719 5.4529 10.4261C5.16001 10.1332 5.16001 9.65835 5.4529 9.36546L7.04389 7.77447C7.33678 7.48158 7.81166 7.48158 8.10455 7.77447Z" fill="#181818"/><path fill-rule="evenodd" clip-rule="evenodd" d="M10.2178 9.88726C10.5107 10.1802 10.5107 10.655 10.2178 10.9479L8.62684 12.5389C8.33395 12.8318 7.85907 12.8318 7.56618 12.5389C7.27329 12.246 7.27329 11.7711 7.56618 11.4783L9.15717 9.88726C9.45006 9.59437 9.92494 9.59437 10.2178 9.88726Z" fill="#181818"/><path d="M4.79595 7.89996C4.50306 7.60707 4.02819 7.60707 3.73529 7.89996C3.4424 8.19285 3.4424 8.66773 3.73529 8.96062L5.32628 10.5516C5.33482 10.5601 5.34351 10.5684 5.35234 10.5765C5.36038 10.5853 5.36866 10.594 5.3772 10.6025L8.4319 13.6572C8.45473 13.6801 8.47867 13.7011 8.50354 13.7204L9.04369 14.2605C9.33611 14.553 9.80965 14.5535 10.1014 14.2618C10.3931 13.9701 10.3925 13.4965 10.1001 13.2041L8.51166 11.6157C8.51146 11.6155 8.51127 11.6153 8.51107 11.6151L6.43786 9.54186C6.42932 9.53333 6.42063 9.52504 6.4118 9.517C6.40376 9.50817 6.39548 9.49948 6.38694 9.49095L4.79595 7.89996Z" fill="#181818"/><path d="M8.94439 3.75054C8.6515 3.45765 8.17663 3.45765 7.88373 3.75055C7.59084 4.04344 7.59084 4.51831 7.88373 4.81121L9.47472 6.4022C9.48326 6.41073 9.49194 6.41901 9.50078 6.42705C9.50882 6.43588 9.5171 6.44457 9.52563 6.45311L12.5803 9.50781C12.6032 9.53064 12.6271 9.5517 12.652 9.57097L13.1921 10.1111C13.4845 10.4035 13.9581 10.4041 14.2498 10.1124C14.5415 9.82066 14.541 9.34712 14.2485 9.05469L12.6601 7.46625C12.6599 7.46605 12.6597 7.46586 12.6595 7.46566L10.5863 5.39245C10.5778 5.38391 10.5691 5.37563 10.5602 5.36759C10.5522 5.35876 10.5439 5.35007 10.5354 5.34153L8.94439 3.75054Z" fill="#181818"/></g><defs><clippath id="clip0_7977_32209"><rect width="18" height="18" fill="white"/></clippath></defs></svg></span><span class="sub-menu__item-link-text">API Reference </span><i class="sub-menu__item-link-icon fas fa-external-link-square-alt"/></a></li><li id="header-navbar-white-search-button-docs-top" class="js-search__button search-button search-button_position-top" data-active-class="search-button_active"><a class="search-button__link search-button__link--in-docs"><span class="search-button__link-icon"><svg width="18" height="18" viewbox="0 0 18 18" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M7.69724 15.3945C9.40504 15.3941 11.0636 14.8224 12.4089 13.7704L16.6385 18L17.999 16.6395L13.7694 12.4099C14.822 11.0645 15.3941 9.40549 15.3945 7.69724C15.3945 3.45318 11.9413 0 7.69724 0C3.45318 0 0 3.45318 0 7.69724C0 11.9413 3.45318 15.3945 7.69724 15.3945ZM7.69724 1.92431C10.881 1.92431 13.4702 4.51347 13.4702 7.69724C13.4702 10.881 10.881 13.4702 7.69724 13.4702C4.51347 13.4702 1.92431 10.881 1.92431 7.69724C1.92431 4.51347 4.51347 1.92431 7.69724 1.92431Z" fill="#181818"/></svg> </span><span class="search-button__link-text">Search</span></a></li></ul></li><li id="header-navbar-white-search-button" class="js-search__button search-button search-button_visible" data-active-class="search-button_active"><a class="search-button__link"><span class="search-button__link-icon"><svg width="18" height="18" viewbox="0 0 18 18" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M7.69724 15.3945C9.40504 15.3941 11.0636 14.8224 12.4089 13.7704L16.6385 18L17.999 16.6395L13.7694 12.4099C14.822 11.0645 15.3941 9.40549 15.3945 7.69724C15.3945 3.45318 11.9413 0 7.69724 0C3.45318 0 0 3.45318 0 7.69724C0 11.9413 3.45318 15.3945 7.69724 15.3945ZM7.69724 1.92431C10.881 1.92431 13.4702 4.51347 13.4702 7.69724C13.4702 10.881 10.881 13.4702 7.69724 13.4702C4.51347 13.4702 1.92431 10.881 1.92431 7.69724C1.92431 4.51347 4.51347 1.92431 7.69724 1.92431Z" fill="#181818"/></svg> </span><span class="search-button__link-text">Search</span></a></li><li id="header-navbar-white-cta" class="navbar-action_out-content"><a id="header-navbar-white-cta-button" class="js-modal-open btn btn-red btn--twolines" href="https://www.nuget.org/packages/IronXL.Excel/" target="_blank" data-modal-id="trial-license-after-download" title="Click to view IronXL on NuGet website"><i class="nuget-icon-white2"/> <span>Free NuGet Download </span><span class="header-navbar-white-cta-button--total-download">Total downloads: 366,708</span></a></li></ul></div></div></nav></div><div id="header-navbar-search" class="js-search search-box" 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"><svg width="18" height="18" viewbox="0 0 18 18" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M7.69724 15.3945C9.40504 15.3941 11.0636 14.8224 12.4089 13.7704L16.6385 18L17.999 16.6395L13.7694 12.4099C14.822 11.0645 15.3941 9.40549 15.3945 7.69724C15.3945 3.45318 11.9413 0 7.69724 0C3.45318 0 0 3.45318 0 7.69724C0 11.9413 3.45318 15.3945 7.69724 15.3945ZM7.69724 1.92431C10.881 1.92431 13.4702 4.51347 13.4702 7.69724C13.4702 10.881 10.881 13.4702 7.69724 13.4702C4.51347 13.4702 1.92431 10.881 1.92431 7.69724C1.92431 4.51347 4.51347 1.92431 7.69724 1.92431Z" fill="#181818"/></svg> </span><input id="header-navbar-search-input" class="js-search__input search-box__label-input" type="search" autocomplete="off" placeholder="Search the API, code examples, and tutorials"/></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"/></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 class="js-search__message-icon search-box__results-icon-img" src="data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACH5BAEAAAAALAAAAAABAAEAAAICRAEAOw==" alt="Message's icon"/></div><div class="js-search__message-text search-box__results-text"/></div></div></div></div></div><div class="banner banner--padding-30 banner__product-home-top-image--left-ironxl banner__blog-header-w-code-example"><div class="container-fluid banner__container_margin-bottom banner__container--padding-left"><div class="col-sm-6 col-md-5 position-for-dark-mode"><p class="product-homepage-header">The C# Excel Library</p><ul class="list-unstyled banner-list"><li>Intuitive C# &amp; <a href="https://VB.NET/">VB.NET</a> Excel Document API</li><li>No need to install Microsoft Office or Excel Interop</li><li><a href="/csharp/excel/tutorials/how-to-read-excel-file-csharp/">Read</a>, <a href="/csharp/excel/tutorials/csharp-open-write-excel-file/">edit</a> &amp; <a href="/csharp/excel/tutorials/create-excel-file-net/">create</a> Excel spreadsheet files</li><li>Fully supports .NET 7,6,5, Core, Framework, and Azure</li></ul><div class="banner__buttons banner__buttons--blog"><a class="btn btn-red btn-red--margin-right-20" href="/csharp/excel/">Explore IronXL <i class="navbar__item-icon fas fa-chevron-right fa-chevron-right--font-size-13"/> </a><a id="page-home-section-banner-cta-button" class="js-modal-open banner__link-white-text btn--twolines" href="https://www.nuget.org/packages/IronXL.Excel" target="_blank" data-modal-id="trial-license-after-download" title="Click to view IronXL on NuGet website"><i class="nuget-icon-white2 nuget-icon-white2--top-1"/> <span>Free NuGet Download</span> <i class="navbar__item-icon fas fa-chevron-right fa-chevron-right--font-size-13"/></a></div></div><div class="tutorial-examples tutorial-examples--blog col-sm-6 col-md-7" id="code-examples"><div class="tutorial-examples__background-linear-gradient"/><div class="examples-box examples-box_margin-left examples-box--ironxl-blog"><div class="hidden col left-bar"><h2 style="font-family: 'Gotham-Black';">Examples</h2><div id="code-dropdown"><select class="selectpicker" data-style="btn-iron" data-width="100%"/></div><div class="nav-side-menu" style="height: 277px;"><i class="fa fa-bars fa-2x toggle-btn" data-toggle="collapse" data-target="#menu-content"/><div class="menu-list"><ul id="menu-content" class="menu-content collapse out" data-collapse-proxy="#code-dropdown select"><li data-code-content="sample-read-excel" data-hash-url="true"><a href="javascript:void(0)">Read Excel Files without Interop</a></li><li data-code-content="sample-excel-worksheets" data-hash-url="true"><a href="javascript:void(0)">Excel Worksheets</a></li><li data-code-content="sample-create-excel-spreadsheet" data-hash-url="true"><a href="javascript:void(0)">Create Excel Files</a></li><li data-code-content="sample-convert-excel-spreadsheet" data-hash-url="true"><a href="javascript:void(0)">Convert Spreadsheet File Types</a></li><li data-code-content="sample-excel-sql-dataset" data-hash-url="true"><a href="javascript:void(0)">Excel to SQL via System.Data.DataSet</a></li><li data-code-content="sample-excel-sql-datatable" data-hash-url="true"><a href="javascript:void(0)">Excel to SQL and DataGrid via DataTable</a></li><li data-code-content="sample-excel-conditional-formatting" data-hash-url="true"><a href="javascript:void(0)">Excel Conditional Formatting</a></li><li data-code-content="sample-protect-excel-file" data-hash-url="true"><a href="javascript:void(0)">Protect Excel Files</a></li><li data-code-content="sample-excel-formulas-csharp" data-hash-url="true"><a href="javascript:void(0)">Excel Formulas in C#</a></li><li data-code-content="sample-edit-excel-metadata-csharp" data-hash-url="true"><a href="javascript:void(0)">Edit Excel Metadata in C#</a></li><li data-code-content="sample-excel-update-database-records" data-hash-url="true"><a href="javascript:void(0)">Update Excel Database Records</a></li><li data-code-content="sample-excel-style-cells-borders-fonts" data-hash-url="true"><a href="javascript:void(0)">Style Excel Cell Borders &amp; Fonts</a></li><li data-code-content="sample-sort-excel-range-csharp" data-hash-url="true"><a href="javascript:void(0)">Sort Excel Ranges in C#</a></li><li data-code-content="sample-repeating-rows-and-columns-in-excel" data-hash-url="true"><a href="javascript:void(0)">Repeat Excel Rows &amp; Columns</a></li><li data-code-content="sample-excel-print-setup" data-hash-url="true"><a href="javascript:void(0)">Excel Print Setup</a></li><li data-code-content="sample-excel-number-formats" data-hash-url="true"><a href="javascript:void(0)">Cell Data Display Format</a></li><li data-code-content="sample-load-excel-from-sql-database" data-hash-url="true"><a href="javascript:void(0)">Load Excel From SQL Database</a></li><li data-code-content="sample-combine-excel-ranges" data-hash-url="true"><a href="javascript:void(0)">Combine Excel Ranges</a></li><li data-code-content="sample-select-excel-range" data-hash-url="true"><a href="javascript:void(0)">Select Excel Range</a></li><li data-code-content="sample-convert-excel-to-html" data-hash-url="true"><a href="javascript:void(0)">Convert Excel to HTML</a></li><li data-code-content="sample-aggregate-excel-functions" data-hash-url="true"><a href="javascript:void(0)">Aggregate Excel Functions</a></li><li data-code-content="sample-create-a-excel-line-chart" data-hash-url="true"><a href="javascript:void(0)">Create Excel Line Chart</a></li><li data-code-content="sample-freeze-panes-in-excel" data-hash-url="true"><a href="javascript:void(0)">Freeze Panes in Excel</a></li><li data-code-content="sample-copy-an-excel-worksheet" data-hash-url="true"><a href="javascript:void(0)">Copy Excel Worksheets</a></li></ul></div></div></div><div class="col right-bar"><div class="code-content lander show" id="sample-read-excel"><div class="code_window add-shadow"><div class="code_window_title"><span style="margin-right: 10px;"><i class="vs-icon2"/> </span><span class="filename" style="margin-left: 0; margin-right: 19px;">Read Excel Files without Interop</span></div><div class="code_window_content"><pre class="prettyprint linenums lang-cs"><code>using IronXL; using System; using System.Linq; // Supported for XLSX, XLS, XLSM, XLTX, CSV and TSV WorkBook workBook = WorkBook.Load("sample.xlsx"); // Select worksheet at index 0 WorkSheet workSheet = workBook.WorkSheets[0]; // Get any existing worksheet WorkSheet firstSheet = workBook.DefaultWorkSheet; // Select a cell and return the converted value int cellValue = workSheet["A2"].IntValue; // Read from ranges of cells elegantly. foreach (var cell in workSheet["A2:A10"]) Console.WriteLine("Cell {0} has value '{1}'", cell.AddressString, cell.Text); // Calculate aggregate values such as Min, Max and Sum decimal sum = workSheet["A2:A10"].Sum(); // Linq compatible decimal max = workSheet["A2:A10"].Max(c =&gt; c.DecimalValue);</code></pre></div><div class="code_window_bottom"/></div></div><div class="code-content lander hide" id="sample-excel-worksheets"><div class="code_window add-shadow"><div class="code_window_title"><span style="margin-right: 10px;"><i class="vs-icon2"/> </span><span class="filename" style="margin-left: 0; margin-right: 19px;">Excel Worksheets</span></div><div class="code_window_content"><pre class="prettyprint linenums lang-cs"><code>using IronXL; // Create new Excel spreadsheet WorkBook workBook = WorkBook.Create(ExcelFileFormat.XLSX); // Create worksheets (workSheet1, workSheet2, workSheet3) WorkSheet workSheet1 = workBook.CreateWorkSheet("workSheet1"); WorkSheet workSheet2 = workBook.CreateWorkSheet("workSheet2"); WorkSheet workSheet3 = workBook.CreateWorkSheet("workSheet3"); // Set worksheet position (workSheet2, workSheet1, workSheet3) workBook.SetSheetPosition("workSheet2", 0); // Set active for workSheet3 workBook.SetActiveTab(2); // Remove workSheet1 workBook.RemoveWorkSheet(1); workBook.SaveAs("manageWorkSheet.xlsx");</code></pre></div><div class="code_window_bottom"/></div></div><div class="code-content lander hide" id="sample-create-excel-spreadsheet"><div class="code_window add-shadow"><div class="code_window_title"><span style="margin-right: 10px;"><i class="vs-icon2"/> </span><span class="filename" style="margin-left: 0; margin-right: 19px;">Create Excel Files</span></div><div class="code_window_content"><pre class="prettyprint linenums lang-cs"><code>using IronXL; // Create new Excel WorkBook document WorkBook workBook = WorkBook.Create(); // Convert XLSX to XLS WorkBook xlsWorkBook = WorkBook.Create(ExcelFileFormat.XLS); // Create a blank WorkSheet WorkSheet workSheet = workBook.CreateWorkSheet("new_sheet"); // Add data and styles to the new worksheet workSheet["A1"].Value = "Hello World"; workSheet["A1"].Style.WrapText = true; workSheet["A2"].BoolValue = true; workSheet["A2"].Style.BottomBorder.Type = IronXL.Styles.BorderType.Double; // Save the excel file as XLS, XLSX, CSV, TSV, JSON, XML, HTML and streams workBook.SaveAs("sample.xlsx");</code></pre></div><div class="code_window_bottom"/></div></div><div class="code-content lander hide" id="sample-convert-excel-spreadsheet"><div class="code_window add-shadow"><div class="code_window_title"><span style="margin-right: 10px;"><i class="vs-icon2"/> </span><span class="filename" style="margin-left: 0; margin-right: 19px;">Convert Spreadsheet File Types</span></div><div class="code_window_content"><pre class="prettyprint linenums lang-cs"><code>using IronXL; using System.IO; // Import any XLSX, XLS, XLSM, XLTX, CSV and TSV WorkBook workBook = WorkBook.Load("sample.xlsx"); // Export the excel file as XLS, XLSX, XLSM, CSV, TSV, JSON, XML workBook.SaveAs("sample.xls"); workBook.SaveAs("sample.xlsx"); workBook.SaveAs("sample.tsv"); workBook.SaveAsCsv("sample.csv"); workBook.SaveAsJson("sample.json"); workBook.SaveAsXml("sample.xml"); // Export the excel file as Html, Html string workBook.ExportToHtml("sample.html"); string htmlString = workBook.ExportToHtmlString(); // Export the excel file as Binary, Byte array, Data set, Stream byte[] binary = workBook.ToBinary(); byte[] byteArray = workBook.ToByteArray(); System.Data.DataSet dataSet = workBook.ToDataSet(); // Allow easy integration with DataGrids, SQL and EF Stream stream = workBook.ToStream();</code></pre></div><div class="code_window_bottom"/></div></div><div class="code-content lander hide" id="sample-excel-sql-dataset"><div class="code_window add-shadow"><div class="code_window_title"><span style="margin-right: 10px;"><i class="vs-icon2"/> </span><span class="filename" style="margin-left: 0; margin-right: 19px;">Excel to SQL via System.Data.DataSet</span></div><div class="code_window_content"><pre class="prettyprint linenums lang-cs"><code>using IronXL; using System; using System.Data; // Supported for XLSX, XLS, XLSM, XLTX, CSV and TSV WorkBook workBook = WorkBook.Load("sample.xlsx"); // Convert the whole Excel WorkBook to a DataSet DataSet dataSet = workBook.ToDataSet(); foreach (DataTable table in dataSet.Tables) Console.WriteLine(table.TableName); // Enumerate by rows or columns first at your preference foreach (DataRow row in table.Rows) for (int i = 0; i &lt; table.Columns.Count; i++) Console.Write(row[i]); }</code></pre></div><div class="code_window_bottom"/></div></div><div class="code-content lander hide" id="sample-excel-sql-datatable"><div class="code_window add-shadow"><div class="code_window_title"><span style="margin-right: 10px;"><i class="vs-icon2"/> </span><span class="filename" style="margin-left: 0; margin-right: 19px;">Excel to SQL and DataGrid via DataTable</span></div><div class="code_window_content"><pre class="prettyprint linenums lang-cs"><code>using IronXL; using System; using System.Data; // Supported for XLSX, XLS, XLSM, XLTX, CSV and TSV WorkBook workBook = WorkBook.Load("sample.xlsx"); // Select default sheet WorkSheet workSheet = workBook.DefaultWorkSheet; // Convert the worksheet to DataTable DataTable dataTable = workSheet.ToDataTable(true); // Enumerate by rows or columns first at your preference foreach (DataRow row in dataTable.Rows) for (int i = 0; i &lt; dataTable.Columns.Count; i++) Console.Write(row[i]); }</code></pre></div><div class="code_window_bottom"/></div></div><div class="code-content lander hide" id="sample-excel-conditional-formatting"><div class="code_window add-shadow"><div class="code_window_title"><span style="margin-right: 10px;"><i class="vs-icon2"/> </span><span class="filename" style="margin-left: 0; margin-right: 19px;">Excel Conditional Formatting</span></div><div class="code_window_content"><pre class="prettyprint linenums lang-cs"><code>using IronXL; using IronXL.Styles; using IronXL.Formatting.Enums; WorkBook workBook = WorkBook.Load("sample.xlsx"); WorkSheet workSheet = workBook.DefaultWorkSheet; // Create conditional formatting rule var rule = workSheet.ConditionalFormatting.CreateConditionalFormattingRule(ComparisonOperator.LessThan, "8"); // Set style options rule.FontFormatting.IsBold = true; rule.FontFormatting.FontColor = "#123456"; rule.BorderFormatting.RightBorderColor = "#ffffff"; rule.BorderFormatting.RightBorderType = BorderType.Thick; rule.PatternFormatting.BackgroundColor = "#54bdd9"; rule.PatternFormatting.FillPattern = FillPattern.Diamonds; // Apply formatting on specified region workSheet.ConditionalFormatting.AddConditionalFormatting("A3:A8", rule); // Create conditional formatting rule var rule1 = workSheet.ConditionalFormatting.CreateConditionalFormattingRule(ComparisonOperator.Between, "7", "10"); // Set style options rule1.FontFormatting.IsItalic = true; rule1.FontFormatting.UnderlineType = FontUnderlineType.Single; // Apply formatting on specified region workSheet.ConditionalFormatting.AddConditionalFormatting("A3:A9", rule1); workBook.SaveAs("applyConditionalFormatting.xlsx");</code></pre></div><div class="code_window_bottom"/></div></div><div class="code-content lander hide" id="sample-protect-excel-file"><div class="code_window add-shadow"><div class="code_window_title"><span style="margin-right: 10px;"><i class="vs-icon2"/> </span><span class="filename" style="margin-left: 0; margin-right: 19px;">Protect Excel Files</span></div><div class="code_window_content"><pre class="prettyprint linenums lang-cs"><code>using IronXL; WorkBook workBook = WorkBook.Load("sample.xlsx"); WorkSheet workSheet = workBook.DefaultWorkSheet; // Open protected spreadsheet file WorkBook protectedWorkBook = WorkBook.Load("sample.xlsx", "IronSoftware"); // Spreadsheet protection // Set protection for spreadsheet file workBook.Encrypt("IronSoftware"); // Remove protection for spreadsheet file. Original password is required. workBook.Password = null; // Worksheet protection // Set protection for individual worksheet workSheet.ProtectSheet("IronXL"); // Remove protection for particular worksheet. It works without password! workSheet.UnprotectSheet(); workBook.Save();</code></pre></div><div class="code_window_bottom"/></div></div><div class="code-content lander hide" id="sample-excel-formulas-csharp"><div class="code_window add-shadow"><div class="code_window_title"><span style="margin-right: 10px;"><i class="vs-icon2"/> </span><span class="filename" style="margin-left: 0; margin-right: 19px;">Excel Formulas in C#</span></div><div class="code_window_content"><pre class="prettyprint linenums lang-cs"><code>using IronXL; using System.Linq; WorkBook workBook = WorkBook.Load("sample.xlsx"); WorkSheet workSheet = workBook.DefaultWorkSheet; // Set Formulas workSheet["A1"].Formula = "Sum(B8:C12)"; workSheet["B8"].Formula = "=C9/C11"; workSheet["G30"].Formula = "Max(C3:C7)"; // Force recalculate all formula values in all sheets. workBook.EvaluateAll(); // Get the formula's calculated value. e.g. "52" var formulaValue = workSheet["G30"].First().FormattedCellValue; // Get the formula as a string. e.g. "Max(C3:C7)" string formulaString = workSheet["G30"].Formula; // Save changes with updated formulas and calculated values. workBook.Save();</code></pre></div><div class="code_window_bottom"/></div></div><div class="code-content lander hide" id="sample-edit-excel-metadata-csharp"><div class="code_window add-shadow"><div class="code_window_title"><span style="margin-right: 10px;"><i class="vs-icon2"/> </span><span class="filename" style="margin-left: 0; margin-right: 19px;">Edit Excel Metadata in C#</span></div><div class="code_window_content"><pre class="prettyprint linenums lang-cs"><code>using IronXL; using System; WorkBook workBook = WorkBook.Load("sample.xlsx"); // Set author workBook.Metadata.Author = "Your Name"; // Set comments workBook.Metadata.Comments = "Monthly report"; // Set title workBook.Metadata.Title = "July"; // Set keywords workBook.Metadata.Keywords = "Report"; // Read the creation date of the excel file DateTime? creationDate = workBook.Metadata.Created; // Read the last printed date of the excel file DateTime? printDate = workBook.Metadata.LastPrinted; workBook.SaveAs("editedMetadata.xlsx");</code></pre></div><div class="code_window_bottom"/></div></div><div class="code-content lander hide" id="sample-excel-update-database-records"><div class="code_window add-shadow"><div class="code_window_title"><span style="margin-right: 10px;"><i class="vs-icon2"/> </span><span class="filename" style="margin-left: 0; margin-right: 19px;">Update Excel Database Records</span></div><div class="code_window_content"><pre class="prettyprint linenums lang-cs"><code>using IronXL; using System.Data; using System.Data.SqlClient; // Supported for XLSX, XLS, XLSM, XLTX, CSV and TSV WorkBook workBook = WorkBook.Load("sample.xlsx"); // Convert the workbook to ToDataSet DataSet dataSet = workBook.ToDataSet(); // Your sql query string sql = "SELECT * FROM Users"; // Your connection string string connectionString = @"Data Source=.\SQLEXPRESS;Initial Catalog=usersdb;Integrated Security=True"; using (SqlConnection connection = new SqlConnection(connectionString)) // Open connections to the database connection.Open(); SqlDataAdapter adapter = new SqlDataAdapter(sql, connection); // Update the values in database using the values in Excel adapter.Update(dataSet); }</code></pre></div><div class="code_window_bottom"/></div></div><div class="code-content lander hide" id="sample-excel-style-cells-borders-fonts"><div class="code_window add-shadow"><div class="code_window_title"><span style="margin-right: 10px;"><i class="vs-icon2"/> </span><span class="filename" style="margin-left: 0; margin-right: 19px;">Style Excel Cell Borders &amp; Fonts</span></div><div class="code_window_content"><pre class="prettyprint linenums lang-cs"><code>using IronXL; using IronXL.Styles; using IronSoftware.Drawing; using System.Linq; WorkBook workBook = WorkBook.Load("sample.xls"); WorkSheet workSheet = workBook.WorkSheets.First(); var range = workSheet["A1:H10"]; var cell = range.First(); // Set background color of the cell with an rgb string cell.Style.SetBackgroundColor("#428D65"); // Apply styling to the whole range. // Set underline property to the font // FontUnderlineType is enum that stands for different types of font underlying range.Style.Font.Underline = FontUnderlineType.SingleAccounting; // Define whether to use horizontal line through the text or not range.Style.Font.Strikeout = false; // Define whether the font is bold or not range.Style.Font.Bold = true; // Define whether the font is italic or not range.Style.Font.Italic = false; // Get or set script property of a font // Font script enum stands for available options range.Style.Font.FontScript = FontScript.Super; // Set the type of the border line // There are also TopBorder,LeftBorder,RightBorder,DiagonalBorder properties // BorderType enum indicates the line style of a border in a cell range.Style.BottomBorder.Type = BorderType.MediumDashed; // Indicate whether the cell should be auto-sized range.Style.ShrinkToFit = true; // Set alignment of the cell range.Style.VerticalAlignment = VerticalAlignment.Bottom; // Set border color range.Style.DiagonalBorder.SetColor("#20C96F"); // Define border type and border direction as well range.Style.DiagonalBorder.Type = BorderType.Thick; // DiagonalBorderDirection enum stands for direction of diagonal border inside cell range.Style.DiagonalBorderDirection = DiagonalBorderDirection.Forward; // Set background color of cells range.Style.SetBackgroundColor(Color.Aquamarine); // Set fill pattern of the cell // FillPattern enum indicates the style of fill pattern range.Style.FillPattern = FillPattern.Diamonds; // Set the number of spaces to intend the text range.Style.Indention = 5; // Indicate if the text is wrapped range.Style.WrapText = true; workBook.SaveAs("stylingOptions.xls");</code></pre></div><div class="code_window_bottom"/></div></div><div class="code-content lander hide" id="sample-sort-excel-range-csharp"><div class="code_window add-shadow"><div class="code_window_title"><span style="margin-right: 10px;"><i class="vs-icon2"/> </span><span class="filename" style="margin-left: 0; margin-right: 19px;">Sort Excel Ranges in C#</span></div><div class="code_window_content"><pre class="prettyprint linenums lang-cs"><code>using IronXL; WorkBook workBook = WorkBook.Load("sample.xlsx"); WorkSheet workSheet = workBook.DefaultWorkSheet; // Select a range var range = workSheet["A1:D20"]; // Select a column(B) var column = workSheet.GetColumn(1); // Sort the range in ascending order (A to Z) range.SortAscending(); // Sort the range by column(C) in ascending order range.SortByColumn("C", SortOrder.Ascending); // Sort the column(B) in descending order (Z to A) column.SortDescending(); workBook.SaveAs("sortExcelRange.xlsx");</code></pre></div><div class="code_window_bottom"/></div></div><div class="code-content lander hide" id="sample-repeating-rows-and-columns-in-excel"><div class="code_window add-shadow"><div class="code_window_title"><span style="margin-right: 10px;"><i class="vs-icon2"/> </span><span class="filename" style="margin-left: 0; margin-right: 19px;">Repeat Excel Rows &amp; Columns</span></div><div class="code_window_content"><pre class="prettyprint linenums lang-cs"><code>using IronXL; WorkBook workBook = WorkBook.Load("sample.xlsx"); WorkSheet workSheet = workBook.DefaultWorkSheet; // Set repeating rows for row(2-4) workSheet.SetRepeatingRows(1, 3); // Set repeating columns for column(C-D) workSheet.SetRepeatingColumns(2, 3); // Set column break after column(H). Hence, the first page will only contain column(A-G) workSheet.SetColumnBreak(7); workBook.SaveAs("repeatingRows.xlsx");</code></pre></div><div class="code_window_bottom"/></div></div><div class="code-content lander hide" id="sample-excel-print-setup"><div class="code_window add-shadow"><div class="code_window_title"><span style="margin-right: 10px;"><i class="vs-icon2"/> </span><span class="filename" style="margin-left: 0; margin-right: 19px;">Excel Print Setup</span></div><div class="code_window_content"><pre class="prettyprint linenums lang-cs"><code>using IronXL; using IronXL.Printing; WorkBook workBook = WorkBook.Load("sample.xlsx"); WorkSheet workSheet = workBook.DefaultWorkSheet; // Set the print header and footer of the worksheet workSheet.Header.Center = "My document"; workSheet.Footer.Center = "Page &amp;P of &amp;N"; // Set the header margin workSheet.PrintSetup.HeaderMargin = 2.33; // Set the size of the paper // Paper size enum represents different sizes of paper workSheet.PrintSetup.PaperSize = PaperSize.B4; // Set the print orientation of the worksheet workSheet.PrintSetup.PrintOrientation = PrintOrientation.Portrait; // Set black and white printing workSheet.PrintSetup.NoColor = true; workBook.SaveAs("PrintSetup.xlsx");</code></pre></div><div class="code_window_bottom"/></div></div><div class="code-content lander hide" id="sample-excel-number-formats"><div class="code_window add-shadow"><div class="code_window_title"><span style="margin-right: 10px;"><i class="vs-icon2"/> </span><span class="filename" style="margin-left: 0; margin-right: 19px;">Cell Data Display Format</span></div><div class="code_window_content"><pre class="prettyprint linenums lang-cs"><code>using IronXL; using System; using System.Linq; // Load an existing WorkSheet WorkBook workBook = WorkBook.Load("sample.xls"); WorkSheet workSheet = workBook.WorkSheets.First(); // Set data display format to cell // The cell value will look like 12300% workSheet["A2"].Value = 123; workSheet["A2"].FormatString = "0.0%"; // The cell value will look like 123.0000 workSheet["A2"].First().FormatString = "0.0000"; // Set data display format to range DateTime dateValue = new DateTime(2020, 1, 1, 12, 12, 12); workSheet["A3"].Value = dateValue; workSheet["A4"].First().Value = new DateTime(2022, 3, 3, 10, 10, 10); workSheet["A5"].First().Value = new DateTime(2021, 2, 2, 11, 11, 11); var range = workSheet["A3:A5"]; // The cell(A3) value will look like 1/1/2020 12:12:12 PM range.FormatString = "MM/dd/yy h:mm:ss"; workBook.SaveAs("numberFormats.xls");</code></pre></div><div class="code_window_bottom"/></div></div><div class="code-content lander hide" id="sample-load-excel-from-sql-database"><div class="code_window add-shadow"><div class="code_window_title"><span style="margin-right: 10px;"><i class="vs-icon2"/> </span><span class="filename" style="margin-left: 0; margin-right: 19px;">Load Excel From SQL Database</span></div><div class="code_window_content"><pre class="prettyprint linenums lang-cs"><code>using IronXL; using System.Data; using System.Data.SqlClient; // Your sql query string sql = "SELECT * FROM Users"; // Your connection string string connectionString = @"Data Source=.\SQLEXPRESS;Initial Catalog=usersdb;Integrated Security=True"; using (SqlConnection connection = new SqlConnection(connectionString)) // Open connections to the database connection.Open(); SqlDataAdapter adapter = new SqlDataAdapter(sql, connection); DataSet ds = new DataSet(); // Fill DataSet with data adapter.Fill(ds); // Create an Excel workbook from the SQL DataSet WorkBook workBook = WorkBook.Load(ds); }</code></pre></div><div class="code_window_bottom"/></div></div><div class="code-content lander hide" id="sample-combine-excel-ranges"><div class="code_window add-shadow"><div class="code_window_title"><span style="margin-right: 10px;"><i class="vs-icon2"/> </span><span class="filename" style="margin-left: 0; margin-right: 19px;">Combine Excel Ranges</span></div><div class="code_window_content"><pre class="prettyprint linenums lang-cs"><code>using IronXL; using System; using System.Linq; WorkBook workBook = WorkBook.Load("sample.xls"); WorkSheet workSheet = workBook.WorkSheets.First(); // Get a range from an Excel worksheet var range = workSheet["A2:A8"]; // Combine two ranges var combinedRange = range + workSheet["A9:A10"]; // Iterate over combined range foreach (var cell in combinedRange) Console.WriteLine(cell.Value); }</code></pre></div><div class="code_window_bottom"/></div></div><div class="code-content lander hide" id="sample-select-excel-range"><div class="code_window add-shadow"><div class="code_window_title"><span style="margin-right: 10px;"><i class="vs-icon2"/> </span><span class="filename" style="margin-left: 0; margin-right: 19px;">Select Excel Range</span></div><div class="code_window_content"><pre class="prettyprint linenums lang-cs"><code>using IronXL; using System; using System.Linq; WorkBook workBook = WorkBook.Load("sample.xls"); WorkSheet workSheet = workBook.WorkSheets.First(); // Get range from worksheet var range = workSheet["A2:A8"]; // Get column from worksheet var columnA = workSheet.GetColumn(0); // Get row from worksheet var row1 = workSheet.GetRow(0); // Iterate over the range foreach (var cell in range) Console.WriteLine($"{cell.Value}"); // Select and print every row var rows = workSheet.Rows; foreach (var eachRow in rows) foreach (var cell in eachRow) Console.Write($" {cell.Value} |"); Console.WriteLine($""); }</code></pre></div><div class="code_window_bottom"/></div></div><div class="code-content lander hide" id="sample-convert-excel-to-html"><div class="code_window add-shadow"><div class="code_window_title"><span style="margin-right: 10px;"><i class="vs-icon2"/> </span><span class="filename" style="margin-left: 0; margin-right: 19px;">Convert Excel to HTML</span></div><div class="code_window_content"><pre class="prettyprint linenums lang-cs"><code>using IronXL; using IronXL.Options; WorkBook workBook = WorkBook.Load("sample.xlsx"); var options = new HtmlExportOptions() // Set row/column numbers visible in html document OutputRowNumbers = true, OutputColumnHeaders = true, // Set hidden rows/columns visible in html document OutputHiddenRows = true, OutputHiddenColumns = true, // Set leading spaces as non-breaking OutputLeadingSpacesAsNonBreaking = true // Export workbook to the HTML file workBook.ExportToHtml("workBook.html", options);</code></pre></div><div class="code_window_bottom"/></div></div><div class="code-content lander hide" id="sample-aggregate-excel-functions"><div class="code_window add-shadow"><div class="code_window_title"><span style="margin-right: 10px;"><i class="vs-icon2"/> </span><span class="filename" style="margin-left: 0; margin-right: 19px;">Aggregate Excel Functions</span></div><div class="code_window_content"><pre class="prettyprint linenums lang-cs"><code>using IronXL; using System.Linq; WorkBook workBook = WorkBook.Load("sample.xls"); WorkSheet workSheet = workBook.WorkSheets.First(); // Get range from worksheet var range = workSheet["A1:A8"]; // Apply sum of all numeric cells within the range decimal sum = range.Sum(); // Apply average value of all numeric cells within the range decimal avg = range.Avg(); // Identify maximum value of all numeric cells within the range decimal max = range.Max(); // Identify minimum value of all numeric cells within the range decimal min = range.Min();</code></pre></div><div class="code_window_bottom"/></div></div><div class="code-content lander hide" id="sample-create-a-excel-line-chart"><div class="code_window add-shadow"><div class="code_window_title"><span style="margin-right: 10px;"><i class="vs-icon2"/> </span><span class="filename" style="margin-left: 0; margin-right: 19px;">Create Excel Line Chart</span></div><div class="code_window_content"><pre class="prettyprint linenums lang-cs"><code>using IronXL; using IronXL.Drawing.Charts; WorkBook workBook = WorkBook.Load("test.xlsx"); WorkSheet workSheet = workBook.DefaultWorkSheet; // Set the chart type and it's position on the worksheet. var chart = workSheet.CreateChart(ChartType.Line, 10, 10, 18, 20); // Add the series to the chart // The first parameter represents the address of the range for horizontal(category) axis. // The second parameter represents the address of the range for vertical(value) axis. var series = chart.AddSeries("B3:B8", "A3:A8"); // Set the chart title. series.Title = "Line Chart"; // Set the legend position. // Can be removed by setting it to None. chart.SetLegendPosition(LegendPosition.Bottom); // We can change the position of the chart. chart.Position.LeftColumnIndex = 2; chart.Position.RightColumnIndex = chart.Position.LeftColumnIndex + 3; // Plot all the data that was added to the chart before. // Multiple call of this method leads to plotting multiple charts instead of modifying the existing chart. // Yet there is no possibility to remove chart or edit it's series/position. // We can just create new one. chart.Plot(); workBook.SaveAs("CreateLineChart.xlsx");</code></pre></div><div class="code_window_bottom"/></div></div><div class="code-content lander hide" id="sample-freeze-panes-in-excel"><div class="code_window add-shadow"><div class="code_window_title"><span style="margin-right: 10px;"><i class="vs-icon2"/> </span><span class="filename" style="margin-left: 0; margin-right: 19px;">Freeze Panes in Excel</span></div><div class="code_window_content"><pre class="prettyprint linenums lang-cs"><code>using IronXL; using System.Linq; WorkBook workBook = WorkBook.Load("sample.xls"); WorkSheet workSheet = workBook.WorkSheets.First(); // Create freeze pane from column(A-B) and row(1-3) workSheet.CreateFreezePane(2, 3); // Overwriting freeze or split pane to column(A-E) and row(1-5) as well as applying prescroll // The column will show E,G,... and the row will show 5,8,... workSheet.CreateFreezePane(5, 5, 6, 7); workBook.SaveAs("createFreezePanes.xls"); // Remove all existing freeze or split pane workSheet.RemovePane();</code></pre></div><div class="code_window_bottom"/></div></div><div class="code-content lander hide" id="sample-copy-an-excel-worksheet"><div class="code_window add-shadow"><div class="code_window_title"><span style="margin-right: 10px;"><i class="vs-icon2"/> </span><span class="filename" style="margin-left: 0; margin-right: 19px;">Copy Excel Worksheets</span></div><div class="code_window_content"><pre class="prettyprint linenums lang-cs"><code>using IronXL; WorkBook firstBook = WorkBook.Load("sample.xlsx"); WorkBook secondBook = WorkBook.Create(); // Select first worksheet in the workbook WorkSheet workSheet = firstBook.DefaultWorkSheet; // Duplicate the worksheet to the same workbook workSheet.CopySheet("Copied Sheet"); // Duplicate the worksheet to another workbook with the specified name workSheet.CopyTo(secondBook, "Copied Sheet"); firstBook.Save(); secondBook.SaveAs("copyExcelWorksheet.xlsx");</code></pre></div><div class="code_window_bottom"/></div></div></div></div></div><img class="add-shadow banner__product-home-top-image banner__product-home-top-image--right-ironxl" src="/img/products/ironxl-logo.svg" alt="IronXL"/></div></div></header><main class="main-inverse js-three-columns-section-mark three-columns-section blog-container" id="main"><div class="container-fluid"><div class="row"><div class="col-sm-12 col-md-12 col-lg-8 main-content__max-width-80ch"><article class="main-article main-content blog-category-wrapper"><ol class="breadcrumb"><li><a href="/csharp/excel/">IronXL</a></li><li><a href="/csharp/excel/blog/">IronXL Blog</a></li><li><a href="/csharp/excel/blog/compare-to-other-components/">Compare to Other Components</a></li><li class="active js-code-explorer-item-replacement" data-code-explorer-item-group="code-explorer" data-code-explorer-item-name="title">Aspose Cells</li></ol><p class="blog-category__post-date">Published March 30, 2022</p><h1>A Comparison between IronXL and Aspose Cells</h1><p>The ability to work with Excel files to generate reports and build databases has become essential for today's software applications. There are many libraries now available that allow users to do this without Microsoft Excel.</p><p>In this article, we are going to discuss and compare how to work with Microsoft Excel documents programmatically in C# .NET technologies using two of the most popular libraries, IronXL and Aspose Cells.</p><p>IronXL and Aspose Cells both provide the methods to create, edit, and read Excel documents in the .NET framework. The next question is to decide which <a href="/csharp/excel/">C# Excel library</a> is best suited to your project. This article will help you decide on the best option for your applications.</p><p>Let's look firstly at what both libraries have to offer, and then move on to the comparison itself.</p><h2 id="anchor-the-ironxl-library">The IronXL Library</h2><p>IronXL is a .NET library that facilitates reading and editing Microsoft Excel documents with C#. IronXL.Excel is a standalone .NET software library for reading a wide range of spreadsheet formats. It does not require Microsoft Excel to be installed, nor does it depend on Interop.</p><p>IronXL is an intuitive C# API that allows you to read, edit and create Excel spreadsheet files in .NET with lightning-fast performance. IronXL fully supports .NET Core, .NET Framework, Xamarin, Mobile, Linux, macOS and Azure.</p><p>IronXL is a leading .NET core and .NET framework Excel spreadsheet library for C#.</p><p>You can download the software product from this <a href="https://ironsoftware.com/csharp/excel/downloads/aspose-cells-read-excel-alternatives.zip">link</a>.</p><h3 id="anchor-ironxl-feature-set">IronXL Feature Set</h3><ul><li>Load, read, and edit data — from XLS/XLSX/CSV/TSV</li><li>Saving and exporting — to XLS/XLSX/CSV/TSV/JSON</li><li>System.Data Objects — work with Excel Spreadsheets as System.Data.DataSet and System.Data.DataTable objects.</li><li>Formulas — works with Excel formulas. Formulas are recalculated every time a sheet is edited.</li><li>Ranges — easy to use WorkSheet["A1:B10"] syntax. Combine and create ranges intuitively.</li><li>Sorting — sort ranges, columns and rows.</li><li>Styling — cell visual styles, font, size, background pattern, border, alignment and number formats.</li></ul><h2 id="anchor-aspose-cells">Aspose Cells</h2><p>Aspose.Cells for .NET is an Excel Spreadsheet Programming API to speed up spreadsheet management and processing tasks. The API supports the building of cross-platform applications that have the ability to generate, modify, convert, render and print spreadsheets. Moreover, it does not rely on Microsoft Excel or any Microsoft Office Interop components to be installed but instead offers a robust set of APIs that deal with all Excel formats as well as CSV and SpreadsheetML formats.</p><p>By integrating the API, developers can perform basic tasks such as managing multiple worksheets, creating spreadsheet content and styles from scratch, importing data into worksheets from different data sources, adding common and complex mathematical, financial, and text formulas, manipulating charts, pictures, comments, drawing objects, and much more.</p><h3 id="anchor-aspose-cells-excel-spreadsheet-api-features">Aspose Cells Excel Spreadsheet API Features</h3><p>Here are some standout features of Aspose Cells:</p><p><strong>Rendering</strong></p><ul><li>Chart to Image</li><li>Worksheet to Image</li><li>Printing</li></ul><p><strong>Data Processing</strong></p><ul><li>Apply Formatting</li><li>Apply Formulas</li><li>Summarize</li><li>Smart Markers</li></ul><p><strong>Grid Suite</strong></p><ul><li>Desktop Control for WinForms</li><li>Web Control for ASP.NET</li><li>Apply Formatting</li><li>Apply Formulas</li><li>Import/Export Data</li></ul><p>The rest of this article continues as follows:</p><ol><li>Create a Console Application</li><li>IronXL C# Library Installation</li><li>Aspose Cells Installation</li><li>Create and Save a new Excel Workbook and Sheet</li><li>Read Excel files</li><li>Working with Excel Formulas</li><li>Inter Convert files</li><li>Licensing</li><li>Conclusion</li></ol><h2 id="anchor-1-create-a-console-application">1. Create a Console Application</h2><p>Use the following steps to create a Console Application:</p><ul><li>Start the Visual Studio 2022 IDE.</li><li>Click on <strong>“Create new project”</strong>.</li><li>On the <strong>“Create new project”</strong> page, select <strong>C#</strong> in the language drop down list, <strong>Windows</strong> from the <strong>Platforms</strong> list, and <strong>Console</strong> from the <strong>“Project types”</strong> list.</li><li>Select <strong>Console App (.NET Framework)</strong> from the project templates displayed.</li></ul><div class="content-img-align-center"><img alt="Create Project - Console Application" class="img-responsive add-shadow lazy" data-src="/static-assets/excel/blog/aspose-cells-read-excel-file-alternative/aspose-cells-read-excel-file-alternative-1.png"/></div><ul><li>Click <strong>Next</strong>.</li><li>In the <strong>Additional Information</strong> screen, specify the <strong>Framework version</strong> you would like to use. We will use <strong>.NET Framework 4.8</strong> in this example.</li></ul><div class="content-img-align-center"><img alt="Create Project -.NET Framework" class="img-responsive add-shadow lazy" data-src="/static-assets/excel/blog/aspose-cells-read-excel-file-alternative/aspose-cells-read-excel-file-alternative-2.png"/></div><ul><li>Click <strong>Create</strong> to complete the process.</li></ul><p>Now the project is created and we are almost ready to test the libraries. However, we still need to install and integrate them into our project. Let's install IronXL first.</p><h2 id="anchor-2-ironxl-c-num-library-installation">2. IronXL C&amp;num; Library Installation</h2><p>You can download and install the IronXL library using the following methods:</p><ol><li>Using Visual Studio with NuGet packages.</li><li>Download the NuGet Package directly.</li><li>Manually install with the DLL.</li></ol><p>Let’s take a closer look at each one.</p><h3 id="anchor-2-1-using-visual-studio-with-nuget-packages">2.1. Using Visual Studio with NuGet packages</h3><p>Visual Studio provides the NuGet Package Manager to install NuGet packages in your projects. You can access it through the Project Menu, or by right-clicking your project in the Solution Explorer.</p><div class="content-img-align-center"><img alt="Select Manage NuGet Package" class="img-responsive add-shadow lazy" data-src="/static-assets/excel/blog/aspose-cells-read-excel-file-alternative/aspose-cells-read-excel-file-alternative-3.png"/></div><ul><li>Next, from the browse tab -&gt; search for IronXL.Excel -&gt; Install</li></ul><div class="content-img-align-center"><img alt="Search for IronXL" class="img-responsive add-shadow lazy" data-src="/static-assets/excel/blog/aspose-cells-read-excel-file-alternative/aspose-cells-read-excel-file-alternative-4.png"/></div><ul><li>And we are done.</li></ul><h3 id="anchor-2-2-download-the-nuget-package-directly">2.2. Download the NuGet Package Directly</h3><p>This can be done by visiting the NuGet site directly and downloading the package. The steps are:</p><ul><li>Navigate to <a href="https://www.nuget.org/packages/IronXL.Excel" target="_blank" rel="nofollow"/><a href="https://www.nuget.org/packages/IronXL.Excel" target="__blank">https://www.nuget.org/packages/IronXL.Excel</a></li><li>Select "Download Package".</li><li>Double-click the downloaded package.</li><li>The package will be installed.</li><li>Reload your Visual Studio project and begin using it.</li></ul><h3 id="anchor-2-3-manually-install-with-the-dll">2.3. Manually Install with the DLL</h3><p>Another way to download and install the IronXL C# Library is to make use of the following steps to install the <strong>IronXL NuGet package</strong> through the Developer Command Prompt.</p><ul><li>Open the <strong>Developer Command Prompt</strong> — usually found in the Visual Studio folder.</li></ul><p>Type the following command:</p><p><code>PM &gt; Install-Package IronXL.Excel</code></p><ul><li>Press Enter.</li><li>This will download and install the package.</li><li>Reload your Visual Studio project and begin using it.</li></ul><h3 id="anchor-2-4-add-necessary-using-directives">2.4. Add Necessary Using Directives</h3><ol><li>In Solution Explorer, right-click the <strong>Program.cs</strong> file and then click View Code.</li><li>Add the following using directives to the top of the code file:</li></ol><pre class="naked-code"><code class="language-cs">using IronXL;</code></pre><div class="code-content code-content-inner"><div class="code_window"><div class="language-selection__content-page-wrapper"/><div class="code_window_content"><div class="code-window__action-buttons-wrapper code-window__action-buttons-wrapper--content-page"><button title="Click to copy" class="code-window__action-button code-window__action-button--copy copy-clipboard" data-clipboard-id="code-explorer" data-placement="bottom"><svg width="16" height="16" viewbox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M9.53515 14.5295C4.88236 14.5295 6.83966 14.5295 2.05009 14.5295V4.55504H3.19663V3.0849H1.75902C1.06465 3.0849 0.5 3.6106 0.5 4.25687V14.8277C0.5 15.475 1.06351 15.9999 1.75871 15.9999C3.47852 15.9999 6.7062 15.9999 9.82653 15.9999C10.5217 15.9999 11.0852 15.4752 11.0852 14.8277C11.0852 14.7177 11.0852 14.6188 11.0852 14.515H9.53512L9.53515 14.5295Z" fill="white"/><path d="M15.2833 2.19563L13.1418 0.201276C13.0019 0.0710973 12.816 0 12.6191 0H6.17382C5.47944 0 4.91479 0.525728 4.91479 1.17225V11.7428C4.91479 12.3901 5.4783 12.9151 6.17382 12.9151C7.89332 12.9151 11.121 12.9151 14.2413 12.9151C14.9365 12.9151 15.5 12.3904 15.5 11.7428C15.5 4.94324 15.5 9.65683 15.5 2.68229C15.5 2.49846 15.4232 2.32552 15.2833 2.19563ZM13.9499 11.4449C9.29688 11.4449 11.2544 11.4449 6.46464 11.4449V1.47043H11.6697V2.75988C11.6697 3.21946 12.071 3.59339 12.5645 3.59339H13.9499V11.4449Z" fill="white"/></svg></button> <button title="Full Screen Mode" class="code-window__action-button code-window__action-button--full-screen js-full-screen-code-example-modal"><svg width="17" height="16" viewbox="0 0 17 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" clip-rule="evenodd" d="M9.81671 0L16.0012 7.41747e-07V6.18358H13.6824V2.31884L9.81671 2.31884V0ZM0.00122688 1.05964e-07H6.18386V2.31884H2.32007V6.18358H0.00122688V1.05964e-07ZM2.31884 9.81614L2.31978 13.6812H6.18386V16H0.00150991L0 9.81671L2.31884 9.81614ZM16 9.81614L16.0015 16H9.81671V13.6812H13.6821L13.6812 9.81671L16 9.81614Z" fill="#454545"/></svg></button> <button title="Exit Full Screen" class="code-window__action-button code-window__action-button--exit-full-screen js-exit-full-screen-code-example-modal"><svg width="16" height="16" viewbox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M15.9653 3.47851V5.56547H10.4012L10.3998 0.000508881L12.4868 0L12.4877 3.47851H15.9653Z" fill="#53B78E"/><path d="M15.9653 12.4869V10.3999H10.4012L10.3998 15.965L12.4868 15.9655L12.4877 12.4869H15.9653Z" fill="#53B78E"/><path d="M0 12.4869L1.82446e-07 10.3999H5.56411L5.56547 15.965L3.47852 15.9655L3.47766 12.4869H0Z" fill="#53B78E"/><path d="M1.82447e-07 3.47851L0 5.56547H5.56411L5.56547 0.000509063L3.47852 0L3.47766 3.47851H1.82447e-07Z" fill="#53B78E"/></svg></button></div><pre class="prettyprint linenums lang-cs"><code>using IronXL;</code></pre><pre class="prettyprint linenums lang-vb"><code>Imports IronXL</code></pre></div><div class="code_window_bottom"><span class="language_selection"><span class="ls-span">VB </span> <span><label class="switch"><input type="checkbox" checked="checked"/> <span class="slider round"/></label> </span><span class="ls-span">C#</span></span></div></div></div><p>All done! IronXL is downloaded, installed, and ready to use. However, before that, we should install Microsoft.Office.Interop.Excel.</p><h2 id="anchor-3-aspose-cells-installation">3. Aspose Cells Installation</h2><h3 id="anchor-3-1-using-visual-studio-with-nuget-packages">3.1. Using Visual Studio with NuGet packages</h3><p>After creating the project, access NuGet Package Manager through the Project Menu, or by right-clicking your project in the Solution Explorer.</p><ul><li>Now, from the browse tab -&gt; search for Aspose Cells -&gt; Install</li></ul><h3 id="anchor-3-2-using-the-nuget-package-manager-console">3.2. Using the NuGet Package Manager Console</h3><p>Another way to download and install the Aspose Cells C# Library is to make use of the following steps to install the <strong>NuGet package</strong> through the Developer Command Prompt.</p><ul><li>Open the <strong>Developer Command Prompt</strong> — usually found in the Visual Studio folder.</li></ul><p>Type the following command:</p><p><code>PM&gt; Install-Package Aspose.Cells</code></p><ul><li>Press Enter.</li><li>This will download and install the package.</li><li>Reload your Visual Studio project and begin using it.</li></ul><h3 id="anchor-3-3-direct-download">3.3. Direct Download</h3><p>You can download any version of Aspose Cells directly from the website by clicking on this link: <a href="https://downloads.aspose.com/cells/net" target="_blank" rel="nofollow"/><a href="https://downloads.aspose.com/cells/net" target="__blank">https://downloads.aspose.com/cells/net</a></p><p>Or:</p><p>download from the NuGet website: <a href="https://www.nuget.org/packages/Aspose.Cells/" target="_blank" rel="nofollow"/><a href="https://www.nuget.org/packages/Aspose.Cells/" target="__blank">https://www.nuget.org/packages/Aspose.Cells/</a></p><h3 id="anchor-3-4-add-necessary-using-directives">3.4. Add Necessary Using Directives</h3><ol><li>In Solution Explorer, right-click the <strong>Program.cs</strong> file and then click View Code.</li><li>Add the following using directives to the top of the code file:</li></ol><pre class="naked-code"><code class="language-cs">using Aspose.Cells;</code></pre><div class="code-content code-content-inner"><div class="code_window"><div class="language-selection__content-page-wrapper"/><div class="code_window_content"><div class="code-window__action-buttons-wrapper code-window__action-buttons-wrapper--content-page"><button title="Click to copy" class="code-window__action-button code-window__action-button--copy copy-clipboard" data-clipboard-id="code-explorer" data-placement="bottom"><svg width="16" height="16" viewbox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M9.53515 14.5295C4.88236 14.5295 6.83966 14.5295 2.05009 14.5295V4.55504H3.19663V3.0849H1.75902C1.06465 3.0849 0.5 3.6106 0.5 4.25687V14.8277C0.5 15.475 1.06351 15.9999 1.75871 15.9999C3.47852 15.9999 6.7062 15.9999 9.82653 15.9999C10.5217 15.9999 11.0852 15.4752 11.0852 14.8277C11.0852 14.7177 11.0852 14.6188 11.0852 14.515H9.53512L9.53515 14.5295Z" fill="white"/><path d="M15.2833 2.19563L13.1418 0.201276C13.0019 0.0710973 12.816 0 12.6191 0H6.17382C5.47944 0 4.91479 0.525728 4.91479 1.17225V11.7428C4.91479 12.3901 5.4783 12.9151 6.17382 12.9151C7.89332 12.9151 11.121 12.9151 14.2413 12.9151C14.9365 12.9151 15.5 12.3904 15.5 11.7428C15.5 4.94324 15.5 9.65683 15.5 2.68229C15.5 2.49846 15.4232 2.32552 15.2833 2.19563ZM13.9499 11.4449C9.29688 11.4449 11.2544 11.4449 6.46464 11.4449V1.47043H11.6697V2.75988C11.6697 3.21946 12.071 3.59339 12.5645 3.59339H13.9499V11.4449Z" fill="white"/></svg></button> <button title="Full Screen Mode" class="code-window__action-button code-window__action-button--full-screen js-full-screen-code-example-modal"><svg width="17" height="16" viewbox="0 0 17 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" clip-rule="evenodd" d="M9.81671 0L16.0012 7.41747e-07V6.18358H13.6824V2.31884L9.81671 2.31884V0ZM0.00122688 1.05964e-07H6.18386V2.31884H2.32007V6.18358H0.00122688V1.05964e-07ZM2.31884 9.81614L2.31978 13.6812H6.18386V16H0.00150991L0 9.81671L2.31884 9.81614ZM16 9.81614L16.0015 16H9.81671V13.6812H13.6821L13.6812 9.81671L16 9.81614Z" fill="#454545"/></svg></button> <button title="Exit Full Screen" class="code-window__action-button code-window__action-button--exit-full-screen js-exit-full-screen-code-example-modal"><svg width="16" height="16" viewbox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M15.9653 3.47851V5.56547H10.4012L10.3998 0.000508881L12.4868 0L12.4877 3.47851H15.9653Z" fill="#53B78E"/><path d="M15.9653 12.4869V10.3999H10.4012L10.3998 15.965L12.4868 15.9655L12.4877 12.4869H15.9653Z" fill="#53B78E"/><path d="M0 12.4869L1.82446e-07 10.3999H5.56411L5.56547 15.965L3.47852 15.9655L3.47766 12.4869H0Z" fill="#53B78E"/><path d="M1.82447e-07 3.47851L0 5.56547H5.56411L5.56547 0.000509063L3.47852 0L3.47766 3.47851H1.82447e-07Z" fill="#53B78E"/></svg></button></div><pre class="prettyprint linenums lang-cs"><code>using Aspose.Cells;</code></pre><pre class="prettyprint linenums lang-vb"><code>Imports Aspose.Cells</code></pre></div><div class="code_window_bottom"><span class="language_selection"><span class="ls-span">VB </span> <span><label class="switch"><input type="checkbox" checked="checked"/> <span class="slider round"/></label> </span><span class="ls-span">C#</span></span></div></div></div><h2 id="anchor-4-create-and-save-a-new-excel-workbook-and-sheet">4. Create and Save a new Excel Workbook and Sheet</h2><p>A workbook is an Excel file containing multiple worksheets with rows and columns. Both the libraries provide the facility to create a new Excel workbook and sheets. Let's have a look at the code step-by-step.</p><h3 id="anchor-4-1-new-excel-workbook-and-sheet-using-ironxl">4.1. New Excel Workbook and Sheet using IronXL</h3><p>It could not be any easier to create a new Excel Workbook using IronXL! It is just one line of code! Yes, really. Add the following code to your static void main function in the Program.cs file:</p><pre class="naked-code"><code class="language-cs">WorkBook workbook = WorkBook.Create(ExcelFileFormat.XLSX);</code></pre><div class="code-content code-content-inner"><div class="code_window"><div class="language-selection__content-page-wrapper"/><div class="code_window_content"><div class="code-window__action-buttons-wrapper code-window__action-buttons-wrapper--content-page"><button title="Click to copy" class="code-window__action-button code-window__action-button--copy copy-clipboard" data-clipboard-id="code-explorer" data-placement="bottom"><svg width="16" height="16" viewbox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M9.53515 14.5295C4.88236 14.5295 6.83966 14.5295 2.05009 14.5295V4.55504H3.19663V3.0849H1.75902C1.06465 3.0849 0.5 3.6106 0.5 4.25687V14.8277C0.5 15.475 1.06351 15.9999 1.75871 15.9999C3.47852 15.9999 6.7062 15.9999 9.82653 15.9999C10.5217 15.9999 11.0852 15.4752 11.0852 14.8277C11.0852 14.7177 11.0852 14.6188 11.0852 14.515H9.53512L9.53515 14.5295Z" fill="white"/><path d="M15.2833 2.19563L13.1418 0.201276C13.0019 0.0710973 12.816 0 12.6191 0H6.17382C5.47944 0 4.91479 0.525728 4.91479 1.17225V11.7428C4.91479 12.3901 5.4783 12.9151 6.17382 12.9151C7.89332 12.9151 11.121 12.9151 14.2413 12.9151C14.9365 12.9151 15.5 12.3904 15.5 11.7428C15.5 4.94324 15.5 9.65683 15.5 2.68229C15.5 2.49846 15.4232 2.32552 15.2833 2.19563ZM13.9499 11.4449C9.29688 11.4449 11.2544 11.4449 6.46464 11.4449V1.47043H11.6697V2.75988C11.6697 3.21946 12.071 3.59339 12.5645 3.59339H13.9499V11.4449Z" fill="white"/></svg></button> <button title="Full Screen Mode" class="code-window__action-button code-window__action-button--full-screen js-full-screen-code-example-modal"><svg width="17" height="16" viewbox="0 0 17 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" clip-rule="evenodd" d="M9.81671 0L16.0012 7.41747e-07V6.18358H13.6824V2.31884L9.81671 2.31884V0ZM0.00122688 1.05964e-07H6.18386V2.31884H2.32007V6.18358H0.00122688V1.05964e-07ZM2.31884 9.81614L2.31978 13.6812H6.18386V16H0.00150991L0 9.81671L2.31884 9.81614ZM16 9.81614L16.0015 16H9.81671V13.6812H13.6821L13.6812 9.81671L16 9.81614Z" fill="#454545"/></svg></button> <button title="Exit Full Screen" class="code-window__action-button code-window__action-button--exit-full-screen js-exit-full-screen-code-example-modal"><svg width="16" height="16" viewbox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M15.9653 3.47851V5.56547H10.4012L10.3998 0.000508881L12.4868 0L12.4877 3.47851H15.9653Z" fill="#53B78E"/><path d="M15.9653 12.4869V10.3999H10.4012L10.3998 15.965L12.4868 15.9655L12.4877 12.4869H15.9653Z" fill="#53B78E"/><path d="M0 12.4869L1.82446e-07 10.3999H5.56411L5.56547 15.965L3.47852 15.9655L3.47766 12.4869H0Z" fill="#53B78E"/><path d="M1.82447e-07 3.47851L0 5.56547H5.56411L5.56547 0.000509063L3.47852 0L3.47766 3.47851H1.82447e-07Z" fill="#53B78E"/></svg></button></div><pre class="prettyprint linenums lang-cs"><code>WorkBook workbook = WorkBook.Create(ExcelFileFormat.XLSX);</code></pre><pre class="prettyprint linenums lang-vb"><code>Dim workbook As WorkBook = WorkBook.Create(ExcelFileFormat.XLSX)</code></pre></div><div class="code_window_bottom"><span class="language_selection"><span class="ls-span">VB </span> <span><label class="switch"><input type="checkbox" checked="checked"/> <span class="slider round"/></label> </span><span class="ls-span">C#</span></span></div></div></div><p>Both XLS (older Excel file version) and XLSX (current and newer file version) file formats can be created with IronXL.</p><p>And, it’s even simpler to create a default Worksheet:</p><pre class="naked-code"><code class="language-cs">var worksheet = workbook.CreateWorkSheet("IronXL Features");</code></pre><div class="code-content code-content-inner"><div class="code_window"><div class="language-selection__content-page-wrapper"/><div class="code_window_content"><div class="code-window__action-buttons-wrapper code-window__action-buttons-wrapper--content-page"><button title="Click to copy" class="code-window__action-button code-window__action-button--copy copy-clipboard" data-clipboard-id="code-explorer" data-placement="bottom"><svg width="16" height="16" viewbox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M9.53515 14.5295C4.88236 14.5295 6.83966 14.5295 2.05009 14.5295V4.55504H3.19663V3.0849H1.75902C1.06465 3.0849 0.5 3.6106 0.5 4.25687V14.8277C0.5 15.475 1.06351 15.9999 1.75871 15.9999C3.47852 15.9999 6.7062 15.9999 9.82653 15.9999C10.5217 15.9999 11.0852 15.4752 11.0852 14.8277C11.0852 14.7177 11.0852 14.6188 11.0852 14.515H9.53512L9.53515 14.5295Z" fill="white"/><path d="M15.2833 2.19563L13.1418 0.201276C13.0019 0.0710973 12.816 0 12.6191 0H6.17382C5.47944 0 4.91479 0.525728 4.91479 1.17225V11.7428C4.91479 12.3901 5.4783 12.9151 6.17382 12.9151C7.89332 12.9151 11.121 12.9151 14.2413 12.9151C14.9365 12.9151 15.5 12.3904 15.5 11.7428C15.5 4.94324 15.5 9.65683 15.5 2.68229C15.5 2.49846 15.4232 2.32552 15.2833 2.19563ZM13.9499 11.4449C9.29688 11.4449 11.2544 11.4449 6.46464 11.4449V1.47043H11.6697V2.75988C11.6697 3.21946 12.071 3.59339 12.5645 3.59339H13.9499V11.4449Z" fill="white"/></svg></button> <button title="Full Screen Mode" class="code-window__action-button code-window__action-button--full-screen js-full-screen-code-example-modal"><svg width="17" height="16" viewbox="0 0 17 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" clip-rule="evenodd" d="M9.81671 0L16.0012 7.41747e-07V6.18358H13.6824V2.31884L9.81671 2.31884V0ZM0.00122688 1.05964e-07H6.18386V2.31884H2.32007V6.18358H0.00122688V1.05964e-07ZM2.31884 9.81614L2.31978 13.6812H6.18386V16H0.00150991L0 9.81671L2.31884 9.81614ZM16 9.81614L16.0015 16H9.81671V13.6812H13.6821L13.6812 9.81671L16 9.81614Z" fill="#454545"/></svg></button> <button title="Exit Full Screen" class="code-window__action-button code-window__action-button--exit-full-screen js-exit-full-screen-code-example-modal"><svg width="16" height="16" viewbox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M15.9653 3.47851V5.56547H10.4012L10.3998 0.000508881L12.4868 0L12.4877 3.47851H15.9653Z" fill="#53B78E"/><path d="M15.9653 12.4869V10.3999H10.4012L10.3998 15.965L12.4868 15.9655L12.4877 12.4869H15.9653Z" fill="#53B78E"/><path d="M0 12.4869L1.82446e-07 10.3999H5.56411L5.56547 15.965L3.47852 15.9655L3.47766 12.4869H0Z" fill="#53B78E"/><path d="M1.82447e-07 3.47851L0 5.56547H5.56411L5.56547 0.000509063L3.47852 0L3.47766 3.47851H1.82447e-07Z" fill="#53B78E"/></svg></button></div><pre class="prettyprint linenums lang-cs"><code>var worksheet = workbook.CreateWorkSheet("IronXL Features");</code></pre><pre class="prettyprint linenums lang-vb"><code>Dim worksheet = workbook.CreateWorkSheet("IronXL Features")</code></pre></div><div class="code_window_bottom"><span class="language_selection"><span class="ls-span">VB </span> <span><label class="switch"><input type="checkbox" checked="checked"/> <span class="slider round"/></label> </span><span class="ls-span">C#</span></span></div></div></div><p>You can now use the worksheet variable to set cell values and do almost everything an Excel file can do.</p><p>Save Excel files:</p><pre class="naked-code"><code class="language-cs">//Save spreadsheet workbook.SaveAs("NewExcelFile.xlsx");</code></pre><div class="code-content code-content-inner"><div class="code_window"><div class="language-selection__content-page-wrapper"/><div class="code_window_content"><div class="code-window__action-buttons-wrapper code-window__action-buttons-wrapper--content-page"><button title="Click to copy" class="code-window__action-button code-window__action-button--copy copy-clipboard" data-clipboard-id="code-explorer" data-placement="bottom"><svg width="16" height="16" viewbox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M9.53515 14.5295C4.88236 14.5295 6.83966 14.5295 2.05009 14.5295V4.55504H3.19663V3.0849H1.75902C1.06465 3.0849 0.5 3.6106 0.5 4.25687V14.8277C0.5 15.475 1.06351 15.9999 1.75871 15.9999C3.47852 15.9999 6.7062 15.9999 9.82653 15.9999C10.5217 15.9999 11.0852 15.4752 11.0852 14.8277C11.0852 14.7177 11.0852 14.6188 11.0852 14.515H9.53512L9.53515 14.5295Z" fill="white"/><path d="M15.2833 2.19563L13.1418 0.201276C13.0019 0.0710973 12.816 0 12.6191 0H6.17382C5.47944 0 4.91479 0.525728 4.91479 1.17225V11.7428C4.91479 12.3901 5.4783 12.9151 6.17382 12.9151C7.89332 12.9151 11.121 12.9151 14.2413 12.9151C14.9365 12.9151 15.5 12.3904 15.5 11.7428C15.5 4.94324 15.5 9.65683 15.5 2.68229C15.5 2.49846 15.4232 2.32552 15.2833 2.19563ZM13.9499 11.4449C9.29688 11.4449 11.2544 11.4449 6.46464 11.4449V1.47043H11.6697V2.75988C11.6697 3.21946 12.071 3.59339 12.5645 3.59339H13.9499V11.4449Z" fill="white"/></svg></button> <button title="Full Screen Mode" class="code-window__action-button code-window__action-button--full-screen js-full-screen-code-example-modal"><svg width="17" height="16" viewbox="0 0 17 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" clip-rule="evenodd" d="M9.81671 0L16.0012 7.41747e-07V6.18358H13.6824V2.31884L9.81671 2.31884V0ZM0.00122688 1.05964e-07H6.18386V2.31884H2.32007V6.18358H0.00122688V1.05964e-07ZM2.31884 9.81614L2.31978 13.6812H6.18386V16H0.00150991L0 9.81671L2.31884 9.81614ZM16 9.81614L16.0015 16H9.81671V13.6812H13.6821L13.6812 9.81671L16 9.81614Z" fill="#454545"/></svg></button> <button title="Exit Full Screen" class="code-window__action-button code-window__action-button--exit-full-screen js-exit-full-screen-code-example-modal"><svg width="16" height="16" viewbox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M15.9653 3.47851V5.56547H10.4012L10.3998 0.000508881L12.4868 0L12.4877 3.47851H15.9653Z" fill="#53B78E"/><path d="M15.9653 12.4869V10.3999H10.4012L10.3998 15.965L12.4868 15.9655L12.4877 12.4869H15.9653Z" fill="#53B78E"/><path d="M0 12.4869L1.82446e-07 10.3999H5.56411L5.56547 15.965L3.47852 15.9655L3.47766 12.4869H0Z" fill="#53B78E"/><path d="M1.82447e-07 3.47851L0 5.56547H5.56411L5.56547 0.000509063L3.47852 0L3.47766 3.47851H1.82447e-07Z" fill="#53B78E"/></svg></button></div><pre class="prettyprint linenums lang-cs"><code>//Save spreadsheet workbook.SaveAs("NewExcelFile.xlsx");</code></pre><pre class="prettyprint linenums lang-vb"><code>'Save spreadsheet&#13; workbook.SaveAs("NewExcelFile.xlsx")</code></pre></div><div class="code_window_bottom"><span class="language_selection"><span class="ls-span">VB </span> <span><label class="switch"><input type="checkbox" checked="checked"/> <span class="slider round"/></label> </span><span class="ls-span">C#</span></span></div></div></div><h3 id="anchor-4-2-new-excel-workbook-and-sheet-using-aspose-cells">4.2. New Excel Workbook and Sheet using Aspose.Cells</h3><p>Before creating a spreadsheet and its content, a license object must be created to avoid the evaluation limitations if a licensed version was purchased. The code goes as follows:</p><pre class="naked-code"><code class="language-cs">// Create a License object License license = new License(); // Set the license of Aspose.Cells to avoid the evaluation limitations license.SetLicense(dataDir + "Aspose.Cells.lic");</code></pre><div class="code-content code-content-inner"><div class="code_window"><div class="language-selection__content-page-wrapper"/><div class="code_window_content"><div class="code-window__action-buttons-wrapper code-window__action-buttons-wrapper--content-page"><button title="Click to copy" class="code-window__action-button code-window__action-button--copy copy-clipboard" data-clipboard-id="code-explorer" data-placement="bottom"><svg width="16" height="16" viewbox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M9.53515 14.5295C4.88236 14.5295 6.83966 14.5295 2.05009 14.5295V4.55504H3.19663V3.0849H1.75902C1.06465 3.0849 0.5 3.6106 0.5 4.25687V14.8277C0.5 15.475 1.06351 15.9999 1.75871 15.9999C3.47852 15.9999 6.7062 15.9999 9.82653 15.9999C10.5217 15.9999 11.0852 15.4752 11.0852 14.8277C11.0852 14.7177 11.0852 14.6188 11.0852 14.515H9.53512L9.53515 14.5295Z" fill="white"/><path d="M15.2833 2.19563L13.1418 0.201276C13.0019 0.0710973 12.816 0 12.6191 0H6.17382C5.47944 0 4.91479 0.525728 4.91479 1.17225V11.7428C4.91479 12.3901 5.4783 12.9151 6.17382 12.9151C7.89332 12.9151 11.121 12.9151 14.2413 12.9151C14.9365 12.9151 15.5 12.3904 15.5 11.7428C15.5 4.94324 15.5 9.65683 15.5 2.68229C15.5 2.49846 15.4232 2.32552 15.2833 2.19563ZM13.9499 11.4449C9.29688 11.4449 11.2544 11.4449 6.46464 11.4449V1.47043H11.6697V2.75988C11.6697 3.21946 12.071 3.59339 12.5645 3.59339H13.9499V11.4449Z" fill="white"/></svg></button> <button title="Full Screen Mode" class="code-window__action-button code-window__action-button--full-screen js-full-screen-code-example-modal"><svg width="17" height="16" viewbox="0 0 17 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" clip-rule="evenodd" d="M9.81671 0L16.0012 7.41747e-07V6.18358H13.6824V2.31884L9.81671 2.31884V0ZM0.00122688 1.05964e-07H6.18386V2.31884H2.32007V6.18358H0.00122688V1.05964e-07ZM2.31884 9.81614L2.31978 13.6812H6.18386V16H0.00150991L0 9.81671L2.31884 9.81614ZM16 9.81614L16.0015 16H9.81671V13.6812H13.6821L13.6812 9.81671L16 9.81614Z" fill="#454545"/></svg></button> <button title="Exit Full Screen" class="code-window__action-button code-window__action-button--exit-full-screen js-exit-full-screen-code-example-modal"><svg width="16" height="16" viewbox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M15.9653 3.47851V5.56547H10.4012L10.3998 0.000508881L12.4868 0L12.4877 3.47851H15.9653Z" fill="#53B78E"/><path d="M15.9653 12.4869V10.3999H10.4012L10.3998 15.965L12.4868 15.9655L12.4877 12.4869H15.9653Z" fill="#53B78E"/><path d="M0 12.4869L1.82446e-07 10.3999H5.56411L5.56547 15.965L3.47852 15.9655L3.47766 12.4869H0Z" fill="#53B78E"/><path d="M1.82447e-07 3.47851L0 5.56547H5.56411L5.56547 0.000509063L3.47852 0L3.47766 3.47851H1.82447e-07Z" fill="#53B78E"/></svg></button></div><pre class="prettyprint linenums lang-cs"><code>// Create a License object License license = new License(); // Set the license of Aspose.Cells to avoid the evaluation limitations license.SetLicense(dataDir + "Aspose.Cells.lic");</code></pre><pre class="prettyprint linenums lang-vb"><code>' Create a License object&#13; Dim license As New License()&#13; ' Set the license of Aspose.Cells to avoid the evaluation limitations&#13; license.SetLicense(dataDir &amp; "Aspose.Cells.lic")</code></pre></div><div class="code_window_bottom"><span class="language_selection"><span class="ls-span">VB </span> <span><label class="switch"><input type="checkbox" checked="checked"/> <span class="slider round"/></label> </span><span class="ls-span">C#</span></span></div></div></div><p>Next, lets have a look at the code to create a workbook and worksheet. The code sample goes as follows:</p><pre class="naked-code"><code class="language-cs">// Instantiate a Workbook object that represents Excel file. Workbook wb = new Workbook(); // When you create a new workbook, a default "Sheet1" is added to the workbook. Worksheet sheet = wb.Worksheets[0];</code></pre><div class="code-content code-content-inner"><div class="code_window"><div class="language-selection__content-page-wrapper"/><div class="code_window_content"><div class="code-window__action-buttons-wrapper code-window__action-buttons-wrapper--content-page"><button title="Click to copy" class="code-window__action-button code-window__action-button--copy copy-clipboard" data-clipboard-id="code-explorer" data-placement="bottom"><svg width="16" height="16" viewbox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M9.53515 14.5295C4.88236 14.5295 6.83966 14.5295 2.05009 14.5295V4.55504H3.19663V3.0849H1.75902C1.06465 3.0849 0.5 3.6106 0.5 4.25687V14.8277C0.5 15.475 1.06351 15.9999 1.75871 15.9999C3.47852 15.9999 6.7062 15.9999 9.82653 15.9999C10.5217 15.9999 11.0852 15.4752 11.0852 14.8277C11.0852 14.7177 11.0852 14.6188 11.0852 14.515H9.53512L9.53515 14.5295Z" fill="white"/><path d="M15.2833 2.19563L13.1418 0.201276C13.0019 0.0710973 12.816 0 12.6191 0H6.17382C5.47944 0 4.91479 0.525728 4.91479 1.17225V11.7428C4.91479 12.3901 5.4783 12.9151 6.17382 12.9151C7.89332 12.9151 11.121 12.9151 14.2413 12.9151C14.9365 12.9151 15.5 12.3904 15.5 11.7428C15.5 4.94324 15.5 9.65683 15.5 2.68229C15.5 2.49846 15.4232 2.32552 15.2833 2.19563ZM13.9499 11.4449C9.29688 11.4449 11.2544 11.4449 6.46464 11.4449V1.47043H11.6697V2.75988C11.6697 3.21946 12.071 3.59339 12.5645 3.59339H13.9499V11.4449Z" fill="white"/></svg></button> <button title="Full Screen Mode" class="code-window__action-button code-window__action-button--full-screen js-full-screen-code-example-modal"><svg width="17" height="16" viewbox="0 0 17 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" clip-rule="evenodd" d="M9.81671 0L16.0012 7.41747e-07V6.18358H13.6824V2.31884L9.81671 2.31884V0ZM0.00122688 1.05964e-07H6.18386V2.31884H2.32007V6.18358H0.00122688V1.05964e-07ZM2.31884 9.81614L2.31978 13.6812H6.18386V16H0.00150991L0 9.81671L2.31884 9.81614ZM16 9.81614L16.0015 16H9.81671V13.6812H13.6821L13.6812 9.81671L16 9.81614Z" fill="#454545"/></svg></button> <button title="Exit Full Screen" class="code-window__action-button code-window__action-button--exit-full-screen js-exit-full-screen-code-example-modal"><svg width="16" height="16" viewbox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M15.9653 3.47851V5.56547H10.4012L10.3998 0.000508881L12.4868 0L12.4877 3.47851H15.9653Z" fill="#53B78E"/><path d="M15.9653 12.4869V10.3999H10.4012L10.3998 15.965L12.4868 15.9655L12.4877 12.4869H15.9653Z" fill="#53B78E"/><path d="M0 12.4869L1.82446e-07 10.3999H5.56411L5.56547 15.965L3.47852 15.9655L3.47766 12.4869H0Z" fill="#53B78E"/><path d="M1.82447e-07 3.47851L0 5.56547H5.56411L5.56547 0.000509063L3.47852 0L3.47766 3.47851H1.82447e-07Z" fill="#53B78E"/></svg></button></div><pre class="prettyprint linenums lang-cs"><code>// Instantiate a Workbook object that represents Excel file. Workbook wb = new Workbook(); // When you create a new workbook, a default "Sheet1" is added to the workbook. Worksheet sheet = wb.Worksheets[0];</code></pre><pre class="prettyprint linenums lang-vb"><code>' Instantiate a Workbook object that represents Excel file.&#13; Dim wb As New Workbook()&#13; ' When you create a new workbook, a default "Sheet1" is added to the workbook.&#13; Dim sheet As Worksheet = wb.Worksheets(0)</code></pre></div><div class="code_window_bottom"><span class="language_selection"><span class="ls-span">VB </span> <span><label class="switch"><input type="checkbox" checked="checked"/> <span class="slider round"/></label> </span><span class="ls-span">C#</span></span></div></div></div><p>Save Excel files:</p><pre class="naked-code"><code class="language-cs">//Save spreadsheet wb.Save("NewExcelFile.xlsx");</code></pre><div class="code-content code-content-inner"><div class="code_window"><div class="language-selection__content-page-wrapper"/><div class="code_window_content"><div class="code-window__action-buttons-wrapper code-window__action-buttons-wrapper--content-page"><button title="Click to copy" class="code-window__action-button code-window__action-button--copy copy-clipboard" data-clipboard-id="code-explorer" data-placement="bottom"><svg width="16" height="16" viewbox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M9.53515 14.5295C4.88236 14.5295 6.83966 14.5295 2.05009 14.5295V4.55504H3.19663V3.0849H1.75902C1.06465 3.0849 0.5 3.6106 0.5 4.25687V14.8277C0.5 15.475 1.06351 15.9999 1.75871 15.9999C3.47852 15.9999 6.7062 15.9999 9.82653 15.9999C10.5217 15.9999 11.0852 15.4752 11.0852 14.8277C11.0852 14.7177 11.0852 14.6188 11.0852 14.515H9.53512L9.53515 14.5295Z" fill="white"/><path d="M15.2833 2.19563L13.1418 0.201276C13.0019 0.0710973 12.816 0 12.6191 0H6.17382C5.47944 0 4.91479 0.525728 4.91479 1.17225V11.7428C4.91479 12.3901 5.4783 12.9151 6.17382 12.9151C7.89332 12.9151 11.121 12.9151 14.2413 12.9151C14.9365 12.9151 15.5 12.3904 15.5 11.7428C15.5 4.94324 15.5 9.65683 15.5 2.68229C15.5 2.49846 15.4232 2.32552 15.2833 2.19563ZM13.9499 11.4449C9.29688 11.4449 11.2544 11.4449 6.46464 11.4449V1.47043H11.6697V2.75988C11.6697 3.21946 12.071 3.59339 12.5645 3.59339H13.9499V11.4449Z" fill="white"/></svg></button> <button title="Full Screen Mode" class="code-window__action-button code-window__action-button--full-screen js-full-screen-code-example-modal"><svg width="17" height="16" viewbox="0 0 17 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" clip-rule="evenodd" d="M9.81671 0L16.0012 7.41747e-07V6.18358H13.6824V2.31884L9.81671 2.31884V0ZM0.00122688 1.05964e-07H6.18386V2.31884H2.32007V6.18358H0.00122688V1.05964e-07ZM2.31884 9.81614L2.31978 13.6812H6.18386V16H0.00150991L0 9.81671L2.31884 9.81614ZM16 9.81614L16.0015 16H9.81671V13.6812H13.6821L13.6812 9.81671L16 9.81614Z" fill="#454545"/></svg></button> <button title="Exit Full Screen" class="code-window__action-button code-window__action-button--exit-full-screen js-exit-full-screen-code-example-modal"><svg width="16" height="16" viewbox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M15.9653 3.47851V5.56547H10.4012L10.3998 0.000508881L12.4868 0L12.4877 3.47851H15.9653Z" fill="#53B78E"/><path d="M15.9653 12.4869V10.3999H10.4012L10.3998 15.965L12.4868 15.9655L12.4877 12.4869H15.9653Z" fill="#53B78E"/><path d="M0 12.4869L1.82446e-07 10.3999H5.56411L5.56547 15.965L3.47852 15.9655L3.47766 12.4869H0Z" fill="#53B78E"/><path d="M1.82447e-07 3.47851L0 5.56547H5.56411L5.56547 0.000509063L3.47852 0L3.47766 3.47851H1.82447e-07Z" fill="#53B78E"/></svg></button></div><pre class="prettyprint linenums lang-cs"><code>//Save spreadsheet wb.Save("NewExcelFile.xlsx");</code></pre><pre class="prettyprint linenums lang-vb"><code>'Save spreadsheet&#13; wb.Save("NewExcelFile.xlsx")</code></pre></div><div class="code_window_bottom"><span class="language_selection"><span class="ls-span">VB </span> <span><label class="switch"><input type="checkbox" checked="checked"/> <span class="slider round"/></label> </span><span class="ls-span">C#</span></span></div></div></div><h2 id="anchor-5-read-excel-files">5. Read Excel Files</h2><p>Both the libraries can open and read existing Excel documents. Let's have a look at the sample code.</p><h3 id="anchor-5-1-read-excel-files-using-ironxl">5.1. Read Excel Files using IronXL</h3><p>The IronXL WorkBook class represents an Excel sheet. To open an Excel file using C#, we use WorkBook.Load and specify the path of the Excel file (.xlsx). The following one-line code is used to open the file for reading:</p><pre class="naked-code"><code class="language-cs">//Load WorkBook var workbook = WorkBook.Load(@"Spreadsheets\\sample.xlsx");</code></pre><div class="code-content code-content-inner"><div class="code_window"><div class="language-selection__content-page-wrapper"/><div class="code_window_content"><div class="code-window__action-buttons-wrapper code-window__action-buttons-wrapper--content-page"><button title="Click to copy" class="code-window__action-button code-window__action-button--copy copy-clipboard" data-clipboard-id="code-explorer" data-placement="bottom"><svg width="16" height="16" viewbox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M9.53515 14.5295C4.88236 14.5295 6.83966 14.5295 2.05009 14.5295V4.55504H3.19663V3.0849H1.75902C1.06465 3.0849 0.5 3.6106 0.5 4.25687V14.8277C0.5 15.475 1.06351 15.9999 1.75871 15.9999C3.47852 15.9999 6.7062 15.9999 9.82653 15.9999C10.5217 15.9999 11.0852 15.4752 11.0852 14.8277C11.0852 14.7177 11.0852 14.6188 11.0852 14.515H9.53512L9.53515 14.5295Z" fill="white"/><path d="M15.2833 2.19563L13.1418 0.201276C13.0019 0.0710973 12.816 0 12.6191 0H6.17382C5.47944 0 4.91479 0.525728 4.91479 1.17225V11.7428C4.91479 12.3901 5.4783 12.9151 6.17382 12.9151C7.89332 12.9151 11.121 12.9151 14.2413 12.9151C14.9365 12.9151 15.5 12.3904 15.5 11.7428C15.5 4.94324 15.5 9.65683 15.5 2.68229C15.5 2.49846 15.4232 2.32552 15.2833 2.19563ZM13.9499 11.4449C9.29688 11.4449 11.2544 11.4449 6.46464 11.4449V1.47043H11.6697V2.75988C11.6697 3.21946 12.071 3.59339 12.5645 3.59339H13.9499V11.4449Z" fill="white"/></svg></button> <button title="Full Screen Mode" class="code-window__action-button code-window__action-button--full-screen js-full-screen-code-example-modal"><svg width="17" height="16" viewbox="0 0 17 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" clip-rule="evenodd" d="M9.81671 0L16.0012 7.41747e-07V6.18358H13.6824V2.31884L9.81671 2.31884V0ZM0.00122688 1.05964e-07H6.18386V2.31884H2.32007V6.18358H0.00122688V1.05964e-07ZM2.31884 9.81614L2.31978 13.6812H6.18386V16H0.00150991L0 9.81671L2.31884 9.81614ZM16 9.81614L16.0015 16H9.81671V13.6812H13.6821L13.6812 9.81671L16 9.81614Z" fill="#454545"/></svg></button> <button title="Exit Full Screen" class="code-window__action-button code-window__action-button--exit-full-screen js-exit-full-screen-code-example-modal"><svg width="16" height="16" viewbox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M15.9653 3.47851V5.56547H10.4012L10.3998 0.000508881L12.4868 0L12.4877 3.47851H15.9653Z" fill="#53B78E"/><path d="M15.9653 12.4869V10.3999H10.4012L10.3998 15.965L12.4868 15.9655L12.4877 12.4869H15.9653Z" fill="#53B78E"/><path d="M0 12.4869L1.82446e-07 10.3999H5.56411L5.56547 15.965L3.47852 15.9655L3.47766 12.4869H0Z" fill="#53B78E"/><path d="M1.82447e-07 3.47851L0 5.56547H5.56411L5.56547 0.000509063L3.47852 0L3.47766 3.47851H1.82447e-07Z" fill="#53B78E"/></svg></button></div><pre class="prettyprint linenums lang-cs"><code>//Load WorkBook var workbook = WorkBook.Load(@"Spreadsheets\\sample.xlsx");</code></pre><pre class="prettyprint linenums lang-vb"><code>'Load WorkBook&#13; Dim workbook = WorkBook.Load("Spreadsheets\\sample.xlsx")</code></pre></div><div class="code_window_bottom"><span class="language_selection"><span class="ls-span">VB </span> <span><label class="switch"><input type="checkbox" checked="checked"/> <span class="slider round"/></label> </span><span class="ls-span">C#</span></span></div></div></div><p>Each WorkBook can have multiple WorkSheet objects. These represent worksheets in the Excel document. If the workbook contains worksheets, retrieve them by name as follows:</p><pre class="naked-code"><code class="language-cs">//Open Sheet for reading var worksheet = workbook.GetWorkSheet("sheetnamegoeshere");</code></pre><div class="code-content code-content-inner"><div class="code_window"><div class="language-selection__content-page-wrapper"/><div class="code_window_content"><div class="code-window__action-buttons-wrapper code-window__action-buttons-wrapper--content-page"><button title="Click to copy" class="code-window__action-button code-window__action-button--copy copy-clipboard" data-clipboard-id="code-explorer" data-placement="bottom"><svg width="16" height="16" viewbox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M9.53515 14.5295C4.88236 14.5295 6.83966 14.5295 2.05009 14.5295V4.55504H3.19663V3.0849H1.75902C1.06465 3.0849 0.5 3.6106 0.5 4.25687V14.8277C0.5 15.475 1.06351 15.9999 1.75871 15.9999C3.47852 15.9999 6.7062 15.9999 9.82653 15.9999C10.5217 15.9999 11.0852 15.4752 11.0852 14.8277C11.0852 14.7177 11.0852 14.6188 11.0852 14.515H9.53512L9.53515 14.5295Z" fill="white"/><path d="M15.2833 2.19563L13.1418 0.201276C13.0019 0.0710973 12.816 0 12.6191 0H6.17382C5.47944 0 4.91479 0.525728 4.91479 1.17225V11.7428C4.91479 12.3901 5.4783 12.9151 6.17382 12.9151C7.89332 12.9151 11.121 12.9151 14.2413 12.9151C14.9365 12.9151 15.5 12.3904 15.5 11.7428C15.5 4.94324 15.5 9.65683 15.5 2.68229C15.5 2.49846 15.4232 2.32552 15.2833 2.19563ZM13.9499 11.4449C9.29688 11.4449 11.2544 11.4449 6.46464 11.4449V1.47043H11.6697V2.75988C11.6697 3.21946 12.071 3.59339 12.5645 3.59339H13.9499V11.4449Z" fill="white"/></svg></button> <button title="Full Screen Mode" class="code-window__action-button code-window__action-button--full-screen js-full-screen-code-example-modal"><svg width="17" height="16" viewbox="0 0 17 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" clip-rule="evenodd" d="M9.81671 0L16.0012 7.41747e-07V6.18358H13.6824V2.31884L9.81671 2.31884V0ZM0.00122688 1.05964e-07H6.18386V2.31884H2.32007V6.18358H0.00122688V1.05964e-07ZM2.31884 9.81614L2.31978 13.6812H6.18386V16H0.00150991L0 9.81671L2.31884 9.81614ZM16 9.81614L16.0015 16H9.81671V13.6812H13.6821L13.6812 9.81671L16 9.81614Z" fill="#454545"/></svg></button> <button title="Exit Full Screen" class="code-window__action-button code-window__action-button--exit-full-screen js-exit-full-screen-code-example-modal"><svg width="16" height="16" viewbox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M15.9653 3.47851V5.56547H10.4012L10.3998 0.000508881L12.4868 0L12.4877 3.47851H15.9653Z" fill="#53B78E"/><path d="M15.9653 12.4869V10.3999H10.4012L10.3998 15.965L12.4868 15.9655L12.4877 12.4869H15.9653Z" fill="#53B78E"/><path d="M0 12.4869L1.82446e-07 10.3999H5.56411L5.56547 15.965L3.47852 15.9655L3.47766 12.4869H0Z" fill="#53B78E"/><path d="M1.82447e-07 3.47851L0 5.56547H5.56411L5.56547 0.000509063L3.47852 0L3.47766 3.47851H1.82447e-07Z" fill="#53B78E"/></svg></button></div><pre class="prettyprint linenums lang-cs"><code>//Open Sheet for reading var worksheet = workbook.GetWorkSheet("sheetnamegoeshere");</code></pre><pre class="prettyprint linenums lang-vb"><code>'Open Sheet for reading&#13; Dim worksheet = workbook.GetWorkSheet("sheetnamegoeshere")</code></pre></div><div class="code_window_bottom"><span class="language_selection"><span class="ls-span">VB </span> <span><label class="switch"><input type="checkbox" checked="checked"/> <span class="slider round"/></label> </span><span class="ls-span">C#</span></span></div></div></div><p>Code for reading the cell values:</p><pre class="naked-code"><code class="language-cs">// Read from Ranges of cells elegantly. foreach (var cell in worksheet["A2:A10"]) Console.WriteLine("Cell {0} has value '{1}'", cell.AddressString, cell.Text); }</code></pre><div class="code-content code-content-inner"><div class="code_window"><div class="language-selection__content-page-wrapper"/><div class="code_window_content"><div class="code-window__action-buttons-wrapper code-window__action-buttons-wrapper--content-page"><button title="Click to copy" class="code-window__action-button code-window__action-button--copy copy-clipboard" data-clipboard-id="code-explorer" data-placement="bottom"><svg width="16" height="16" viewbox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M9.53515 14.5295C4.88236 14.5295 6.83966 14.5295 2.05009 14.5295V4.55504H3.19663V3.0849H1.75902C1.06465 3.0849 0.5 3.6106 0.5 4.25687V14.8277C0.5 15.475 1.06351 15.9999 1.75871 15.9999C3.47852 15.9999 6.7062 15.9999 9.82653 15.9999C10.5217 15.9999 11.0852 15.4752 11.0852 14.8277C11.0852 14.7177 11.0852 14.6188 11.0852 14.515H9.53512L9.53515 14.5295Z" fill="white"/><path d="M15.2833 2.19563L13.1418 0.201276C13.0019 0.0710973 12.816 0 12.6191 0H6.17382C5.47944 0 4.91479 0.525728 4.91479 1.17225V11.7428C4.91479 12.3901 5.4783 12.9151 6.17382 12.9151C7.89332 12.9151 11.121 12.9151 14.2413 12.9151C14.9365 12.9151 15.5 12.3904 15.5 11.7428C15.5 4.94324 15.5 9.65683 15.5 2.68229C15.5 2.49846 15.4232 2.32552 15.2833 2.19563ZM13.9499 11.4449C9.29688 11.4449 11.2544 11.4449 6.46464 11.4449V1.47043H11.6697V2.75988C11.6697 3.21946 12.071 3.59339 12.5645 3.59339H13.9499V11.4449Z" fill="white"/></svg></button> <button title="Full Screen Mode" class="code-window__action-button code-window__action-button--full-screen js-full-screen-code-example-modal"><svg width="17" height="16" viewbox="0 0 17 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" clip-rule="evenodd" d="M9.81671 0L16.0012 7.41747e-07V6.18358H13.6824V2.31884L9.81671 2.31884V0ZM0.00122688 1.05964e-07H6.18386V2.31884H2.32007V6.18358H0.00122688V1.05964e-07ZM2.31884 9.81614L2.31978 13.6812H6.18386V16H0.00150991L0 9.81671L2.31884 9.81614ZM16 9.81614L16.0015 16H9.81671V13.6812H13.6821L13.6812 9.81671L16 9.81614Z" fill="#454545"/></svg></button> <button title="Exit Full Screen" class="code-window__action-button code-window__action-button--exit-full-screen js-exit-full-screen-code-example-modal"><svg width="16" height="16" viewbox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M15.9653 3.47851V5.56547H10.4012L10.3998 0.000508881L12.4868 0L12.4877 3.47851H15.9653Z" fill="#53B78E"/><path d="M15.9653 12.4869V10.3999H10.4012L10.3998 15.965L12.4868 15.9655L12.4877 12.4869H15.9653Z" fill="#53B78E"/><path d="M0 12.4869L1.82446e-07 10.3999H5.56411L5.56547 15.965L3.47852 15.9655L3.47766 12.4869H0Z" fill="#53B78E"/><path d="M1.82447e-07 3.47851L0 5.56547H5.56411L5.56547 0.000509063L3.47852 0L3.47766 3.47851H1.82447e-07Z" fill="#53B78E"/></svg></button></div><pre class="prettyprint linenums lang-cs"><code>// Read from Ranges of cells elegantly. foreach (var cell in worksheet["A2:A10"]) Console.WriteLine("Cell {0} has value '{1}'", cell.AddressString, cell.Text); }</code></pre><pre class="prettyprint linenums lang-vb"><code>' Read from Ranges of cells elegantly.&#13; For Each cell In worksheet("A2:A10")&#13; Console.WriteLine("Cell {0} has value '{1}'", cell.AddressString, cell.Text)&#13; Next cell</code></pre></div><div class="code_window_bottom"><span class="language_selection"><span class="ls-span">VB </span> <span><label class="switch"><input type="checkbox" checked="checked"/> <span class="slider round"/></label> </span><span class="ls-span">C#</span></span></div></div></div><h3 id="anchor-5-2-read-excel-files-using-aspose-cells">5.2. Read Excel Files using Aspose.Cells</h3><p>Reading Excel files in Aspose cells is also a straightforward task, as it can manage multiple worksheets easily. Take a look at the code below:</p><pre class="naked-code"><code class="language-cs">// Creating a Workbook object and opening an Excel file using its file path var workbook = new Workbook(@"Spreadsheets\\sample.xlsx"); //Adding new sheet Worksheet sheet = workbook1.Worksheets.Add("MySheet");</code></pre><div class="code-content code-content-inner"><div class="code_window"><div class="language-selection__content-page-wrapper"/><div class="code_window_content"><div class="code-window__action-buttons-wrapper code-window__action-buttons-wrapper--content-page"><button title="Click to copy" class="code-window__action-button code-window__action-button--copy copy-clipboard" data-clipboard-id="code-explorer" data-placement="bottom"><svg width="16" height="16" viewbox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M9.53515 14.5295C4.88236 14.5295 6.83966 14.5295 2.05009 14.5295V4.55504H3.19663V3.0849H1.75902C1.06465 3.0849 0.5 3.6106 0.5 4.25687V14.8277C0.5 15.475 1.06351 15.9999 1.75871 15.9999C3.47852 15.9999 6.7062 15.9999 9.82653 15.9999C10.5217 15.9999 11.0852 15.4752 11.0852 14.8277C11.0852 14.7177 11.0852 14.6188 11.0852 14.515H9.53512L9.53515 14.5295Z" fill="white"/><path d="M15.2833 2.19563L13.1418 0.201276C13.0019 0.0710973 12.816 0 12.6191 0H6.17382C5.47944 0 4.91479 0.525728 4.91479 1.17225V11.7428C4.91479 12.3901 5.4783 12.9151 6.17382 12.9151C7.89332 12.9151 11.121 12.9151 14.2413 12.9151C14.9365 12.9151 15.5 12.3904 15.5 11.7428C15.5 4.94324 15.5 9.65683 15.5 2.68229C15.5 2.49846 15.4232 2.32552 15.2833 2.19563ZM13.9499 11.4449C9.29688 11.4449 11.2544 11.4449 6.46464 11.4449V1.47043H11.6697V2.75988C11.6697 3.21946 12.071 3.59339 12.5645 3.59339H13.9499V11.4449Z" fill="white"/></svg></button> <button title="Full Screen Mode" class="code-window__action-button code-window__action-button--full-screen js-full-screen-code-example-modal"><svg width="17" height="16" viewbox="0 0 17 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" clip-rule="evenodd" d="M9.81671 0L16.0012 7.41747e-07V6.18358H13.6824V2.31884L9.81671 2.31884V0ZM0.00122688 1.05964e-07H6.18386V2.31884H2.32007V6.18358H0.00122688V1.05964e-07ZM2.31884 9.81614L2.31978 13.6812H6.18386V16H0.00150991L0 9.81671L2.31884 9.81614ZM16 9.81614L16.0015 16H9.81671V13.6812H13.6821L13.6812 9.81671L16 9.81614Z" fill="#454545"/></svg></button> <button title="Exit Full Screen" class="code-window__action-button code-window__action-button--exit-full-screen js-exit-full-screen-code-example-modal"><svg width="16" height="16" viewbox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M15.9653 3.47851V5.56547H10.4012L10.3998 0.000508881L12.4868 0L12.4877 3.47851H15.9653Z" fill="#53B78E"/><path d="M15.9653 12.4869V10.3999H10.4012L10.3998 15.965L12.4868 15.9655L12.4877 12.4869H15.9653Z" fill="#53B78E"/><path d="M0 12.4869L1.82446e-07 10.3999H5.56411L5.56547 15.965L3.47852 15.9655L3.47766 12.4869H0Z" fill="#53B78E"/><path d="M1.82447e-07 3.47851L0 5.56547H5.56411L5.56547 0.000509063L3.47852 0L3.47766 3.47851H1.82447e-07Z" fill="#53B78E"/></svg></button></div><pre class="prettyprint linenums lang-cs"><code>// Creating a Workbook object and opening an Excel file using its file path var workbook = new Workbook(@"Spreadsheets\\sample.xlsx"); //Adding new sheet Worksheet sheet = workbook1.Worksheets.Add("MySheet");</code></pre><pre class="prettyprint linenums lang-vb"><code>' Creating a Workbook object and opening an Excel file using its file path&#13; Dim workbook As New Workbook("Spreadsheets\\sample.xlsx")&#13; 'Adding new sheet&#13; Dim sheet As Worksheet = workbook1.Worksheets.Add("MySheet")</code></pre></div><div class="code_window_bottom"><span class="language_selection"><span class="ls-span">VB </span> <span><label class="switch"><input type="checkbox" checked="checked"/> <span class="slider round"/></label> </span><span class="ls-span">C#</span></span></div></div></div><p>The code for reading cell values:</p><pre class="naked-code"><code class="language-cs">//Get Cells Cells cells = sheet.Cells; foreach (var cell in cells) Console.WriteLine(cell.Value); }</code></pre><div class="code-content code-content-inner"><div class="code_window"><div class="language-selection__content-page-wrapper"/><div class="code_window_content"><div class="code-window__action-buttons-wrapper code-window__action-buttons-wrapper--content-page"><button title="Click to copy" class="code-window__action-button code-window__action-button--copy copy-clipboard" data-clipboard-id="code-explorer" data-placement="bottom"><svg width="16" height="16" viewbox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M9.53515 14.5295C4.88236 14.5295 6.83966 14.5295 2.05009 14.5295V4.55504H3.19663V3.0849H1.75902C1.06465 3.0849 0.5 3.6106 0.5 4.25687V14.8277C0.5 15.475 1.06351 15.9999 1.75871 15.9999C3.47852 15.9999 6.7062 15.9999 9.82653 15.9999C10.5217 15.9999 11.0852 15.4752 11.0852 14.8277C11.0852 14.7177 11.0852 14.6188 11.0852 14.515H9.53512L9.53515 14.5295Z" fill="white"/><path d="M15.2833 2.19563L13.1418 0.201276C13.0019 0.0710973 12.816 0 12.6191 0H6.17382C5.47944 0 4.91479 0.525728 4.91479 1.17225V11.7428C4.91479 12.3901 5.4783 12.9151 6.17382 12.9151C7.89332 12.9151 11.121 12.9151 14.2413 12.9151C14.9365 12.9151 15.5 12.3904 15.5 11.7428C15.5 4.94324 15.5 9.65683 15.5 2.68229C15.5 2.49846 15.4232 2.32552 15.2833 2.19563ZM13.9499 11.4449C9.29688 11.4449 11.2544 11.4449 6.46464 11.4449V1.47043H11.6697V2.75988C11.6697 3.21946 12.071 3.59339 12.5645 3.59339H13.9499V11.4449Z" fill="white"/></svg></button> <button title="Full Screen Mode" class="code-window__action-button code-window__action-button--full-screen js-full-screen-code-example-modal"><svg width="17" height="16" viewbox="0 0 17 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" clip-rule="evenodd" d="M9.81671 0L16.0012 7.41747e-07V6.18358H13.6824V2.31884L9.81671 2.31884V0ZM0.00122688 1.05964e-07H6.18386V2.31884H2.32007V6.18358H0.00122688V1.05964e-07ZM2.31884 9.81614L2.31978 13.6812H6.18386V16H0.00150991L0 9.81671L2.31884 9.81614ZM16 9.81614L16.0015 16H9.81671V13.6812H13.6821L13.6812 9.81671L16 9.81614Z" fill="#454545"/></svg></button> <button title="Exit Full Screen" class="code-window__action-button code-window__action-button--exit-full-screen js-exit-full-screen-code-example-modal"><svg width="16" height="16" viewbox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M15.9653 3.47851V5.56547H10.4012L10.3998 0.000508881L12.4868 0L12.4877 3.47851H15.9653Z" fill="#53B78E"/><path d="M15.9653 12.4869V10.3999H10.4012L10.3998 15.965L12.4868 15.9655L12.4877 12.4869H15.9653Z" fill="#53B78E"/><path d="M0 12.4869L1.82446e-07 10.3999H5.56411L5.56547 15.965L3.47852 15.9655L3.47766 12.4869H0Z" fill="#53B78E"/><path d="M1.82447e-07 3.47851L0 5.56547H5.56411L5.56547 0.000509063L3.47852 0L3.47766 3.47851H1.82447e-07Z" fill="#53B78E"/></svg></button></div><pre class="prettyprint linenums lang-cs"><code>//Get Cells Cells cells = sheet.Cells; foreach (var cell in cells) Console.WriteLine(cell.Value); }</code></pre><pre class="prettyprint linenums lang-vb"><code>'Get Cells&#13; Dim cells As Cells = sheet.Cells&#13; For Each cell In cells&#13; Console.WriteLine(cell.Value)&#13; Next cell</code></pre></div><div class="code_window_bottom"><span class="language_selection"><span class="ls-span">VB </span> <span><label class="switch"><input type="checkbox" checked="checked"/> <span class="slider round"/></label> </span><span class="ls-span">C#</span></span></div></div></div><h2 id="anchor-6-working-with-excel-formulas">6. Working with Excel Formulas</h2><p>Excel formulas are one of the most important features of working with Excel files. <code>Both the libraries have a powerful formula calculation engine.</code> They provide the facility to work with formulas and easily apply them to cells.</p><h3 id="anchor-6-1-working-with-excel-formulas-using-ironxl">6.1. Working with Excel Formulas using IronXL</h3><p>After loading the workbook and worksheet, the following code sample can be used to either make changes to formulas, or be applied to specific cells. The code goes as follows:</p><pre class="naked-code"><code class="language-cs">// Set Formulas worksheet["A1"].Formula = "Sum(B8:C12)"; worksheet["B8"].Formula = "=C9/C11"; worksheet["G30"].Formula = "Max(C3:C7)"; // Force recalculate all formula values in all sheets. workbook.EvaluateAll();</code></pre><div class="code-content code-content-inner"><div class="code_window"><div class="language-selection__content-page-wrapper"/><div class="code_window_content"><div class="code-window__action-buttons-wrapper code-window__action-buttons-wrapper--content-page"><button title="Click to copy" class="code-window__action-button code-window__action-button--copy copy-clipboard" data-clipboard-id="code-explorer" data-placement="bottom"><svg width="16" height="16" viewbox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M9.53515 14.5295C4.88236 14.5295 6.83966 14.5295 2.05009 14.5295V4.55504H3.19663V3.0849H1.75902C1.06465 3.0849 0.5 3.6106 0.5 4.25687V14.8277C0.5 15.475 1.06351 15.9999 1.75871 15.9999C3.47852 15.9999 6.7062 15.9999 9.82653 15.9999C10.5217 15.9999 11.0852 15.4752 11.0852 14.8277C11.0852 14.7177 11.0852 14.6188 11.0852 14.515H9.53512L9.53515 14.5295Z" fill="white"/><path d="M15.2833 2.19563L13.1418 0.201276C13.0019 0.0710973 12.816 0 12.6191 0H6.17382C5.47944 0 4.91479 0.525728 4.91479 1.17225V11.7428C4.91479 12.3901 5.4783 12.9151 6.17382 12.9151C7.89332 12.9151 11.121 12.9151 14.2413 12.9151C14.9365 12.9151 15.5 12.3904 15.5 11.7428C15.5 4.94324 15.5 9.65683 15.5 2.68229C15.5 2.49846 15.4232 2.32552 15.2833 2.19563ZM13.9499 11.4449C9.29688 11.4449 11.2544 11.4449 6.46464 11.4449V1.47043H11.6697V2.75988C11.6697 3.21946 12.071 3.59339 12.5645 3.59339H13.9499V11.4449Z" fill="white"/></svg></button> <button title="Full Screen Mode" class="code-window__action-button code-window__action-button--full-screen js-full-screen-code-example-modal"><svg width="17" height="16" viewbox="0 0 17 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" clip-rule="evenodd" d="M9.81671 0L16.0012 7.41747e-07V6.18358H13.6824V2.31884L9.81671 2.31884V0ZM0.00122688 1.05964e-07H6.18386V2.31884H2.32007V6.18358H0.00122688V1.05964e-07ZM2.31884 9.81614L2.31978 13.6812H6.18386V16H0.00150991L0 9.81671L2.31884 9.81614ZM16 9.81614L16.0015 16H9.81671V13.6812H13.6821L13.6812 9.81671L16 9.81614Z" fill="#454545"/></svg></button> <button title="Exit Full Screen" class="code-window__action-button code-window__action-button--exit-full-screen js-exit-full-screen-code-example-modal"><svg width="16" height="16" viewbox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M15.9653 3.47851V5.56547H10.4012L10.3998 0.000508881L12.4868 0L12.4877 3.47851H15.9653Z" fill="#53B78E"/><path d="M15.9653 12.4869V10.3999H10.4012L10.3998 15.965L12.4868 15.9655L12.4877 12.4869H15.9653Z" fill="#53B78E"/><path d="M0 12.4869L1.82446e-07 10.3999H5.56411L5.56547 15.965L3.47852 15.9655L3.47766 12.4869H0Z" fill="#53B78E"/><path d="M1.82447e-07 3.47851L0 5.56547H5.56411L5.56547 0.000509063L3.47852 0L3.47766 3.47851H1.82447e-07Z" fill="#53B78E"/></svg></button></div><pre class="prettyprint linenums lang-cs"><code>// Set Formulas worksheet["A1"].Formula = "Sum(B8:C12)"; worksheet["B8"].Formula = "=C9/C11"; worksheet["G30"].Formula = "Max(C3:C7)"; // Force recalculate all formula values in all sheets. workbook.EvaluateAll();</code></pre><pre class="prettyprint linenums lang-vb"><code>' Set Formulas&#13; worksheet("A1").Formula = "Sum(B8:C12)"&#13; worksheet("B8").Formula = "=C9/C11"&#13; worksheet("G30").Formula = "Max(C3:C7)"&#13; ' Force recalculate all formula values in all sheets. &#13; workbook.EvaluateAll()</code></pre></div><div class="code_window_bottom"><span class="language_selection"><span class="ls-span">VB </span> <span><label class="switch"><input type="checkbox" checked="checked"/> <span class="slider round"/></label> </span><span class="ls-span">C#</span></span></div></div></div><p>You can also retrieve formulas and their values:</p><pre class="naked-code"><code class="language-cs">// Get the formula's calculated value. e.g. "52" string formulaValue = worksheet["G30"].Value; //Get the formula as a string. e.g. "Max(C3:C7)" string formulaString = worksheet["G30"].Formula; //Save your changes with updated formulas and calculated values. workbook.Save();</code></pre><div class="code-content code-content-inner"><div class="code_window"><div class="language-selection__content-page-wrapper"/><div class="code_window_content"><div class="code-window__action-buttons-wrapper code-window__action-buttons-wrapper--content-page"><button title="Click to copy" class="code-window__action-button code-window__action-button--copy copy-clipboard" data-clipboard-id="code-explorer" data-placement="bottom"><svg width="16" height="16" viewbox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M9.53515 14.5295C4.88236 14.5295 6.83966 14.5295 2.05009 14.5295V4.55504H3.19663V3.0849H1.75902C1.06465 3.0849 0.5 3.6106 0.5 4.25687V14.8277C0.5 15.475 1.06351 15.9999 1.75871 15.9999C3.47852 15.9999 6.7062 15.9999 9.82653 15.9999C10.5217 15.9999 11.0852 15.4752 11.0852 14.8277C11.0852 14.7177 11.0852 14.6188 11.0852 14.515H9.53512L9.53515 14.5295Z" fill="white"/><path d="M15.2833 2.19563L13.1418 0.201276C13.0019 0.0710973 12.816 0 12.6191 0H6.17382C5.47944 0 4.91479 0.525728 4.91479 1.17225V11.7428C4.91479 12.3901 5.4783 12.9151 6.17382 12.9151C7.89332 12.9151 11.121 12.9151 14.2413 12.9151C14.9365 12.9151 15.5 12.3904 15.5 11.7428C15.5 4.94324 15.5 9.65683 15.5 2.68229C15.5 2.49846 15.4232 2.32552 15.2833 2.19563ZM13.9499 11.4449C9.29688 11.4449 11.2544 11.4449 6.46464 11.4449V1.47043H11.6697V2.75988C11.6697 3.21946 12.071 3.59339 12.5645 3.59339H13.9499V11.4449Z" fill="white"/></svg></button> <button title="Full Screen Mode" class="code-window__action-button code-window__action-button--full-screen js-full-screen-code-example-modal"><svg width="17" height="16" viewbox="0 0 17 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" clip-rule="evenodd" d="M9.81671 0L16.0012 7.41747e-07V6.18358H13.6824V2.31884L9.81671 2.31884V0ZM0.00122688 1.05964e-07H6.18386V2.31884H2.32007V6.18358H0.00122688V1.05964e-07ZM2.31884 9.81614L2.31978 13.6812H6.18386V16H0.00150991L0 9.81671L2.31884 9.81614ZM16 9.81614L16.0015 16H9.81671V13.6812H13.6821L13.6812 9.81671L16 9.81614Z" fill="#454545"/></svg></button> <button title="Exit Full Screen" class="code-window__action-button code-window__action-button--exit-full-screen js-exit-full-screen-code-example-modal"><svg width="16" height="16" viewbox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M15.9653 3.47851V5.56547H10.4012L10.3998 0.000508881L12.4868 0L12.4877 3.47851H15.9653Z" fill="#53B78E"/><path d="M15.9653 12.4869V10.3999H10.4012L10.3998 15.965L12.4868 15.9655L12.4877 12.4869H15.9653Z" fill="#53B78E"/><path d="M0 12.4869L1.82446e-07 10.3999H5.56411L5.56547 15.965L3.47852 15.9655L3.47766 12.4869H0Z" fill="#53B78E"/><path d="M1.82447e-07 3.47851L0 5.56547H5.56411L5.56547 0.000509063L3.47852 0L3.47766 3.47851H1.82447e-07Z" fill="#53B78E"/></svg></button></div><pre class="prettyprint linenums lang-cs"><code>// Get the formula's calculated value. e.g. "52" string formulaValue = worksheet["G30"].Value; //Get the formula as a string. e.g. "Max(C3:C7)" string formulaString = worksheet["G30"].Formula; //Save your changes with updated formulas and calculated values. workbook.Save();</code></pre><pre class="prettyprint linenums lang-vb"><code>' Get the formula's calculated value. e.g. "52"&#13; Dim formulaValue As String = worksheet("G30").Value&#13; 'Get the formula as a string. e.g. "Max(C3:C7)"&#13; Dim formulaString As String = worksheet("G30").Formula&#13; 'Save your changes with updated formulas and calculated values.&#13; workbook.Save()</code></pre></div><div class="code_window_bottom"><span class="language_selection"><span class="ls-span">VB </span> <span><label class="switch"><input type="checkbox" checked="checked"/> <span class="slider round"/></label> </span><span class="ls-span">C#</span></span></div></div></div><h3 id="anchor-6-2-working-with-excel-formulas-using-aspose-cells">6.2. Working with Excel Formulas using Aspose.Cells</h3><p>With Aspose.Cells it is also easy to work with formulas. Add the below code to the Excel file being read. The code goes as follows:</p><pre class="naked-code"><code class="language-cs">//Setting values Cells cells = sheet.Cells; //Setting formula cells["A4"].Formula = "=SUM(A1:A3)"; // Calculating the results of formulas workbook.CalculateFormula();</code></pre><div class="code-content code-content-inner"><div class="code_window"><div class="language-selection__content-page-wrapper"/><div class="code_window_content"><div class="code-window__action-buttons-wrapper code-window__action-buttons-wrapper--content-page"><button title="Click to copy" class="code-window__action-button code-window__action-button--copy copy-clipboard" data-clipboard-id="code-explorer" data-placement="bottom"><svg width="16" height="16" viewbox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M9.53515 14.5295C4.88236 14.5295 6.83966 14.5295 2.05009 14.5295V4.55504H3.19663V3.0849H1.75902C1.06465 3.0849 0.5 3.6106 0.5 4.25687V14.8277C0.5 15.475 1.06351 15.9999 1.75871 15.9999C3.47852 15.9999 6.7062 15.9999 9.82653 15.9999C10.5217 15.9999 11.0852 15.4752 11.0852 14.8277C11.0852 14.7177 11.0852 14.6188 11.0852 14.515H9.53512L9.53515 14.5295Z" fill="white"/><path d="M15.2833 2.19563L13.1418 0.201276C13.0019 0.0710973 12.816 0 12.6191 0H6.17382C5.47944 0 4.91479 0.525728 4.91479 1.17225V11.7428C4.91479 12.3901 5.4783 12.9151 6.17382 12.9151C7.89332 12.9151 11.121 12.9151 14.2413 12.9151C14.9365 12.9151 15.5 12.3904 15.5 11.7428C15.5 4.94324 15.5 9.65683 15.5 2.68229C15.5 2.49846 15.4232 2.32552 15.2833 2.19563ZM13.9499 11.4449C9.29688 11.4449 11.2544 11.4449 6.46464 11.4449V1.47043H11.6697V2.75988C11.6697 3.21946 12.071 3.59339 12.5645 3.59339H13.9499V11.4449Z" fill="white"/></svg></button> <button title="Full Screen Mode" class="code-window__action-button code-window__action-button--full-screen js-full-screen-code-example-modal"><svg width="17" height="16" viewbox="0 0 17 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" clip-rule="evenodd" d="M9.81671 0L16.0012 7.41747e-07V6.18358H13.6824V2.31884L9.81671 2.31884V0ZM0.00122688 1.05964e-07H6.18386V2.31884H2.32007V6.18358H0.00122688V1.05964e-07ZM2.31884 9.81614L2.31978 13.6812H6.18386V16H0.00150991L0 9.81671L2.31884 9.81614ZM16 9.81614L16.0015 16H9.81671V13.6812H13.6821L13.6812 9.81671L16 9.81614Z" fill="#454545"/></svg></button> <button title="Exit Full Screen" class="code-window__action-button code-window__action-button--exit-full-screen js-exit-full-screen-code-example-modal"><svg width="16" height="16" viewbox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M15.9653 3.47851V5.56547H10.4012L10.3998 0.000508881L12.4868 0L12.4877 3.47851H15.9653Z" fill="#53B78E"/><path d="M15.9653 12.4869V10.3999H10.4012L10.3998 15.965L12.4868 15.9655L12.4877 12.4869H15.9653Z" fill="#53B78E"/><path d="M0 12.4869L1.82446e-07 10.3999H5.56411L5.56547 15.965L3.47852 15.9655L3.47766 12.4869H0Z" fill="#53B78E"/><path d="M1.82447e-07 3.47851L0 5.56547H5.56411L5.56547 0.000509063L3.47852 0L3.47766 3.47851H1.82447e-07Z" fill="#53B78E"/></svg></button></div><pre class="prettyprint linenums lang-cs"><code>//Setting values Cells cells = sheet.Cells; //Setting formula cells["A4"].Formula = "=SUM(A1:A3)"; // Calculating the results of formulas workbook.CalculateFormula();</code></pre><pre class="prettyprint linenums lang-vb"><code>'Setting values&#13; Dim cells As Cells = sheet.Cells&#13; 'Setting formula&#13; cells("A4").Formula = "=SUM(A1:A3)"&#13; ' Calculating the results of formulas&#13; workbook.CalculateFormula()</code></pre></div><div class="code_window_bottom"><span class="language_selection"><span class="ls-span">VB </span> <span><label class="switch"><input type="checkbox" checked="checked"/> <span class="slider round"/></label> </span><span class="ls-span">C#</span></span></div></div></div><p>Following the above code you can set more formulas with ease.</p><h2 id="anchor-7-inter-convert-files-excel-xls-xlsx-xlsb-xlsm-xps-data-interchange">7. Inter Convert files — (Excel, XlS, XlSX, XlSb, XlSM, XPS Data Interchange)</h2><p>Both IronXL and Aspose Cells provide the facility to convert Excel xlsx files to different formats, and from different formats to Excel workbooks.</p><h3 id="anchor-7-1-conversion-process-using-ironxl">7.1. Conversion Process using IronXL</h3><p>The process is pretty simple and easy. It is usually done with one line of code.</p><p><strong>CSV to Excel formats:</strong></p><pre class="naked-code"><code class="language-cs">WorkBook workbook = WorkBook.LoadCSV("test.csv", fileFormat: ExcelFileFormat.XLSX, ListDelimiter: ","); WorkSheet ws = workbook.DefaultWorkSheet; workbook.SaveAs("CsvToExcelConversion.xlsx");</code></pre><div class="code-content code-content-inner"><div class="code_window"><div class="language-selection__content-page-wrapper"/><div class="code_window_content"><div class="code-window__action-buttons-wrapper code-window__action-buttons-wrapper--content-page"><button title="Click to copy" class="code-window__action-button code-window__action-button--copy copy-clipboard" data-clipboard-id="code-explorer" data-placement="bottom"><svg width="16" height="16" viewbox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M9.53515 14.5295C4.88236 14.5295 6.83966 14.5295 2.05009 14.5295V4.55504H3.19663V3.0849H1.75902C1.06465 3.0849 0.5 3.6106 0.5 4.25687V14.8277C0.5 15.475 1.06351 15.9999 1.75871 15.9999C3.47852 15.9999 6.7062 15.9999 9.82653 15.9999C10.5217 15.9999 11.0852 15.4752 11.0852 14.8277C11.0852 14.7177 11.0852 14.6188 11.0852 14.515H9.53512L9.53515 14.5295Z" fill="white"/><path d="M15.2833 2.19563L13.1418 0.201276C13.0019 0.0710973 12.816 0 12.6191 0H6.17382C5.47944 0 4.91479 0.525728 4.91479 1.17225V11.7428C4.91479 12.3901 5.4783 12.9151 6.17382 12.9151C7.89332 12.9151 11.121 12.9151 14.2413 12.9151C14.9365 12.9151 15.5 12.3904 15.5 11.7428C15.5 4.94324 15.5 9.65683 15.5 2.68229C15.5 2.49846 15.4232 2.32552 15.2833 2.19563ZM13.9499 11.4449C9.29688 11.4449 11.2544 11.4449 6.46464 11.4449V1.47043H11.6697V2.75988C11.6697 3.21946 12.071 3.59339 12.5645 3.59339H13.9499V11.4449Z" fill="white"/></svg></button> <button title="Full Screen Mode" class="code-window__action-button code-window__action-button--full-screen js-full-screen-code-example-modal"><svg width="17" height="16" viewbox="0 0 17 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" clip-rule="evenodd" d="M9.81671 0L16.0012 7.41747e-07V6.18358H13.6824V2.31884L9.81671 2.31884V0ZM0.00122688 1.05964e-07H6.18386V2.31884H2.32007V6.18358H0.00122688V1.05964e-07ZM2.31884 9.81614L2.31978 13.6812H6.18386V16H0.00150991L0 9.81671L2.31884 9.81614ZM16 9.81614L16.0015 16H9.81671V13.6812H13.6821L13.6812 9.81671L16 9.81614Z" fill="#454545"/></svg></button> <button title="Exit Full Screen" class="code-window__action-button code-window__action-button--exit-full-screen js-exit-full-screen-code-example-modal"><svg width="16" height="16" viewbox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M15.9653 3.47851V5.56547H10.4012L10.3998 0.000508881L12.4868 0L12.4877 3.47851H15.9653Z" fill="#53B78E"/><path d="M15.9653 12.4869V10.3999H10.4012L10.3998 15.965L12.4868 15.9655L12.4877 12.4869H15.9653Z" fill="#53B78E"/><path d="M0 12.4869L1.82446e-07 10.3999H5.56411L5.56547 15.965L3.47852 15.9655L3.47766 12.4869H0Z" fill="#53B78E"/><path d="M1.82447e-07 3.47851L0 5.56547H5.56411L5.56547 0.000509063L3.47852 0L3.47766 3.47851H1.82447e-07Z" fill="#53B78E"/></svg></button></div><pre class="prettyprint linenums lang-cs"><code>WorkBook workbook = WorkBook.LoadCSV("test.csv", fileFormat: ExcelFileFormat.XLSX, ListDelimiter: ","); WorkSheet ws = workbook.DefaultWorkSheet; workbook.SaveAs("CsvToExcelConversion.xlsx");</code></pre><pre class="prettyprint linenums lang-vb"><code>Dim workbook As WorkBook = WorkBook.LoadCSV("test.csv", fileFormat:= ExcelFileFormat.XLSX, ListDelimiter:= ",")&#13; Dim ws As WorkSheet = workbook.DefaultWorkSheet&#13; workbook.SaveAs("CsvToExcelConversion.xlsx")</code></pre></div><div class="code_window_bottom"><span class="language_selection"><span class="ls-span">VB </span> <span><label class="switch"><input type="checkbox" checked="checked"/> <span class="slider round"/></label> </span><span class="ls-span">C#</span></span></div></div></div><p><strong>XLSX file to XLSM:</strong></p><pre class="naked-code"><code class="language-cs">WorkBook workbook = WorkBook.Load("test.xlsx"); //This is how you can export workbook to .xlsm format workbook.SaveAs("test.xlsm");</code></pre><div class="code-content code-content-inner"><div class="code_window"><div class="language-selection__content-page-wrapper"/><div class="code_window_content"><div class="code-window__action-buttons-wrapper code-window__action-buttons-wrapper--content-page"><button title="Click to copy" class="code-window__action-button code-window__action-button--copy copy-clipboard" data-clipboard-id="code-explorer" data-placement="bottom"><svg width="16" height="16" viewbox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M9.53515 14.5295C4.88236 14.5295 6.83966 14.5295 2.05009 14.5295V4.55504H3.19663V3.0849H1.75902C1.06465 3.0849 0.5 3.6106 0.5 4.25687V14.8277C0.5 15.475 1.06351 15.9999 1.75871 15.9999C3.47852 15.9999 6.7062 15.9999 9.82653 15.9999C10.5217 15.9999 11.0852 15.4752 11.0852 14.8277C11.0852 14.7177 11.0852 14.6188 11.0852 14.515H9.53512L9.53515 14.5295Z" fill="white"/><path d="M15.2833 2.19563L13.1418 0.201276C13.0019 0.0710973 12.816 0 12.6191 0H6.17382C5.47944 0 4.91479 0.525728 4.91479 1.17225V11.7428C4.91479 12.3901 5.4783 12.9151 6.17382 12.9151C7.89332 12.9151 11.121 12.9151 14.2413 12.9151C14.9365 12.9151 15.5 12.3904 15.5 11.7428C15.5 4.94324 15.5 9.65683 15.5 2.68229C15.5 2.49846 15.4232 2.32552 15.2833 2.19563ZM13.9499 11.4449C9.29688 11.4449 11.2544 11.4449 6.46464 11.4449V1.47043H11.6697V2.75988C11.6697 3.21946 12.071 3.59339 12.5645 3.59339H13.9499V11.4449Z" fill="white"/></svg></button> <button title="Full Screen Mode" class="code-window__action-button code-window__action-button--full-screen js-full-screen-code-example-modal"><svg width="17" height="16" viewbox="0 0 17 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" clip-rule="evenodd" d="M9.81671 0L16.0012 7.41747e-07V6.18358H13.6824V2.31884L9.81671 2.31884V0ZM0.00122688 1.05964e-07H6.18386V2.31884H2.32007V6.18358H0.00122688V1.05964e-07ZM2.31884 9.81614L2.31978 13.6812H6.18386V16H0.00150991L0 9.81671L2.31884 9.81614ZM16 9.81614L16.0015 16H9.81671V13.6812H13.6821L13.6812 9.81671L16 9.81614Z" fill="#454545"/></svg></button> <button title="Exit Full Screen" class="code-window__action-button code-window__action-button--exit-full-screen js-exit-full-screen-code-example-modal"><svg width="16" height="16" viewbox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M15.9653 3.47851V5.56547H10.4012L10.3998 0.000508881L12.4868 0L12.4877 3.47851H15.9653Z" fill="#53B78E"/><path d="M15.9653 12.4869V10.3999H10.4012L10.3998 15.965L12.4868 15.9655L12.4877 12.4869H15.9653Z" fill="#53B78E"/><path d="M0 12.4869L1.82446e-07 10.3999H5.56411L5.56547 15.965L3.47852 15.9655L3.47766 12.4869H0Z" fill="#53B78E"/><path d="M1.82447e-07 3.47851L0 5.56547H5.56411L5.56547 0.000509063L3.47852 0L3.47766 3.47851H1.82447e-07Z" fill="#53B78E"/></svg></button></div><pre class="prettyprint linenums lang-cs"><code>WorkBook workbook = WorkBook.Load("test.xlsx"); //This is how you can export workbook to .xlsm format workbook.SaveAs("test.xlsm");</code></pre><pre class="prettyprint linenums lang-vb"><code>Dim workbook As WorkBook = WorkBook.Load("test.xlsx")&#13; 'This is how you can export workbook to .xlsm format&#13; workbook.SaveAs("test.xlsm")</code></pre></div><div class="code_window_bottom"><span class="language_selection"><span class="ls-span">VB </span> <span><label class="switch"><input type="checkbox" checked="checked"/> <span class="slider round"/></label> </span><span class="ls-span">C#</span></span></div></div></div><p><strong>Excel to HTML with options:</strong></p><pre class="naked-code"><code class="language-cs">WorkBook workbook = WorkBook.Load("test.xlsx"); var options = new HtmlExportOptions() //This is how we can make row/column numbers visible in html document OutputRowNumbers = true, OutputColumnHeaders = true, OutputHiddenColumns = true, //This is how we can make hidden rows/columns visible in html document OutputHiddenRows = true, OutputLeadingSpacesAsNonBreaking = true //This is how we can export workbook to the HTML file workbook.ExportToHtml("workbook.html",options);</code></pre><div class="code-content code-content-inner"><div class="code_window"><div class="language-selection__content-page-wrapper"/><div class="code_window_content"><div class="code-window__action-buttons-wrapper code-window__action-buttons-wrapper--content-page"><button title="Click to copy" class="code-window__action-button code-window__action-button--copy copy-clipboard" data-clipboard-id="code-explorer" data-placement="bottom"><svg width="16" height="16" viewbox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M9.53515 14.5295C4.88236 14.5295 6.83966 14.5295 2.05009 14.5295V4.55504H3.19663V3.0849H1.75902C1.06465 3.0849 0.5 3.6106 0.5 4.25687V14.8277C0.5 15.475 1.06351 15.9999 1.75871 15.9999C3.47852 15.9999 6.7062 15.9999 9.82653 15.9999C10.5217 15.9999 11.0852 15.4752 11.0852 14.8277C11.0852 14.7177 11.0852 14.6188 11.0852 14.515H9.53512L9.53515 14.5295Z" fill="white"/><path d="M15.2833 2.19563L13.1418 0.201276C13.0019 0.0710973 12.816 0 12.6191 0H6.17382C5.47944 0 4.91479 0.525728 4.91479 1.17225V11.7428C4.91479 12.3901 5.4783 12.9151 6.17382 12.9151C7.89332 12.9151 11.121 12.9151 14.2413 12.9151C14.9365 12.9151 15.5 12.3904 15.5 11.7428C15.5 4.94324 15.5 9.65683 15.5 2.68229C15.5 2.49846 15.4232 2.32552 15.2833 2.19563ZM13.9499 11.4449C9.29688 11.4449 11.2544 11.4449 6.46464 11.4449V1.47043H11.6697V2.75988C11.6697 3.21946 12.071 3.59339 12.5645 3.59339H13.9499V11.4449Z" fill="white"/></svg></button> <button title="Full Screen Mode" class="code-window__action-button code-window__action-button--full-screen js-full-screen-code-example-modal"><svg width="17" height="16" viewbox="0 0 17 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" clip-rule="evenodd" d="M9.81671 0L16.0012 7.41747e-07V6.18358H13.6824V2.31884L9.81671 2.31884V0ZM0.00122688 1.05964e-07H6.18386V2.31884H2.32007V6.18358H0.00122688V1.05964e-07ZM2.31884 9.81614L2.31978 13.6812H6.18386V16H0.00150991L0 9.81671L2.31884 9.81614ZM16 9.81614L16.0015 16H9.81671V13.6812H13.6821L13.6812 9.81671L16 9.81614Z" fill="#454545"/></svg></button> <button title="Exit Full Screen" class="code-window__action-button code-window__action-button--exit-full-screen js-exit-full-screen-code-example-modal"><svg width="16" height="16" viewbox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M15.9653 3.47851V5.56547H10.4012L10.3998 0.000508881L12.4868 0L12.4877 3.47851H15.9653Z" fill="#53B78E"/><path d="M15.9653 12.4869V10.3999H10.4012L10.3998 15.965L12.4868 15.9655L12.4877 12.4869H15.9653Z" fill="#53B78E"/><path d="M0 12.4869L1.82446e-07 10.3999H5.56411L5.56547 15.965L3.47852 15.9655L3.47766 12.4869H0Z" fill="#53B78E"/><path d="M1.82447e-07 3.47851L0 5.56547H5.56411L5.56547 0.000509063L3.47852 0L3.47766 3.47851H1.82447e-07Z" fill="#53B78E"/></svg></button></div><pre class="prettyprint linenums lang-cs"><code>WorkBook workbook = WorkBook.Load("test.xlsx"); var options = new HtmlExportOptions() //This is how we can make row/column numbers visible in html document OutputRowNumbers = true, OutputColumnHeaders = true, OutputHiddenColumns = true, //This is how we can make hidden rows/columns visible in html document OutputHiddenRows = true, OutputLeadingSpacesAsNonBreaking = true //This is how we can export workbook to the HTML file workbook.ExportToHtml("workbook.html",options);</code></pre><pre class="prettyprint linenums lang-vb"><code>Dim workbook As WorkBook = WorkBook.Load("test.xlsx")&#13; Dim options = New HtmlExportOptions() With {&#13; .OutputRowNumbers = True,&#13; .OutputColumnHeaders = True,&#13; .OutputHiddenColumns = True,&#13; .OutputHiddenRows = True,&#13; .OutputLeadingSpacesAsNonBreaking = True&#13; 'This is how we can export workbook to the HTML file&#13; workbook.ExportToHtml("workbook.html",options)</code></pre></div><div class="code_window_bottom"><span class="language_selection"><span class="ls-span">VB </span> <span><label class="switch"><input type="checkbox" checked="checked"/> <span class="slider round"/></label> </span><span class="ls-span">C#</span></span></div></div></div><h3 id="anchor-7-2-conversion-process-using-aspose-cells">7.2. Conversion Process using Aspose.Cells</h3><p>It is fairly simple to convert Excel xlsx files in Aspose cells as well. Take a look at the codes below:</p><p><strong>Excel to HTML:</strong></p><pre class="naked-code"><code class="language-cs">//Load your source workbook Workbook workbook = new Workbook("Book1.xlsx"); //save file to html format workbook.Save("out.html");</code></pre><div class="code-content code-content-inner"><div class="code_window"><div class="language-selection__content-page-wrapper"/><div class="code_window_content"><div class="code-window__action-buttons-wrapper code-window__action-buttons-wrapper--content-page"><button title="Click to copy" class="code-window__action-button code-window__action-button--copy copy-clipboard" data-clipboard-id="code-explorer" data-placement="bottom"><svg width="16" height="16" viewbox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M9.53515 14.5295C4.88236 14.5295 6.83966 14.5295 2.05009 14.5295V4.55504H3.19663V3.0849H1.75902C1.06465 3.0849 0.5 3.6106 0.5 4.25687V14.8277C0.5 15.475 1.06351 15.9999 1.75871 15.9999C3.47852 15.9999 6.7062 15.9999 9.82653 15.9999C10.5217 15.9999 11.0852 15.4752 11.0852 14.8277C11.0852 14.7177 11.0852 14.6188 11.0852 14.515H9.53512L9.53515 14.5295Z" fill="white"/><path d="M15.2833 2.19563L13.1418 0.201276C13.0019 0.0710973 12.816 0 12.6191 0H6.17382C5.47944 0 4.91479 0.525728 4.91479 1.17225V11.7428C4.91479 12.3901 5.4783 12.9151 6.17382 12.9151C7.89332 12.9151 11.121 12.9151 14.2413 12.9151C14.9365 12.9151 15.5 12.3904 15.5 11.7428C15.5 4.94324 15.5 9.65683 15.5 2.68229C15.5 2.49846 15.4232 2.32552 15.2833 2.19563ZM13.9499 11.4449C9.29688 11.4449 11.2544 11.4449 6.46464 11.4449V1.47043H11.6697V2.75988C11.6697 3.21946 12.071 3.59339 12.5645 3.59339H13.9499V11.4449Z" fill="white"/></svg></button> <button title="Full Screen Mode" class="code-window__action-button code-window__action-button--full-screen js-full-screen-code-example-modal"><svg width="17" height="16" viewbox="0 0 17 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" clip-rule="evenodd" d="M9.81671 0L16.0012 7.41747e-07V6.18358H13.6824V2.31884L9.81671 2.31884V0ZM0.00122688 1.05964e-07H6.18386V2.31884H2.32007V6.18358H0.00122688V1.05964e-07ZM2.31884 9.81614L2.31978 13.6812H6.18386V16H0.00150991L0 9.81671L2.31884 9.81614ZM16 9.81614L16.0015 16H9.81671V13.6812H13.6821L13.6812 9.81671L16 9.81614Z" fill="#454545"/></svg></button> <button title="Exit Full Screen" class="code-window__action-button code-window__action-button--exit-full-screen js-exit-full-screen-code-example-modal"><svg width="16" height="16" viewbox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M15.9653 3.47851V5.56547H10.4012L10.3998 0.000508881L12.4868 0L12.4877 3.47851H15.9653Z" fill="#53B78E"/><path d="M15.9653 12.4869V10.3999H10.4012L10.3998 15.965L12.4868 15.9655L12.4877 12.4869H15.9653Z" fill="#53B78E"/><path d="M0 12.4869L1.82446e-07 10.3999H5.56411L5.56547 15.965L3.47852 15.9655L3.47766 12.4869H0Z" fill="#53B78E"/><path d="M1.82447e-07 3.47851L0 5.56547H5.56411L5.56547 0.000509063L3.47852 0L3.47766 3.47851H1.82447e-07Z" fill="#53B78E"/></svg></button></div><pre class="prettyprint linenums lang-cs"><code>//Load your source workbook Workbook workbook = new Workbook("Book1.xlsx"); //save file to html format workbook.Save("out.html");</code></pre><pre class="prettyprint linenums lang-vb"><code>'Load your source workbook&#13; Dim workbook As New Workbook("Book1.xlsx")&#13; 'save file to html format&#13; workbook.Save("out.html")</code></pre></div><div class="code_window_bottom"><span class="language_selection"><span class="ls-span">VB </span> <span><label class="switch"><input type="checkbox" checked="checked"/> <span class="slider round"/></label> </span><span class="ls-span">C#</span></span></div></div></div><p><strong>ODs text to Excel:</strong></p><pre class="naked-code"><code class="language-cs">//Load your source ods text file Workbook workbook = new Workbook("book1.ods"); //Save as xlsx file workbook.Save("ods_out.xlsx");</code></pre><div class="code-content code-content-inner"><div class="code_window"><div class="language-selection__content-page-wrapper"/><div class="code_window_content"><div class="code-window__action-buttons-wrapper code-window__action-buttons-wrapper--content-page"><button title="Click to copy" class="code-window__action-button code-window__action-button--copy copy-clipboard" data-clipboard-id="code-explorer" data-placement="bottom"><svg width="16" height="16" viewbox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M9.53515 14.5295C4.88236 14.5295 6.83966 14.5295 2.05009 14.5295V4.55504H3.19663V3.0849H1.75902C1.06465 3.0849 0.5 3.6106 0.5 4.25687V14.8277C0.5 15.475 1.06351 15.9999 1.75871 15.9999C3.47852 15.9999 6.7062 15.9999 9.82653 15.9999C10.5217 15.9999 11.0852 15.4752 11.0852 14.8277C11.0852 14.7177 11.0852 14.6188 11.0852 14.515H9.53512L9.53515 14.5295Z" fill="white"/><path d="M15.2833 2.19563L13.1418 0.201276C13.0019 0.0710973 12.816 0 12.6191 0H6.17382C5.47944 0 4.91479 0.525728 4.91479 1.17225V11.7428C4.91479 12.3901 5.4783 12.9151 6.17382 12.9151C7.89332 12.9151 11.121 12.9151 14.2413 12.9151C14.9365 12.9151 15.5 12.3904 15.5 11.7428C15.5 4.94324 15.5 9.65683 15.5 2.68229C15.5 2.49846 15.4232 2.32552 15.2833 2.19563ZM13.9499 11.4449C9.29688 11.4449 11.2544 11.4449 6.46464 11.4449V1.47043H11.6697V2.75988C11.6697 3.21946 12.071 3.59339 12.5645 3.59339H13.9499V11.4449Z" fill="white"/></svg></button> <button title="Full Screen Mode" class="code-window__action-button code-window__action-button--full-screen js-full-screen-code-example-modal"><svg width="17" height="16" viewbox="0 0 17 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" clip-rule="evenodd" d="M9.81671 0L16.0012 7.41747e-07V6.18358H13.6824V2.31884L9.81671 2.31884V0ZM0.00122688 1.05964e-07H6.18386V2.31884H2.32007V6.18358H0.00122688V1.05964e-07ZM2.31884 9.81614L2.31978 13.6812H6.18386V16H0.00150991L0 9.81671L2.31884 9.81614ZM16 9.81614L16.0015 16H9.81671V13.6812H13.6821L13.6812 9.81671L16 9.81614Z" fill="#454545"/></svg></button> <button title="Exit Full Screen" class="code-window__action-button code-window__action-button--exit-full-screen js-exit-full-screen-code-example-modal"><svg width="16" height="16" viewbox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M15.9653 3.47851V5.56547H10.4012L10.3998 0.000508881L12.4868 0L12.4877 3.47851H15.9653Z" fill="#53B78E"/><path d="M15.9653 12.4869V10.3999H10.4012L10.3998 15.965L12.4868 15.9655L12.4877 12.4869H15.9653Z" fill="#53B78E"/><path d="M0 12.4869L1.82446e-07 10.3999H5.56411L5.56547 15.965L3.47852 15.9655L3.47766 12.4869H0Z" fill="#53B78E"/><path d="M1.82447e-07 3.47851L0 5.56547H5.56411L5.56547 0.000509063L3.47852 0L3.47766 3.47851H1.82447e-07Z" fill="#53B78E"/></svg></button></div><pre class="prettyprint linenums lang-cs"><code>//Load your source ods text file Workbook workbook = new Workbook("book1.ods"); //Save as xlsx file workbook.Save("ods_out.xlsx");</code></pre><pre class="prettyprint linenums lang-vb"><code>'Load your source ods text file&#13; Dim workbook As New Workbook("book1.ods")&#13; 'Save as xlsx file&#13; workbook.Save("ods_out.xlsx")</code></pre></div><div class="code_window_bottom"><span class="language_selection"><span class="ls-span">VB </span> <span><label class="switch"><input type="checkbox" checked="checked"/> <span class="slider round"/></label> </span><span class="ls-span">C#</span></span></div></div></div><p><strong>Excel Worksheet to SVG formats:</strong></p><pre class="naked-code"><code class="language-cs">// Instantiate a workbook var workbook = new Workbook(); // Populate worksheets first cell workbook.Worksheets[0].Cells["A1"].Value = "DEMO TEXT ON SHEET1"; // Convert Worksheets workbook.Save("ConvertWorksheetToSVG_out.svg");</code></pre><div class="code-content code-content-inner"><div class="code_window"><div class="language-selection__content-page-wrapper"/><div class="code_window_content"><div class="code-window__action-buttons-wrapper code-window__action-buttons-wrapper--content-page"><button title="Click to copy" class="code-window__action-button code-window__action-button--copy copy-clipboard" data-clipboard-id="code-explorer" data-placement="bottom"><svg width="16" height="16" viewbox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M9.53515 14.5295C4.88236 14.5295 6.83966 14.5295 2.05009 14.5295V4.55504H3.19663V3.0849H1.75902C1.06465 3.0849 0.5 3.6106 0.5 4.25687V14.8277C0.5 15.475 1.06351 15.9999 1.75871 15.9999C3.47852 15.9999 6.7062 15.9999 9.82653 15.9999C10.5217 15.9999 11.0852 15.4752 11.0852 14.8277C11.0852 14.7177 11.0852 14.6188 11.0852 14.515H9.53512L9.53515 14.5295Z" fill="white"/><path d="M15.2833 2.19563L13.1418 0.201276C13.0019 0.0710973 12.816 0 12.6191 0H6.17382C5.47944 0 4.91479 0.525728 4.91479 1.17225V11.7428C4.91479 12.3901 5.4783 12.9151 6.17382 12.9151C7.89332 12.9151 11.121 12.9151 14.2413 12.9151C14.9365 12.9151 15.5 12.3904 15.5 11.7428C15.5 4.94324 15.5 9.65683 15.5 2.68229C15.5 2.49846 15.4232 2.32552 15.2833 2.19563ZM13.9499 11.4449C9.29688 11.4449 11.2544 11.4449 6.46464 11.4449V1.47043H11.6697V2.75988C11.6697 3.21946 12.071 3.59339 12.5645 3.59339H13.9499V11.4449Z" fill="white"/></svg></button> <button title="Full Screen Mode" class="code-window__action-button code-window__action-button--full-screen js-full-screen-code-example-modal"><svg width="17" height="16" viewbox="0 0 17 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" clip-rule="evenodd" d="M9.81671 0L16.0012 7.41747e-07V6.18358H13.6824V2.31884L9.81671 2.31884V0ZM0.00122688 1.05964e-07H6.18386V2.31884H2.32007V6.18358H0.00122688V1.05964e-07ZM2.31884 9.81614L2.31978 13.6812H6.18386V16H0.00150991L0 9.81671L2.31884 9.81614ZM16 9.81614L16.0015 16H9.81671V13.6812H13.6821L13.6812 9.81671L16 9.81614Z" fill="#454545"/></svg></button> <button title="Exit Full Screen" class="code-window__action-button code-window__action-button--exit-full-screen js-exit-full-screen-code-example-modal"><svg width="16" height="16" viewbox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M15.9653 3.47851V5.56547H10.4012L10.3998 0.000508881L12.4868 0L12.4877 3.47851H15.9653Z" fill="#53B78E"/><path d="M15.9653 12.4869V10.3999H10.4012L10.3998 15.965L12.4868 15.9655L12.4877 12.4869H15.9653Z" fill="#53B78E"/><path d="M0 12.4869L1.82446e-07 10.3999H5.56411L5.56547 15.965L3.47852 15.9655L3.47766 12.4869H0Z" fill="#53B78E"/><path d="M1.82447e-07 3.47851L0 5.56547H5.56411L5.56547 0.000509063L3.47852 0L3.47766 3.47851H1.82447e-07Z" fill="#53B78E"/></svg></button></div><pre class="prettyprint linenums lang-cs"><code>// Instantiate a workbook var workbook = new Workbook(); // Populate worksheets first cell workbook.Worksheets[0].Cells["A1"].Value = "DEMO TEXT ON SHEET1"; // Convert Worksheets workbook.Save("ConvertWorksheetToSVG_out.svg");</code></pre><pre class="prettyprint linenums lang-vb"><code>' Instantiate a workbook&#13; Dim workbook As New Workbook()&#13;