Skip to content

DevExpress-Examples/spreadsheet-document-api-examples-part1

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

104 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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

The DevExpress Spreadsheet Document API is a non-visual library that allows you to generate, import, export, modify, and print Microsoft Excel workbooks in code.

You need a license for theβ€―DevExpress Office File API Subscriptionβ€―orβ€―DevExpress Universal Subscriptionβ€―to use this library in production code.

This example demonstrates how to use the Spreadsheet Document 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
  • Specify the built-in and custom document properties

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 Microsoft Excel.

Spreadsheet Document API - List of Supported Operations

Files to Look At

C# Visual Basic
CellActions.cs CellActions.vb
DocumentPropertiesActions.cs DocumentPropertiesActions.vb
ExportActions.cs ExportActions.vb
FormattingActions.cs FormattingActions.vb
FormulaActions.cs FormulaActions.vb
ImportActions.cs ImportActions.vb
PrintingActions.cs PrintingActions.vb
RowAndColumnActions.cs RowAndColumnActions.vb
WorksheetActions.cs WorksheetActions.vb

Documentation

More Examples

Does This Example Address Your Development Requirements/Objectives?

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

About

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

Topics

Resources

License

Stars

Watchers

Forks

Contributors