This project has moved and is read-only. For the latest updates, please go here.

How to use closed xml to create excel file ?

Jan 3, 2014 at 8:10 AM
Hello People, I searched in web and i got to tht openxml-sdk helps us to create excel file and also i found closed xml makes it simpler. But i couldn't find how to use the simple way (closed xml) .

What i did- 1) created a asp.net project with jqgrid (exporting to excel remains)
2) Downloaded the closed xml file (to create the excel file)

My Doubts - 1) Should i install Open xml sdk to use closed xml? 2) How to use the "Closedxml.dll" and "Closedxml" i mean where to add these file in my project to create excel file?
Jan 8, 2014 at 6:41 PM
1) Yes. the open xml sdk 2.0 needs to either be installed on the system where you test or deploy your application, or it needs to be referenced as part of the project and marked as Copy Local = True
2) ClosedXML should be referenced in your project and marked as Copy Local = True. You can put the closedxml.dll as part of the project area or elsewhere as long as it is referenced and marked Copy Local = True which will make it part of the delivered code set.
Marked as answer by inandasram on 1/8/2014 at 10:42 PM