彩票走势图

Aspose.Cells for Reporting Services概述

常见用途：

将RDL报告导出为以下格式    

• Excel 97-2003 Binary XLS
• Spreadsheet ML
• Excel 2007 XLSX
• Excel 2007 XLSM
• CSV
• TXT (Tab Delimited Text)

支持的格式

支持一般的电子数据表格，文本和元语言文件格式 。

功能描述

无需安装MS Excel

Aspose.Cells for Reporting Services是一种令人难以置信的通用组件,它允许开发人员在不需要安装MS Excel或MS Office的情况下创建、管理和操作Excel电子表格。 原生Excel 格式 Aspose.Cells for Reporting Services对于MS SQL Server报告服务和微软的报表查看器来说是一种渲染扩展。

在安装Aspose.Cells for Reporting Services 之后，将会添加下列文件导出格式。

• S - Excel Workbook via Aspose.Cells
• Excel2007Xlsx - Excel 2007 via Aspose.Cells
• Excel2007Xlsm - Excel 2007 via Aspose.Cells
• SpreadsheetML - SpreadsheetML via Aspose.Cells
• CSV - CSV via Aspose.Cells
• TXT- TabDelimited text via Aspose.Cells
• HTML - HTML via Aspose.Cells.

高级特性

有两种公式可供用户使用：有两种类型的公式,用户可以利用:一个是报告服务公式,另一个是Aspose.Cells for Reporting Services提供的MS Excel动态公式。报告服务公式使用起来和Visual Studio所提供的公式是一样的。用户可以根据报告模板单元格中的数值设置报告服务公式,公式将被计算，计算结果将在渲染时发送回单元格中。与报告服务公式不同,MS Excel的动态公式不会被计算而是转换为一个真正的具有一定的规则和法规MS Excel表达式,然后送回单元格中。

设计师工具

用户可以直接使用Aspose.Cells.Report.Designer向MS Excel中设计并交付报告。 设计师是我们简单和易于使用的设计工具。这意味着用户不需要使用Visual Studio创建报告。因此,用户无需购买额外的Visual Studio许可证，也可降低熟悉我们工具的训练要求，从而能够节省费用。 随着Aspose.Cells.Report.Designer将MS Excel作为一个报告模板,用户可以因此利用包括数据透视表、交互式图表,VBA,宏和公式在内的MS Excel强大功能和特性。这些属性并不支持由Reporting Services 所发送的标准MS Excel格式。此外he Aspose.Cells.Report.Designer可以在两种报告定义格式中创建报告，并支持Microsoft SQL Server 2000、2005或2008年Reporting Services。

灵活的显示选项

Aspose.Cells for Reporting Services使您可以完全控制页面设置,并允许您操纵一个广泛的显示选项,例如;预览页面分页和为工作表设置缩放级别、使用冻结窗格控制数据可视化,设置页面方向、缩放、纸张的大小、页眉/页脚和打印区域等。

安全特性

Aspose.Cells for Reporting Services提供了广泛的安全特性,比如;支持Excel 2007 XLSX文件的加密/解密、保护内容、对象和工作表的脚本和隐藏/显示工作表。

操纵行列

Aspose.Cells for Reporting Services允许您以多种不同方式操纵行和列。您可以按照要求轻松调整行高和列的宽度,根据单元格内容自动调节单元格宽和高、插入或删除,隐藏或显示，合并或拆分行和列。

数据处理

Aspose.Cells for Reporting Services支持带有分组行和页脚的表格。行和页脚的分组可以像其他报表条目一样在设计时设置。Aspose.Cells for Reporting Services也支持参数和全局变量作为报告的数据源。用户还可以使用MS Query创建数据源和查询,这是一种广泛使用的工具，并被大多数用户熟悉。 此外Aspose.Cells for Reporting Services同时支持在Report Server上提前创建的报告特定数据源和共享的数据源。此外,用户可以在设计时使用报告特定数据源，在发表报告时将共享数据源指定为报告数据源。Aspose.Cells for Reporting Services可以无缝地整合Microsoft Reporting Services,因此用户可以充分利用Reporting Services的报告管理、安全和交付选项。

