Introduction of an Open source class Excel spreadsheet software

Source: Internet
Author: User

??

Excel has been the dominant position, occupied the Windows desktop Forms software Market No 1, and at the same time, Office suite products almost become the IT industry standard office skills. Is there a desktop program similar to Excel, the green version, to achieve the main data editing function? If you do not install Office, can you implement table editing, formula editing, printing, import, export and other operations?

Yes, the open source Spreaddesginer introduced in this article will be able to achieve this requirement.

who is suitable for reading this article?
      • Software designer
      • Product Manager
      • Excel user

System Prerequisites:

      • . NET Framework 4.0
Embed Excel features in the management platform

Many industry management systems need to be like Excel's rich formula and data processing functions, spread can help embed these functions into enterprise management system, such as financial data model, risk analysis, insurance calculation, project application and so on.

Source code path: Http://git.oschina.net/GrapeCity/SpreadDesigner

Less than 10,000 lines of source code (core functionality encapsulated within the spread control)

Download the zip package, the green version number, decompression can be used.

and compiled EXE program, can be distributed for free deployment

Here's a comparison between Excel and Spreaddesigner:

Control items

Office Excel 2007

Spreaddesigner

Price

680 USD

Free

Installation method

Need to install

Green Decompression

Deployment distribution

Buy License again

Free

System Prerequisites

. NET Framework 3.5

. NET Framework 3.5

can be programmed

VBA\COM components

C#.net\vb.net

Technical support

Yes

24-hour response (within the week)

Support for Excel data

Is

Is

Support Chinese

Is

Is

Customizable features

Whether

Is

Excel for Office 2007:

    • A rich chart

      Support for 85 colorful chart effects. The ability to generate charts directly from the worksheet-based data in the spread designer is simple to do. At the same time, software staff can customize all elements of a chart in the Visual Studio design environment, including headings, sequences, axes, styles, legends, and so on.

    • Free-to-use formula engine

      Spread's powerful formula calculation engine supports more than 300 built-in functions and supports the definition of formulas by using built-in functions and operators. The supported functions include date, time function, project calculation function, financial calculation function, logical function, mathematical and trigonometric functions, statistical function, text function, and so on.

Compatible with Excel

Spread will independently install the Excel file format of the input and output engine, in the environment without the installation of Excel can also be in Excel file format input and output, the development of the design of the chart, graphics, images, etc. will be exported as objects to Excel files. Spread provides multiple version numbers for the import and export service for Excel and various file types, including Excel files (XLS, XLSX), archive files (CSV), and text files (TXT).

wide range of cell types

Supports your own definition of rich cell types. Determine what data can be entered in a cell, avoid unnecessary checks and validations of the program Ape, and provide a natural way for users to enter data by using the cell type provided with spread or customizing their own type

built-in functions

There are more than 200 built-in functions, and formulas are also supported by built-in functions and operators. The supported functions include date, time function, project calculation function, financial calculation function, logical function, mathematical and trigonometric functions, statistical function, text function, and so on.

      • Place a formula in a cell
      • Specify a cell index in a formula
      • Using circular references in formulas
      • Embed a function in a formula
      • The formula itself is actively and again calculated and updated
      • Agree to user input formula
      • Define your own functions
      • Create a name for a custom function

The supported functions include date and time functions, project functions, financial functions, logical functions, mathematical and trigonometric functions, statistics, text functions, and so on.

features for importing and exporting

Spread supports import and export of multiple data formats. Not only in the design state can through the designer to import, export data, execution state, through the code, the entire form, the specified form table or a specific range of cells to import, export to different file types or stream files.

    • Export File Type:
      • XML file for spread
      • Excel (. xls) file
      • Text file
    • Import file Type:
      • Spread XML File
      • Excel (. xls) file
      • Spread file
      • Text file

Based on the existing source code, play your creative try it:

    • Excel-like spreadsheet software, Green edition
    • Resources provided by the spread control: video, community, documents
    • Spread Control Latest Version: Spread

Note that the official spread control has a 30-day free usage limit, i.e. on the 31st day, the IDE compiles the source code to expire.

Welcome to Excel spreadsheets Interested in child boots: to provide spread cases, blog posts, reports examples, we have value gift both hands.

Contact qq:2190296544 [Annotated spread]

Introduction of an Open source class Excel spreadsheet software

Related Article

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.