Class CellStyleXlsx

constructor

• new CellStyleXlsx(cellLocked?: boolean, cellHidden?: boolean, cellBackground?: string, fontName?: string, fontSize?: string | number, fontColor?: string, fontItalic?: boolean, fontBold?: boolean, fontStrike?: boolean, fontUnderline?: boolean, fontSuperscript?: boolean, fontSubscript?: boolean, borderTop?: string, borderTopColor?: string, borderBottom?: string, borderBottomColor?: string, borderLeft?: string, borderLeftColor?: string, borderRight?: string, borderRightColor?: string, borderDiagonal?: string, borderDiagonalDirection?: string, borderDiagonalColor?: string, textHAlignment?: string, textVAlignment?: string, textRotation?: string | number): CellStyleXlsx

• Parameters

  • Optional cellLocked: boolean

    Whether or not the cell is locked. Optional.

  • Optional cellHidden: boolean

    Whether or not the cell is hidden. Optional.

  • Optional cellBackground: string

    hex color e.g: #ff0000. Optional.

  • Optional fontName: string

    name of the font e.g: Arial. Optional.

  • Optional fontSize: string | number

    The size of the font. Optional.

  • Optional fontColor: string

    hex color e.g: #00ff00. Optional.

  • Optional fontItalic: boolean

    Whether or not the text is in italic. Optional.

  • Optional fontBold: boolean

    Whether or not the text is in bold. Optional.

  • Optional fontStrike: boolean

    Whether or not the text is struck. Optional.

  • Optional fontUnderline: boolean

    Whether or not the text is underlined. Optional.

  • Optional fontSuperscript: boolean

    Whether or not the text is in superscript. Optional.

  • Optional fontSubscript: boolean

    Whether or not the text is in subscript. Optional.

  • Optional borderTop: string

    [dashed / dashDot / hair / dashDotDot / dotted / mediumDashDot / mediumDashed / mediumDashDotDot / slantDashDot / medium / double / thick ]. Optional.

  • Optional borderTopColor: string

    hex color e.g: #000000. Optional.

  • Optional borderBottom: string

    [dashed / dashDot / hair / dashDotDot / dotted / mediumDashDot / mediumDashed / mediumDashDotDot / slantDashDot / medium / double / thick ]. Optional.

  • Optional borderBottomColor: string

    hex color e.g: #000000. Optional.

  • Optional borderLeft: string

    [dashed / dashDot / hair / dashDotDot / dotted / mediumDashDot / mediumDashed / mediumDashDotDot / slantDashDot / medium / double / thick ]. Optional.

  • Optional borderLeftColor: string

    hex color e.g: #000000. Optional.

  • Optional borderRight: string

    [dashed / dashDot / hair / dashDotDot / dotted / mediumDashDot / mediumDashed / mediumDashDotDot / slantDashDot / medium / double / thick ]. Optional.

  • Optional borderRightColor: string

    hex color e.g: #000000. Optional.

  • Optional borderDiagonal: string

    [dashed / dashDot / hair / dashDotDot / dotted / mediumDashDot / mediumDashed / mediumDashDotDot / slantDashDot / medium / double / thick ]. Optional.

  • Optional borderDiagonalDirection: string

    . Optional.

  • Optional borderDiagonalColor: string

    hex color e.g: #000000. Optional.

  • Optional textHAlignment: string

    . Optional.

  • Optional textVAlignment: string

    . Optional.

  • Optional textRotation: string | number

    rotation of text value from 0-90 degrees. Optional.

  Returns CellStyleXlsx