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

Source: Internet
Author: User

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.