如何使用ASP.NET CODE打开Excel文件刷新Excel工作表中的数据 [英] How to refresh the data in Excel sheet with opening the Excel file using ASP.NET CODE

问题描述

朋友，

谁能告诉我如何在不打开Excel表格的情况下刷新它.
对于我的项目，我有一个Excel文件作为数据库.但是，excel文件中的数据只有在打开，保存和关闭后才会刷新.
现在的问题是我必须在网页上显示来自此excel文件的实时数据.
请帮忙..

问候
Kishor

Hi Friends,

Can anyone please tell me how to refresh an excel sheet without opening it.
For my project i have an excel file as a database. However the data in the excel file will refresh only if it is opened, saved and closed.
Now the problem is that i have to display the real time data from this excel file on a webpage.
Please help..

Regards
Kishor

推荐答案

我知道的唯一方法是执行以下操作:
1.使用服务定期使用Web服务API在Excel Services中打开文件.
2.调用RefreshAll()方法.
3.调用GetWorkbook()
4.使用SharePoint API保存回文档库.

The only way to do this that I know of is to do the following:
1. Use a service to periodically use the Web Services API to open the file in Excel Services.
2. Call the RefreshAll() method.
3. Call GetWorkbook()
4. Use SharePoint API to save back to the document library.

这篇关于如何使用ASP.NET CODE打开Excel文件刷新Excel工作表中的数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！