[Expand]General Information
[Expand]WinForms Controls
[Collapse]ASP.NET Controls and MVC Extensions
 [Expand]What's Installed
 [Expand]Common Concepts
 [Collapse]ASP.NET WebForms Controls
   Getting Started
  [Expand]Grid View
  [Expand]Tree List
  [Expand]Card View
  [Expand]Chart Control
  [Expand]Pivot Grid
   [Expand]Product Information
    Getting Started
    [Expand]Spreadsheet Document
     Supported Formats
     Import and Export
    [Expand]Cell Basics
    [Expand]Spreadsheet Formulas
     Defined Names
     Data Validation
    [Expand]Data Presentation
     Pivot Table
    [Expand]Mail Merge
     Keyboard Shortcuts
   [Expand]Visual Elements
  [Expand]Rich Text Editor
  [Expand]Site Navigation and Layout
  [Expand]HTML Editor
  [Expand]Vertical Grid
  [Expand]Data Editors
  [Expand]Docking and Popups
  [Expand]File Management
  [Expand]Data and Image Navigation
  [Expand]Multi-Use Site Controls
  [Expand]Spell Checker
  [Expand]Query Builder
 [Expand]ASP.NET MVC Extensions
 [Expand]Redistribution and Deployment
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Report and Dashboard Server
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

Import and Export

This document contains an overview of techniques, methods and properties used to load and save documents in different formats.

Expanded Load a Document

To load a file into the ASPxSpreadsheet control, an end-user can use a standard Open command from the ribbon File tab. It invokes the built-in Open dialog.

To programmatically load a document, call the ASPxSpreadsheet.Open method. It can be used to load a document from a file or a stream; a file format can be specified explicitly or deduced from the file extension.

Expanded Save a Document

To save a document, an end-user must use the standard SaveAs command from the ribbon File tab. This command invokes the built-in Save As... dialog. The ribbon Save command can also be used to save modifications under the same name, without invoking any dialog.

The Spreadsheet API has the ASPxSpreadsheet.Save method to save current modifications, and the ASPxSpreadsheet.SaveCopy and SpreadsheetDocumentInfo.SaveCopy methods allowing you to export a document to any of the supported file formats.

Expanded See Also

Is this topic helpful?​​​​​​​