How to read excel cells from database using asp.net?
I'd like to upload an excel file from a user into a SQL database, then capture certain cells and insert them into a table in the database. I can't upload the file to the server due to restrictions, but I can upload it into a database field. I've seen examples on how to read cells from an uploaded excel file on the server, but how do you read cells from an excel file stored in the database?
I'm using visual studio 2005 and SQL server 2008. Can this be done by reading from a stream? I'm not sure wher开发者_高级运维e to start on this.
精彩评论