Libraries for ASP.net that show Excel spreadsheets interactively...

[emilyragsdale]

I'm doing research for my employer, and I'm looking for a library for ASP.net that allows you to post an Excel spreadsheet online and have clients enter their data, saving and storing the data on our computer. I'm completely clueless, is this possible? And if so, what program would do the trick. This is all the info I have on the subject, so any help would be greatly appreciated. Thanks!

[cemenc]

I know this may not be helpful , but I though I should tell you this anyway,

There are lot of component builders that sells kind of object (control). look as www.asp.net you will find lots of company there. They are not cheap I tell you this ahead.

http://asp.net/default.aspx?tabindex=6&tabid=31

also, I am working on a personal project that reads excel files and displays them, here is the code I have ;

Dim myConnectionString As String
Dim myConnection As OleDbConnection
Dim myCommand As OleDbCommand
Dim myDataReader As OleDbDataReader
Dim at As String
Try
Dim sloc As String = MapPath("filesfolder/myexcelfile.xls")
Dim fileExists As Boolean
fileExists = My.Computer.FileSystem.FileExists(sloc)
If fileExists = False Then
Response.Write("File exists = " & fileExists & "</br>")
Exit Sub
Else
Response.Write("File exists = " & fileExists & "</br>")
End If
myConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" _
& "Data Source=" & sloc & ";" _
& "Extended Properties=Excel 8.0;"
myConnection = New OleDbConnection(myConnectionString)
myCommand = New OleDbCommand("SELECT * FROM [3DHDistributing-bagscarrycasesA.xls$] where quantity>0;", myConnection)
myConnection.Open()
myDataReader = myCommand.ExecuteReader()

While myDataReader.Read
'For i = 0 To myDataReader.FieldCount - 1
' Response.Write(myDataReader(i))
'Next

Catch ex As Exception
Response.Write(ex.Message & " Error Line #" & Err.Erl)
End Try

End While

myDataReader.Close()
myConnection.Close()
Catch ex As Exception
Response.Write(ex.Message & " Line # " & Err.Erl & "</br>")
End Try


I hope this gives you an idea. I can picture you using this connection sample to import an excel file into datagrid and have your clients change anything and update it back with the excel file.

just a suggestion