This article introduces an open-source Excel spreadsheet-like software.

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:

• . NET Framework 4.0

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.