??
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:
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