Loading

how to display excel sheets on aspx page for dataEntry

vaquas khan

16y6.4k.NET

please help me....

how can i display excel sheets on my aspx page for data entry from users and save these value in sql database...

i am using the SQL dataabse 2005, Visual Studio 2008 with C#

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

paul daniel16y ago
Hi

Refer this link

http://www.beansoftware.com/asp.net-tutorials/generating-excel-reports.aspx
0
Andrew Fenster16y ago
The short answer is that you shouldn't do it.

There are lots of articles about how to use Excel or Word on the fly inside a web application. Microsoft, however, recommends that you NOT do this. See http://support.microsoft.com/kb/257757 . The big problem is that this causes memory leaks, slow performance and crashes. So Nikhil's suggestion is correct. Have them enter the data in a GridView or other data control.
0