set style to cell

[GHWels]

hey,

Is it possible to set a style to a cell.

thank you GH

[Betsy.jiang]

Hi GH,

Thanks for your inquiry.
Spire.Spreadsheet could set a style format to a cell, please right-click cells and find the option "Format cells".
If I misunderstand your meaning, please describe your requirement in detail.

Sincerely,
Betsy
E-iceblue support team

[GHWels]

Hey,
I want to define the style like spire.xls

'Dim style As CellStyle = .Styles.Add("RedText")
'style.Font.FontName = "Calibri"
'style.Font.Color = Color.Red
'style.Font.Size = 12
'style.Font.IsBold = True
'style.Font.IsItalic = True

and set the style "RedText" to a cell
Gh

[Betsy.jiang]

Hi GH,

Please refer to following code to achieve your target:

Code: Select all

spreadsheet1.ActiveWorksheet.GetActiveCell().Font = New Font("Calibri", 16, FontStyle.Bold Or FontStyle.Italic)
spreadsheet1.ActiveWorksheet.GetActiveCell().FontColor = Color.Red

Any question, welcome to get it back to us.

Sincerely,
Betsy
E-iceblue support team

[GHWels]

Thank you, for your fast help.
GH

[Betsy.jiang]

Hi GH,

Thanks for your feedback.
Any question, just feel free to contact us.
Have a nice day!

Sincerely,
Betsy
E-iceblue support team