广泛的平台支持

Aspose.Cells for Reporting Services使您能够完全控制在高级格式特性中数据的呈现形式。你可以应用格式工作表、行、列和单元格。你也可以添加Rich Text到单个单元格，并能应用不同的边界,背景图案和字体。条件格式也可以被应用到单元格中。

创建图表

Aspose.Cells for Reporting Services带有完整的图表支持和支持所有标准图表类型。你可以很容易地添加使用产品API的自定义图表并能为图表设置动态数据。Aspose.Cells for Reporting Services还能让您将图表转换为图片。

图形功能

Aspose.Cells for Reporting Services提供了广泛的图形功能,您能在运行时轻松地将工作表转换成图片以及将图片添加在工作表中。

支持多种文件格式

使用Aspose.Cells for Reporting Services，开发者能轻松地打开和保存大量的文件格式，包括 ：

• Excel 97 / 2000 / XP / 2007 (XLSX)
• SpreadSheetML
• Tab Delimited
• CSV

使用Aspose.Cells for Reporting Services你也能打开加密的Excel文件。也支持打开和保存ODS(Open Document Spreadsheet)格式文件。

Native Excel Format

Aspose.Cells for Reporting Services is a rendering extension for Microsoft SQL Server Reporting Services and Microsoft Report Viewer.

After installing Aspose.Cells for Reporting Services, you will get access to the following additional export formats: 

• XLS - Excel Workbook via Aspose.Cells
• Excel2007Xlsx - Excel 2007 via Aspose.Cells
• Excel2007Xlsm - Excel 2007 via Aspose.Cells
• SpreadsheetML - SpreadsheetML via Aspose.Cells
• CSV - CSV via Aspose.Cells
• Txt - TabDelimited text via Aspose.Cells
• Html - Html via Aspose.Cells

Designer

Users can design and deliver reports into MS Excel directly using Aspose.Cells.Report.Designer, which is a very simple and easy to use tool. They don’t necessarily need to use Visual Studio IDE to create reports. As a result, a user can save costs for buying additional Visual Studio licenses and does not have to spend more time in learning how to use complex development environments in Visual Studio. Since Aspose.Cells.Report.Designer uses MS Excel as a report template, therefore users can take advantage of all the powerful functionalities / features available in MS Excel including Pivot Tables, Interactive Charts, VBA, Macros and Formulas. All these attributes are not supported by the standard MS Excel format delivered by Reporting Services. Moreover, Aspose.Cells.Report.Designer can create reports in two kinds of report define format to support Microsoft SQL Server 2000, 2005 or 2008 Reporting Services.

Advanced Formulas

There are two types of formulas that we can make use of: one is Reporting Services formulas and the other is MS Excel dynamic formula provided by Aspose.Cells for Reporting Services. Using Reporting Services formulas in Aspose.Cells.Report.Designer is same as applying formulas in Visual Studio. Users can set Reporting Services formulas based on the values of Cells in report template, the formulas will be calculated and the calculation results will be filled back to Cells at rendering time. Comparing it with Reporting Services formulas, MS Excel dynamic formula is not calculated but converted to a real MS Excel formula according to certain rules / regulations and then filled back to Cells at rendering time.

Data Handling

Aspose.Cells for Reporting Services supports tables with grouped rows and footers. The grouping of rows and footers can be setup at design time like other report items. Aspose.Cells for Reporting Services also supports parameters and global variables as report data sources. Users can also make use of MS Query for creating data sources and queries, which is a widely used tool and familiar to most users. In addition to this, Aspose.Cells for Reporting Services supports both report specific data sources and shared data sources created on Report Server in advance. Moreover, users can utilize report specific data sources at design time and specify shared data sources as report data sources while publishing reports. Aspose.Cells for Reporting Services is integrated with Microsoft Reporting Services seamlessly and therefore users can take full advantage of Reporting Services' report management, security and delivery options.