问题描述
我正在寻找有关用于 ASP MVC 环境的类似电子表格的输入工具的建议.
I'm looking for recommendations for a spreadsheet-like input facility to sit in an ASP MVC environment.
客户目前拥有大量非常复杂的相互关联的共享电子表格(他们有效地运行 90% 的核心业务)用于收集和处理信息.他们希望将其移动到 Web 应用程序并需要 ASP MVC.他们意识到他们将无法像目前使用电子表格那样在屏幕上显示尽可能多的信息，因此在大多数情况下，40 x 60 的网格就足够了.其中，它们将是用于数据输入的有限数量的单元格，这些单元格将使用各种类似电子表格的公式立即更新网格中的其他单元格.网格必须启用 AJAX.
The client currently has a large number of very complex interlinked shared spreadsheets (which they are effectively running 90% of their core business from) for collecting and processing information. They wish to move this to a web application and require ASP MVC. They realise that they will not be able to display as much information on screen as they do currently with their spreadsheets, so a 40 x 60 grid should suffice in most cases. Of this they'll be a limited number of cells for data entry that will immediately update other cells in the grid using various spreadsheet-like formula. The grid must be AJAX enabled.
用户界面的质量是这里的首要问题.由于转移到数据库/网络不可避免地会有一定的阻力(无论如何这个项目是一个试点)，系统必须尽可能地光滑.几乎同样重要的是易于实施 - 最终系统将非常大，因此配置网格越快越好.
The quality of the user-interface is of primary concern here. As inevitably there will be a certain amount of resistance to move to database/web (and this project is a pilot anyway) the system must be as slick as possible. Almost as important is ease of implementation - the final system will be quite large so the quicker it is possible to configure the grid the better.
开源或商业都可以.HTML/Javascript、Silverlight 和 Flex 实现都可以考虑.
Either Open Source or commercial would be fine. HTML/Javascript, Silverlight and Flex implementations can all be considered.
我在一年前最初问过一个类似的问题(客户花了很长时间才同意该项目)，但我确信从那时起选项已经改变，我们的环境现在得到了更好的定义.
I initially asked a similar question a year ago (it's taken that long for the client to agree the project) but I'm sure options have changed since then and our environment is now better defined.
推荐答案
Microsoft Silverlight.对于具有 Web 部署的丰富业务应用程序，它几乎可以肯定是您的最佳选择.它将允许您在后端和前端组件中使用一致的代码库.
Microsoft Silverlight. It is almost certainly your best bet for a rich line of business application with web deployment. It will allow you to utilise a consistent code base across your back-end and front-end component.
虽然存在许多商业数据网格包(Telerik 等)，但我建议使用可用的默认 Datagrid 组件，并充分了解可用的数据绑定和模板选项.
Whilst a number of commercial datagrid packages exist (Telerik, etc), I'd suggest using the default Datagrid component that is available, and understanding fully the databinding and templating options available.
这篇关于类似于 ASP MVC 的输入工具的电子表格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！