# Cell Settings Imported

## Content

This table summarizes how the cell settings are handled when SpreadJS imports data from an Excel file. The properties are members of the GC.Spread.Sheets.CellRange class unless specifically noted otherwise.

| **Excel Setting** | **SpreadJS Setting** | **Remarks** |
| ------------- | ---------------- | ------- |
| Cell color or pattern | Cell.[backColor](/spreadjs/api/classes/GC.Spread.Sheets.CellRange#backcolor) or Cell.[foreColor](/spreadjs/api/classes/GC.Spread.Sheets.CellRange#forecolor) | SpreadJS reads the color setting from Excel and assigns color based on the setting of each cell’s individual setting. Fill patterns are supported. |
| Cell borders | Cell.[borderLeft](/spreadjs/api/classes/GC.Spread.Sheets.CellRange#borderleft), [borderTop](/spreadjs/api/classes/GC.Spread.Sheets.CellRange#bordertop), [borderRight](/spreadjs/api/classes/GC.Spread.Sheets.CellRange#borderright), [borderBottom](/spreadjs/api/classes/GC.Spread.Sheets.CellRange#borderbottom) | SpreadJS imports borders. SpreadJS sets the color to the color used in Excel. |
| Cell value | Cell.[value](/spreadjs/api/classes/GC.Spread.Sheets.CellRange#value) or Cell.[text](/spreadjs/api/classes/GC.Spread.Sheets.CellRange#text) | Cell contents are imported as the corresponding cell value in SpreadJS. Certain specialized content types may be mapped to dedicated value models. |
| Cell ThemeFont, Fonts, font types | Cell.[font](/spreadjs/api/classes/GC.Spread.Sheets.CellRange#font) | SpreadJS loads the cell fonts from Excel. |
| Cell Horizontal and vertical text alignment | Cell.[hAlign](/spreadjs/api/classes/GC.Spread.Sheets.CellRange#halign) or Cell.[vAlign](/spreadjs/api/classes/GC.Spread.Sheets.CellRange#valign) | SpreadJS imports this setting from Excel. |
| Cell Locked | Cell.[locked](/spreadjs/api/classes/GC.Spread.Sheets.CellRange#locked) | SpreadJS imports the Excel setting. Note the default value of the Lock property is True for all cells in Excel. |
| Cell Shrink to fit | Cell.[shrinkToFit](/spreadjs/api/classes/GC.Spread.Sheets.CellRange#shrinktofit) | SpreadJS imports this setting from Excel. |
| Cell WordWrap | Cell.[wordWrap](/spreadjs/api/classes/GC.Spread.Sheets.CellRange#wordwrap) | SpreadJS imports this setting from Excel. |
| Cell TextIndent | Cell.[textIndent](/spreadjs/api/classes/GC.Spread.Sheets.CellRange#textindent) | SpreadJS imports this setting from Excel. |
| Cell Format | Cell.[formatter](/spreadjs/api/classes/GC.Spread.Sheets.CellRange#formatter) | SpreadJS imports all the Excel cell formats to the General cell type and assigns the formats as closely as possible by setting the NumberFormat, DateTimeFormat, and FormatString properties. |
| Cell Validator | Cell.[validator](/spreadjs/api/classes/GC.Spread.Sheets.CellRange#validator) | SpreadJS imports the Excel cell validator to DefaultDataValidator and assigns the validator as closely as possible by setting the different types of Validator properties. |
| Formula Cell Hide | Style.hidden<br>CellRange.hidden | SpreadJS imports Excel files with hidden formula cells. |