Is there any free or purchased library or any API which allows me to update excel sheet while it is opened also.
Asked
Active
Viewed 2,159 times
4
-
As far as I know it is not possible to edit a excel sheet the same time. All you can do is open it read only, but then you can also make a copy and open it. The problem will always be how to sync the data then. There are some solutions in the past (don't know if they still exists) that transfer a sheet into a multi editable webpage (the program called Excel worksheet Server, was from a german company, but no clue if this still exists). – YvesR Jan 06 '12 at 07:46
-
See http://stackoverflow.com/questions/7852894/basic-of-xll-excel-addin-need-to-invoke-a-c-sharp-api-from-excel/7854055#7854055 and http://stackoverflow.com/questions/3840270/fastest-way-to-interface-between-live-unsaved-excel-data-and-c-sharp-objects and http://stackoverflow.com/questions/8129580/copying-mapping-data-between-excel-spread-sheets-vb-net – Jon49 Jan 06 '12 at 15:06
4 Answers
1
I'm not certain of the nature of your project, but perhaps you could create an Office Add-In? I've had some very good experiences with Add-In-Express: http://www.add-in-express.com/add-in-net/index.php
If just creating an add-in isn't going to work for your application, consider writing a plugin that your application can communicate with to do the work for you behind the scenes.
apiguy
- 5,282
- 1
- 23
- 24
1
If you want your Excel spreadsheet to be updated in real time, you have to develop an RTD which can be queried by Excel itself. Please refers to Microsoft documentation for that. Add-In express provides you excellent simplified API to develop that, we are using them and we are very happy with that.
Edmondo
- 19,559
- 13
- 62
- 115
0
There is no tool that can do that since the file is locked by the operating system.
linkerro
- 5,318
- 3
- 25
- 29
0
With COM you should be able to drive a workbook that has been opened by the user.
Mark Robbins
- 2,427
- 3
- 24
- 33