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.