Connect to remote Excel

  • Thread starter Thread starter jcotroneo
  • Start date Start date
J

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
 
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
/// ------------------------------
 
Back
Top