Geeks With Blogs
Rodney Vinyard - .NET & SQL Developer When all is said and done, more will be said than done

OpenXML SDK 2.0: Export a DataTable to Excel

Very good article and download project

http://lateral8.com/articles/2010/3/5/openxml-sdk-20-export-a-datatable-to-excel.aspx

 

The DocumentFormat.OpenXml.dll is registered in the GAC when the SDK is installed so it doesn't physically copy it to your project's output folder by default when you build the application.  If you select the option to Show All Files in Visual Studio (Project | Show All Files), you'll see a References node appear in your VB.NET project in the Solution Explorer.  Expand it, select DocumentFormat.OpenXml, view it's properties, and set the Copy Local option to True so that it copies it to the output folder when you build the app.  You can then copy it along with the app to any other PC and it will run without having to install the SDK on them.

 

Posted on Thursday, October 6, 2011 7:01 AM Excel | Back to top


Comments on this post: OpenXML SDK 2.0: Export a DataTable to Excel

# re: OpenXML SDK 2.0: Export a DataTable to Excel
Requesting Gravatar...
Left by raheja upcoming project on Mar 29, 2012 5:09 AM

Your comment:
 (will show your gravatar)


Copyright © Rodney Vinyard | Powered by: GeeksWithBlogs.net