XLSX: Programmatically edit a spreadsheet document using high-level editor

In This Topic

The SpreadsheetEditor class is a high-level editor for new or existing spreadsheet document, i.e. class allows to edit a spreadsheet document in terms of spreadsheet document.

The SpreadsheetEditor class allows to:

Create a new or open an existing XLSX document in spreadsheet editor
Work with spreadsheet document
- Set culture of spreadsheet document
- Assign settings (author, etc) of spreadsheet document
- Edit style properties of spreadsheet document
- Add/delete defined names to/from spreadsheet document
Work with worksheets of spreadsheet document
- Get a list of worksheets
- Add/delete/rename a worksheet; copy/insert a worksheet; reorder worksheets
Work with worksheet of spreadsheet document
- Change settings of worksheet view
- Insert or delete columns/rows
- Change size of columns/rows
- Show/hide columns/rows
- Search and replace text
Work with cells set of worksheet
- Insert, copy, paste and delete a cells set
- Change style properties (font, fill, borders, number format, text style, alignment, indent, etc) of cells set
- Change size of cells set
- Clear styles, content, hyperlinks of cells set
- Merge and unmerge a cells set
- Specify a hyperlink to URL or location in document of cells set
Work with cell of worksheet
- Get a value, formatted value and localized formula of cell
- Calculate cell formula
- Change cell value or cell formula
Work with Drawing (Charts, Pictures, Graphics)
- Add picture
- Delete drawing
Work with comments
- Add, edit, delete a comment

If you want to use the SpreadsheetEditor class in your .NET application, you need License for VintaSoft Office .NET Plug-in (Reader+Writer and Spreadsheet Editor edition).

Send Feedback