Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using OWC10 to access an Excel file with linked SQL Server
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 OWC10 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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving linked files from one server to anoter one | Excel Worksheet Functions | |||
how to make Excel linked to SQL Server 2005 worksheet editable? | Excel Discussion (Misc queries) | |||
Displaying linked data in excel 2007 when linked file is not avail | Excel Discussion (Misc queries) | |||
Can't Access Charts Linked to Files on Server | Excel Discussion (Misc queries) | |||
Excel File Linked in Access | Excel Discussion (Misc queries) |