Using OWC to access an Excel file with linked SQL Server

[Comcast]

Hello,

I have an Excel spreadsheet with a table in SQL Server as
an extenal data source. I am using C# to access this
spreadsheet using OWC(10) on the web server in an ASP.NET
application.

The goal is to change a cell's value in Excel through
server-side code based on input on a web form, let Excel
grab the related data from SQL Server, perform its
calculations, and put results in another cell. The
server side code would then grab the results from the
Excel and display it in the browser.

The challenge that I am facing here is that for some
strange reason, the data from SQL Server does not get
refreshed in Excel. When I use the same spreadsheet in
interactive mode (meaning not through server side code),
as soon as I change the value in the input cell, the data
from SQL Server gets refreshed in the spreadsheet
immidiately. I have already tried calling the Refresh,
Calculate, and CalculateFull methods on the spreadsheet
object -- but no success.

Any help will be deeply appreciated.

Thank you.

 

[Alvin Bruney]

If I got you right, the server side excel object is not interactive. When
you change values you will need to stream that data out to the client all
over again. I hope it didn't miss what you were asking.