Get Data on excel sheet using stored procedure

Question

hi As we all know that in excel sheet there is a option of get external data in data tab in MS Office-2007 & 2003. Here we can use wizard to get the data from database using queries and SPs. Similarly Now i want to get the data on excel sheet using stored procedure in my application which is in C#.Net. Any Help will be appreciated. Thanks A.Eagle

Anurag vatsa · Answer

Its a bit differnt from usual problem. Yet To get any solution

Andrew Fenster · Answer

You wouldn't do it in the stored procedure. You would use C# to read the spreadsheet and then update the database. It's not very hard to do in .Net. There are classes for Cell Column Row Sheet Range etc. These allow you to pick a sheet a column or an individual cell and read the data. (You can update the data too.) Once you get started coding is pretty intuitive. For example: foreach (Row row in Worksheets[0].Rows) { for (int column = 1; column { row.Cells[1 column].Text = Andy; } } You can also use .Net to open a spreadsheet as if it were a database and then use a DataReader. http://www.davidhayden.com/blog/dave/archive/2006/05/26/2973.aspx I don't think this is the best way to go. Good luck!

Anurag vatsa · Answer

The same output is supposed to done programatically in C#.net