Aspose.Cells for Reporting Services概述

常見用途：

將RDL報(bào)告導(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報(bào)告服務(wù)和微軟的報(bào)表查看器來說是一種渲染擴(kuò)展。

在安裝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.

高級特性

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

設(shè)計(jì)師工具

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

靈活的顯示選項(xiàng)

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

安全特性

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

操縱行列

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

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

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

廣泛的平臺支持

Aspose.Cells for Reporting Services使您能夠完全控制在高級格式特性中數(shù)據(jù)的呈現(xiàn)形式。你可以應(yīng)用格式工作表、行、列和單元格。你也可以添加Rich Text到單個(gè)單元格，并能應(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提供了廣泛的圖形功能,您能在運(yùn)行時(shí)輕松地將工作表轉(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.