Export Oracle SQL query result in to Excel

Jan 15, 2014 at 2:31 AM
I am trying to create a very simple WPF application on .Net 4.0 using C# and Oracle as a backend database. Everything works fine, i can pull the data I want (using oracle sql queries)from the database and fill the UI DataGrid. But,

1) I am trying to see that If it is possible to dump(export) the entire result in to an excel work sheet(created using ClosedXML).

2) I would want to name the work sheet, a value of a particular cell from the result.

Please advise. Thanks!!