ASP.NET Spreadsheet
Excel inspired UI
Read/Write XLSx, XLS, CSV and TXT Files
ASP.NET Rich Text Editor (CTP)
|
|
Automatically Generated UI
The DevExpress Spreadsheet provides the UI experience your end users have come to expect from today's most popular office productivity suite.
|
|
|
Straightforward and Easy-to-Use Spreadsheet
The new DevExpress ASP.NET Spreadsheet is an Excel inspired control and allows you to introduce spreadsheet functionality to any ASP.NET application with absolute ease. It can load, convert and save workbooks to the XLS binary file format and can export and import XLSX, CSV and TXT files.
Help Topic: Supported Formats |
|
|
Automated Formula Calculation Engine
DevExpress formula calculation results have been engineered to closely match those of Microsoft Excel. A spreadsheet formula is an equation that performs a calculation on numbers, functions and values of one or more cells.
Demo: Dynamic Sheet Generation |
|
|
Built-in Spreadsheet Functions
The DevExpress Spreadsheet Control supports a comprehensive range of functions for use within formulas. Functions are compatible with Microsoft Excel. You can also define your own functions.
Demo: Formulas |
|
|
Cell References
A formula can contain references to other cells or cell ranges within the same or different worksheets. The following references are supported:
- Relative, Absolute and Mixed References
- Cross-Worksheet References
- 3D References
- Structured References
- External References
Help Topic: Cells and Cell Ranges | Help Topic: Cell Referencing |
|
|
Worksheet Management
To organize worksheets in a workbook, you can create new worksheets, copy, rename and delete existing worksheets.
Help Topic: Worksheets |
|
|
Charting
Charts can help you display data in ways that are meaningful to your customer. Select from a variety of chart types (such as a bar chart or a line chart) and their subtypes (such as a stacked horizontal pyramid chart or a 3-D line chart).
Demo: Charts |
|
|
Pictures
You can insert, move, change, transform and delete pictures incorporated into a worksheet.
Demo: Images |
|
|
Cell Formatting
Proper cell formatting improves worksheet appearance, and allows end-users to read, find and understand worksheet data more easily. You can specify the following format attributes for cells:
- Cell font settings (font name, size, color, style, etc.)
- Cell background
- Cell content alignment (vertical and horizontal alignment, indent and text wrapping)
- Cell borders
- Number formats
|
No comments:
Post a Comment