Create excel worksheet

Nov 10, 2009 at 1:43 PM

I need help creating an excel worksheet with data from a datareader. Are there any examples on how I would go about doing this? My goal is exporting data from multiple tables (SQL server) into an excel document each table having its own worksheet. Im a bit lost of how to do it with this wrapper..

Nov 10, 2009 at 2:09 PM

There are no built-in function for import/export with datareader.

You must load data from SQL server by your self, then create(or use existing) worsheet and set the "Values" property of the cells.