Office Open XML Format file creation

i want to open a new xl sheet thru ofice open xml format. and how to export the datatable reco开发者_JS百科rds to that xl sheet without loop.

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.