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).