Excel作为网络上的一个计算引擎？ [英] Excel as a calculation engine on the web?
问题描述
我已经写在Excel中现有的业务应用程序，客户想使在网络上进行访问。
我开始想我将不得不重新实现它，但是它已经发生了，我认为这将使工作更加轻松，保持在s preadsheet的知识和价值，使新的工具，如果我更灵活可以在现在的S preadsheet连接从ASP.NET数据源，并使用它作为一个引擎。
这听起来像一个很好的解决方案，直到我认为Excel中会催生一个新的进程为每个连接，我们可能会得到锁定问题。
这是假设是正确的？有没有我可以用它来管理这个组件？
请注意：我看到的Excel Services，但Sharepoint的是不是一种选择。该应用程序将是面向公众的网站，但只有某些用户将被允许访问该应用程序。保守估计：其中一半1000月活跃用户已支付访问应用程序
的办公自动化不是由MS在这种情况下 ...
MS提供的OpenXML SDK 2.0版 - 见 HTTP ：//msdn.microsoft.com/en-us/library/bb448854%28office.14%29.aspx
这可以读+写MS Office文件（包括Excel）...
另一种方法请参见 HTTP：//www.$c$cproject.com /KB/office/OpenXML.aspx
如果您需要更多像渲染，公式等，然后有喜欢的Aspose.Cells和FLEXCEL不同的商业库和S preadsheetgear ...
I have an existing business application written in Excel which the client would like to make accessible on the web.
I started off thinking I would have to reimplement it, however it has occurred to me that it would make the job much easier, maintain the knowledge and value in the spreadsheet and make the new tool more flexible if I could connect the existing spreadsheet as a data source from ASP.NET and use it as an engine.
This sounded like a good solution until I considered that Excel would spawn a new process for each connection and we would likely get locking issues.
Is this assumption correct? Is there a component that I could use to manage this?
Note: I have seen Excel Services but Sharepoint is not an option. The application will be a public facing website but only some users will be allowed to access the application. Conservative estimate: 1000 monthly active users of which half have paid to access the application.
Office automation is NOT supported by MS in this scenario...
MS provides the OpenXML SDK V 2.0 - see http://msdn.microsoft.com/en-us/library/bb448854%28office.14%29.aspx
This can read+write MS Office files (including Excel)...
Another option see http://www.codeproject.com/KB/office/OpenXML.aspx
IF you need more like rendering, formulas etc. then there are different commercial libraries like Aspose.Cells and Flexcel and Spreadsheetgear...
这篇关于Excel作为网络上的一个计算引擎？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
