Create, View, Edit, Convert Excel Files
The Spreadsheet control displays Excel workbooks containing formulas, data sources, pivot tables, charts, and other advanced Excel capabilities with a great deal of precision. It supports nearly all Microsoft Excel document formats including:
- XLS, XLSX, XLSM, XLSB, BIFF5
- XLT, XLTX, XLTM
- CSV
- TXT
Print. Export to PDF
Reporting made easy.
Turn the contents of your workbook or specific worksheets into a printed report or file with a simple method call or using the Print Dialog. Use built-in dialogs to customize page margins, document orientation, paper size, add headers/footer, incorporate page numbers, current date and file name to printed worksheets.
With the Print Titles option you can specify rows and columns that will be printed on each printed page. This can make your printed copy easier to read.
And of course, our WPF Spreadsheet can also convert workbooks to PDF and HTML.
400+ Excel Formulas & Functions
Excel compatible functions are built-in.
Over 400 built-in functions with array formula support allow you to create formulas and perform high-precision and multi-threaded calculations at incredibly fast speeds. You can use basic mathematical functions to aggregate data within a spreadsheet or create complex formulas with statistical, engineering, and financial functions for advanced data analysis.
Our Spreadsheet (WPF Excel control) includes RTD (Real-Time Data) function. The RTD function retrieves data in real time from programs that support COM automation. Financial apps use this function to pull market data from various financial service data providers (Yahoo! Finance, Google Finance, Bloomberg, etc.) into spreadsheets.
Spreadsheet API allows you to create your own functions. Custom functions are available for all spreadsheet calculations, and can be used in formulas.
Spreadsheet Data Visualization
Charts, Pivot Tables, Sparklines
Summarize, analyze, explore, and present your worksheet data graphically. Embed an Excel-like pivot table engineered for multi-dimensional data analysis and cross-tab reporting. Add a chart to visualize information. Our Spreadsheet control supports sparklines (Line, Column, Win/Loss) and a wide range of 2D/3D charts:
- Column and Bar Charts
- Line and Area Charts
- Pie and Doughnut Charts
- Scatter, Radar and Bubble Charts
- Stock Charts
Conditional Formatting & Styles
Intuitively present workbook data to your users.
The Spreadsheet control ships with Microsoft Excel-inspired Conditional Formatting support. This powerful feature allows you to highlight cells based on specified criteria without writing a single line of code. Cells can be highlighted with data bars, icons and predefined color scales.
End-users can easily apply a varity of predefined style conditions and make worksheets easier to understand. Integrated Ribbon UI allows end-users to add, change, or remove conditional formatting styles much like they do in Microsoft Excel.
And of course, you can use cell styles to apply predefined formats, and other manual formatting features to highlight important data.
Data Editing & Validation
Keep your data clear and accurate.
Our Spreadsheet control gives you the total control over cell editing.
- Auto Fill
- Formula Bar
- Copy / Cut / Paste / Paste Special
- Copy / Cut / Paste / Paste Specials
- Redo / Undo
- Highlight Invalid Values
You can use predefined in-place editors or embed your own (custom) data editors into worksheet cells.
Shape & Search Data Instantly
A broad range of data shaping and filter options.
Unleash the power of information and intuitively present it to your end-users. Our WPF Spreadsheet ships with dozens of advanced data shaping and search options, including:
Protect Your Work
Prevent unauthorized access.
Password encryption prevents unauthorized users from opening or modifying your workbooks. You can restrict changes to workbooks, worksheets, and specific ranges. In a protected workbook, users are not allowed to add, delete or rename worksheets.
Various sheets can have different protection levels. For instance, you can unlock a range for some users while other users may be prompted for a password.
You can configure which actions are available to users and which are restricted. Unavailable operations will be hidden from corresponding context menus and disabled in Ribbon UI.