Office Open XML Format file creation

Question

i want to open a new xl sheet thru ofice open xml format. and how to export the datatable records to that xl sheet without loop.

Answer 1

Here's a tutorial that shows how to inject the contents of a DataTable into a template Excel worksheet. It uses the Microsoft OpenXML SDK in conjunction with ExtremeML, an open-source extension library.

The accompanying tutorials in the series demonstrate how to perform similar operations using other data sources, such as arrays, DataSets and Linq.