Shulou(Shulou.com)06/01 Report--

In this issue, Xiaobian will bring you about which attributes SpreadJS supports binding in Angular2. The article is rich in content and analyzed and described from a professional perspective. After reading this article, I hope you can gain something.

SpreadJS is a JavaScript spreadsheet and grid function control based on HTML5. It provides complete formula engine, sorting, filtering, input control, data visualization, Excel import/export and other functions. It is suitable for online editing Excel function form program development on various platforms such as. NET, Java and mobile.

In the previous article, we learned that SpreadJS has full Angular2 support and that integrating SpreadJS in Angular2 is a 4-step process.

Below we will show you which properties SpreadJS supports binding in Angular2. Different tags can be bound to different attributes. We will introduce them according to the classification of tags. The following is a list of the main attributes. For more detailed descriptions of attributes, please click here.

gc-spread-sheets：

Attribute

Type

Comment

name

string

The name of the entire workbook, Excel's default name when exported

tabStripVisible

boolean

Show navigation bar for bottom left sheet

allowUserDragFill

boolean

Allow users to drag fill

highlightInvalidData

boolean

Whether to highlight invalid data during data validation (invalid data is circled in red when highlighted)

backColor

string

set the background color

backgroundImage

string

Set background picture

hostStyle

any

Tag style, equivalent to HTML style attribute, using method equivalent to angular2 style binding, for example: {width: 400px, height: 600px}

hostClass

string

Tag class, equivalent to HTML class attribute.

gc-worksheet：

Attribute

type

Comment

dataSource

any

Forms-level bindings, set data sources.

name

string

Set the name of the sheet

frozenColumnCount

number

Top frozen column, parameter colindex

frozenRowCount

number

Top frozen row, parameter rowindex

frozenTrailingColumnCount

number

Freeze the bottom column, parameter colcount-colindex, for example freeze the last two rows, parameter 2.

frozenTrailingRowCount

number

Bottom frozen row, parameter rowcount-rowindex

rowCount

number

Set the number of rows

colCount

number

Set Number of Columns

rowHeaderVisible

boolean

Display rowHeader

columnHeaderVisible

boolean

Whether columnHeader is displayed

isProtected

boolean

Set up form protection

selectionBackColor

string

Set the background color of the selected area

selectionBorderColor

string

Set border color of selected area

defaultStyle

GC.Spread.Sheets.Style

Sets the default style with parameters as instances of GC.Spread.Sheets.Style.

gc-column ：

Attribute

type

Comment

width

number

column width

resizable

boolean

Resize based on drag

autoFit

boolean

Automatically match column widths

style

GC.Spread.Sheets.Style

Column Set Style

cellType

GC.Spread.Sheets.CellTypes.Base

Set cell type for whole column

formatter

string

Format cells as columns

It should be noted that the maximum precision of SpreadJS in Angular2 can only be set to the column level, which is related to the binding mechanism of Angular2 and needs special attention.

The above is what SpreadJS supports binding in Angular2. If there is a similar doubt, please refer to the above analysis for understanding. If you want to know more about it, please pay attention to the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.