ReoGridEditor

ReoGridEditor is a open source project that provides a Microsoft Excel-like user interface to create or edit spreadsheet. ReoGridEditor uses ReoGrid spreadsheet component extension edition.

Overview

Following is the appearance of ReoGridEditor main window.

383

Get Binary and Source Code

Binary Executable

Download the release package, extract the archive folder named ‘ReoGrid-version-Demo-Binary’.

384

Double click to execute the file ‘unvell.ReoGridEditor.exe’, the main window of ReoGridEditor will display.

Source Code

Download the release package, extract the archive file named ‘ReoGrid-version-Demo-Editor-Source.zip’.

Build

To build ReoGridEditor, perform the following steps:

  1. Open solution file ‘Editor2013.sln’ by using Visual Studio 2012/2013/2015 and higher.
  2. Remove the reference items marked as warning from reference list.
    386
  3. Extract the folder ‘ReoGrid-version-Demo-Binary’ from downloaded release package.
  4. Add following DLLs as project reference.
    • unvell.ReoGrid.dll
    • unvell.ReoScript.dll
    • unvell.ReoScript.EditorLib.dll
  5. Build project.

Build with ReoGrid Pro

Change the build configuration from ‘Debug’ to ‘DebugPro’, then build the project.

Edit Spreadsheet

Open and save spreadsheet

Open and save files by using menu ‘Open’ and ‘Save’.

387

Supported File Format

ReoGridEditor uses ReoGrid to open and save files. The following format are supported:

Load Save Import Export
Excel 2007 (Open Office XML) Checkmark-18 Checkmark-18
RGF (ReoGrid Format) Checkmark-18 Checkmark-18 Checkmark-18 Checkmark-18
CSV Checkmark-18 Checkmark-18
HTML Checkmark-18

Table Definitions:

  • Load Read entire workbook and all worksheets from a file
  • Save Write entire workbook and all worksheets into a file
  • Import Read specified worksheet into current workbook
  • Export Write specified worksheet from current workbook

Oepn Source .NET UI Controls

ReoGridEditor provides many user controls under open source license, such as Font Box, Color Picker, Border Editor, Rotation Angle Editor etc. These UI controls can be used in other application for free.

See Also