Mô tả sản phẩm: Aspose.Cells for Reporting Services
Aspose.Cells for Reporting Services
Aspose.Cells is an award-winning spreadsheet component that allows developers to embed the ability to read, write and manipulate Excel spreadsheets into their own applications without relying on Microsoft Excel.
Aspose.Cells for Reporting Services allows you to deliver native Excel reports in Reporting Services on Microsoft SQL Server 2000, 2005 and 2008, as well as in Microsoft Report Viewer 2005 and 2008. Unlike the native renderer for Excel based reports, Aspose.Cells for Reporting Services provides an extended feature set and allows RDL/RDLC reports to be converted to: Excel 97-2003 binary XLS, SpreadsheetML, the Excel 2007 XLSX and the Excel 2007 XLSM, CSV, HTML and TXT formats.
At a Glance
An overview of the formats, report designer, data processing and RDL features that Aspose.Cells for Reporting Services supports.
Platform Independence
Aspose.Cells for Reporting Services supports Reporting Services 2005 and 2008.
Supported File Formats
Aspose.Cells for Reporting Services supports common spreadsheet, text and meta language file formats.
Common Uses
Export RDL reports in the following formats:
- Excel 97-2003 Binary XLS
- SpreadsheetML
- Excel 2007 XLSX
- Excel 2007 XLSM
- CSV
- TXT (Tab Delimited Text)
Customer Types
We have clients of many different types, including:
- Banks
- Data processing houses
- Educational institutions
- Government organizations
- Insurance firms
- Legal institutions
- Postal/cargo services
- Search engines
| Key Features |
No Microsoft Excel Automation |
|
Aspose.Cells for Reporting Services is an incredibly versatile component that allows developers to create, manage and manipulate Excel spreadsheets without requiring Microsoft Excel or Microsoft Office to be installed on the system. In short, Aspose.Cells for .NET is a better alternative to Office Automation in terms of security, stability, scalibility, speed, price and features. Native Excel FormatAspose.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, the following file format export options will be added:
Advanced FeaturesThere are two types of formulas that users 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 the exactly the 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 sent back to Cells at rendering time. Comparing it with Reporting Services formulas, MS Excel dynamic formulas are not calculated but instead converted to a real MS Excel formula dependant on certain rules and regulations and then sent back to Cells at rendering time DesignerUsers can design and deliver reports into MS Excel directly using Aspose.Cells.Report.Designer, this is our simple and easy to use design tool. This means that users do not need to use Visual Studio to create reports. As a result, an organisation can save costs by not purchasing additional Visual Studio licenses and reducing the training requirement to become familiar with our easy to use tools. As the Aspose.Cells.Report.Designer uses MS Excel as a report template, users can therefor take advantage of all the powerful functionality and features available within MS Excel including Pivot Tables, Interactive Charts, VBA, Macros and Formulas. These attributes are not supported by the standard MS Excel format delivered by Reporting Services. Moreover, the Aspose.Cells.Report.Designer can create reports in both types of report definition format to support Microsoft SQL Server 2000, 2005 or 2008 Reporting Services. Flexible Display OptionsAspose.Cells for Reporting Services gives you complete control over page setup and allows you to manipulate a wide range of display options such as; preview page breaks and set zoom level for the Worksheet, control data visibility using Freeze Panes, set page orientation, scaling, paper size, headers/footers, and print area etc. Security featuresAspose.Cells for Reporting Services offers a wide range of security features such as; support for Excel 2007 XLSX file encryption/decryption, protect Contents, Objects and Scenarios of a Worksheet and hide/unhide a Worksheet. Manipulate Rows and ColumnsAspose.Cells for Reporting Services allows you to manipulate Rows and Columns in many different ways. You can easily adjust Row height and Column width as required, auto size the width/height of cells according to contents, insert or delete, hide or unhide and group or ungroup Rows and Columns. Data HandlingAspose.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, this 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 use report specific data sources at design time and specify shared data sources as report data sources while publishing reports. Aspose.Cells for Reporting Services integrates with Microsoft Reporting Services seamlessly and therefore users can take full advantage of Reporting Services' report management, security and delivery options. Comprehensive Formatting SupportAspose.Cells for Reporting Services gives you full control over how your data is presented by offering advanced formatting features. You can apply formatting to a Worksheet, Row, Column or Cell. You can also add Rich Text to a Single Cell and apply different Borders, Background Patterns and Fonts. Conditional formatting can also be applied to Cells. Creating ChartsAspose.Cells for Reporting Services comes with complete support for charting and supports all standard chart types. You can easily add customized charts using the products API and dynamically set data for the charts. Aspose.Cells for Reporting Services also allows you to convert charts to images. Graphical CapabilitiesAspose.Cells for Reporting Services provides extensive graphical capabilities, allowing you to easily convert Worksheets to images as well as add images to Worksheets at runtime. Support for many Different File FormatsUsing Aspose.Cells for Reporting Services, developers can easily open and save a multitude of file formats. These include
|
