Webix Spreadsheet User Guide
  • Introduction
  • SpreadSheet Basics
  • Working with Cells
  • Using Formulas for Math Calculations
  • Formatting Text and Cells
  • Formatting Text
  • Formatting Numbers
  • Formatting Dates
  • Working with Rows and Columns
  • Working with Sheets
  • Excel Import/Export
  • Printing Interface
  • Working with embedded Charts and Images
Powered by GitBook
On this page
  • Importing data from Excel
  • Exporting data to Excel
  • Supported elements/settings for Excel export/import

Excel Import/Export

PreviousWorking with SheetsNextPrinting Interface

Last updated 5 months ago

Importing data from Excel

It is possible to import data from an Excel file into a sheet of SpreadSheet.

To import data from Excel:

1) Click the Import from Excel button in the File section:

2) Choose an Excel file the content of which you want to export to SpreadSheet from your computer. Its data will be displayed in the current sheet.

Exporting data to Excel

You can export the content of a sheet to an Excel file.

To export data to Excel:

1) Click the Export to Excel button in the File section:

2) In the appeared dialog window, type the name of a new Excel file that will contain the content of the current sheet.

3) Сlick Save to save the file.

A new Excel file with exported data will be downloaded to your computer.

Supported elements/settings for Excel export/import

In this section you can check what elements SpreadSheet can process and what settings it supports for Excel data export/import.

Export to Excel

  • data (including math and dates)

  • font

  • font size (converts px into pt)

  • bold, italic, underline, strike

  • background

  • color

  • borders

  • horizontal align

  • vertical align

  • rows/cols sizes (converts px into pt)

  • hidden rows/cols

  • merge

  • wrap

  • indent

  • number format

  • named ranges

  • sheet visibility

  • links

  • conditional formats (saves color and background-color)

  • checkbox/radio (exported as TRUE/FALSE)

  • images

  • frozen rows/columns

  • zoom

  • header visibility

  • gridlines

  • formulas mode

Import from Excel

  • data (including math and dates)

  • font

  • font size (converts pt into px)

  • bold, italic, underline, strike

  • background

  • color

  • borders

  • horizontal align

  • vertical align

  • rows/cols sizes (converts pt into px)

  • hidden rows/cols

  • merge

  • wrap

  • indent

  • number format (those supported by SpreadSheet)

  • named ranges

  • sheet visibility

  • links (all links are converted into the HYPERLINK method)

  • filters

  • images

  • frozen rows/columns

  • zoom

  • header visibility

  • gridlines

  • formulas mode

Import from Excel
Export to Excel
Export to Excel Popup