Aspose.Cells for Reporting Services概述

常見用途：

將RDL報告導出為以下格式    

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

支持的格式

支持一般的電子數(shù)據(jù)表格，文本和元語言文件格式 。

功能描述

無需安裝MS Excel

Aspose.Cells for Reporting Services是一種令人難以置信的通用組件,它允許開發(fā)人員在不需要安裝MS Excel或MS Office的情況下創(chuàng)建、管理和操作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動態(tài)公式。報告服務公式使用起來和Visual Studio所提供的公式是一樣的。用戶可以根據(jù)報告模板單元格中的數(shù)值設置報告服務公式,公式將被計算，計算結果將在渲染時發(fā)送回單元格中。與報告服務公式不同,MS Excel的動態(tài)公式不會被計算而是轉換為一個真正的具有一定的規(guī)則和法規(guī)MS Excel表達式,然后送回單元格中。

設計師工具

用戶可以直接使用Aspose.Cells.Report.Designer向MS Excel中設計并交付報告。 設計師是我們簡單和易于使用的設計工具。這意味著用戶不需要使用Visual Studio創(chuàng)建報告。因此,用戶無需購買額外的Visual Studio許可證，也可降低熟悉我們工具的訓練要求，從而能夠節(jié)省費用。 隨著Aspose.Cells.Report.Designer將MS Excel作為一個報告模板,用戶可以因此利用包括數(shù)據(jù)透視表、交互式圖表,VBA,宏和公式在內(nèi)的MS Excel強大功能和特性。這些屬性并不支持由Reporting Services 所發(fā)送的標準MS Excel格式。此外he Aspose.Cells.Report.Designer可以在兩種報告定義格式中創(chuàng)建報告，并支持Microsoft SQL Server 2000、2005或2008年Reporting Services。

靈活的顯示選項

Aspose.Cells for Reporting Services使您可以完全控制頁面設置,并允許您操縱一個廣泛的顯示選項,例如;預覽頁面分頁和為工作表設置縮放級別、使用凍結窗格控制數(shù)據(jù)可視化,設置頁面方向、縮放、紙張的大小、頁眉/頁腳和打印區(qū)域等。

安全特性

Aspose.Cells for Reporting Services提供了廣泛的安全特性,比如;支持Excel 2007 XLSX文件的加密/解密、保護內(nèi)容、對象和工作表的腳本和隱藏/顯示工作表。

操縱行列

Aspose.Cells for Reporting Services允許您以多種不同方式操縱行和列。您可以按照要求輕松調(diào)整行高和列的寬度,根據(jù)單元格內(nèi)容自動調(diào)節(jié)單元格寬和高、插入或刪除,隱藏或顯示，合并或拆分行和列。

數(shù)據(jù)處理

Aspose.Cells for Reporting Services支持帶有分組行和頁腳的表格。行和頁腳的分組可以像其他報表條目一樣在設計時設置。Aspose.Cells for Reporting Services也支持參數(shù)和全局變量作為報告的數(shù)據(jù)源。用戶還可以使用MS Query創(chuàng)建數(shù)據(jù)源和查詢,這是一種廣泛使用的工具，并被大多數(shù)用戶熟悉。 此外Aspose.Cells for Reporting Services同時支持在Report Server上提前創(chuàng)建的報告特定數(shù)據(jù)源和共享的數(shù)據(jù)源。此外,用戶可以在設計時使用報告特定數(shù)據(jù)源，在發(fā)表報告時將共享數(shù)據(jù)源指定為報告數(shù)據(jù)源。Aspose.Cells for Reporting Services可以無縫地整合Microsoft Reporting Services,因此用戶可以充分利用Reporting Services的報告管理、安全和交付選項。

廣泛的平臺支持

Aspose.Cells for Reporting Services使您能夠完全控制在高級格式特性中數(shù)據(jù)的呈現(xiàn)形式。你可以應用格式工作表、行、列和單元格。你也可以添加Rich Text到單個單元格，并能應用不同的邊界,背景圖案和字體。條件格式也可以被應用到單元格中。

創(chuàng)建圖表

Aspose.Cells for Reporting Services帶有完整的圖表支持和支持所有標準圖表類型。你可以很容易地添加使用產(chǎn)品API的自定義圖表并能為圖表設置動態(tài)數(shù)據(jù)。Aspose.Cells for Reporting Services還能讓您將圖表轉換為圖片。

圖形功能

Aspose.Cells for Reporting Services提供了廣泛的圖形功能,您能在運行時輕松地將工作表轉換成圖片以及將圖片添加在工作表中。

支持多種文件格式

使用Aspose.Cells for Reporting Services，開發(fā)者能輕松地打開和保存大量的文件格式，包括 ：

• 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.