Save Dataset in .xls file

Question

Hello Everyone

I need to save dataset in .xls file on a shared drive. How can I acheive this ?
I have no clue how to proceed and I will appreciate if anyone can even tell me in
which direction to proceed.

Thank you.
C_sharpkid

Ivan Vasilyev · Answer

Hi here is another approach which you can try: // Create new ExcelFile. var workbook = new ExcelFile(); // Imports all tables from DataSet to new file. foreach (DataTable dataTable in dataSet.Tables) { // Add new worksheet to the file. var worksheet = workbook.Worksheets.Add(dataTable.TableName); // Insert the data from DataTable to the worksheet starting at cell A1. worksheet.InsertDataTable(dataTable new InsertDataTableOptions(A1) { ColumnHeaders = true }); } // Save the file to XLS format. workbook.Save(\shared\DataSet.xls); The code uses an excel component for .NET framework .

Mahesh Chand · Answer

You need open a connection with an Excel document and use Data adapter to save the data back to the sheet. Here is some basic info. Also look at Office .NET section of http://www.c-sharpcorner.com/Code/2002/Sept/ODBCDataProvider1.asp http://www.c-sharpcorner.com/Code/2003/May/Excel2003fromCSharp.asp http://www.c-sharpcorner.com/Code/2004/June/AccessExcelDb.asp