Excel Import/Export
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
Last updated