Enterprise .NET Spreadsheet Components
Develop in .NET, ASP.NET, WPF, and WinRT
Use as a spreadsheet, grid, input form, or dashboard
Read/write native Microsoft Excel™ files
Spread Studio is a multi-functional spreadsheet that professional Visual Studio developers use to create analysis, dashboard, data collection and management, scientific, and financial applications for Windows and web. The Spread Studio package includes .NET spreadsheet components, template designers, charting components, calculation engine, API, and much more.
Familiar Spreadsheet UI
Workbook Support
Present data in a grid, a single spreadsheet, or in a multiple sheet workbook. However you choose to display data, you get features such as a function library, grouping, sorting, filtering, and conditional formatting.
Spreadsheet Authoring
Whether you are working in bound or unbound mode, users will enjoy an easy click-to-edit spreadsheet authoring workflow.
Style and Formatting
Format cells exactly the way you wish with features such as fonts, alignment, merging, borders, and shading. Apply data type formatting, such as currency, to cells.
Spreadsheet Features and Excel Compatibility
Excel-like Data Display
Sort, filter, group, and outline flat and hierarchical data to get the view you need. Table formatting and conditional formatting are also supported.
Excel Features
Give your users the spreadsheet features they expect such as drag-fill, drag move, hidden columns, hidden rows, shapes, cell protection, and frozen panes.
Excel Import/Export Support
Spread imports Excel files with features, formatting, and security rules intact. If the Excel file has a feature unsupported in Spread, it will still be preserved upon Excel export.
Print and Print Preview
Full Set of Print Options
Spread fully supports printing and includes a print settings and preview window you can display in your applications.
Print API
Customize Print behavior to your specifications by coding against the print API.
PDF Export
Export and share your spreadsheet views to platform independent PDF files.
Modern Technology
Works with Microsoft’s Latest Releases
Spread Studio is fully tested in Visual Studio 2015 and Windows 10. It can also import/export Excel 2016 files and includes Excel 2016 themes.
The Latest Versions of All Modern Browsers
ASP.NET applications created with Spread Studio will run in the latest releases of Google Chrome, Microsoft Internet Explorer, Microsoft Edge, Mozilla Firefox, and Safari. Touch interactions are also supported.
All .NET Development Platforms
Spread Studio includes components for Windows Forms, WPF, ASP.NET, and WinRT.
Visual Designers for Creating Spreadsheets, Data Views, Dashboards, and Input Forms
Spreadsheet Designer Application
Included application helps you lay out data views and forms in a familiar Excel-like interface. Use it to create new forms or import Excel files.
Spreadsheet Designer Component
Embed the spreadsheet designer component in your applications to give your end-users ad-hoc data view design features.
Powerful Calculation Engine
Built-in Function Library
Choose from over 300 functions and apply them to individual cells, rows/columns, or entire sheets.
Advanced Function Support
Take advantage of cross-sheet referencing, structured formulas, and array formulas. You can also create your own custom functions.
Formula Text Box Control
Add an Excel-like formula text box to your applications.
Cell Types for Data Input, Validation, and Display
Editable Cell Types
Choose from a library of cell types, such as date or number, that automatically add input controls and enforce data validation rules.
Graphical Cell Types
Cell types, such as barcode, button, and image are included to display data in a specific format.
Custom Cell Types
Spread is fully extensible, so you can create your own cell types tailored to your needs.
Powerful Charting Features
Complete Chart Collection
Visualize data with over 80 chart types such as line, column, financial, polar, and radar. Multiple axes and 3D charts are also supported.
Chart Component
Spread adds a separate chart component to your toolbox so you can use the chart anywhere in your application.
Chart Designer
Use the point-and-click designer to select a chart type, select data, format axes, design series, and more.
More Features
Dashboards
Use Spread to create complete dashboards, giving your decision makers a snapshot of the current trends or KPIs to make informed decisions.
Sparklines
Show data trends with column, line, and win-loss Sparklines.
Conditional Formatting
Add conditional elements such as performance indicators, icon sets, data bars, and color scales.
Tables
Format data sets with features such as pre-defined table styles, automatic filtering, sorting, structured references, and named items.
Cell Formatting
Full styling options for text, alignment, borders, and colors.
Format data for numbers, currency, dates, images, links, buttons, and more.
Cell Borders
All border design properties including diagonal borders, thickness, color, and style are supported.
Flexible Data Binding
Bind individual cells, ranges, tables, or entire sheets to any data source. Mix bound and unbound modes on the same sheet.
Groups, Outlines, and Subtotals
Organize and summarize your data with Excel-like automatic and manual groups, outlines, and subtotals.
Clipboard Support
Spread fully supports clipboard operations including those specific to spreadsheets such as paste all cell info or only data, formatting, or formulas.
Sorting and Filtering
Give your users Excel-like sorting and filtering features including Outlook-style drag and drop functionality.
Sorting and Filtering
Themes
Spread includes themes from Office 2003 through 2016 and other professionally designed skins. A skin editor is also included so you can create your own.
Fully Documented API
Customize your Windows Forms, ASP.NET, WPF, and WinRT applications to fit your needs with Spread’s comprehensive API.
Scroll Tips
Show a tooltip containing a content preview on the scroll bar as a user scrolls.
Localization Support
Spread controls honor culture settings for symbols such as currency, will render any character set, and you can localize interface strings. Double-byte characters and right-to-left layout are also supported.
Camera Shapes
Camera shapes allow you to embed a live view of a range and place it anywhere else in the workbook. This gives you a way to embed a portion of one sheet on another in a floating object.
Multiple Headers
Cell Merging
Named Items
Search
Shapes
Comments
Zoom
Sheet and Cell Protection