What is GrapeCity Spread.NET?
Spread.NET makes it possible to produce spreadsheets, grids, dashboards, and types. It features a strong search engine using 450+ works and the capability to export and import Excel spreadsheets. Leverage the extensive .NET spreadsheet API and powerful calculation engine to evaluate, budget, dash, data collection and management, scientific, and financial programs. You can create in Visual Studio using VB or even C# for WinForms, ASP.NET, and WPF. Each stage of Spread.NET ensures optimum speed and performance for your business programs, and its modular structure means you have to add exactly what you use to your .NET recorder programs.
GrapeCity Spread.NET Great Attributes:
- Deliver Excel-like spreadsheet adventures quickly, with desktop apps
- Create business spreadsheets, grids, dashboards, and types together with the thorough API
- Powerful lookup engine features 450+ works.
- Import and export Excel Documents
- Develop in Visual Studio with VB or C# for WinForms, ASP.NET, along with WPF
NuGet Bundle for .NET 5, .NET Core 3.1, along with .NET 4.52+
Insert Spread to your job quickly and easily using NuGet Package Manager, and make new programs for .NET Core 3.1 along with .NET 5 Windows targets.
Cell Information Types for habit. NET items
Create customized data types and place items in cells, and then use formulas to mention the item's properties in calculations. Use built-in UI or code to add formulas in adjoining cells and table columns.
LET Function borrows formula calculations
Make your formulas easier to read and enhance calculation performance by utilizing the newest LET function to specify domains for intermediate calculation steps.
Edit Points in Improved Shapes
Easily create custom shapes using the newest Edit Points attribute, or produce customized contours in code with the new API to define the contour points and sections.
Enriched Hyperlink Support
Add links in cells by just typing in connection with AutoCreateHyperlink, or use the Edit Hyperlink dialog. Hyperlinks may be applied to cells or shapes and import/export in XLSX.
Prove Shortcuts Command
Built-in support for your Display Formulas command permits the user to toggle displaying formulas in cells with Ctrl+' as in Excel.
Enriched Excel-compatible Keyboard Shortcuts
Easily enable-shared Excel keyboard shortcuts on your software for users. The API enables complete customization of the Input and Action Maps to fit your requirements.
Multiple Worksheet Select
Use Ctrl+Click to select multiple worksheet tabs for Copy, Cut, Delete, or Hide. Implement customized activities to process numerous selected worksheets.
Powerful, Fast, Optimized Calculation Engine
This high-speed, optimized search engine provides computing power to the most complicated formulas without dragging your programs.
450+ Functions in Customizable Library
More acts than in virtually any accessible. NET spreadsheet, and complete customization to your formulas--you will take your complicated spreadsheets to another level
No-Code Layout with Spread Designers
Together with the strong Spread Desktop Designer Program, you are going to acquire code-free. NET recorder programs very quickly.
Import/Export Excel Files to a. NET Spreadsheet
No spreadsheet is complete with no complete Excel import/export support! Publish your advanced Excel spreadsheets, then export your Spread.NET recorder to XLSX or alternative document formats... all without dependencies on Excel.
Enriched Ridge Engine with Group Shape
Create flowcharts, process diagrams, mobile callouts, and much more with over 150 contours, lines, and arrows. Connect and combine to Group Shapes to design logos or custom dash controls scripted to do consumer activities.
Slicers for Easy Table Filtering Choice
Produce Slicers to exhibit table column values such as filtering, use themes, and designs to personalize. Cut and glue the Slicer to a different sheet to function as a dashboard controller.
Dynamic Array Formulas and Functions to Boost Your Calculations
Use lively array formulas to maximize your calculations by simply calculating various results in 1 formula using all the newest functions such as FILTER, RANDARRAY, SEQUENCE, SINGLE, SORT, SORT BY, and UNIQUE.
Language Packages for Formulas and Boost Localization for Clients
Localize your mobile formulas with 18 fresh Language Packages to parse and format the formulas utilizing structured references such as Excel, or create a new custom made Language Package.
Prove Precedent and Dependent Cells with Formula Tracing and Auditing
Easily follow your formulation's reference chains employing built-in formulation tracing approaches to display arrows in the mobile to all determined or precedent cells, and audit formulas utilizing Dependents, DirectDependents, DirectPrecedents, and Precedents.
LOOKUP and XMATCH Works
Boost your formulas and remove these older HLOOKUP, VLOOKUP, and MATCH functions utilizing the newest XLOOKUP and XMATCH functions.
Custom Calculation Works to Expand the Calculation Engine
Produce custom calculation capabilities that apply custom code to do your calculation and return the result value or lively selection that may spill to adjoining cells, and optionally enable the end-user to input formulas utilizing these functions.
Custom Data Visualization Utilizing Visual Functions
Create customized data visualization capabilities that expand the Custom Function attribute with new ports for implementing drawing or styling custom material directly in the mobile to make brand new reusable data visualizations, which may be utilized directly in cell formulas.
Sorting and Filtering
Add sorting and filtering drop-down at a desk or variety and empower your customers to use filters on colors, dates, text, and figures.
Employ built-in mobile styles using Theme colors, and make new custom made mobile styles with Number, Alignment, Font, Border, Fill, or Protection settings such as Pattern and Gradient Fills from the Cellular Format.
Conditional Format Rules
Apply Conditional Format Rules in cells and ranges to employ styles dependent on mobile content or a customized formulation, exhibit icons, information bars, and color scales from the cells to visualize values rapidly.
Tables and Table Designs
Create tables with built-in table designs or make custom table designs to employ banded rows or columns and custom formatting.
Cellular Types, Data Validation
Employ Cell Types, Cellular Validators, or validation for information validation in cells like whole amount, record date, time, and habit with input and error awake.
Cellular Telephones and Sticky Notes
Insert pop-up mobile comments that reveal when the user hangs on the mobile note index, or employ sticky notes to the mobile that stay visible in the sheet using a line indicating the mobile.
Apply cell borders with assorted styles and colors such as diagonal line boundaries, bevel boundaries, double-line boundaries, and much more.
Merged Cells and Mobile Spans
Employ column or row merge to combine cells with similar information or use span cells into information place or header cells to either combine certain cells.
Enable your customers to search for text in cells employing the built-in Basic Search and Advanced Search dialogs.
Visualize your data with advanced chart kinds like Waterfall, Pareto, Funnel, TreeMap, and much more.
Visualize your data in a more streamlined manner with sparkline graphs that draw directly within the cell.
Add a status bar and personalize it to demonstrate purpose calculations on the choice and worksheet zoom controllers.
Bind the worksheet into any. NET data sources such as DataSet, DataView, DataTable, or a custom made a set of items reveal hierarchical viewpoints with expandable rows and kid worksheets.
Overview and Range Group
Produce column and row range groups that may expand and collapse columns or rows to make horizontal and vertical outlines.
Produce Outlook-style groupings of rows with the built-in group pub and customize set footers with aggregation works in the footer cells.
Publish your worksheets with innovative options such as borders, header, footer, best match column or row, and publish scaling.
Customize the look of this workbook and worksheet using built-in skins or custom-made skin working with the Skins Editor.
Utilize touch gestures such as tap, press and hold, slip, swipe, pinch, rotate, extend, and customize the popup signature menu with custom controls.