Connect to remote Excel

[jcotroneo]

Hi all, we need to be able to connect to an Excel in a remote server
via ADO.NET.

We have a component that makes queries to that excel a retrieves the
data requested, but when we are trying to get the data from the remote
excel we can´t connect because we have an URL and not a physical path.

Any idea?


thanks in advance

Julio

 

[Guest]

Mmm...

Is the excel spread sheet quite big? One possiblity could be to download
the sheet from your site and then read it locally, you can use WebClien class
to do that:

http://www.csharpfriends.com/Articles/getArticle.aspx?articleID=115

On the other hand if what you are looking for is to use the Excel
calculation engine and let your client define his calculation in a excel
sheet, you could use "Excel services" (running excel spreadsheets on a
server):

http://blogs.msdn.com/excel/archive/2005/11/08/490502.aspx

Good Luck
Braulio

/// ------------------------------
/// Braulio Diez
///
/// http://www.tipsdotnet.com
/// ------------------------------