Spread Studio Features

Excel Compatible Spreadsheet.
Excel Compatible
Dashboard Data Visualization.
Dashboard
Integrated Chart Control.
Chart Control
Extensive Customization.
Customization
Flexible Data Binding Support.
Data Binding
Excel Compatible Spreadsheet.

Excel Compatible Spreadsheet.

Through built-in support for Excel document import and export, Spread allows you to apply complete programmatic control of user interactions with data in Excel documents, allowing you to maintain business rules, security and data integrity. And if you want to have the familiar Excel user experience as the interface to your corporate data, Spread supports all the .Net data binding options. Import Microsoft Excel documents and preserve complete formatting. Interact with the data in Spread from within your application, then export your spreadsheets to Microsoft Excel for portable distribution to your users. Spread supports the current versions of Excel, and supports multiple Excel file formats, including Excel (2007-current xlsx), Excel 97 (xls), comma-delimited (csv), and text (txt).

Dashboard Data Visualization.

Dashboard Data Visualization.

Allow your data to tell stories through the data visualization functionality provided in Spread. Use Sparklines to provide small, focused cell-level charts that give more meaning to your data. Use Camera Shapes to bring together content from various locations within a spreadsheet, even on different sheets, into a dashboard. In Spread, the Camera Shape object provides a live view of a range of cells, including any values, formatting, shapes, charts, or other content. Ranges with different column widths and row heights can be arranged together in the same sheet without affecting one another to create a customized report or interactive dashboard. Additional data visualization is provided in Spread through chart support, conditional format, filtering, and grouping.

Integrated Chart Control.

Integrated Chart Control.

Create expressive 2D and 3D charts within your spreadsheets. Chart types include Column, Line, Pie, Bar, Area, XY, Bubble, Stock, XYZ, Doughnut, Radar and Polar. Add charts through code by using the comprehensive chart object model, or at design time by accessing the Spread Designer and Chart Designer. Charts can be bound to external data sources, and you can allow end users to make changes to chart formatting at run time. The fully integrated support for charts in Spread features built-in design dialogs that you can make available in your applications to allow your end-users to create and modify charts in Spread just as they do in Microsoft Excel.

Extensive Customization.

Extensive Customization.

Spread has an extensive and robust object model, and allows .NET Windows Forms and ASP.NET developers to customize many elements of the user interface. It also lets them manage the behavior of the control by extending built-in classes and assigning custom objects to Spread. Developers can use Spread .NET controls to embed advanced Microsoft Excel-compatible spreadsheet features into their .NET and ASP.NET applications — features that would otherwise be considered impossible to achieve.

Flexible Data Binding Support.

Flexible Data Binding Support.

Spread can bind to any .NET data source, including built-in support for displaying relational datasets. Run-time support for unbound rows and columns within bound data allows for inclusion of aggregation information, or for performing what-if scenario analysis. Spread also lets you bind a range of cells to a data source, or provide a range of cells as a data source. Whether using Spread as a spreadsheet or a rich data grid, the flexible data binding options allow you to reach the data you need.