>>I have a request to allow a user to enter a mass amount of SQL server records in an interface like Excel that allows for features like fill down, fill right, etc. Has anybody ever done this, and how much work is it?
>
>Are you expected to Ctrl R and D, or put in that fill box/handle and just fly with that?
>
>Have you considered putting Excel on your form, and then take the data sheet they generate and insert to your backend from there?
I want the functionality to mimic Excel as much as possible.
I played around a bit with putting an Excel component on my form, but it didn't seem as fully featured as Excel.
Another gotcha is that they want this on a web form in .NET 1.1.