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 "Visual Editor" edition).