Excel has always been dominant in the Windows desktop table software market No 1. At the same time, office suits have almost become a standard office skill in the IT industry. Is there any desktop program similar to excel, Green Edition, to implement basic data editing functions? If the office is not installed, can table editing, formula editing, printing, export, and export be performed?
Yes. This open-source spreaddesginer introduced in this article can meet this requirement.
Who should read this article?
Software Designer
Product Manager
Excel user
System essential:
EMBED Excel in the Management Platform
Many industry management systems need the same rich formulas and data processing functions as Excel. Spread can help to embed these functions into enterprise management systems, such as financial data models, risk analysis, insurance calculation, and engineering applications.
Source code path: http://git.oschina.net/GrapeCity/SpreadDesigner
Less than 10 thousand lines of source code (core functions are encapsulated in the spread Control)
Download the zip package, green version, and unzip it.
The compiled exe program can be distributed and deployed for free.
The following compares Excel and spreaddesigner:
Item |
Microsoft Office Excel 2007 |
Spreaddesigner |
Price |
$680 |
Free |
Installation Method |
Installation required |
Decompress green |
Deployment and distribution |
Purchase license again |
Free |
Required |
. NET Framework 3.5 |
. NET Framework 3.5 |
Programmable |
VBA \ COM Component |
C #. Net \ VB. NET |
Technical Support |
Yes |
24-hour response (within weeks) |
Support Excel Data |
Yes |
Yes |
Supports Chinese Characters |
Yes |
Yes |
Customizable Functions |
No |
Yes |
Excel in Office 2007:
- Rich charts
Supports 85 different types of charts. You can directly generate charts based on worksheet data in the spread designer, which is easy to operate. Software engineers can also customize all the elements of a chart in the Visual Studio design environment, including the title, sequence, axis, style, and legend.
- Free-to-use formula Engine
The powerful formula computing engine of spread supports over 300 built-in functions, and supports customizing formulas through built-in functions and operators. Supported functions include date, time function, engineering calculation function, financial calculation function, logical function, mathematical and trigonometric function, statistical function, and text function.
Excel compatibility
Spread will independently install the Excel file format input and output engine. In an environment where Excel is not installed, you can also input and output the Excel file format, charts, graphs, and images designed during development are output to the Excel file as objects. Spread provides multiple versions of Excel and multiple file types of import and export services, including Excel files (xls, XLSX), file files (CSV), and text files (txt ).
Rich cell types
Supports customizing rich cell types. You can use the cell type provided by spread or customize your own type to determine the data that can be entered in a cell and avoid unnecessary checks and verification by programmers, it also provides users with a natural way to input data.
Built-in functions
There are more than 200 built-in functions and formulas can be compiled using built-in functions and operators. Supported functions include date, time function, engineering calculation function, financial calculation function, logical function, mathematical and trigonometric function, statistical function, and text function.
Place formulas in Cells
Specify the cell index in the formula
Use circular references in Formulas
Embedding a function in a formula
Automatic recalculation and update of Formulas
Allow users to enter Formulas
Custom Functions
Create a name for a custom function
Supported functions include date and time functions, engineering functions, financial functions, logical functions, mathematical and trigonometric functions, statistical functions, and text functions.
Import and export functions
Spread supports the import and export of multiple data formats. In the design status, you can use the designer to import and export data. In the running status, you can use the code, you can import and export data from the entire form, specified form table, or specific cell range to different file types or stream files.
Export File Type:
XML file of Spread
Excel(.xls) File
Text Files
Import file type:
Spread XML file
Excel(.xls) File
Spread File
Text Files
Based on the existing source code, let's take a look at your creativity:
Excel spreadsheet software, Green Edition
Resources provided by the spread control: videos, communities, and documents
Spread control Latest Version: Spread
Note: The official spread control is free to use for 30 days. That is, the source code compiled by IDE will expire in 31st days.
If you are very interested in Excel workbooks, we would like to provide spread cases, blog articles, and report examples. We have a great gift to deliver.
Contact QQ: 2190296544 [Specifying spread]
This article introduces an open-source Excel spreadsheet-like software.