{"id":22798,"date":"2022-11-21T17:45:58","date_gmt":"2022-11-21T12:15:58","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-how-to-load-a-value-from-a-datatable-to-excel-programmatically-closed\/"},"modified":"2022-11-21T17:45:58","modified_gmt":"2022-11-21T12:15:58","slug":"solved-how-to-load-a-value-from-a-datatable-to-excel-programmatically-closed","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-how-to-load-a-value-from-a-datatable-to-excel-programmatically-closed\/","title":{"rendered":"[Solved] How to load a value from a DataTable to Excel programmatically? [closed]"},"content":{"rendered":"<p> [ad_1]<br \/>\n<\/p>\n<div id=\"answer-17495646\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"17495646\" data-parentid=\"17495560\" data-score=\"0\" data-position-on-page=\"1\" data-highest-scored=\"1\" data-question-has-accepted-highest-score=\"1\" itemprop=\"acceptedAnswer\" itemscope itemtype=\"https:\/\/schema.org\/Answer\">\n<div class=\"post-layout\">\n<div class=\"votecell post-layout--left\"><\/div>\n<div class=\"answercell post-layout--right\">\n<div class=\"s-prose js-post-body\" itemprop=\"text\">\n<p>There are many ways to export Dataset into Excel.<br \/>\nHere is a very simple function to export data without using excel object and other messy stuff.<br \/>\nXSL Transformation is applied to dataset and XML for excel is generated.<br \/>\nYou have to pass it the DataSet to export and path to where file should be generated.<\/p>\n<pre><code> public class WorkbookEngine\n{\n  public static void CreateWorkbook(DataSet ds, String path)\n  {\n    XmlDataDocument xmlDataDoc = new XmlDataDocument(ds);\n    XslTransform xt = new XslTransform();\n    StreamReader reader =new StreamReader(typeof(WorkbookEngine).Assembly.GetManifestResourceStream(typeof (WorkbookEngine), \u201cExcel.xsl\u201d));\n    XmlTextReader xRdr = new XmlTextReader(reader);\n    xt.Load(xRdr, null, null);\n    StringWriter sw = new StringWriter();\n    xt.Transform(xmlDataDoc, null, sw, null);\n    StreamWriter myWriter = new StreamWriter (path + \u201c\\\\Report.xls\u201d);\n    myWriter.Write (sw.ToString());\n    myWriter.Close ();\n }\n}\n<\/code><\/pre>\n<p>The links below contain more information that may help you:<br \/>\n<a rel=\"nofollow noopener\" target=\"_blank\" href=\"http:\/\/www.codeproject.com\/Tips\/406704\/Export-DataTable-to-Excel-with-Formatting-in-Cshar\">http:\/\/www.codeproject.com\/Tips\/406704\/Export-DataTable-to-Excel-with-Formatting-in-Cshar<\/a> <\/p>\n<p>Have a nice day.<\/p>\n<\/p><\/div>\n<div class=\"mt24\"><\/div>\n<\/div>\n<p>            <span class=\"d-none\" itemprop=\"commentCount\"><\/span> <\/p><\/div>\n<\/div>\n<p>[ad_2]<\/p>\n<p>solved How to load a value from a DataTable to Excel programmatically? [closed] <\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad_1] There are many ways to export Dataset into Excel. Here is a very simple function to export data without using excel object and other messy stuff. XSL Transformation is applied to dataset and XML for excel is generated. You have to pass it the DataSet to export and path to where file should be &#8230; <a title=\"[Solved] How to load a value from a DataTable to Excel programmatically? [closed]\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-how-to-load-a-value-from-a-datatable-to-excel-programmatically-closed\/\" aria-label=\"More on [Solved] How to load a value from a DataTable to Excel programmatically? [closed]\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[751,2001,3448,400],"class_list":["post-22798","post","type-post","status-publish","format-standard","hentry","category-solved","tag-asp-net","tag-datatable","tag-email-attachments","tag-excel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>[Solved] How to load a value from a DataTable to Excel programmatically? [closed] - JassWeb<\/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:\/\/jassweb.com\/solved\/solved-how-to-load-a-value-from-a-datatable-to-excel-programmatically-closed\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] How to load a value from a DataTable to Excel programmatically? [closed] - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] There are many ways to export Dataset into Excel. Here is a very simple function to export data without using excel object and other messy stuff. XSL Transformation is applied to dataset and XML for excel is generated. You have to pass it the DataSet to export and path to where file should be ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-how-to-load-a-value-from-a-datatable-to-excel-programmatically-closed\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-21T12:15:58+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\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:\/\/jassweb.com\/solved\/solved-how-to-load-a-value-from-a-datatable-to-excel-programmatically-closed\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-to-load-a-value-from-a-datatable-to-excel-programmatically-closed\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] How to load a value from a DataTable to Excel programmatically? [closed]\",\"datePublished\":\"2022-11-21T12:15:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-to-load-a-value-from-a-datatable-to-excel-programmatically-closed\/\"},\"wordCount\":103,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"asp.net\",\"datatable\",\"email-attachments\",\"excel\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-to-load-a-value-from-a-datatable-to-excel-programmatically-closed\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-how-to-load-a-value-from-a-datatable-to-excel-programmatically-closed\/\",\"name\":\"[Solved] How to load a value from a DataTable to Excel programmatically? [closed] - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-11-21T12:15:58+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-to-load-a-value-from-a-datatable-to-excel-programmatically-closed\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-how-to-load-a-value-from-a-datatable-to-excel-programmatically-closed\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-to-load-a-value-from-a-datatable-to-excel-programmatically-closed\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] How to load a value from a DataTable to Excel programmatically? [closed]\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] How to load a value from a DataTable to Excel programmatically? [closed] - JassWeb","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:\/\/jassweb.com\/solved\/solved-how-to-load-a-value-from-a-datatable-to-excel-programmatically-closed\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] How to load a value from a DataTable to Excel programmatically? [closed] - JassWeb","og_description":"[ad_1] There are many ways to export Dataset into Excel. Here is a very simple function to export data without using excel object and other messy stuff. XSL Transformation is applied to dataset and XML for excel is generated. You have to pass it the DataSet to export and path to where file should be ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-how-to-load-a-value-from-a-datatable-to-excel-programmatically-closed\/","og_site_name":"JassWeb","article_published_time":"2022-11-21T12:15:58+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-how-to-load-a-value-from-a-datatable-to-excel-programmatically-closed\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-how-to-load-a-value-from-a-datatable-to-excel-programmatically-closed\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] How to load a value from a DataTable to Excel programmatically? [closed]","datePublished":"2022-11-21T12:15:58+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-how-to-load-a-value-from-a-datatable-to-excel-programmatically-closed\/"},"wordCount":103,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["asp.net","datatable","email-attachments","excel"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-how-to-load-a-value-from-a-datatable-to-excel-programmatically-closed\/","url":"https:\/\/jassweb.com\/solved\/solved-how-to-load-a-value-from-a-datatable-to-excel-programmatically-closed\/","name":"[Solved] How to load a value from a DataTable to Excel programmatically? [closed] - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-11-21T12:15:58+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-how-to-load-a-value-from-a-datatable-to-excel-programmatically-closed\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-how-to-load-a-value-from-a-datatable-to-excel-programmatically-closed\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-how-to-load-a-value-from-a-datatable-to-excel-programmatically-closed\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] How to load a value from a DataTable to Excel programmatically? [closed]"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/22798","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=22798"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/22798\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=22798"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=22798"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=22798"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}