Log In
[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
  [Expand]Chart Control
  [Expand]Grid View
  [Expand]Card View
  [Expand]Vertical Grid
   [Expand]Product Information
    [Expand]Spreadsheet Document
     Supported Formats
     Import and Export
    [Expand]Cell Basics
    [Expand]Spreadsheet Formulas
     Defined Names
     Data Validation
    [Expand]Data Presentation
    [Expand]Mail Merge
     Keyboard Shortcuts
   [Expand]Visual Elements
  [Expand]Rich Text Editor
  [Expand]Image and Data Browsing
  [Expand]Docking and Popups
  [Expand]Site Navigation and Layout
  [Expand]File Management
  [Expand]Multi-Use Site Controls
  [Expand]HTML Editor
  [Expand]Pivot Grid
  [Expand]Tree List
  [Expand]Data Editors
  [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]Document Server
[Expand]Report Server
[Expand]eXpressApp Framework
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

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

How would you rate this topic?​​​​​​​