devexpress-examples/winforms-spreadsheetcontrol-api-part1

Use the WinForms Spreadsheet API to manage spreadsheet documents in code.

WinForms Spreadsheet API – How to Process Excel Workbooks in Code (Part 1)

The WinForms Spreadsheet Control allows you to create high-impact business data analysis solutions that emulate the look, feel and capabilities of Microsoft Excel®. It includes full integration with the DevExpress Ribbon control so you can deliver Excel inspired functionality with minimal effort.

This example demonstrates how to use the Spreadsheet API to execute the following actions:

• Manage spreadsheet document elements (worksheets, cells, rows, and columns)
• Create formulas
• Format cells
• Import data from different data sources
• Export a workbook to PDF
• Print a workbook

The application form contains the list of supported operations. A user can select an operation and click the Run button to view the resulting spreadsheet document in the Spreadsheet control.

Files to Look At

• CellActions.cs (VB: CellActions.vb)
• FormattingActions.cs (VB: FormattingActions.vb)
• FormulaActions.cs (VB: FormulaActions.vb)
• ImportExportActions.cs (VB: ImportExportActions.vb)
• PrintingActions.cs (VB: PrintingActions.vb)
• RowAndColumnActions.cs (VB: RowAndColumnActions.vb)
• WorksheetActions.cs (VB: WorksheetActions.vb)

Documentation

• Spreadsheet Document
• Cell Basics
• Formulas
• Print Spreadsheet Documents
• How to: Specify Document Properties

More Examples

• WinForms SpreadsheetControl API - Part 2
• WinForms SpreadsheetControl API - Part 3

Does this example address your development requirements/objectives?

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