Reading and Writing Excel Spreadsheets Using ADO.NET C#

Hot Topic

Destructor doesn’t function in release mode
How to import display flash in visual studio C#?
Program Crashes. :(
Is there any way to implement an application that close other running application???
multiple backgroundworkers filling multiple datasets at once
MapPoint - Faster Route Calculation (Performance Problem)
Same KEY & IV for TripleDES Encryption as well as Decryption in 2 different Win Services.
Music
Three Dimentional array
Switch statement

Visual C#

Build Events Error
Private constructor
Long serial number.
Join W2K Domain
Class Property (Accessor)
Best way to achieve this?
finding documents and settings directory.
SSaver -finding the bottom of the screen
Abstract Generic Base Classes... how to refer to the derived type?
Form control properties auto layout feature

Reading and Writing Excel Spreadsheets Using ADO.NET C#

Hi all, (apologies if this is in the wrong section)

I am trying to read and write to an excel spreadsheet in c#. I want to put a web form on the front-end that will allow the user to read and write to the spreadsheet.

This is a good tutorial i found: http://davidhayden.com/blog/dave/archive/2006/05/26/2973.aspx

Though i don't know where abouts to put the code.

Any help, any working examples please

Thanks in advance.

Answer this question

Reading and Writing Excel Spreadsheets Using ADO.NET C#

  • Tracey Macias

    Why are you trying to run a website from an Excel file The example you gave is a standalone app to place data into a database...hence it doesn't fit in your scheme.

    You may want to look into Visual Studio Tools For Office (VSTO) and create a C# addin in a specific Excel file that will allow the user to modify the sheet...

    Here is information on VSTO tour and read this post, Can a VSTO 2005 Excel application be started from a Web site. Look at my response, which gives a design for usage which could apply to your situation and see if it interests you. If it does see the Capital Expenditure VSTO example.

    Otherwise check out some SQLStarter Kits which may be related. Good Luck.




  • Reading and Writing Excel Spreadsheets Using ADO.NET C#
Answer this question