469,623 Members | 1,439 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,623 developers. It's quick & easy.

Retrive data from an client side Excel source

Hello

I'm looking for an solution about how to retrive data from an client side
located Excel document by using an ASP.Net application. I don't want to
upload the file to the server. I just want to get the data and persist it in
an database after that some business validation have been done.

Does anyone have any idea?
Mar 30 '07 #1
3 1840
"Peter J, Scania" <Pe**********@discussions.microsoft.comwrote in message
news:CC**********************************@microsof t.com...
I'm looking for an solution about how to retrive data from an client side
located Excel document by using an ASP.Net application. I don't want to
upload the file to the server. I just want to get the data and persist it
in
an database after that some business validation have been done.

Does anyone have any idea?
You're going to really struggle with this, especially if this is a public
Internet app...

If you don't want to upload the Excel spreadsheet, you're going to have to
develop an ActiveX solution to open the spreadsheet client-side and extract
the data you want.

Obviously, you'll have to really ramp down the security in order to do this,
as under normal circumstances web browsers have no interaction with the
client hardware...

Obviously, ActiveX controls will only work in IE...

Is there any particular reason you don't want to upload the spreadsheet to
the server...? If you did that, this would be a fairly simple matter...
Mar 30 '07 #2
Hello Mark

I agree with you on the security issue.

Is it possible to stream the spreadsheet to the server and from there
retrive the data I want to handle? Or do you have other solutions?

\Peter

"Mark Rae" wrote:
"Peter J, Scania" <Pe**********@discussions.microsoft.comwrote in message
news:CC**********************************@microsof t.com...
I'm looking for an solution about how to retrive data from an client side
located Excel document by using an ASP.Net application. I don't want to
upload the file to the server. I just want to get the data and persist it
in
an database after that some business validation have been done.

Does anyone have any idea?

You're going to really struggle with this, especially if this is a public
Internet app...

If you don't want to upload the Excel spreadsheet, you're going to have to
develop an ActiveX solution to open the spreadsheet client-side and extract
the data you want.

Obviously, you'll have to really ramp down the security in order to do this,
as under normal circumstances web browsers have no interaction with the
client hardware...

Obviously, ActiveX controls will only work in IE...

Is there any particular reason you don't want to upload the spreadsheet to
the server...? If you did that, this would be a fairly simple matter...
Mar 30 '07 #3
"Peter J, Scania" <Pe**********@discussions.microsoft.comwrote in message
news:46**********************************@microsof t.com...
Is it possible to stream the spreadsheet to the server and from there
retrive the data I want to handle? Or do you have other solutions?
Absolutely!

1) Use an <asp:FileUploadwebcontrol to allow the user to specify what
spreadsheet to upload
http://msdn2.microsoft.com/en-us/lib...ileupload.aspx

2) Use ADO.NET to extract the data
http://www.google.co.uk/search?sourc...DO%2eNET+Excel
Mar 30 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Mel | last post: by
6 posts views Thread by insirawali | last post: by
reply views Thread by devrayhaan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.