Excel file format (xlsx)

Multiple Format Support

ReoGrid supports loading and saving Excel xlsx file format, import and export CSV file, output spreadsheet to printer or preview on screen, generate worksheet as HTML or PDF.

245

Workbook Input & Output API

ReoGrid control itself is workbook, both screen workbook control and memory workbook has same APIs.

var workbook = reoGridControl;

To load Excel workbook:

workbook.Load(path, IO.FileFormat.Excel2007);

ReoGrid will create and load all worksheets from the Excel file automatically. To save Excel file:

workbook.Save(path, IO.FileFormat.Excel2007);

Supported objects

Loading or saving the following objects from/to an Excel is supported:

Not supported objects

Loading or saving the following objects is not supported yet:

Available function list

See Excel-Compatible Function List.

Memory Workbook

ReoGrid also provides an off-screen interface that has the ability to load and save spreadsheets without a GUI. This feature is typically used for importing and exporting Excel files and handling data on the background or server side.

Typical usage of memory workbook

Create memory workbook instance, then load or save spreadsheet as Excel format.

// create memory workbook
var workbook = ReoGridControl.CreateMemoryWorkbook();

// load Excel workbook from stream
workbook.Load(stream, FileFormat.Excel2007);
// save stream as Excel workbook
workbook.Save(stream, FileFormat.Excel2007);

Learn more about memory workbook.


Was the content of the page helpful?