{"id":27981,"date":"2024-03-16T09:33:07","date_gmt":"2024-03-16T09:33:07","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-specify-the-columns-to-export-when-exporting-gridview-data-to-excel\/"},"modified":"2024-03-22T12:20:53","modified_gmt":"2024-03-22T12:20:53","slug":"how-to-specify-the-columns-to-export-when-exporting-gridview-data-to-excel","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-specify-the-columns-to-export-when-exporting-gridview-data-to-excel\/","title":{"rendered":"How to specify the columns to export when exporting GridView data to Excel?"},"content":{"rendered":"<p>To export GridView data to Excel by specifying columns, the following steps can be used:<\/p>\n<ol>\n<li>Create a new Excel file and specify the columns to export.<\/li>\n<li>Iterate through the rows of the GridView, for each row, get the data from the specified column and write it to the corresponding position in the Excel file.<\/li>\n<li>Finally, save and close the Excel file.<\/li>\n<\/ol>\n<p>Here is a sample code demonstrating how to export data from a GridView to Excel, specifying only the columns to export:<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">using<\/span> System;\r\n<span class=\"hljs-keyword\">using<\/span> System.Data;\r\n<span class=\"hljs-keyword\">using<\/span> System.IO;\r\n<span class=\"hljs-keyword\">using<\/span> System.Web;\r\n<span class=\"hljs-keyword\">using<\/span> System.Web.UI;\r\n<span class=\"hljs-keyword\">using<\/span> System.Web.UI.WebControls;\r\n<span class=\"hljs-keyword\">using<\/span> System.Web.UI.HtmlControls;\r\n<span class=\"hljs-keyword\">using<\/span> Microsoft.Office.Interop.Excel;\r\n\r\n<span class=\"hljs-function\"><span class=\"hljs-keyword\">protected<\/span> <span class=\"hljs-keyword\">void<\/span> <span class=\"hljs-title\">ExportToExcel_Click<\/span>(<span class=\"hljs-params\"><span class=\"hljs-built_in\">object<\/span> sender, EventArgs e<\/span>)<\/span>\r\n{\r\n    <span class=\"hljs-comment\">\/\/ \u521b\u5efa\u4e00\u4e2a\u65b0\u7684Excel\u6587\u4ef6<\/span>\r\n    Application excelApp = <span class=\"hljs-keyword\">new<\/span> Application();\r\n    Workbook excelWorkbook = excelApp.Workbooks.Add(Type.Missing);\r\n    Worksheet excelWorksheet = excelWorkbook.ActiveSheet;\r\n\r\n    <span class=\"hljs-comment\">\/\/ \u83b7\u53d6\u8981\u5bfc\u51fa\u7684\u5217\u7684\u7d22\u5f15<\/span>\r\n    <span class=\"hljs-built_in\">int<\/span>[] selectedColumns = { <span class=\"hljs-number\">0<\/span>, <span class=\"hljs-number\">2<\/span>, <span class=\"hljs-number\">3<\/span> }; <span class=\"hljs-comment\">\/\/ \u8fd9\u91cc\u5047\u8bbe\u8981\u5bfc\u51fa\u7b2c\u4e00\u3001\u4e09\u3001\u56db\u5217<\/span>\r\n\r\n    <span class=\"hljs-comment\">\/\/ \u5199\u5165\u5217\u6807\u9898<\/span>\r\n    <span class=\"hljs-keyword\">for<\/span> (<span class=\"hljs-built_in\">int<\/span> i = <span class=\"hljs-number\">0<\/span>; i &lt; selectedColumns.Length; i++)\r\n    {\r\n        excelWorksheet.Cells[<span class=\"hljs-number\">1<\/span>, i + <span class=\"hljs-number\">1<\/span>] = GridView1.Columns[selectedColumns[i]].HeaderText;\r\n    }\r\n\r\n    <span class=\"hljs-comment\">\/\/ \u5199\u5165\u884c\u6570\u636e<\/span>\r\n    <span class=\"hljs-keyword\">for<\/span> (<span class=\"hljs-built_in\">int<\/span> rowIndex = <span class=\"hljs-number\">0<\/span>; rowIndex &lt; GridView1.Rows.Count; rowIndex++)\r\n    {\r\n        <span class=\"hljs-keyword\">for<\/span> (<span class=\"hljs-built_in\">int<\/span> colIndex = <span class=\"hljs-number\">0<\/span>; colIndex &lt; selectedColumns.Length; colIndex++)\r\n        {\r\n            excelWorksheet.Cells[rowIndex + <span class=\"hljs-number\">2<\/span>, colIndex + <span class=\"hljs-number\">1<\/span>] = GridView1.Rows[rowIndex].Cells[selectedColumns[colIndex]].Text;\r\n        }\r\n    }\r\n\r\n    <span class=\"hljs-comment\">\/\/ \u4fdd\u5b58Excel\u6587\u4ef6<\/span>\r\n    <span class=\"hljs-built_in\">string<\/span> fileName = <span class=\"hljs-string\">\"GridViewData.xlsx\"<\/span>;\r\n    <span class=\"hljs-built_in\">string<\/span> filePath = Path.Combine(Server.MapPath(<span class=\"hljs-string\">\"~\/ExportFiles\/\"<\/span>), fileName);\r\n    excelWorkbook.SaveAs(filePath);\r\n    excelWorkbook.Close();\r\n    excelApp.Quit();\r\n\r\n    <span class=\"hljs-comment\">\/\/ \u4e0b\u8f7dExcel\u6587\u4ef6<\/span>\r\n    Response.ContentType = <span class=\"hljs-string\">\"application\/vnd.openxmlformats-officedocument.spreadsheetml.sheet\"<\/span>;\r\n    Response.AppendHeader(<span class=\"hljs-string\">\"Content-Disposition\"<\/span>, <span class=\"hljs-string\">\"attachment; filename=\"<\/span> + fileName);\r\n    Response.TransmitFile(filePath);\r\n    Response.End();\r\n}\r\n<\/code><\/pre>\n<p>Please note that this example utilizes the Microsoft Office Interop library, so you will need to reference the Microsoft.Office.Interop.Excel assembly in your project in order to use it. Additionally, you will need to have Excel installed on the server as this library relies on the Excel application.<\/p>\n<p>Additionally, you may also consider utilizing third-party libraries such as EPPlus or ClosedXML, which offer simpler and more flexible ways to export data to Excel.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>To export GridView data to Excel by specifying columns, the following steps can be used: Create a new Excel file and specify the columns to export. Iterate through the rows of the GridView, for each row, get the data from the specified column and write it to the corresponding position in the Excel file. Finally, [&hellip;]<\/p>\n","protected":false},"author":14,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-27981","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to specify the columns to export when exporting GridView data to Excel? - Blog - Silicon Cloud<\/title>\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-specify-the-columns-to-export-when-exporting-gridview-data-to-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to specify the columns to export when exporting GridView data to Excel?\" \/>\n<meta property=\"og:description\" content=\"To export GridView data to Excel by specifying columns, the following steps can be used: Create a new Excel file and specify the columns to export. Iterate through the rows of the GridView, for each row, get the data from the specified column and write it to the corresponding position in the Excel file. Finally, [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-specify-the-columns-to-export-when-exporting-gridview-data-to-excel\/\" \/>\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-16T09:33:07+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-22T12:20:53+00:00\" \/>\n<meta name=\"author\" content=\"Noah Thompson\" \/>\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=\"Noah Thompson\" \/>\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-specify-the-columns-to-export-when-exporting-gridview-data-to-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-specify-the-columns-to-export-when-exporting-gridview-data-to-excel\/\"},\"author\":{\"name\":\"Noah Thompson\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/2e83cc6ab9f60d36921c2d0f9f280f4a\"},\"headline\":\"How to specify the columns to export when exporting GridView data to Excel?\",\"datePublished\":\"2024-03-16T09:33:07+00:00\",\"dateModified\":\"2024-03-22T12:20:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-specify-the-columns-to-export-when-exporting-gridview-data-to-excel\/\"},\"wordCount\":170,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-specify-the-columns-to-export-when-exporting-gridview-data-to-excel\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-specify-the-columns-to-export-when-exporting-gridview-data-to-excel\/\",\"name\":\"How to specify the columns to export when exporting GridView data to Excel? - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-16T09:33:07+00:00\",\"dateModified\":\"2024-03-22T12:20:53+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-specify-the-columns-to-export-when-exporting-gridview-data-to-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-specify-the-columns-to-export-when-exporting-gridview-data-to-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-specify-the-columns-to-export-when-exporting-gridview-data-to-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to specify the columns to export when exporting GridView data to Excel?\"}]},{\"@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\/2e83cc6ab9f60d36921c2d0f9f280f4a\",\"name\":\"Noah Thompson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/350e537e1530ede2762ee0237e877d6693f4f7163ab4f303202cc9a6b27b6cb4?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/350e537e1530ede2762ee0237e877d6693f4f7163ab4f303202cc9a6b27b6cb4?s=96&d=mm&r=g\",\"caption\":\"Noah Thompson\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/noahthompson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to specify the columns to export when exporting GridView data to Excel? - Blog - Silicon Cloud","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-specify-the-columns-to-export-when-exporting-gridview-data-to-excel\/","og_locale":"en_US","og_type":"article","og_title":"How to specify the columns to export when exporting GridView data to Excel?","og_description":"To export GridView data to Excel by specifying columns, the following steps can be used: Create a new Excel file and specify the columns to export. Iterate through the rows of the GridView, for each row, get the data from the specified column and write it to the corresponding position in the Excel file. Finally, [&hellip;]","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-specify-the-columns-to-export-when-exporting-gridview-data-to-excel\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-16T09:33:07+00:00","article_modified_time":"2024-03-22T12:20:53+00:00","author":"Noah Thompson","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Noah Thompson","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-to-specify-the-columns-to-export-when-exporting-gridview-data-to-excel\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-specify-the-columns-to-export-when-exporting-gridview-data-to-excel\/"},"author":{"name":"Noah Thompson","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/2e83cc6ab9f60d36921c2d0f9f280f4a"},"headline":"How to specify the columns to export when exporting GridView data to Excel?","datePublished":"2024-03-16T09:33:07+00:00","dateModified":"2024-03-22T12:20:53+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-specify-the-columns-to-export-when-exporting-gridview-data-to-excel\/"},"wordCount":170,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-specify-the-columns-to-export-when-exporting-gridview-data-to-excel\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-specify-the-columns-to-export-when-exporting-gridview-data-to-excel\/","name":"How to specify the columns to export when exporting GridView data to Excel? - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-16T09:33:07+00:00","dateModified":"2024-03-22T12:20:53+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-specify-the-columns-to-export-when-exporting-gridview-data-to-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-specify-the-columns-to-export-when-exporting-gridview-data-to-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-specify-the-columns-to-export-when-exporting-gridview-data-to-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to specify the columns to export when exporting GridView data to Excel?"}]},{"@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\/2e83cc6ab9f60d36921c2d0f9f280f4a","name":"Noah Thompson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/350e537e1530ede2762ee0237e877d6693f4f7163ab4f303202cc9a6b27b6cb4?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/350e537e1530ede2762ee0237e877d6693f4f7163ab4f303202cc9a6b27b6cb4?s=96&d=mm&r=g","caption":"Noah Thompson"},"url":"https:\/\/www.silicloud.com\/blog\/author\/noahthompson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/27981","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\/14"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=27981"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/27981\/revisions"}],"predecessor-version":[{"id":62249,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/27981\/revisions\/62249"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=27981"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=27981"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=27981"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}