{"id":7896,"date":"2024-03-14T07:15:38","date_gmt":"2024-03-14T07:15:38","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-export-excel-using-npoi-in-c\/"},"modified":"2025-08-02T22:06:31","modified_gmt":"2025-08-02T22:06:31","slug":"how-to-export-excel-using-npoi-in-c","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-export-excel-using-npoi-in-c\/","title":{"rendered":"NPOI C# Excel Export: Complete Guide"},"content":{"rendered":"

You can export to Excel using NPOI by following these steps:<\/p>\n

    \n
  1. Firstly, you need to import the NPOI library. You can search for NPOI in the NuGet package manager and install it.<\/li>\n
  2. Create an Excel document and input data. Here is an example code:<\/li>\n<\/ol>\n
    using<\/span> NPOI.SS.UserModel;\r\nusing<\/span> NPOI.XSSF.UserModel;\r\nusing<\/span> System.IO;\r\n\r\n\/\/ \u521b\u5efa\u4e00\u4e2aExcel\u6587\u6863<\/span>\r\nIWorkbook workbook = new<\/span> XSSFWorkbook();\r\n\r\n\/\/ \u521b\u5efa\u4e00\u4e2a\u5de5\u4f5c\u8868<\/span>\r\nISheet sheet = workbook.CreateSheet(\"Sheet1\"<\/span>);\r\n\r\n\/\/ \u6dfb\u52a0\u6570\u636e\u5230\u5de5\u4f5c\u8868<\/span>\r\nIRow row = sheet.CreateRow(0<\/span>);\r\nrow.CreateCell(0<\/span>).SetCellValue(\"Name\"<\/span>);\r\nrow.CreateCell(1<\/span>).SetCellValue(\"Age\"<\/span>);\r\n\r\nrow = sheet.CreateRow(1<\/span>);\r\nrow.CreateCell(0<\/span>).SetCellValue(\"Alice\"<\/span>);\r\nrow.CreateCell(1<\/span>).SetCellValue(25<\/span>);\r\n\r\n\/\/ \u4fdd\u5b58Excel\u6587\u6863<\/span>\r\nusing<\/span> (FileStream file = new<\/span> FileStream(\"data.xlsx\"<\/span>, FileMode.Create, FileAccess.Write))\r\n{\r\n    workbook.Write(file);\r\n}\r\n<\/code><\/pre>\n
      \n
    1. After running the program, an Excel file named “data.xlsx” will be generated with added data.<\/li>\n<\/ol>\n
      This way, you can export Excel using NPOI. You can manipulate the data according to your needs and add it to the worksheet.<\/p>\n","protected":false},"excerpt":{"rendered":"
      You can export to Excel using NPOI by following these steps: Firstly, you need to import the NPOI library. You can search for NPOI in the NuGet package manager and install it. Create an Excel document and input data. Here is an example code: using NPOI.SS.UserModel; using NPOI.XSSF.UserModel; using System.IO; \/\/ \u521b\u5efa\u4e00\u4e2aExcel\u6587\u6863 IWorkbook workbook = […]<\/p>\n","protected":false},"author":11,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[10313,10315,10312,10316,10314],"class_list":["post-7896","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-c-excel-generation","tag-excel-export-c","tag-npoi-c-excel-export","tag-npoi-library-c","tag-npoi-tutorial"],"yoast_head":"\nNPOI C# Excel Export: Complete Guide - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Learn how to export Excel files in C# using NPOI library with easy code examples. Follow our step-by-step guide for Excel generation in C#.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/blog\/how-to-export-excel-using-npoi-in-c\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"NPOI C# Excel Export: Complete Guide\" \/>\n<meta property=\"og:description\" content=\"Learn how to export Excel files in C# using NPOI library with easy code examples. Follow our step-by-step guide for Excel generation in C#.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-export-excel-using-npoi-in-c\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-14T07:15:38+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-02T22:06:31+00:00\" \/>\n<meta name=\"author\" content=\"Olivia Parker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Olivia Parker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-export-excel-using-npoi-in-c\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-export-excel-using-npoi-in-c\/\"},\"author\":{\"name\":\"Olivia Parker\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3ff7b3da0e45ac5dbbef2502f3cea8d9\"},\"headline\":\"NPOI C# Excel Export: Complete Guide\",\"datePublished\":\"2024-03-14T07:15:38+00:00\",\"dateModified\":\"2025-08-02T22:06:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-export-excel-using-npoi-in-c\/\"},\"wordCount\":89,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"C# Excel Generation\",\"Excel Export C#\",\"NPOI C# Excel Export\",\"NPOI Library C#\",\"NPOI Tutorial\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-export-excel-using-npoi-in-c\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-export-excel-using-npoi-in-c\/\",\"name\":\"NPOI C# Excel Export: Complete Guide - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-14T07:15:38+00:00\",\"dateModified\":\"2025-08-02T22:06:31+00:00\",\"description\":\"Learn how to export Excel files in C# using NPOI library with easy code examples. Follow our step-by-step guide for Excel generation in C#.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-export-excel-using-npoi-in-c\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-export-excel-using-npoi-in-c\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-export-excel-using-npoi-in-c\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"NPOI C# Excel Export: Complete Guide\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3ff7b3da0e45ac5dbbef2502f3cea8d9\",\"name\":\"Olivia Parker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/56c66f189ba32a6f9eb50f31a38fe774e2a725c213d4070835ccc51b8fbbc54b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/56c66f189ba32a6f9eb50f31a38fe774e2a725c213d4070835ccc51b8fbbc54b?s=96&d=mm&r=g\",\"caption\":\"Olivia Parker\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/oliviaparker\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"NPOI C# Excel Export: Complete Guide - Blog - Silicon Cloud","description":"Learn how to export Excel files in C# using NPOI library with easy code examples. Follow our step-by-step guide for Excel generation in C#.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/blog\/how-to-export-excel-using-npoi-in-c\/","og_locale":"en_US","og_type":"article","og_title":"NPOI C# Excel Export: Complete Guide","og_description":"Learn how to export Excel files in C# using NPOI library with easy code examples. Follow our step-by-step guide for Excel generation in C#.","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-export-excel-using-npoi-in-c\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-14T07:15:38+00:00","article_modified_time":"2025-08-02T22:06:31+00:00","author":"Olivia Parker","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Olivia Parker","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-to-export-excel-using-npoi-in-c\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-export-excel-using-npoi-in-c\/"},"author":{"name":"Olivia Parker","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3ff7b3da0e45ac5dbbef2502f3cea8d9"},"headline":"NPOI C# Excel Export: Complete Guide","datePublished":"2024-03-14T07:15:38+00:00","dateModified":"2025-08-02T22:06:31+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-export-excel-using-npoi-in-c\/"},"wordCount":89,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["C# Excel Generation","Excel Export C#","NPOI C# Excel Export","NPOI Library C#","NPOI Tutorial"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-export-excel-using-npoi-in-c\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-export-excel-using-npoi-in-c\/","name":"NPOI C# Excel Export: Complete Guide - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-14T07:15:38+00:00","dateModified":"2025-08-02T22:06:31+00:00","description":"Learn how to export Excel files in C# using NPOI library with easy code examples. Follow our step-by-step guide for Excel generation in C#.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-export-excel-using-npoi-in-c\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-export-excel-using-npoi-in-c\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-export-excel-using-npoi-in-c\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"NPOI C# Excel Export: Complete Guide"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3ff7b3da0e45ac5dbbef2502f3cea8d9","name":"Olivia Parker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/56c66f189ba32a6f9eb50f31a38fe774e2a725c213d4070835ccc51b8fbbc54b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/56c66f189ba32a6f9eb50f31a38fe774e2a725c213d4070835ccc51b8fbbc54b?s=96&d=mm&r=g","caption":"Olivia Parker"},"url":"https:\/\/www.silicloud.com\/blog\/author\/oliviaparker\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/7896","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=7896"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/7896\/revisions"}],"predecessor-version":[{"id":152691,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/7896\/revisions\/152691"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=7896"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=7896"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=7896"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}