Excel services part 5: all about “interactivity”
Excel services (第5部分):介绍“交互”
Now that I have discussed publishing spreadsheets to Excel Services, let’s review how users can “interact” with spreadsheets that Excel Services has generated. To start, I want to explain what we mean by “interact” because it is anther development-team term that may not be clear to everyone reading this article.
到目前为止,我已经讲述了将电子表格发布到Excel Services上的方法,现在来介绍用户如何与Excel Services上的电子表格交互。首先,我想解释一下”交互”的含义,因为这是另一个开发团队的项目,读这篇文章的人可能对此不太清楚。
When we set about building Excel Services, we wanted to provide a richer experience than simply displaying a static spreadsheet in a browser. For example, we wanted users to be able to be able to change sorts and filters to better understand data they were looking at without leaving the context of the browser. We wanted users to be able to adjust PivotTables to see exactly they data they wanted to see in order to make better business decisions, again without leaving the context of the browser. We wanted users to be able to set parameters to perform what-if analysis, again from within their browser. We call all these sorts of things “interactivity”, since they involve the user taking actions that change the spreadsheet the user is working with, but do so without leaving the context of the browser.
当我们着手建立Excel Services时,我们希望提供更丰富的用户体验而不是简单地在浏览器中显示静态的电子表格。例如,我们希望用户不必离开浏览器页面就能变换排序和筛选来更好地理解他们正在查看的数据;能调整数据透视表以确切地看到他们想要的数据以便于做更好的商业决策;在浏览器页面就能设置参数来执行假设分析。上述这些都称作”交互”,即用户不须离开浏览器页面就能处理电子表格。
Specifically, our goals in this area are to allow users to:
具体地讲,我们的目标是允许用户能做如下操作:
• view spreadsheets in a browser
• 在浏览器中查看电子表格
• navigate around those spreadsheets
• 在那些电子表格中切换
• perform further exploration of the data in those spreadsheets
• 在(浏览器的)电子表格对数据进行进一步的处理
• change parameters to facilitate what-if analysis in said spreadsheets
• 在上述电子表格中变化参数便于进行假设分析
We did not have a goal to enable full-blown authoring of spreadsheets in a browser – to author spreadsheets, users will need Excel 12. Also, we did not have time to enable every feature in Excel 12 in the browser, so we focused on features based on the four goals outlined above. Finally, it is worth noting that if the user has permission, they can always press one button to open the spreadsheet in Excel 12, and they can then do anything they want.
我们并不打算允许在浏览器中能够完全编辑电子表格——为了编辑电子表格,用户需要使用Excel 12。并且,我们也没有必要在浏览器中能够应用Excel 12的每一个功能,因此,我们将功能主要集中在上述4个目标上。此外,如果用户有权限的话,他们能在浏览器中通过使用一个按钮启动Excel 12打开电子表格,并对它进行任何编辑操作。
Generally, when we talk about interactivity, we generally group the features we enabled into three areas: worksheets, tables, and PivotTables. Let’s take a look at the details of what we did in each area.
通常,当我们谈到交互时,一般集中谈论在工作表、列表和数据透视表中所能实现的功能。先看一下我们在这些方面所做的具体内容。
Interactivity – Worksheets
交互——工作表
As we have already seen, when a user is viewing an Excel-Services-generated spreadsheet in a browser, the visual fidelity between the Excel Services spreadsheet and Excel 12 is very good. Excel Services supports the same layout and formatting capabilities as Excel 12, so to users, a spreadsheet viewed in Excel 12 will look exactly the same as a spreadsheet in a browser (within the constraints of HTML). This includes basic formatting (e.g. row height and column width, font, colour, grid lines on or off, text rotation, etc.) as well as the new features I have already talked about like Data Bars, Colour Scales, Table Styles, and some others I have yet to discuss like charts.
正如我们所看到的,用户在浏览器中查看的由Excel Services创建的电子表格与Excel 12非常相似。Excel Services支持与Excel 12相同的页面布局和格式功能,因此,对用户来说,在Excel 12中的电子表格与在浏览器(仅适用HTML语言)中的电子表格外观相同。包括基本的格式(例如,行高和列宽、字体、颜色、开启和关闭网格线、文字方向等等),就像我已经介绍过的新功能如Data Bars, Colour Scales, Table Styles以及将要介绍的图表等一样。
上一篇:excel宏教程:Excel2007的新特性(一) 下一篇:xcel表格制作教程入门:Excel定义名称的3种方法
郑重声明:本文版权归原作者所有,转载文章仅为传播更多信息之目的,如作者信息标记有误,请第一时间联系我们修改或删除,多谢。