Introduction of an Open source class Excel spreadsheet software

??

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