# 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](https://developer.mescius.com/spreadjs/docs/latest/online/SpreadJS~GC.Spread.Sheets.CellRange~backColor.html) or Cell.[foreColor](https://developer.mescius.com/spreadjs/docs/latest/online/SpreadJS~GC.Spread.Sheets.CellRange~foreColor.html) | 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](https://developer.mescius.com/spreadjs/docs/latest/online/SpreadJS~GC.Spread.Sheets.CellRange~borderLeft.html), [borderTop](https://developer.mescius.com/spreadjs/docs/latest/online/SpreadJS~GC.Spread.Sheets.CellRange~borderTop.html), [borderRight](https://developer.mescius.com/spreadjs/docs/latest/online/SpreadJS~GC.Spread.Sheets.CellRange~borderRight.html), [borderBottom](https://developer.mescius.com/spreadjs/docs/latest/online/SpreadJS~GC.Spread.Sheets.CellRange~borderBottom.html) | SpreadJS imports borders. SpreadJS sets the color to the color used in Excel. |
| Cell value | Cell.[value](https://developer.mescius.com/spreadjs/docs/latest/online/SpreadJS~GC.Spread.Sheets.CellRange~value.html) or Cell.[text](https://developer.mescius.com/spreadjs/docs/latest/online/SpreadJS~GC.Spread.Sheets.CellRange~text.html) | SpreadJS imports cell contents as the Value and displays it using the size specified by the Font property. |
| Cell ThemeFont, Fonts, font types | Cell.[font](https://developer.mescius.com/spreadjs/docs/latest/online/SpreadJS~GC.Spread.Sheets.CellRange~font.html) | SpreadJS loads the cell fonts from Excel. |
| Cell Horizontal and vertical text alignment | Cell.[hAlign](https://developer.mescius.com/spreadjs/docs/latest/online/SpreadJS~GC.Spread.Sheets.CellRange~hAlign.html) or Cell.[vAlign](https://developer.mescius.com/spreadjs/docs/latest/online/SpreadJS~GC.Spread.Sheets.CellRange~vAlign.html) | SpreadJS imports this setting from Excel. |
| Cell Locked | Cell.[locked](https://developer.mescius.com/spreadjs/docs/latest/online/SpreadJS~GC.Spread.Sheets.CellRange~locked.html) | 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](https://developer.mescius.com/spreadjs/docs/latest/online/SpreadJS~GC.Spread.Sheets.CellRange~shrinkToFit.html) | SpreadJS imports this setting from Excel. |
| Cell WordWrap | Cell.[wordWrap](https://developer.mescius.com/spreadjs/docs/latest/online/SpreadJS~GC.Spread.Sheets.CellRange~wordWrap.html) | SpreadJS imports this setting from Excel. |
| Cell TextIndent | Cell.[textIndent](https://developer.mescius.com/spreadjs/docs/latest/online/SpreadJS~GC.Spread.Sheets.CellRange~textIndent.html) | SpreadJS imports this setting from Excel. |
| Cell Format | Cell.[formatter](https://developer.mescius.com/spreadjs/docs/latest/online/SpreadJS~GC.Spread.Sheets.CellRange~formatter.html) | 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](https://developer.mescius.com/spreadjs/docs/latest/online/SpreadJS~GC.Spread.Sheets.CellRange~validator.html) | SpreadJS imports the Excel cell validator to DefaultDataValidator and assigns the validator as closely as possible by setting the different types of Validator properties. |