Example E4938
Visible to All Users

WPF SpreadsheetControl API - Part 1

This example demonstrates how to use the SpreadsheetControl API to manage spreadsheet documents in code, without the need for Microsoft Excel to be installed.

Double-click the action name in the Navigation Bar to run the code that illustrates the API functionality. The results are shown in the SpreadsheetControl and saved to the SavedDocument.xlsx file in the Document subfolder of the working folder.

In particular, this sample introduces API used to perform the following operations:

  • Manage worksheets (activate, create, delete, rename, copy, adjust worksheet view, etc.)
  • Manipulate rows and columns (insert, delete, copy rows and columns, adjust row height and column width, etc.)
  • Manipulate cells and cell ranges (set cell values, add hyperlinks to cells, copy and merge cells), create, edit and copy cell comments
  • Create formulas (use various functions and cell references in formulas, use names in formulas, create shared and array formulas, etc.)
  • Format cells (set cell font, colors, alignment, borders, number format, etc.)
  • Export the workbook to PDF
  • Print the workbook

Files to Review

CodeExamples (VB: CodeExamples)

More Examples

Does this example address your development requirements/objectives?

(you will be redirected to DevExpress.com to submit your response)

Disclaimer: The information provided on DevExpress.com and affiliated web properties (including the DevExpress Support Center) is provided "as is" without warranty of any kind. Developer Express Inc disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.

Confidential Information: Developer Express Inc does not wish to receive, will not act to procure, nor will it solicit, confidential or proprietary materials and information from you through the DevExpress Support Center or its web properties. Any and all materials or information divulged during chats, email communications, online discussions, Support Center tickets, or made available to Developer Express Inc in any manner will be deemed NOT to be confidential by Developer Express Inc. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.