Aspose.Cells for Reporting Services概述

常見用途：

將RDL報告導(dǎo)出為以下格式    

• 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報告服務(wù)和微軟的報表查看器來說是一種渲染擴展。

在安裝Aspose.Cells for Reporting Services 之后，將會添加下列文件導(dǎo)出格式。

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

高級特性

有兩種公式可供用戶使用：有兩種類型的公式,用戶可以利用:一個是報告服務(wù)公式,另一個是Aspose.Cells for Reporting Services提供的MS Excel動態(tài)公式。報告服務(wù)公式使用起來和Visual Studio所提供的公式是一樣的。用戶可以根據(jù)報告模板單元格中的數(shù)值設(shè)置報告服務(wù)公式,公式將被計算，計算結(jié)果將在渲染時發(fā)送回單元格中。與報告服務(wù)公式不同,MS Excel的動態(tài)公式不會被計算而是轉(zhuǎn)換為一個真正的具有一定的規(guī)則和法規(guī)MS Excel表達(dá)式,然后送回單元格中。

設(shè)計師工具

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

靈活的顯示選項

Aspose.Cells for Reporting Services使您可以完全控制頁面設(shè)置,并允許您操縱一個廣泛的顯示選項,例如;預(yù)覽頁面分頁和為工作表設(shè)置縮放級別、使用凍結(jié)窗格控制數(shù)據(jù)可視化,設(shè)置頁面方向、縮放、紙張的大小、頁眉/頁腳和打印區(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支持帶有分組行和頁腳的表格。行和頁腳的分組可以像其他報表條目一樣在設(shè)計時設(shè)置。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è)計時使用報告特定數(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)形式。你可以應(yīng)用格式工作表、行、列和單元格。你也可以添加Rich Text到單個單元格，并能應(yīng)用不同的邊界,背景圖案和字體。條件格式也可以被應(yīng)用到單元格中。

創(chuàng)建圖表

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

圖形功能

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

支持多種文件格式

使用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.